Hi, I’m really new to natural and I’m having trouble doing a database read the depends on 3 fields.
I have 3 parameters that the user puts in, only one of them is required, the others may be blank (may come blank from the map and may be blank in the db).
it’s kind like this:
read view with param1 = #field1
now, if #field2 is not empty, then there should be an where param2 = #field2 and same for #field3.
I’ve tried something like
if #field1 and #field2
etc… but as I suspected, it didn’t work…
Other thing I’m having trouble is to check if a field (from map or from db) is empty… I’m using a control variable for maps, but I’m guessing there’s a better way.
Thanks in advance,