With WebIRC (v4.3 SP2 with Oracle 19), I want to have in the report a variable containing the list of the selected values in the prompt pop-up.

I tried this (simplified code) :

SELECT
  REFERENTIEL.CODE,
  @Prompt('Ref values ?','A',{'1040','2814','4860','8514','AL33','TY20'},Multi,constrained,persistent,) AS LIST_OF_SELECTED_VALUES
FROM REFERENTIEL
WHERE
  REFERENTIEL.CODE IN @Prompt('Ref values ?','A',{'1040','2814','4860','8514','AL33','TY20'},Multi,constrained,persistent,)

Same prompt labels (here "Ref values ?") twice, then BO will ask only once at pop-up window.

But it does not work since the @prompt(...) seems to be dynamically replaced with :

('selected value 1','selected value 2','selected value 3')

I tried also that line, but it does not work :

    Replace(@Prompt('Ref values ?','A',{'1040','2814','4860','8514','AL33','TY20'},Multi,constrained,persistent,) ,''',''', ',') AS LIST_OF_SELECTED_VALUES

Thus, how to have in the report a variable that contains all the selected value ? Be aware that all the selected values are not necessarily present in the REFERENTIEL table. Please note that my Oracle version has LISTAGG function but not CONCAT_WS.