https://community.esri.com/t5/arcgis-survey123-questions/one-pulldata-statement-with-a-where-clause-and/m-p/1344575#M52630 <P>Hello!&nbsp; I am trying to figure out how to write a pulldata function that has two feature filters, I assume placed in the WHERE clause.&nbsp; I am building a refuse cart solution that tracks cart type (trash, recycle, yardwaste), cart size, cart serial number, etc. in Survey123 Connect (on Enterprise Portal 10.9.1).&nbsp; The original feature class contains three records per property, one record for each cart type, from which I published a feature service to our federated Server.&nbsp; I am using the pulldata&nbsp;@layer workflow and would like to filter on cart_type first, based on the choice in a select_one question, then filter on the address field, thus retrieving that one unique record from the service table.&nbsp; Is this possible to do in one pulldata statement?&nbsp; Any help, example code, workflow, etc. would be appreciated.&nbsp; Many thanks, Jay</P> Wed, 01 Nov 2023 18:20:10 GMT JayHodny 2023-11-01T18:20:10Z https://community.esri.com/t5/arcgis-survey123-questions/one-pulldata-statement-with-a-where-clause-and/m-p/1344575#M52630 <P>Hello!&nbsp; I am trying to figure out how to write a pulldata function that has two feature filters, I assume placed in the WHERE clause.&nbsp; I am building a refuse cart solution that tracks cart type (trash, recycle, yardwaste), cart size, cart serial number, etc. in Survey123 Connect (on Enterprise Portal 10.9.1).&nbsp; The original feature class contains three records per property, one record for each cart type, from which I published a feature service to our federated Server.&nbsp; I am using the pulldata&nbsp;@layer workflow and would like to filter on cart_type first, based on the choice in a select_one question, then filter on the address field, thus retrieving that one unique record from the service table.&nbsp; Is this possible to do in one pulldata statement?&nbsp; Any help, example code, workflow, etc. would be appreciated.&nbsp; Many thanks, Jay</P> Wed, 01 Nov 2023 18:20:10 GMT https://community.esri.com/t5/arcgis-survey123-questions/one-pulldata-statement-with-a-where-clause-and/m-p/1344575#M52630 JayHodny 2023-11-01T18:20:10Z https://community.esri.com/t5/arcgis-survey123-questions/one-pulldata-statement-with-a-where-clause-and/m-p/1345565#M52670 <P><STRONG>UPDATE:</STRONG> I can now choose cart type, enter an address, and have the record associated with the cart type and its location (geometry) retrieved. After tinkering with the Calculation, Choice_Filter, Relevant, etc. options in Connect, I ended up adding search parameters to my 'autocomplete search' function in the <U>Appearance</U> option:&nbsp;autocomplete search("address?url=<A href="https://yourserviceurl/FeatureServer/0" target="_blank" rel="noopener">https://yourserviceurl/FeatureServer/0</A>",'contains','cart_type',${cart_type}).&nbsp; I also had to increase the "max record count returned by the Server" service to be able to access the 20,000+ records.&nbsp; Data retrieval time remains fast.</P><P><A href="https://community.esri.com/t5/arcgis-survey123-blog/dynamic-choice-lists-using-search-appearance/ba-p/1060838" target="_self">For more information on Search Appearance....</A></P> Fri, 03 Nov 2023 15:47:20 GMT https://community.esri.com/t5/arcgis-survey123-questions/one-pulldata-statement-with-a-where-clause-and/m-p/1345565#M52670 JayHodny 2023-11-03T15:47:20Z