Description |
When the user tries to filter status column in contract sequence screen with all lower case value(unconfirmed) at that time filter is not returning any data but when using filters with Unconfirmed at that time search screen is showing data.
This happened due to to the collation of the status column is SQL_Latin1_General_CP1_CS_AS
It is a computed column in the view due to that its collation is SQL_Latin1_General_CP1_CS_AS
Use the below query find out the collation difference.
select DISTINCT TABLE_NAME from INFORMATION_SCHEMA.COLUMNS WHERE COLLATION_NAME = 'SQL_Latin1_General_CP1_CS_AS' AND (TABLE_NAME LIKE 'vyuLG%' OR TABLE_NAME LIKE 'tblLG%')
|