Skip to main content
Solved

How to database column names for writing reports easily

  • January 27, 2025
  • 1 reply
  • 29 views

Forum|alt.badge.img+8
  • Sidekick (Customer)
  • 76 replies

We’ve recently moved to cloud and I’m struggling writing a new report based off of customer order lines. Back in IEE, there was a “system information” tab at the bottom that told the admins what the sql column names were. Does this exist in any form in cloud?

If not, what is the easiest way for me to figure out the the database names for the columns displayed? A good example of this is QTY_ASSIGNED. The column names don’t match what they are in the database therefore if I was brand new, I wouldn’t have any idea that QTY_ASSIGNED is the “Reserved QTY” and I haven’t found an easy way to figure this out in the application.

 

Best answer by Tracy Norwillo

@Anna  You could use the Page Designer to view the attribute.  Or you could connect to the Build Place database with an SQL tool and view the objects there.

 

View original
Did this topic help you find an answer to your question?

1 reply

Forum|alt.badge.img+14
  • Hero (Partner)
  • 179 replies
  • Answer
  • January 28, 2025

@Anna  You could use the Page Designer to view the attribute.  Or you could connect to the Build Place database with an SQL tool and view the objects there.

 


Reply


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