Hi,
I am using interactive grid to display data from table. I am facing a rather interesting issue. I created my IG using a simple select SQL query. One of the columns (Highlighted in screenshot) in the table has data with trailing space in it. So, when data is displayed in the application it shows multiple rows of the same data even though the table has only one row of data. If I run the query separately in SQL commands, I get data with only one row and not multiple rows of same data. If I remove the trailing space from the data, this issue is resolved.
I am unsure if this is some kind of bug, or I am making a mistake in my query.
If anyone has faced this issue or has any idea regarding this, please advise or suggest what I can do.
I am using Apex Version 23.1.
Thanks & Regards,
Rohit