Alternative of IN keyword of SQL in Siebel Server scripting for search spec?

Question

Does anyone know how can we filter BC results based on multiple values in search specification? As IN keyword in SQL ? something like:

bc.SetSearchExpr("[Id] in ('a','b','c')");

Or use of OR operator is the only solution?

score 3 · Accepted Answer · answered Jun 10 '15 at 08:52

No, you can't use IN in Siebel, it's not a valid search operator. But at least, you can simplify your expression by using a search specification instead of a search expression. These two lines do exactly the same:

bc.SetSearchExpr("[Id]='a' or [Id]='b' or [Id]='c'");

bc.SetSearchSpec("Id", "='a' OR ='b' OR ='c'");

Note that you can't use both SetSearchSpec and SetSearchExpr methods simultaneously.

score 0 · Answer 2 · answered Jun 10 '15 at 05:43

0

You can use OR like this:

bc.SetSearchExpr("[Id] = 'a' or [Id] ='b' or [Id] ='c')");

but I think using IN is better than using OR.

Other than using IN or OR you dont have any option.

answered Jun 10 '15 at 05:43

Rahul Tripathi

168,305
31
280
331

So, `IN` keyword can be used in Siebel like I wrote ? – Reminisce Jun 10 '15 at 05:47
Siebel didnt recognize `IN` keyword in this function :( – Reminisce Jun 10 '15 at 05:54
@Reminisce:- Did you try using the OR query which I wrote? – Rahul Tripathi Jun 10 '15 at 05:55
`OR` works, I mentioned it actually in my post. The reason I don't want to use it is, it requires copying the field name everytime for different values. So I was just asking is there a way to avoid this duplications. – Reminisce Jun 10 '15 at 05:56
1

@Reminisce:- I am afraid that there is no IN statement in Siebel. You have to use the OR. – Rahul Tripathi Jun 10 '15 at 06:08

Alternative of IN keyword of SQL in Siebel Server scripting for search spec?

2 Answers2