topic pulldata("@layer") fails when WHERE clause includes value from earlier question in ArcGIS Survey123 Questions

pulldata("@layer") fails when WHERE clause includes value from earlier question

TobiasFimpel1 — Mon, 31 Oct 2022 21:05:47 GMT

My question1 asks the user to identify the asset id. That works beautifully:

autocomplete search("Manhole_IDs?<url>", ‘contains’, ‘MANHOLE_ID’)

Then I have a note that needs to display the work order number based on the asset id. It runs the following calculation:

pulldata("@layer", "getValue", "attributes.WORKTASK_NUMBER",<url>, "MANHOLE_ID= ${question1}")

Is the where clause supposed to allow for inclusion of variables, i.e. values from previous questions?

If I hard-code the value in the where clause then the pulldata function returns the correct value. The documentation doesn't clarify if variables are supported, and Esri's Survey123 Connect samples don't show it either.

Re: pulldata("@layer") fails when WHERE clause includes value from earlier question

IsmaelChivite — Mon, 31 Oct 2022 21:13:19 GMT

Did you try this?

pulldata("@layer", "getValue", "<json_path>",<url>, concat("MANHOLE_ID=", ${question1}))

Re: pulldata("@layer") fails when WHERE clause includes value from earlier question

TobiasFimpel1 — Mon, 31 Oct 2022 21:30:22 GMT

Still no luck. I've tried using a variable in the where clause in all kinds of ways, never gotten it to work.

I appreciate the quick reply.

Re: pulldata("@layer") fails when WHERE clause includes value from earlier question

IsmaelChivite — Mon, 31 Oct 2022 22:59:16 GMT

Is the ManholeID a number or text? If text, the Manhole ID must be enclosed with quotes.

pulldata("@layer", "getValue", "<json_path>",<url>, concat("MANHOLE_ID='", ${question1},"'"))

Re: pulldata("@layer") fails when WHERE clause includes value from earlier question

TobiasFimpel1 — Tue, 01 Nov 2022 03:16:25 GMT

Perfect! That did it. I can't believe I didn't catch that myself. Thank you for the quick replies, Ismael, you and the Survey123 team are the best. Much appreciated.

Re: pulldata("@layer") fails when WHERE clause includes value from earlier question

RobertAnderson3 — Fri, 12 May 2023 14:49:04 GMT

I was struggling with this, I feel like the fact it needs to be in a concat() with the quotes would be handy to include in your Tricks of the Trade blog about pulldata(@layer) or documentation somewhere. I had tried the style of "MANHOLE_ID= '${question1}'" with the single quotes directly and it didn't want to work which surprised me.

Thank you for the solution!

Re: pulldata("@layer") fails when WHERE clause includes value from earlier question

HelenaBallart — Tue, 16 May 2023 14:30:37 GMT

Hello,

I have the same problem, I work with text and I use your code, no error appears but no value appears either.

pulldata("@layer","getValue","attributes.perfil_professional","URL",concat("nom_ramader='", ${nom_ramader},"'"))

The Featre layer permits queries, can you help me?

Much appreciated.;)

Re: pulldata("@layer") fails when WHERE clause includes value from earlier question

RobertAnderson3 — Tue, 16 May 2023 15:32:39 GMT

I can't see anything that seems off really, the only thing I'd say is make sure everything is spelt matching, and case matching as well! (Upper vs lower case letters).

The only other difference I see with yours compared to mine is I used single quotes around my variables instead of double quotes.

Re: pulldata("@layer") fails when WHERE clause includes value from earlier question

JoshuaReyling — Wed, 28 Jun 2023 17:32:55 GMT

When I enter my pulldata request in the above format, I get the following syntax error in my text box:

Invalid regular expression flag 'P' in expression: pulldata("@layer", "getValue", "attributes.scientific","https://services1.arcgis.com/KNdRU5cN6ENqCTjk/arcgis/rest/services/PlantList/FeatureServer/0",concat("name='", /Bee_Test/PlantsBees/Observations/Plant/PlantCommon ,"'"))

call in my xlsForm: pulldata("@layer", "getValue", "attributes.scientific","https://services1.arcgis.com/KNdRU5cN6ENqCTjk/arcgis/rest/services/PlantList/FeatureServer/0",concat("name='",${PlantCommon},"'"))

PlantCommon is a dropdown of common names

Re: pulldata("@layer") fails when WHERE clause includes value from earlier question

CoryBowlin — Sat, 29 Jul 2023 00:14:12 GMT

I'm getting a very similar error. Even the ESRI sample survey 123 form "Query a Feature Layer" has the same error.

Re: pulldata("@layer") fails when WHERE clause includes value from earlier question

CoryBowlin — Mon, 31 Jul 2023 03:53:29 GMT

The error may have been fixed in a later survey 123 release. I just downloaded 3.18 and it works in the sample form "Query a Feature Layer" like it should, but in my own environment the wrong value is returned inconsistently. Sometimes the correct value is returned, and sometimes the correct value appears for a brief second and then changes to the same incorrect value first record in the table. I am out of ideas.

Re: pulldata("@layer") fails when WHERE clause includes value from earlier question

lannguyentl — Sun, 13 Aug 2023 23:39:18 GMT

Hi All,

Has anyone really made the pulldata@layer work? I have tried all the possibilities and even the sample code from ESRI does not work.

I upgraded to 3.18 but it keeps saying: TypeError: Cannot read property 'toString' of underfined in expression: pulldata("@layer",....)

This is an useful function, hope that it should work.

Thanks,

Lan

Re: pulldata("@layer") fails when WHERE clause includes value from earlier question

DustyJordan — Mon, 14 Aug 2023 03:10:29 GMT

Hey Joshua,

Did you ever get this syntax error figured out? I'm running into the same problem with my pulldata(@layer...) calculations.

Re: pulldata("@layer") fails when WHERE clause includes value from earlier question

CoryBowlin — Mon, 14 Aug 2023 13:30:57 GMT

I was able to get it to work in 3.18, but not like the ESRI sample. I had to place the entire pulldata function into a single field. If I separated the concat and referenced it, pulldata retrieved the wrong record. @lannguyentl include your pulldata syntax and I bet someone can find the problem.

Re: pulldata("@layer") fails when WHERE clause includes value from earlier question

JoshuaReyling — Mon, 14 Aug 2023 15:18:53 GMT

Unfortunately, no. But because my list was not going to grow much larger than 250 items, I added it to the survey itself without taking a hit to performance.

Re: pulldata("@layer") fails when WHERE clause includes value from earlier question

MihaRobar — Fri, 08 Dec 2023 14:08:32 GMT

I am also struggling with pull data from feature layer. Can you share last solution that worked?

Re: pulldata("@layer") fails when WHERE clause includes value from earlier question

AshneyDaniel — Thu, 02 May 2024 19:41:50 GMT

Well done.

Doesn't make any sense but this is key!

"MANHOLE_ID='hard coded text value'" works.

"MANHOLE_ID='${question1}'" does not work.

concat("MANHOLE_ID='", ${question1},"'") works.

Re: pulldata("@layer") fails when WHERE clause includes value from earlier question

OussamaMerhi — Sun, 07 Jul 2024 09:44:02 GMT

Hi Ismael,

How can I add two conditions. ex.: id=123 and name="xyz"

Hope to hear soon.

Best,

Oussama

Re: pulldata("@layer") fails when WHERE clause includes value from earlier question

OussamaMerhi — Sun, 07 Jul 2024 09:49:12 GMT

Dear Ismael,

I have managed to do it. "id="123 and "name='xyz'"

Best,

Oussama