Hi there,
I need to do the following search in a contact table.
Ex: Find records where country not equals Hong Kong and not equals Singapore and but contact_type is member.
How do I do this search in Servoy find mode.
Your help would be greatly appreciated.
Thanks
Unless it clashes with the way you have built your database, you could try doing it with SQL, i.e. databasemanager.getDataSetByQuery.
Some databases allow you do set operations as part of the query, so you can do something like
SELECT pk WHERE countrycode NOT IN (‘HK’,‘SG’) AND etc…