Advice for contructing a query against multiple possible fields
I'm just getting into using workflow, so I'm still wrapping my head around it. I have a situation where I need to query a layer based on several possible fields—the user may enter a value for one field, or the user can specify values for several fields to search for features. Any field which does not have a value chosen/specified will not be used in the query.
Can someone advise me on a workflow design that will construct a query string based on one or more possible fields once the form is submitted? What I imagine is using a series of Flow Decisions and, in each, if the form variable has a value, then append a string with "AND field LIKE value"; if not, move on to the next Decision. Is there a more elegant way to construct the query string?
Thanks,
Jim
Please sign in to leave a comment.
Comments
0 comments