topic Filter Data Geodatabase in ArcGIS AppStudio Questions

Filter Data Geodatabase

jaykapalczynski — Sun, 12 Dec 2021 09:30:25 GMT

I have a local .geodatabase on my mobile device. I can read it fine.

I am now attempting to set a where clause or filter that allows the user to click a button and filter / ONLY show data that is there based on the Created_User field

Can I just set a WHERE clause in the Geodatabase or do I nee to do something else...

I would like to be able to click the button to just show that specific persons from the field and then click the button again and go back to ALL data.

Thoughts?

                FeatureLayer {
                    id: Points
                    visible: false
                    featureTable: gdb.geodatabaseFeatureTablesByTableName["Hunting"]
                   
                    // create the geodatabase
                    Geodatabase {
                        id: gdb
                        path: Path
                        onErrorChanged: errorMessage = error.message;
                    }
                    onErrorChanged: errorMessage = error.message;
                }‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Filter Data Geodatabase

jaykapalczynski — Sun, 12 Dec 2021 09:30:28 GMT

Im trying this but not sure because I am using a local geodatabase and think my syntax might be incorrect

It removes all of the records when I click the button and then turns them all on

BUT its removing them all and I know there are a couple different values in the created_user field.

thoughts?

                    Button {
                        text: "Apply Expression"
                        enabled: gdb.loadStatus === Enums.LoadStatusLoaded
                        onClicked: {
                            Points.definitionExpression = "created_user = \'ESRI_Anonymous\'"
                        }
                    }
                    Button {
                        text: "Reset"
                        enabled: gdb.loadStatus === Enums.LoadStatusLoaded
                        onClicked: {
                            Points.definitionExpression = "";
                        }
                    }‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Filter Data Geodatabase

jaykapalczynski — Sun, 12 Dec 2021 16:56:50 GMT

Think I have it...just syntax...

what are the \ used in his example

Feature layer definition expression | ArcGIS for Developers

How can I make a LIKE statement

onClicked: {

   Points.definitionExpression = "created_user = 'Law'"
 }

Re: Filter Data Geodatabase

jaykapalczynski — Sun, 12 Dec 2021 16:56:53 GMT

Does this look correct? Seems like I could make this look nicer but this seems to work.

"created_user = " + "'" + credentialUsersNameNew + "'" + " AND PublicPrivate = 'public'";


Last question....any idea how to query between specific dates?

Re: Filter Data Geodatabase

jaykapalczynski — Fri, 27 Dec 2019 14:57:44 GMT

I am trying this but no luck

This is trying to query the created_date that is created automatically

var startdate = "12/18/2019 1:30:10 AM";

Points.definitionExpression = "created_date >= " + " ' " + startdate + " ' ";

Does a .geodatabase file follow SQL standards?

preferably I would simply like to query for a specific year....

i.e. show me the records for 2018 or 2019

Re: Filter Data Geodatabase

ErwinSoekianto — Fri, 27 Dec 2019 17:23:56 GMT

I would assume, it would be the same as how you would put the query parameter for the REST end point of the feature layer. Querying Feature Services: Date-Time Queries

cc: ArcGIS Runtime SDK for Qt‌

Re: Filter Data Geodatabase

jaykapalczynski — Fri, 27 Dec 2019 17:32:02 GMT

OK great...yea wanted to know if it follow standard SQL....looks like it does....Cheers