Query tool

Discussions related to custom development with Select.
Post Reply
mike.dice
Posts: 4
Joined: Mon Apr 17, 2023 12:01 pm

Query tool

Post by mike.dice »

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?
Post Reply