How to use a custom field as variable in another custom field

Dear @Link ,

Maybe you can try;

select cf$_c_inventor_part from inventory_part_cfv where v.contract=:contract and v.cf$_c_inventor_part=:part_no

Kind Regards

Ozgun Bal

Hi @Link ,

You need to modify the select statement so that, instead of using “from dual” you base the select statement to use the view ending with _CFV, where the custom field CF$_C_INVENTORY_PART column is available.

For example:

select 

IFSAPP.INVENTORY_PART_API(:CONTRACT, :CF$_C_INVENTORY_PART)

from INVENTORY_PART_CFV

I’m puzzled about how this is done in IFS Cloud and Aurena GUI. Any insights would be highly appreciated. 

Hi @AveTonitM , hi @Ozgun BAL 

thank you all at first.

Then I need a select statement like this:

select description from ifsapp.inventory_part
where part_no = :cf$_c_inventor_part
and contract = :contract

I want to fetch the description form the inventory_part view. The screen where I want to put it in has the field Inventory Part (also custom field). Now i want to use thís field as a argument to get the description.

But I get this error message:

Thank you

Hello @Link 

Why you do not use the API function created in the page where you created the custom field?

you can call the API for the custom field. 

You can pass the API function as a parameter as well and you can “Expression” to just write the PLSQL code.

Thanks,

JL

@Link 

Hi Link,

Can you try the settings like below .(Use a expression) 

Regards,

Sahan

Hi @ZTC ZTC JGOTA 

in this case the API function will work if I use the expression:

But what if an API doesn’t exists?

Thank you