Hello everyone,
I am trying to pull owner information from a hosted table (PropertyOwnerDetails) using the Parcel number (parcel_number in Parcels_Carlisle, map in PropertyOwnerDetails, both fields are String) as the common link. I have tried different solutions but just cannot get it to work. I do not get any error message - the field just remains blank.
Any help would be appreciated.
Thanks!
Is the parcel number field actually a number field type (like an integer)? Our parcel numbers are stored as text. If it is a text field you need to enclose your parcel number in quotes. So your query builder field should look like:
concat("map='",${parcel_number},"'")
Try to do a helper field with your where clause outside of your pulldata calculation
whcl: concat("map = ",${parcel_number})
and then put ...FeatureServer/0", ${whcl})
Calculations in side pulldata functions sometime cause issues
@Neal_t_k thanks for your help.
I tried your suggestion but it did not work:
Again, no error message.
Just to rule it out, did you check that the rest url allow queries? and did you directly query the url to see if it works as expected?
Hello @Neal_t_k yes the REST url allows query.
And I was able to query the layer directly using steps shown here, and it worked without any problem.
@TylerGraham2 you are absolutely right. That was indeed the solution that was offered by Esri tech support.
Additionally, we also realized that the table I was trying to pull the records from had around 700+ values in the join field (parcel number) that was formatted differently (and extra "-"). I was sitting inside one of those parcels whose ID was formatted incorrectly while I tested the app. So no records were returned during my tests. 🙄
Thank you all!
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
