Skip to main content

dear all,

i want to create new field in ifs10. how can i revised below query for read only select expression,

 

SELECT ipis.QTY_ONHAND - ipis.QTY_RESERVED eldeki_miktar fROM PURCHASE_ORDER_LINE_ALL pola RIGHT JOIN INVENTORY_PART_IN_STOCK_UIV ipis ON ipis.project_id = pola.:project_id AND ipis.part_no = pola.:part_no and ipis.activity_seq=pola.:ACTIVITY_SEQ and ipis.CONTRACT=pola.:CONTRACT 

 

ps: Below is the screen where I will make this development.


 

@sevo You can add a Read Only custom field as follow

 

Query is modified to

SELECT sum(x.QTY_ONHAND - x.QTY_RESERVED) FROM INVENTORY_PART_IN_STOCK_UIV x WHERE x.CONTRACT=:SITE AND x.ACTIVITY_SEQ=:ACTIVITY_SEQ AND x.PART_NO =:PART_NO

The output of the custom field

Records in Inventory Part in Stock

Hope this helps !

@sevo You can add a Read Only custom field as follow

 

Query is modified to

SELECT sum(x.QTY_ONHAND - x.QTY_RESERVED) FROM INVENTORY_PART_IN_STOCK_UIV x WHERE x.CONTRACT=:SITE AND x.ACTIVITY_SEQ=:ACTIVITY_SEQ AND x.PART_NO =:PART_NO

The output of the custom field

Records in Inventory Part in Stock

Hope this helps !

thank you so much for the help. 

@sevo you are welcome and if you need to find out how to refer the values of the view in the sql query, check the following

 

Reply


Terms & ConditionsCookie settings