We have a need to do a select query. The "WHERE" of the SQL statement

scotte over 10 years ago

We have a need to do a select query. The "WHERE" of the SQL statement will need to be dynamic.The reason is that this is a "search" that our users are doing. They may select to search on 1 to 5 fields. In other words, the columns in our where clause will vary depending on the user situation. When using the Query Database smart node, we are struggling to find a way to accomplish this. Is there a way to get this done? Thanks!...

Discussion posts and replies are publicly visible

Parents

0 scotte over 10 years ago

Yes, that is what we thought. But when we put in a % as a value, you only get returned records that have something in that field. Try it yourself? So if I have 10 records and 3 of the records Last_Name is null and WHERE FIRST_NAME LIKE ac!acFirstName and acFirstName has a value of % I only get 7 records returned. I should get all 10?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 scotte over 10 years ago

Yes, that is what we thought. But when we put in a % as a value, you only get returned records that have something in that field. Try it yourself? So if I have 10 records and 3 of the records Last_Name is null and WHERE FIRST_NAME LIKE ac!acFirstName and acFirstName has a value of % I only get 7 records returned. I should get all 10?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data