on 08-03-2009 5:47 AM
Hi,
I have table customer and I need to search for a value which may exits in Field1 or Field2. So is there any way to search the record in a single search, insted of searching for a record with the value existence in field1 if not again researching the
field 2
Regards,
Sandeep Reddy.
Hi Sandeep,
Yes there is a way to do this, try the below:
Add the search items for both the fields (fld 1 & fld 2) in the Search object that you pass to RetrieveLimitedRecordsCommand.
Once the search items are added to the Search Object, you can set the Comparison Operator to (OR) and it will check the value in the fields and if found in any one of them it will return the result.
objSearch.setComparisonOperator(Search.OR_OPERATOR);
Hope this helps!!
Cheers,
Arafat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.