Operational Report Parameter - Select Value From Dropdown Hey all,We are creating an operational report where one of the parameters is “Org Code” (field ORG_CODE from CompanyOrg LU). We would like the parameter to display existing Org Code values in the dropdown.We have examples of showing a list of values in the dropdown when an Enumerate method can be called from a Package API. For example, we get values in the list if we link the parameter to something like Pur_Order_Print_Option_API.Enumerate(). The dropdown then looks like this: So, we know it can be done. But we cannot find a enumeration method for Org Codes. As far as we can tell, the enumerated list is simply values with the “unit separator” character (CHR(31)) after each value. I can generate such a string with the query: SELECT OrgCodeEnum FROM (SELECT Company_Id, LISTAGG(Org_Code, CHR(31)) WITHIN GROUP (ORDER BY Org_Code) AS OrgCodeEnum FROM Company_Org GROUP BY Company_Id) WHERE Company_Id = '01' Love me some LISTAGG(). But how do we do a manual query such as
