How to utilize Table Finder (a eOne’s SmartList Builder functionality).
Initial ConditionsPrerequisites
SmartList Builder would need to be installed to utilize Table Finder. It is highly recommended to utilize SmartList Builder as it allows you to easily build custom reports.
...
3. Selecting the Create SmartList button, would create a SmartList pulling all the fields in the selected table.
Example:IRGNPurchCtrWORK table selection shown from the screenshot, the SQL Script is defined as: select * from “selected table”. (* meaning “all”)
This functionality is not recommended for use with Report Windows. Reports utilize TEMP tables and require you to enter information to print the report. TEMP tables are not recommended for building SmartLists.