Skip to main content
Solved

Which SQL Table for Any Form?

C
Do Gooder
Forum|alt.badge.img+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

Best answer by Shan Peiris

Hi @Craig_IFS8_to_Cloud 

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

 


 

Thanks & Regards
Shan

View original
3 Attachments
Kishanth Prabakaran
S
Ragul Ravindira
3 people like this
  • Kishanth Prabakaran
    Kishanth Prabakaran
  • S
    Shageesha Prabagaran
  • Ragul Ravindira
    Ragul Ravindira
Did this topic help you find an answer to your question?

2 replies

S
Hero (Employee)
Forum|alt.badge.img+9
  • Shan Peiris
  • Hero (Employee)
  • 79 replies
  • Answer
  • January 3, 2023

Hi @Craig_IFS8_to_Cloud 

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

 


 

Thanks & Regards
Shan

S
1 person likes this
  • S
    Shan Peiris
C
Do Gooder
Forum|alt.badge.img+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.

 

M
Mark_Braun
2 people like this
  • M
    Michael.Biermann
  • Mark_Braun
    Mark_Braun

Reply


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings