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

We are on release 7.2. Can someone give me an example of building a Select Query where using queryrecord or queryentity. We have 5 fields that may be searchable. The user can search on 1 to 5 of these fields. How is this done? So the WHERE clause will be dynamic... 1-5 fields. Thanks!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 scotte over 10 years ago

We are on release 7.2. Can someone give me an example of building a Select Query where using queryrecord or queryentity. We have 5 fields that may be searchable. The user can search on 1 to 5 of these fields. How is this done? So the WHERE clause will be dynamic... 1-5 fields. Thanks!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data