Hi, I'm probably missing someting really obvious but I cant figure this one out.
I am connecting to an SQL server, on-premise with a gateway.
In my app I am connected to two data sources that are customer tables in two different databases on the same server.
If I have two Galleries with these two data sources:
Search('[dbo].[tblCust]',searchTerm, "OrganisationV6")
Search('[LV1_DB].[Customer]',searchTerm, "CompanyName")Then I:
UpdateContext({searchTerm:"tower"})
[dbl].[tblCust] returns results but [LV1_DB].[Customer] does not
If I do
UpdateContext({searchTerm:"Tower"})Then both return results.
It seems that the search function is case-sensitive for [LV1_DB].[Customer]
The documentation says the search function is supposed to be case-insensitive which is what I want, but I cant find a way to make it work with this table.
Could it be something to do with the delegation of the search function to the SQL server?
If so, does anyone know what I might need to change to make it case-insensitive?
