Query Problem in Siebel

(2 votes, average: 3.50 out of 5)

 Loading ...

In this post I am going to discuss the most trivial issue you might have ever heard in Siebel and most of you must be aware of the solution already.

I had been facing this issue from a long time but it is so trivial never paid attention on finding the solution. Before going into detail let me tell you the problem or issue that I am talking about.

Problem:

Let me explain this problem with help of an example. I have 4 Account records with name as “Test Account”, “Test Account 1”, “Test Account 2”, “Test Account 3”.

I want to query only for “Test Account” record. Normal Siebel behavior is to return all the records (4 in this case) with similar names if we query with term Test Account.

I tried querying with term Test Account in single quote (‘Test Account’) and also in double quote (“Test Account”) but it always used to return all the 4 records.

Solution:

Then I tried lot of combination and found that will return me only one record is as following:

= “Test Account”

When I query with an equal to sign in front of the “Test Account” it returned me only one record. Siebel has same behaviour to return all the records if we query in eScript but I have not tried this solution in eScript though.

Do you guys have anything else that works for the above mentioned problem. If yes then please do share with all.