function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
lpadminlpadmin 

Multiple Search String Criteria

The following code was provided to allow us to put a users' cases on their home page however we need it to list only "Open" cases.
Not beinga programmer was wondering if someone could update provide additional criteria of only open cases?
 
Code snippet in question.
var SearchString="Select Id, OwnerId,CreatedDate, Status, CaseNumber, Priority, Type from Case";
SearchString = SearchString + " Where OwnerId = '" + ThisUser + "'"
 
Any assistance would be appreciated.
Thanks
NaishadhNaishadh
hope this will help

 Select Id, OwnerId,CreatedDate, Status, CaseNumber, Priority, Type from Case  where OwnerId = 'xxxxxxxxxx' and  Status = 'New'
lpadminlpadmin
Outstanding. I appreciate the assistance greatly.