Solved

Read Only MultiLine custom field

  • 15 May 2020
  • 5 replies
  • 285 views
B
Rank
Userlevel 3
Badge +10

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?

icon

Best answer by bhavesh 18 May 2020, 10:34

View original

5 replies

eqbstal
Rank
Userlevel 7
Badge +21

bhavesh,

You might try chr(10) in stead of chr(13).

if that doesn’t work try chr(10) || chr(13)

Steve

Please like this response if it helped you
B
Rank
Userlevel 3
Badge +10

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.

B
Rank
Userlevel 3
Badge +10

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

 

 

eqbstal
Rank
Userlevel 7
Badge +21

Good to know that it works like that. I have never used listagg before, but can see its value.

Thanks,

Steve

Please like this response if it helped you
M
Rank
Userlevel 5
Badge +10

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'

MR10, please like if it is the best answer.

Reply


Terms & ConditionsCookie settings