Question
Accenture
IN
Last activity: 8 Dec 2023 0:11 EST
How to ignore case on report definition column
Hi All,
While pulling the data using report definition, I am able to get different results if the entered data has case sensitive combinations. Ex: If the data entered is abc, ABC, Abc, the report definition fetches 3 results. I want to ignore this and show only 1 result. How can I achieve this.Please note It is not a filter where I can check ignore case. It is a column. I have checked remove duplicates checkbox as well. Can somebody help me on this?
Attached the screen shot displaying results.
Thanks in advance,
Sakhib Hussain
Accepted Solution
Updated: 8 Dec 2023 0:11 EST
Rulesstack Private Limited
IN
Hi @SakhibHussain ,
Just to understand your query in a proper way, can you please let me know, why you trying to understand as a duplicate? In Db, many records may contain with same name (which also includes case sensitive). You also stated it as not to consider it as Ignore case to filter the values. I failed to catch the exact query of yours.
Accenture
IN
Hi @Mohammad Ravoof,
If you see the attachment, I just want a single result because a person will enter his name with different case and the requirement is we have to display in a dropdown only with single value. In the attachment, I want to display only as single "Sakhib" not other two.
For your question: In Db, many records may contain with same name (which also includes case sensitive)->Yes correct. I want to display the same name once(ignoring all other records)
why you trying to understand as a duplicate--> I understand it is not a duplicate but, I wanted to omit other cases. This is my requirement.
You also stated it as not to consider it as Ignore case to filter the values--> Because in filter we have already one checkbox for ignore case and not for columns.
Thanks,
Sakhib Hussain
Updated: 23 Nov 2023 0:43 EST
Cognizant Solutions
IN
Hi @SakhibHussain,
In order to achieve this you have to select Display (Top Ranked/Bottom Ranked) at the bottom of Report Definition and select Rows as 1 and select Overall give the property for which you want case sensitive to be ignored. This works.
Thanks, Deeksha MD
Accenture
IN
But this will only display very first row result if the word is same but of different case.
I agree with @Mohammad Ravoof , we should not consider the query result as duplicate and in DB many records may contain the dame name. May be I need to find some other way to display the above leave as is.
Thanks,
Sakhib Hussain