I have a read only multiline text field (4000). The query to show data in this screen is something like this
select listagg(t.CF$_field1 || ' - ' || t.CF$_field2, CHR(13)) within group(order by cf$_part_no, cf$_site)
from table_clv tThis will show field value in a each separate line if I copy the result to notepad++, however the custom field on the screen does not show in separate lines
Notepad++
1233 - some test
1265 - adfadf
Ifs shows below
Is there any way to solve this problem?
Best answer by bhavesh
I have just got this resolved using
select listagg(t.CF$_field1 || ' - ' || t.CF$_field2 || CHR(13), CHR(10)) within group(order by cf$_part_no, cf$_site) from table_clv t
+21bhavesh,
You might try chr(10) in stead of chr(13).
if that doesn’t work try chr(10) || chr(13)
Steve
I have tried both char(10) and char(13) plus concatenated both, but still IFS textbox does not show seem to show line feed and carried returns.
I have just got this resolved using
select listagg(t.CF$_field1 || ' - ' || t.CF$_field2 || CHR(13), CHR(10)) within group(order by cf$_part_no, cf$_site) from table_clv t
+21Good to know that it works like that. I have never used listagg before, but can see its value.
Thanks,
Steve
Used it on an information card on the customer, seeing the companies where the customer is active for.
Select LISTAGG( COMPANY ||' - '|| COMPANY_SITE_API.Get_Description(COMPANY),' # ') WITHIN GROUP( ORDER BY t.COMPANY) COMPANY
from IFSAPP.IDENTITY_INVOICE_INFO t
where t.IDENTITY = :CUSTOMER_ID and PARTY_TYPE = 'Customer'
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
