Can a URL parameter be used to filter a feature service in a search appearance question?

Mark_Johnson — Fri, 03 Mar 2023 21:27:51 GMT

I'm trying to use a table in a feature service to populate a select_one question with the autocomplete search appearance. The table includes a column called Active with 0 or 1 for project status. I'd like to filter the list to only show "active" records using a URL parameter. For instance if I put this URL in a browser (server info redacted):

https://<enterprise server>/server/rest/services/<feature service>/FeatureServer/1/query?where=Active=1&orderFields=JobNumber&f=json

returns the expected result in json format. But if I try similar in Survey123 Connect:

autocomplete search('projnum?url=https://<enterprise server>/server/rest/services/<feature service>/FeatureServer/1/query?where=Active=1', 'contains', 'JobName')

it doesn't filter anything out. Is this not possible or do I have the syntax wrong or is there a better way to do this?

Thanks

Enterprise 10.9.1, Survey123 Connect 3.17.54

topic Can a URL parameter be used to filter a feature service in a search appearance question? in ArcGIS Survey123 Questions

Can a URL parameter be used to filter a feature service in a search appearance question?