I have a record with shops, and then also a record with products. I assign a Shop ID to each product, depending on which shop sells this product.
So for example, the product with ID 47, has a value 20 in the ID Shop Column, because the shop with ID 20 has this product.
Then I have an Interface with a report that you acces from each shop. If I acces to the shop with ID 20, I want the report to be filtred in a way that it only shows products with Shop ID 20.
My interface, my query and my filter works correctly when I test it with an integer in the value:
But when I try to get this value from my rule input which is a data type, it doesn't work, and shows this error:
Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!gridField [line 4]: Expression evaluation error at function a!queryLogicalExpression [line 33]: The a!queryFilter function has an invalid value for the "value" parameter. When the value of "operator" is "=" "value" must not be null or empty.
Why is this value recognized as null?
Thank you so much!
Discussion posts and replies are publicly visible
HI, Looks like you are passing null value in your filter. Make sure to use applyWhen parameter to make it null safe.
You aren't passing a value for ri!record. Thus local!comercioId will be null in value, and thus your queryFilter will break. What were you expecting the behavior to be when ri!record has no value?
Thanks, your answer help me.