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
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?