I have a myssql table in which I have also a field named “is_active” that can be 0 or 1. When its value is 1 I want to display values in select of add form and also o list page filter. I manage to solve it for add page but don t where to set/ place the code in order to be displayes only values that have “is_active” = 1
You may check page ID in your filter expression, e.g.
CurrentPageID() == "add" ? "my filter" : ""