Skip to main content
Question

Get data from multiple tables

  • July 19, 2017
  • 0 replies
  • 72 views
I am creating the report to extract the data from multiple tables. Now i just need the data from a  table which i am not able to figure out.
I have 4 tables Order, Shipping, transactions and numbers
relation is 
order < shipping < transactions > numbers  (1 order has many shipping , 1 shipping has many transactions, 1 number has many transactions)

i want to get the related data from numbers in order table 
how can i do it?
    This topic has been closed for replies.

    Can you clarify?

    What if there are 10 transactions and each one comes from a different number. What data are you needing to get up to the Order.  How do we know from which number to pull from?
    You can use api_genResultsTable and <ifram> tag to set an html page and add report from whatever table you want.
    Terms & ConditionsAccessibility statement