Skip to main content

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 t

This 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?

bhavesh,

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

 

 

Good 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'

Reply


Terms & ConditionsCookie settings