Solved

Which SQL Table for Any Form?

  • 3 January 2023
  • 2 replies
  • 207 views
C
Rank
Userlevel 2
Badge +2

Hi,

I work in the Management Information Systems Team an I often get asked to write a custom report in SQL based upon the screen that a User is looking at.

 

For example, looking at the Customer Form in IFS Cloud:

1. IFS Cloud Web Front End - Customer.png

How is possible to see which SQL Table is used in that Form?

 

I happen to know the answer to this particular question, it’s CUSTOMER_INFO_TAB:

2. SQL Developer Oracle Query.png

 

because it used to be easy to look at the IFS 8 Windows Form - System Info tab for which it tells me uses the CUSTOMER_INFO View and I can explode that to find the CUSTOMER_INFO_TAB Table:

3. IFS8 Customer Windows Form - System Info.png

 

How can I most easily find  which SQL Table is behind any Web Form I look at?

 

Thank you in advance.

 

Craig

UK

icon

Best answer by Shan Peiris 3 January 2023, 23:25

View original
3 Attachments

2 replies

S
Rank
Userlevel 5
Badge +9

Hi @Craig_IFS8_to_Cloud 

You can use Debug Console to find SQL view, which is behind Web Form as follows

 


 

Thanks & Regards
Shan

C
Rank
Userlevel 2
Badge +2

Shan,

 

your title of “Hero” does you justice :)  Thank you!

 

I’ll elaborate a little as I’ve just checked a number of other Forms which I’d been asked about to check the method and there is a standard pattern which you’ve correctly shown.

 

Whatever the Entity is: “CustomerInfo” or “InventoryPartInStock” or “IdentityInvoiceInfo”...

separate the words with underscores and run the equivalent search:

 

SELECT * FROM ALL_VIEWS WHERE VIEW_NAME = 'CUSTOMER_INFO'

or

SELECT * FROM ALL_VIEWS WHERE VIEW_NAME = 'INVENTORY_PART_IN_STOCK'

or

SELECT * FROM ALL_VIEWS WHERE VIEW_NAME = 'IDENTITY_INVOICE_INFO'

 

and extract the TEXT from the result.

 

Brilliant.

 

Reply


Terms & ConditionsCookie settings