Skip to main content

Hello IFS Community,

 

Could I get the SQL or any idea to build the logic to create the SQL behind the report on the Screenshot? 

 

We are using IFS 9

Hi,

 

You can query the report definition window to get the report view/ID. For this report it’s SHOP_ORD_WIP_REP.  You can check the view definition from the view SHOP_ORD_WIP_REP. 

However, for a report view, if you want to check the report method, you have to remove the _REP of the report view and use RPI instead. For this report, it’s SHOP_ORD_WIP_RPI

Hope this answers your question. 

 

Thanks,

Kasun