Hello, i have the next problem, so if anyone can help, it would be much appreciate it, thanks in advance.
I was trying to create and interactive grid with two Popup LOV columns, that consumes an ORDS, in which two of the columns are Listagg (List aggregations), with id's concatenated with the colon(:) separator both for the Popup LOV and the Listagg; but i am facing the next issues:
On one side, when i get the data on the Popup LOV column and before clicking one specific row of this column, i get the id's concatenated the same way i have them in the Listagg (in my SQL Developer DB, with the colon separator), not getting the names related to that id's, even though the Popup LOV is consuming a LOV with the return attribute as an id and the display attribute as a name (the LOV that consumes the Popup LOV and the GET operation from the ORDS that consumes the interactive grid and show the information, it is from the same class/object in the column of the grid and in the LOV, so it is not a problem of types or something like that); and when i click on this cell and go to another cell then the Popup LOV shows the separator as a comma and if i click again on this cell instead of showing the elements as separated items(item1 item2) , it shows them as something like this 1:2(one item) 2(other item) and when i go to another cell it shows a comma between this two "new malformed" items.
I have solved this strange separation using comma as the separator both in the Listagg and in the Popup LOV, showing 1, 2 in this case, but either way it is no turning the id (the return value of the LOV) to a name (the display value of the LOV). I think the problem has to do with the integration of the Popup LOV inside the interactive grid, because when it has/consumes(from the GET operation from the ORDS) just one id, it transform it to a name.
On the other side if i use the shuttle that uses a colon (:) as default (you don't have an option to change this separator) and i use a colon too for the Listagg, it works properly on the interactive grid, so i think there is an issue with using the Popup LOV inside an interactive grid (consuming multiple values from an ORDS) because it is not transforming more than one id to a name, so i think there is a problem with the Popup LOV component itself, that tries to transform the varchar2 from the Listagg; first it tries to separate the id's in varchar2 and quit the colon/comma and use the "to_number" operation(operation that the interactive grid is making not work with more than one id in the Listagg of id's) to compare them with the id's stored in the LOV that the Popup LOV is consuming as a shared component.