APEX

Oracle APEX 24.2.5

I have an hierarchical query listing documents. Each level 2 document type is indicated by a prefix of ‘ - ’ and looks like this:

          SELECT DECODE (LEVEL, 2, c.description, ' - ' || c.description) AS display_value,
                 c.code_id AS return_value  
            FROM WKSP_AFPLAYS.code_list c
           WHERE LEVEL > 1
      START WITH code = 'IDENTITY_DOCUMENT_TYPE' AND parent_code_id IS NULL
      CONNECT BY parent_code_id = PRIOR code_id
ORDER SIBLINGS BY c.description

This is clunky and it doesn't look great and I am trying to ‘indent’ the level 2 value instead.

I understand that the Select List / Popup LOV components always renders the LOV entries as plain text, so HTML entities like nbsp ; or &#160 ; are escaped automatically. So I cannot use HTML-based indentation.

Any suggestions that doesn't require using the legacy LOV or a plug-in?

Thank you