Question

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

  • 8 April 2022
  • 6 replies
  • 248 views
Link
Rank
Userlevel 7
Badge +22
  • Link
  • Superhero (Customer)
  • 949 replies

Dear community,

it is possible to use a custom field as variable in another custom field?

The argument v.cf$_c_inventor_part is already a custom field. Now I want to use it another custom field to get the description.

 

Thank you.

Kind regards

6 replies

Ozgun BAL
Rank
Userlevel 4
Badge +8

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

AveTonitM
Rank
Userlevel 3
Badge +8

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. 

-Toni-
Link
Rank
Userlevel 7
Badge +22

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

Kind regards
ZTC ZTC JGOTA
Rank
Userlevel 6
Badge +14

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

 

JL
S
Rank
Userlevel 6
Badge +12

@Link 

Hi Link,

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

 

Regards,

Sahan

Link
Rank
Userlevel 7
Badge +22

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

 

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

Kind regards

Reply


Terms & ConditionsCookie settings