I have a client list database query that works fine without an parameters or filter.
However, when i add a condition to the query like ‘firstname contains’ i get an issue with the database query running.
here is a screenshot of what i have
Here is the Query setup
here is the output when i test it
here is the link to the query
http://mymondaymorningcoffee.com/dmxConnect/api/client_list.asp
Hi,
Try enabling the DEBUG option in the query and then run the query you see in output, directly on the DB.
Also, please share the observations here.
Well you have entered a filter for your query tgg he at points to a get parameter “filter”
So the database is filtered by that value and records found are returned.
When you just run your server connect action and you don’t specify filter as query param- it gets a filter value of empty so you are searching for empty records and you don’t have those so nothing is returned.
Either give the filter a default value or make it a conditional so when it is empty it just don’t get used.
Use the condition option in the query builder. Select the same GET variable you are using as a filter value. This way the filter will be applied only when the GET variable has a value:
Teodor…that is exactly what was needed - Thank you
