Skip to main content
Solved

LISTAGG in a custom field

A
Do Gooder (Customer)
Forum|alt.badge.img+6

Hi Community,

we manufacture our products in different steps. We have several production orders for this. If there are special features, these are stored in a note field of a production order. In order to see this information in all production orders of a product, I wanted to create a CF and combine and display the different information with LISTAGG. However, when syschronising, I get the error that no data is found (ORA-01403). Is it possible to use the LISTAGG function in CFs at all?

 

Regards

André

Best answer by InfFilipV

Hi @Andre Martin,
are you sure about that parameter? I think it should be v.CF$_NORDERNO.
Also try use :p1 instead of :CF$_NORDERNO (that prefix or $ could make some difference)
Or maybe should be better do reference via rowkey on LU where you are creating CF.

select LISTAGG(so.X) within group (so.Y) from view so where so.Y = (select a.Y from CURRENT_LU_CFV a where a.objkey = :rowkey)

with parameter t.rowkey or v.objkey
BR
Filip

View original
Did this topic help you find an answer to your question?

6 replies

InfFilipV
Hero (Partner)
Forum|alt.badge.img+12
  • InfFilipV
  • Hero (Partner)
  • 225 replies
  • June 2, 2022

Hi @Andre Martin,
yes ListAgg is allowed.


Read Only MultiLine custom field | IFS Community


Unfortunately debugging of CF creation is quite complicated.
Do you use v and t aliases properly?

BR
Filip

Filip | Developer | InfoConsulting.com
A
Do Gooder (Customer)
Forum|alt.badge.img+6
  • Andre Martin
  • Author
  • Do Gooder (Customer)
  • 9 replies
  • June 2, 2022

Hi @InfFilipV ,

 

thank you for your quick answer.

I hope that I use the aliaes right.

 

In PL/SQL Developer it works well.

André

InfFilipV
Hero (Partner)
Forum|alt.badge.img+12
  • InfFilipV
  • Hero (Partner)
  • 225 replies
  • Answer
  • June 2, 2022

Hi @Andre Martin,
are you sure about that parameter? I think it should be v.CF$_NORDERNO.
Also try use :p1 instead of :CF$_NORDERNO (that prefix or $ could make some difference)
Or maybe should be better do reference via rowkey on LU where you are creating CF.

select LISTAGG(so.X) within group (so.Y) from view so where so.Y = (select a.Y from CURRENT_LU_CFV a where a.objkey = :rowkey)

with parameter t.rowkey or v.objkey
BR
Filip

Filip | Developer | InfoConsulting.com
A
Do Gooder (Customer)
Forum|alt.badge.img+6
  • Andre Martin
  • Author
  • Do Gooder (Customer)
  • 9 replies
  • June 2, 2022

Hi @InfFilipV,

i changed my statement and now it works, but it is too slow in that LU. 🙄

 

Thank you for your support.

André

InfFilipV
Hero (Partner)
Forum|alt.badge.img+12
  • InfFilipV
  • Hero (Partner)
  • 225 replies
  • June 2, 2022

Hi @Andre Martin,

rewrite that Get function to subselect, it shall speed up it little.

Filip | Developer | InfoConsulting.com
A
Do Gooder (Customer)
Forum|alt.badge.img+6
  • Andre Martin
  • Author
  • Do Gooder (Customer)
  • 9 replies
  • June 3, 2022

Hi @InfFilipV ,

in this case is “a litte” not enougt. 😏

Thank you and regards

André

Reply


Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings