Query tool
Posted: Mon Apr 17, 2023 2:56 pm
Hi - my client would like me to write a query tool that queries Softpro data for a set of fields that are of interest to them. Example: Select all users who's SSN is 'xxx-xxx-xxxx' OR(lastname contains 'doe' and 'firstname' contains jane')
I want this query to run from a service process and I will assign the user ID to the process.
From reading the SDK docs it looks like maybe Lookup Tables? I could create a table that does the query I want and then just run that query from my service process using the SDK? What are the suggestions from the experts?
I want this query to run from a service process and I will assign the user ID to the process.
From reading the SDK docs it looks like maybe Lookup Tables? I could create a table that does the query I want and then just run that query from my service process using the SDK? What are the suggestions from the experts?