Community_Admin
04-17-2023Admin
Status:
Needs Votes & Comments
Apply case-insensitivity option across all custom queries
**Please note this idea was migrated to the Product Feedback Forum from older submission areas**
Custom queries are case sensitive by default. There are workarounds possible, but are just not productive. Every custom query requires something similar to the following:
LEFT JOIN [MedStorageUsers] mu ON upper(mu.UserID) = upper(c.UpdatedBy)
I want a global option in Sisense to automatically add tags that makes all custom queries case-insensitive