Grooper 21.00.0082 is available as of 12-12-2023! Check the Downloads Discussion for the release notes and to get the latest version.
Grooper 23.1.0016 is available as of 03-15-2024! Check the Downloads Discussion for the release notes and to get the latest version.
Grooper 23.00.0042 is available as of 03-22-2024! Check the Downloads Discussion for the release notes and to get the latest version.
Database lookup
DungVu
Posts: 88 ✭
Currently we have an issue to get supplier information from database lookup due to supplier name from invoice does not match exactly with database and some of the supplier has multiple address in database. Is there a way we can do the lookup the database using 2 parameters such as supplier name and address?
0
Best Answer
-
RandoCalrisian Posts: 195 adminIn Grooper 2.8, lookups are now done on the Data Model. Click the Lookups property and click the ellipsis button. On the Data Model and in the Lookups Specification Collection Editor window, Add a Database Lookup. From there, point it to an established database connection, and this will expose the SQL Query property. From there you could add a query like:
SELECT * FROM table_name WHERE (Parameter01=@Param01) AND (Parameter02=@Param02)<br>
Be sure to observe the help documentation on these properties and in the SQL Query window for more information. Let us know if something in that documentation is lacking or could be improved.
Randall Kinard
rkinard@bisok.com5
Answers