Skip to main content
Solved

How could I get or build the SQL that run for the Shop Order Work In Progress?

  • December 3, 2021
  • 1 reply
  • 195 views
ZTC ZTC JGOTA
Hero (Customer)
Forum|alt.badge.img+14

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

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

JL
Darshana Herath
Asela Munasinghe
This topic has been closed for replies.

1 reply

Kasun Balasooriya
Superhero (Employee)
Forum|alt.badge.img+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

Kasun B - https://www.linkedin.com/in/kasunbalasooriya/
AvinduHendawitharana
Darshana Herath
ZTC ZTC JGOTA
Terms & ConditionsCookie settingsAccessibility statement