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
Best answer by Kasun Balasooriya
View original
How could I get or build the SQL that run for the Shop Order Work In Progress?
Userlevel 6
+14
This topic has been closed for comments
Userlevel 7
+20
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.