Finder
HelpID: 460022005
Finder is a tool for locating all tables in the GP company database that contain a specified user-entered value.
Navigation: Tools >> Utilities >> System >> Finder
Datatype: set the Datatype of the data you are searching for. Finder can search for strings, numbers and dates. Datatype also contains an option for Table Information, which is discussed further below.
Find: enter the search target. For strings Finder does a “contains” search. So if the search target is “red” is will find “Red phone” and “Blocks – Red”.
Find Button: after entering the search target click the FIND button. The first step in a search will be to locate tables that contain columns of the specified datatype. You will see the status message display “Adding….” as it locates columns & tables. When the status message displays “Searching…” the system is in the process of examining each table for the search target.
Get Table Info ( 
): Click on a row in the results, then click this button to get information about the table. The button launches Resource Explorer and executes a search for the table information the table in the selected row. See the Resource Explorer chapter for more information.
Query Table For Selected Record ( 
): Click on a row in the results, then click this button to query the selected table for the selected record. It opens the SQL Query window and automatically builds a query to return the complete record. See the Query chapter for more information.
Table Information
The Table Information query searches all installed dexterity-based modules for information about the table. In the “Find” box enter the physical name of the table (the name of the table in the SQL Server database, such as IV00101). This is the Table Name displayed in the first column of a Finder Search as described above.
After entering the SQL table name (this is case sensitive), click FIND. The results window will show the product (or products) which contain the specified table name. As shown above, Dynamics GP contains IV00101, but there are copies of it in Manufacturing and Report Scheduler.