Query Relationship results to use in the Query or show on map
Hi everyone,
I am trying to show the results from Query Relationship activity. The workflow goal is to find parcels based on the user provided address. We have 2 layers: addresses and parcels, and relationship table that connects parcels and addresses.
My workflow consists of:
1. Display form to get the address
2. Query Layer activity to get the address: =`FULLADDR=('${$form1.state.autoComplete1.label}')`
3. Query Relationship: that searches through related table based on the address Object Id and Relationship ID
I can see in the Console tab the result of the Query Relationship. It finds the correct parcel.
I tried this syntax for the Query Layer, but it did not work:
Where: `APN=('{$queryRelationship1.results.relatedRecordGroups[0].relatedRecords[0].attributes("APN")}')`
But I need to either directly show this parcel, or at lest get its APN to pass to another Query Layer activity.
The structure of the Query Relationship result is as follow.
-
If you copy-pasted that JS from your workflow, I can tell that the string template literal syntax is incorrect. If you look at the .where input arg to your query in the console, did the clause build properly? If so, the next step is to test that your query works directly against the REST interface, can you get your query to work there?
0 -
Thank you for your answer. I found the way how to use relationship query results in the next queries
0
Du måste logga in om du vill lämna en kommentar.
Kommentarer
2 kommentarer