Hi!
Why if I use such search form I get all BOs that exists instead that contains values that entered, even if I enter value that is not existing.
The rule of query is:
FIND BO WHERE TO_LOWER_CASE(BO.Client.EmailAddress) CONTAINS TO_LOWER_CASE(?'Email') OR TO_LOWER_CASE(BO.Subject) CONTAINS TO_LOWER_CASE(?'Subject') OR TO_LOWER_CASE(BO.Surname) CONTAINS TO_LOWER_CASE(?'Surname')
When
TO_LOWER_CASE(BO.Client.EmailAddress) CONTAINS TO_LOWER_CASE(?'Email')
is removed - it works.
When TO_LOWER_CASE is not used with (BO.Client.EmailAddress) and (?'Email')- it works also.
When
TO_LOWER_CASE(BO.Client.EmailAddress) CONTAINS TO_LOWER_CASE(?'Email')
is used alone it works also.
Then I added more conditions with TO_LOWER_CASE and it now doesnt work also even if I remove "TO_LOWER_CASE(BO.Client.EmailAddress) CONTAINS TO_LOWER_CASE(?'Email')"
