ddichev
Member
Hello
I have a UBE in which the data selection requires the LT column from a business view to be equal to "AA" (not equal to or empty or anything else, just "equal to"), but I was getting other entries as well, so I went on to check the SQL query that is generated on execution, and and the part about the LT column is wrong - instead of LT = :Key3 (the Key3 being "AA" in this case), I get LT = :Key3 OR LT = NULL. Why does it accept the null values, when I explicitly tell it to only look for a certain value? Is there a particular reason for this behavior, or is it some sort of bug? Any help will be appreciated.
I have a UBE in which the data selection requires the LT column from a business view to be equal to "AA" (not equal to or empty or anything else, just "equal to"), but I was getting other entries as well, so I went on to check the SQL query that is generated on execution, and and the part about the LT column is wrong - instead of LT = :Key3 (the Key3 being "AA" in this case), I get LT = :Key3 OR LT = NULL. Why does it accept the null values, when I explicitly tell it to only look for a certain value? Is there a particular reason for this behavior, or is it some sort of bug? Any help will be appreciated.