Hello all
I have a pulldata function that utilizes a date field for a query. I can use orderByFields ASC and DESC successfully, but when I try a simple "and Current_date= DATE 'YYYY-MM-DD' in my concat statement, it does not work.
Doesn't work: pulldata("@layer","getValue", "attributes.variable",concat( ${URL}, "?t=", now() ), ${where} )
where: concat("Plot=",${plot}, "and Current_Date= DATE '2026-05-12' " )
I've tried many different methods involving TIMESTAMPS and Intervals to no success, so I'm starting with a simple query to narrow down the problem. Can anyone suggest why ordering would work and not the other? I suspect that caches are involved, but not sure. Thanks for any help.
Doug
