Question

Create parameter for WHERE clause

  • 29 November 2021
  • 3 replies
  • 3 views
R

I have two arcgis online feature layers (jobsites and trees) that are in a 1:M relationship. On the trees reader, I've set where clause as "EditDate" >= CURRENT_TIMESTAMP() - 7.

The resulting features in this reader have the globalid attribute found in the jobsites layer. I would like to read just jobsites with globalids found in the trees reader. How do I create a dynamic where clause for the jobsites useing a unique list of globalids from the trees layer?

 

So far I've used Listbuilder, DuplicateFilter, ListConcatenator, and StringReplacer to get a list of unique globalid's -

'{28F268A5-7390-4FFC-9EF6-C522D1237ECE}','{28F268A5-7390-4FFC-9EF6-C522D1237ECE}','{28F268A5-7390-4FFC-9EF6-C522D1237ECE}','{28F268A5-7390-4FFC-9EF6-C522D1237ECE}','{28F268A5-7390-4FFC-9EF6-C522D1237ECE}','{28F268A5-7390-4FFC-9EF6-C522D1237ECE}'

 

The first issue is how do I make the string say the following:

GlobalID IN ('{28F268A5-7390-4FFC-9EF6-C522D1237ECE}','{28F268A5-7390-4FFC-9EF6-C522D1237ECE}','{28F268A5-7390-4FFC-9EF6-C522D1237ECE}','{28F268A5-7390-4FFC-9EF6-C522D1237ECE}','{28F268A5-7390-4FFC-9EF6-C522D1237ECE}','{28F268A5-7390-4FFC-9EF6-C522D1237ECE}')

 

The second issue is how do make that where statement a paramenter for the jobsite reader?

 

Thanks!

 

3 replies

nielsgerrits
Rank
Userlevel 6
Badge +33

If I understand you want to chain two FeatureReaders together. This way you can read the jobsite you want, then all trees with that jobsite id?

R

If I understand you want to chain two FeatureReaders together. This way you can read the jobsite you want, then all trees with that jobsite id?

That sounds pretty close except I want all jobsites with jobsiteIDs that are found in the tree FeatureReader.

ctredinnick
Rank
Userlevel 3
Badge +16

Assuming the output of your ListConcatenator/StringReplacer is an attribute named jobsitelist, then I think you can just pass that into a FeatureReader, reading from the jobsites layer where GlobalID IN (@Value(jobsitelist))

Reply


Community Stats

28,731
Posts
109,528
Replies
36,565
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.