Oracle Database String Handling

0
Hello Makers, In one of my projects, I am using oracle as my database. In a datagrid I have put an xpath condition [UserId != empty and UserId != ‘’]. When I am using this constraint, the data grid does not show any record even though there are records with UserId filled in. When I use UserId != empty or when I only use UserId != ‘’ then in that case, records are visible in the data grid. And also different records are retrieved for the both the conditions(with more number of records for condition UserId != empty). Not sure how the conditions are processed. And this is the case only when I am using oracle as database. For postgre sql the condition works perfectly fine. Does anyone have any explanation for this behavior?
asked
1 answers
0

Weird stuff, i'd create a support ticket for this if i were you.

answered