pulldata @layer no calculate expression

ALANDIA40

Good evening I have tried to use pulldata(@layer) to automatically fill in a text in a form I want as a calculation where the date of form 1 must be equal to the date of form 2 to be able to use the filtered feature

This is one of the conditions with pull data:

pulldata("@layer", "getValue", "attributes.descritivo_comportamento_de_fog", "https://services-eu1.arcgis.c om/VlrHb7fn5ewYhX6y/arcgis/rest/services/survey123_bd2f7d69157440b3b88384238c9f8a4e/FeatureServer/0", "(dia_em_an_lise NOT BETWEEN CURRENT_TIMESTAMP - 3 AND CURRENT_TIMESTAMP) AND (classe_dia = 'Day 1')")

the code like this is functional but not as I intend it to filter

so its this:

pulldata("@layer","getValue","attributes.meteo_d1",${url}, ${where_clause})

where_clause is: concat("dia_em_an_lise=", ${d1})

The answer is this

Should fill in the text in Meteo D1

And did nothing

In short, the idea is that you fill in the text of an uploaded report in which only the text of the record of the day under analysis is equal to the date uploaded to the form.

Form Date:

Field to be filled from another outer layer:

Thanks

 

 

 

form.xlsx

ALANDIA40

This is the solution that worked:

"dia_em_an_lise BETWEEN CURRENT_DATE AND CURRENT_DATE + INTERVAL '1' DAY - INTERVAL '1' SECOND")

It's not bad, but it's too complex for such a simple mind-reading and limits the construction of conditions.
I think ESRI should consider allowing the use of this type of condition even in web search, in the same way it exists in the experiment builder.

It's not bad, but it's too complex for such a simple mind-reading and limits the construction of conditions.
I think ESRI should consider allowing the use of this type of condition even in web search, in the same way it exists in the experiment builder.

In short, it does not facilitate the dreamed dynamics in their entirety.