I have a named query that works fine in testing but does not work with binded variables on the view.
When I look at the table binding, it shows the named query without the passed in parameters.
Is there any way to see what the query being run is with my parameters to help troubleshoot whats going on?
show us the names query and the binding and we might be able to spot the issue. Unless you add a transform that logs the data before the query its a little hard. What does it show in the binding preview in the designer?
I just figured it out, I have an integer column in the database I am querying but on the view I didn’t want to use a numeric entry as it has to always have a value (0 when not entered). So I used a string entry and when that was empty, it was not null but an empty string.
For some reason, the named query was requiring that if the integer column is left empty, it must be NULL, empty string was coming in as a value and it couldn’t be found. To get around it, I created a custom property on the text entry for when the text is empty, return NULL, else its the entered number. That got it working.
It was working fine before we upgraded to 8.3 so I am assuming something must have changed with the way named query parameters get expressed. Thanks