Which product are you using ? IFS Cloud ? Apps 10 ? Apps 9 ?

Typically if your Entity (Cloud) or Logical Unit (Apps) is enabled for custom fields, you can just configure it to add either a persistent or read only custom field.

Here’s a video on it for Cloud.

Hi,

I use Apps 9 and I created both of them. I writed a select statement use dual but this field look empty on screen.

ok couple things, first if all if you “add” a custom field to a page or table, you always need to refresh the screen to get it to actually populate data.

I assume you’ve already done that, in which case:

1. Can you please share the select statement you wrote for the custom field
2. If you execute the same code in PLSQL Developer, do you get any results?

Select ‘INFORMATION

1-You must careful to fill up to data

2-Read the instruction …….. ’ from dual;

When I run this code in PL/SQL, I saw data, but custom field don’t show this data.

and I try this method,

But also static value is not working :(

@SimonTestard Hi,

I used where statement in view with adding information statement then is working.

You wouldn’t use an expression to return data from dual.

Not sure what’s missing from your select statement but why does it start with a “-” ? on the second screenshot.

Right now you’re retrieving any sort of data (the red obscured stuff) from a view (TRFIM_IZLNER) based on the bind variable izin_talep_no. If there isn’t any data in with that field in the table, it won’t return anything, that’s not the same as doing from dual.

(Also if there is multiple rows with that same IZIN_TALEP_NO, it’ll return multiple rows for subselect and won’t work either)

I understand that an expression not return data from dual for this reason I should find another way to do this then I tried Static Value area but this also not working.

Later I write a select statement ,This has solved my problem for now, I can't think of anything else.

and another thing information message same each rows so this select statement return same data each row.

well yeah , if you do a select from dual, it will only return static information unless you somehow use other APIs and bind variables.

What’s the problem with returning static data? The example message you gave is returning static data so I’m not clear on the use case and what you’re trying to achieve here.