data-api-builder icon indicating copy to clipboard operation
data-api-builder copied to clipboard

Provide case (in)sensitive filtering through collations

Open gledis69 opened this issue 3 years ago • 2 comments

The task is discussed here: https://github.com/Azure/project-hawaii/issues/11#issuecomment-1055396030

To achieve this we need to:

  • know what collation a column is (and account for keeping this information up to date if the user can change it)
  • know the equivalent collation of the existing collation which will provide case sensitive or insensitive comparison.
  • make sure that the abovementioned equivalent collation exists / is recognized by the db (or if it doesn't exist, we error out)

gledis69 avatar Mar 09 '22 20:03 gledis69

All special case naming features (like aliasing or formatting column names to be GraphQL best practice) moved to Mar2023

Aniruddh25 avatar Nov 04 '22 21:11 Aniruddh25

Hi @Aniruddh25, as this was planned for March 2023, how can the filter be adjusted to be case sensitive or insensitive?

itpropro avatar Oct 02 '24 15:10 itpropro