Help Center
Table of Contents
< All Topics

How do I search in TGP Resources?

In order to search in TGP Resources for all information about a field as well as its SQL code, follow the following guide.

STEP 1:

In the search box: enter either the table name or the physical name. Then, click the blue physical name to see the details.

STEP 2:

The system will display all the field names with display names, data type, size, and the possible values.

STEP 3:

Click on Show SQL and the window will transform to show you an SQL Statement with translated names and possible values calculated. It also converts Account Indexes to account numbers and names, and Note Indexes to text.

~ Oate: Feb : SQL Select table 101 , trE%YPE , CA ! IIEHrYPE ELSE , )• DECPLQrY ce(DECPLQTY,ø))) , | Index) Shipping

STEP 4:

Press the Preview button to see a limited dataset using the new column names. Export to SQL and Create an SQL View, or copy the statement to the clipboard.

Keep an eye on our social media for updates on changes coming to TitaniumGP. We hope to see you!

link to LinkedIn
link to Facebook
link to Twitter
link to Instagram
Previous How do I activate TGP Resources?
Categories