Understanding the Search Results

the return value of the search web method is a list of webservicebusinessobject objects in a two dimensional array the previous section provided simple search examples, where the records were returned against a single business object when performing searches against the current object and related objects, each item in the two dimensional array represents the matching parent child combination this section contains the following topics search result scenarios docid\ fk2go6ofqplvvovxpbo7nrelated search examples docid\ fk2go6ofqplvvovxpbo7ngrouping the rule criteria docid\ fk2go6ofqplvvovxpbo7nabout full text searching docid\ fk2go6ofqplvvovxpbo7nformal description of the classes used by the search web method docid\ fk2go6ofqplvvovxpbo7n search result scenarios scenario 1 searching against a single business object, returning an exact match docid\ fk2go6ofqplvvovxpbo7nscenario 2 searching against a single business object, returning several matches docid\ fk2go6ofqplvvovxpbo7nscenario 3 searching against a single business object and its related child objects, returning one exact match for the parent business object docid\ fk2go6ofqplvvovxpbo7nscenario 4 searching against a single business object and its related child business objects, returning several matches for the parent business object docid\ fk2go6ofqplvvovxpbo7n scenario 1 searching against a single business object, returning an exact match in this scenario, the search is defined against a single business object and the search result returns one exact record objlist\[0]\[0] contains the matching incident record objectquerydefinition query = new objectquerydefinition(); fieldclass\[] fieldobjects = new fieldclass\[] { new fieldclass() { name = "incidentnumber", type = "text" }, new fieldclass() { name = "status", type = "text" } }; query select = new selectclass(); query select fields = fieldobjects; query from = new fromclass(); query from object = "incident"; query where = new ruleclass\[] { new ruleclass() { field = "incidentnumber", condition = "=", value = "10001" } }; frsheatintegrationsearchresponse searchresponse = frsvc search(authsessionkey, tenantid, query); if (searchresponse status == "success") { webservicebusinessobject\[]\[] objlist = searchresponse objlist; foreach (webservicebusinessobject\[] objouterlist in objlist) { foreach (webservicebusinessobject obj in objouterlist) { webservicefieldvalue\[] objfieldlist = obj fieldvalues; console writeline(" with \\" \\" matches the selection criteria", obj businessobjectname, objfieldlist\[0] name, objfieldlist\[0] value); } } } } here we are searching specifically for incident 10001 in the tenant if the record exists in the tenant, it is available in the objlist\[0]\[0] array scenario 2 searching against a single business object, returning several matches in this scenario, the search is defined against a single business object and the search result returns n matching records the matching records can be accessed from objlist\[0]\[0] through objlist\[ n 1]\[0] for example, assume the search returns ten incident records the incident records can be accessed from objlist\[0]\[0] through objlist\[9]\[0] the first index in the two dimensional array changes, but the second index remains at 0 objectquerydefinition query = new objectquerydefinition(); fieldclass\[] fieldobjects = new fieldclass\[] { new fieldclass() { name = "incidentnumber", type = "text" }, new fieldclass() { name = "status", type = "text" } }; query select = new selectclass(); query select fields = fieldobjects; query from = new fromclass(); query from object = "incident"; query where = new ruleclass\[] { new ruleclass() { field = "incidentnumber", condition = "<=", value = "10010" } }; query orderby = new orderbyclass\[] { new orderbyclass() { name = "incidentnumber", direction = "asc" } }; frsheatintegrationsearchresponse searchresponse = frsvc search(authsessionkey, tenantid, query); if (searchresponse status == "success") { webservicebusinessobject\[]\[] objlist = searchresponse objlist; foreach (webservicebusinessobject\[] objouterlist in objlist) { foreach (webservicebusinessobject obj in objouterlist) { webservicefieldvalue\[] objfieldlist = obj fieldvalues; console writeline(" with \\" \\" matches the selection criteria", obj businessobjectname, objfieldlist\[0] name, objfieldlist\[0] value); } } } } compared to the code from scenario 1, only the following has been updated query where = new ruleclass\[] { new ruleclass() { field = "incidentnumber", condition = "<=", value = "10010" } }; we are searching for incident records where the incident number is less than or equal to 10010 if the tenant has incident records starting from 10001 through 10010, then incident 10001 can be accessed via objlist\[0]\[0] , incident 10002 can be accessed via objlist\[1]\[0] , up to incident 10010 that can be accessed via objlist\[9]\[0] this topic illustrates how each of the items in the collection can be accessed individually, via the two dimensional array of search results because there are no child objects to search against, all of the items can be accessed using objlist\[n]\[0] scenario 2 search results scenario 3 searching against a single business object and its related child objects, returning one exact match for the parent business object in this scenario, we are searching for incidents with matching journal email records the search returns one matching incident record that contains four related journal email records when performing searches against the current object and related objects, it is important to note that each item in the two dimensional array represents the matching parent child combination in this scenario, since there is only one matching parent incident record, the search results contain the same parent record four times, one for each matching journal email record the parent incident record can be accessed using either objlist\[0]\[0] , objlist\[1]\[0] , objlist\[2]\[0] , or objlist\[3]\[0] here, the first index value varies, and the second index value is 0 (denoting the main object) each individual matching journal email child record can be accessed using objlist\[0]\[1] , objlist\[1]\[1] , objlist\[2]\[1] , and objlist\[3]\[1] the first index value varies (to correspond to each matching journal email record), and the second index is 1 (denoting the first child object) objectquerydefinition query = new objectquerydefinition(); fieldclass\[] fieldobjects = new fieldclass\[] { new fieldclass() { name = "incidentnumber", type = "text" }, new fieldclass() { name = "journal subject", type = "text" } }; query select = new selectclass(); query select fields = fieldobjects; query from = new fromclass(); query from object = "incident"; query from links = new fromlinkclass\[] { new fromlinkclass { relation = "", object = "journal#email" } }; query where = new ruleclass\[] { new ruleclass() { field = "incidentnumber", condition = "=", value = "10001" }, new ruleclass() { field = "journal category", condition = "=", value = "incoming email" }, }; query orderby = new orderbyclass\[] { new orderbyclass() { name = "incidentnumber", direction = "asc" }, new orderbyclass() { name = "journal subject", direction = "asc" } }; frsheatintegrationsearchresponse searchresponse = frsvc search(authsessionkey, tenantid, query); if (searchresponse status == "success") { webservicebusinessobject\[]\[] objlist = searchresponse objlist; foreach (webservicebusinessobject\[] objouterlist in objlist) { foreach (webservicebusinessobject obj in objouterlist) { webservicefieldvalue\[] objfieldlist = obj fieldvalues; console writeline(" with matches the selection criteria", obj businessobjectname, objfieldlist\[0] name, objfieldlist\[0] value); } } } we are searching for incident records where the incident number is equal to 10001, and has associated journal email records with a category of "incoming email" (that is, emails attached to the incident record, via the email listener) because the search needs to consider not only the top level object (incident), but also the related journal email records, we need to write additional lines of code the fromlinkclass class needs to be specified query from links = new fromlinkclass\[] { new fromlinkclass { relation = "", object = "journal#email" } }; here, we create a new instance of the fromlinkclass class, which designates the relationship from incident to journal email the existing incidentcontainsjournal relationship (which points to the journal base object) can be used to associate the incident with the child journal records because the relationship has no value specified for the internal reference name parameter, the relation value is left as an empty string, in the relation member above the actual object to be searched against (in this case, journal email) needs to be specified above in the object member with the links property specified for the fromclass class, the fields from the related business object can be accessed for example, besides accessing the incident number field of the incident, the subject of the journal email can be accessed fieldclass\[] fieldobjects = new fieldclass\[] { new fieldclass() { name = "incidentnumber", type = "text" }, new fieldclass() { name = "journal subject", type = "text" } }; to reference the subject field in the journal email business object, the field name needs to be specified as "journal subject" to specify the rule condition using fields in the journal email business object (for example, category), the field name needs to be specified as "journal category" query where = new ruleclass\[] { new ruleclass() { field = "incidentnumber", condition = "=", value = "10001" }, new ruleclass() { field = "journal category", condition = "=", value = "incoming email" }, }; in the example scenario, assume that incident 10001 exists in the tenant, with four journal emails attached to it, with subject values of "email 1", "email 2", "email 3", and "email 4" running the above sample code yields the following results in the console window incident with incidentnumber "10001" matches the selection criteria journal email with journal subject "email 1" matches the selection criteria incident with incidentnumber "10001" matches the selection criteria journal email with journal subject "email 2" matches the selection criteria incident with incidentnumber "10001" matches the selection criteria journal email with journal subject "email 3" matches the selection criteria incident with incidentnumber "10001" matches the selection criteria journal email with journal subject "email 4" matches the selection criteria the results are returned for each parent child combination because the four journal email records are associated with the same incident record (incident 10001), this same incident record shows up four times, once for each journal email child record associated with it the figure below illustrates how each of the items in the parent child combination can be accessed individually, via the two dimensional array of search results scenario 3 search results scenario 4 searching against a single business object and its related child business objects, returning several matches for the parent business object assume we are searching for incidents with matching journal email records assume that the search returns two matching incident records, which contains six related journal email records four for the first incident record (such as incident 10001), and two for the second incident record (such as incident 10008) when performing searches against the current object and related objects, each item in the two dimensional array represents the matching parent child combination in this scenario, since there are two matching parent incident records, and six related journal email records, the search returns six results the first incident record shows up using either objlist\[0]\[0] , objlist\[1]\[0] , objlist\[2]\[0] , and objlist\[3]\[0] , and its corresponding journal email records show up via objlist\[0]\[1] , objlist\[1]\[1] , objlist\[2]\[1] , and objlist\[3]\[1] the second incident record shows up using either objlist\[4]\[0] and objlist\[5]\[0] and its corresponding journal email records will show up via objlist\[4]\[1] and objlist\[5]\[1] objectquerydefinition query = new objectquerydefinition(); fieldclass\[] fieldobjects = new fieldclass\[] { new fieldclass() { name = "incidentnumber", type = "text" }, new fieldclass() { name = "journal subject", type = "text" } }; query select = new selectclass(); query select fields = fieldobjects; query from = new fromclass(); query from object = "incident"; query from links = new fromlinkclass\[] { new fromlinkclass { relation = "", object = "journal#email" } }; query where = new ruleclass\[] { new ruleclass() { field = "incidentnumber", condition = "<=", value = "10010" }, new ruleclass() { field = "journal category", condition = "=", value = "incoming email" }, }; query orderby = new orderbyclass\[] { new orderbyclass() { name = "incidentnumber", direction = "asc" }, new orderbyclass() { name = "journal subject", direction = "asc" } }; frsheatintegrationsearchresponse searchresponse = frsvc search(authsessionkey, tenantid, query); if (searchresponse status == "success") { webservicebusinessobject\[]\[] objlist = searchresponse objlist; foreach (webservicebusinessobject\[] objouterlist in objlist) { foreach (webservicebusinessobject obj in objouterlist) { webservicefieldvalue\[] objfieldlist = obj fieldvalues; console writeline(" with matches the selection criteria", obj businessobjectname, objfieldlist\[0] name, objfieldlist\[0] value); } } } compared to the code from scenario 3, only the following has been updated query where = new ruleclass\[] { new ruleclass() { field = "incidentnumber", condition = "<=", value = "10010" } }; we are searching for incident records where the incident number is less than or equal to 10010, and has associated journal email records with a category of incoming email (that is, emails attached to the incident record, via the email listener) so in the example scenario, assume that incident 10001 exists in the tenant, with four journal email records attached to it, with subject values of "email 1", "email 2", "email 3", and "email 4" assume that incident 10008 also exists in the tenant, with two journal email records attached to it, with subject values of "email 5" and "email 6" running the above sample code yields the following results in the console window incident with incidentnumber "10001" matches the selection criteria journal email with journal subject "email 1" matches the selection criteria incident with incidentnumber "10001" matches the selection criteria journal email with journal subject "email 2" matches the selection criteria incident with incidentnumber "10001" matches the selection criteria journal email with journal subject "email 3" matches the selection criteria incident with incidentnumber "10001" matches the selection criteria journal email with journal subject "email 4" matches the selection criteria incident with incidentnumber "10008" matches the selection criteria journal email with journal subject "email 5" matches the selection criteria incident with incidentnumber "10008" matches the selection criteria journal email with journal subject "email 6" matches the selection criteria the results are returned for each parent child combination because there are four journal email records associated with incident 10001, this same incident record shows up four times, once for each of the four journal email child records associated with it afterward, there are two journal email records associated with incident 10008, so this same incident shows up two times, once for each of the two journal email child records associated with it in total, there are six such parent child combinations, so there are twelve object records returned (six for the incident, and six for the distinct journal email records) the figure below illustrates how each of the items in the parent child combination can be accessed individually, via the two dimensional array of search results scenario 4 search results related search examples this section provides full code examples which expand on the related search capability as described in the previous section the example code below illustrates how to search for roles which are associated with the specified employee by login id string loginid = "admin"; objectquerydefinition query = new objectquerydefinition(); // here, we are querying for related role records for the current employee when querying // against specific fields from related business objects, the field name should be // specified first with the business object name, followed by a period, then followed by // the name of the field e g "frs def role roleid" // in this example, we are querying for the roleid and displayname fields from the related // "frs def role"business object // note that when querying for fields against the current business object //(e g "employee"), it // is not necessary in the field name to preface the business object (e g "loginid" // instead of "employee loginid") fieldclass\[] fieldobjects = new fieldclass\[] { new fieldclass() { name = "frs def role roleid", type = "text" }, new fieldclass() { name = "frs def role displayname", type = "text" } }; query select = new selectclass(); query select fields = fieldobjects; // here we specify employee as the business object to query against, and // specify the relationship to search against via the fromlinkclass // besides specifying the object, the value for the relation property should // be the internal reference name of the relationship // in the case of the relationship between employee and frs def role, // the internal reference name is empty, so it should be specified as an // empty string here query from = new fromclass(); query from object = "profile employee"; query from links = new fromlinkclass\[] { new fromlinkclass { relation = "", object = "frs def role#" } }; // specify the criteria for querying the specific employee record // (e g employee with login id of "admin") query where = new ruleclass\[] { new ruleclass() { field = "loginid", condition = "=", value = loginid } }; frsheatintegrationsearchresponse searchresponse = frsvc search(authsessionkey, tenantid, query); if (searchresponse status == "success") { // assuming the search is successful, the objlist search result is // returned via a two dimensional array each item in the result corresponds // to a specific parent child combination so in this example, each returned // result in objlist is a matching \<employee, role> combination webservicebusinessobject\[]\[] objlist = searchresponse objlist; // for each of the items in objlist, the first item is the parent // object, and the second object is the child object so in this example, // objouterlist\[0] corresponds to employee, whereas // objouterlist\[1] corresponds to role console writeline("\nthe following roles are associated with the \\" \\" user \n", loginid); foreach (webservicebusinessobject\[] objouterlist in objlist) { webservicebusinessobject obj = objouterlist\[1]; // here obj is pointing to the role record, so objfieldlist contains the list of // available fields from the matching role record in this example, // two fields from the role are queried against the roleid and the displayname webservicefieldvalue\[] objfieldlist = obj fieldvalues; console writeline(" ( )", objfieldlist\[0] value, objfieldlist\[1] value); } } the example code below illustrates how to search for teams that are associated with the specified employee by login id string loginid = "admin"; objectquerydefinition query = new objectquerydefinition(); // here, we are querying for related team records for the current employee // when querying against specific fields from related business objects, the field name should // be specified first with the business object name, followed by a period, then followed by the // name of the field e g "standarduserteam team" // in this example, we are querying for the team and teamemail fields from the related // "standarduserrteam" business object // note that when querying for fields against the current business object (e g "employee"), it is not // necessary in the field name to preface the business object (e g "loginid" instead of // "employee loginid") fieldclass\[] fieldobjects = new fieldclass\[] { new fieldclass() { name = "standarduserteam team", type = "text" }, new fieldclass() { name = "standarduserteam teamemail", type = "text" } }; query select = new selectclass(); query select fields = fieldobjects; // here we specify employee as the business object to query against, and specify the relationship to // search against via the fromlinkclass besides specifying the object, // the value for the relation property should be the internal reference name // of the relationship // in the case of the relationship between wmployee and standarduserteam, the internal reference // name is "rev2" query from = new fromclass(); query from object = "profile employee"; query from links = new fromlinkclass\[] { new fromlinkclass { relation = "rev2", object = "standarduserteam#" } }; // specify the criteria for querying the specific employee record (e g employee with login id of // "admin") query where = new ruleclass\[] { new ruleclass() { field = "loginid", condition = "=", value = loginid } }; frsheatintegrationsearchresponse searchresponse = frsvc search(authsessionkey, tenantid, query); if (searchresponse status == "success") { // assuming the search is successful, the objlist search result is returned via a two // dimensional array each item in the result corresponds to a specific parent child // combination so in this example, each returned result // in objlist is a matching \<employee, team> combination webservicebusinessobject\[]\[] objlist = searchresponse objlist; // for each of the items in objlist, the first item is the parent object, and the second // object is the child object so in this example, objouterlist\[0] corresponds // to employee, whereas objouterlist\[1] corresponds to team console writeline("\nthe following teams are associated with the \\" \\" user, with the corresponding team email address \n", loginid); foreach (webservicebusinessobject\[] objouterlist in objlist) { webservicebusinessobject obj = objouterlist\[1]; // here obj is pointing to the role record, so objfieldlist contains the list of // available fields from the matching role record in this example, two // fields from the role are queried against the team and the teamemail webservicefieldvalue\[] objfieldlist = obj fieldvalues; console writeline(" ( )", objfieldlist\[0] value, objfieldlist\[1] value); } } grouping the rule criteria the previous section describes how to search for records based on the current business object (incident) and its related child business objects (journal email) the earlier examples describe how to formulate queries such as the following retrieve all incident records with an incident number less than 10010, containing related journal email records with a category of "incoming email" the search web method is actually flexible enough to express searches through the grouping of the rule criteria for example, the search web method allows one to express queries such as the following retrieve all incident records with incidentnumber less than 10010, containing related journal email records where (the category of the journal email is "incoming email" or the subject of the journal email is "urgent request") the above search allows the user to search for incidents containing journal email records, either if the journal email has a category of "incoming email" (that is, it was created via the email listener), or the subject of the journal email has a subject line of "urgent request" regardless if the email has a category of "incoming email" or "outgoing email" to express the above search, consider the following code sample objectquerydefinition query = new objectquerydefinition(); fieldclass\[] fieldobjects = new fieldclass\[] { new fieldclass() { name = "incidentnumber", type = "text" }, new fieldclass() { name = "journal category", type = "text" } }; query select = new selectclass(); query select fields = fieldobjects; query from = new fromclass(); query from object = "incident"; query from links = new fromlinkclass\[] { new fromlinkclass { relation = "", object = "journal#email" } }; query where = new ruleclass\[] { new ruleclass { join = "and", field = "incidentnumber", condition = "<=", value = "10010" }, new ruleclass { rules = new ruleclass\[] { new ruleclass { field = "journal category", condition = "=", value = "outgoing email" }, new ruleclass { join = "or", field = "journal subject", condition = "=", value = "urgent request" } } } }; frsheatintegrationsearchresponse searchresponse = frsvc search(authsessionkey, tenantid, query); if (searchresponse status == "success") { webservicebusinessobject\[]\[] objlist = searchresponse objlist; foreach (webservicebusinessobject\[] objouterlist in objlist) { foreach (webservicebusinessobject obj in objouterlist) { webservicefieldvalue\[] objfieldlist = obj fieldvalues; console writeline(" with \\" \\" matches the selection criteria", obj businessobjectname, objfieldlist\[0] name, objfieldlist\[0] value); } } } this code sample is a variation of the samples from the earlier section, with several important differences notice the update to the where property for the objectquerydefinition object query where = new ruleclass\[] { new ruleclass { join = "and", field = "incidentnumber", condition = "<=", value = "10010" }, new ruleclass { rules = new ruleclass\[] { new ruleclass { field = "journal category", condition = "=", value = "outgoing email" }, new ruleclass { join = "or", field = "journal subject", condition = "=", value = "urgent request" } } } }; at the top level are two ruleclass objects" one for expression the condition to search for incident records with an incident number less than or equal to 10010, as illustrated in the previous sections new ruleclass { join = "and", field = "incidentnumber", condition = "<=", value = "10010" }, the second ruleclass object is used solely to populate the rules member of the ruleclass class new ruleclass { rules = new ruleclass\[] { } } inside the second ruleclass class, another ruleclass array is being instantiated with two inner ruleclass classes new ruleclass { field = "journal category", condition = "=", value = "outgoing email" }, new ruleclass { join = "or", field = "journal subject", condition = "=", value = "urgent request" } so the inner ruleclass array essentially allows one to express the following portion of the search retrieve the related journal email records where either (the category of the journal email is "incoming email" or the subject of the journal email is "urgent request") to express the following related query retrieve the related journal email records where either (the category of the journal email is "incoming email" and the subject of the journal email is "urgent request") the join member needs to be changed from "or" to "and", as follows new ruleclass { field = "journal category", condition = "=", value = "outgoing email" }, new ruleclass { join = "and", field = "journal subject", condition = "=", value = "urgent request" } the above example shows how rules can be grouped together, by populating the rules member of the ruleclass object the ruleclass class uses composition to allow ruleclass classes to be arbitrarily grouped together, using and or or operators via the join property about full text searching besides regular microsoft sql style searches, the search web method also supports performing full text searches against a business object an example is searching for records containing the terms "email down", against the full text catalog of the incident business object the ruleclass class contains a member called conditiontype , which is of type searchconditiontype this is an enumeration with two permissible values byfield 0 (regular microsoft sql search) bytext 1 (full text microsoft sql search) public enum searchconditiontype { byfield = 0, bytext = 1 } regular searches are performed by setting searchconditiontype to byfield this is the default mode for searching, so it is not necessary to have this explicitly set during the ruleclass instantiation to perform full text searches, it is necessary to explicitly set the condition type of the ruleclass class to bytext new ruleclass() { join = "and", condition = "=", conditiontype = searchconditiontype bytext, value = "email down" } the field member (which was present in the earlier search examples) is not specified in the ruleclass class" since the search is now performed against the full text catalog (by virtue of the conditiontype value of bytext ), it is an error to also specify field member in the ruleclass class the following code sample illustrates how to search for incident records with the matching terms "email down" objectquerydefinition query = new objectquerydefinition(); query select = new selectclass(); // retrieve just the incidentnumber field value from the incident, // when invoking the search fieldclass\[] incidentfieldobjects = new fieldclass\[] { new fieldclass() { name = "incidentnumber", type = "text" }, new fieldclass() { name = "service", type = "text" } }; query select fields = incidentfieldobjects; query from = new fromclass(); query from object = "incident"; query where = new ruleclass\[] { new ruleclass() { join = "and", condition = "=", conditiontype = searchconditiontype bytext, value = "email down" }, }; frsheatintegrationsearchresponse searchresponse = frsvc search(authsessionkey, tenantid, query); if (searchresponse status == "success") { webservicebusinessobject\[]\[] incidentlist = searchresponse objlist; foreach (webservicebusinessobject\[] incidentouterlist in incidentlist) { foreach (webservicebusinessobject incident in incidentouterlist) { // since we are just retrieving one field in the selection criteria // (i e incidentnumber), this corresponds to // incident fieldvalues\[0] value when retrieving the results console writeline("incident matches the selection criteria", incident fieldvalues\[0] value); } } } formal description of the classes used by the search web method to execute the search web method properly, you must properly create and populate objects from several classes before the web method is called about the objectquerydefinition class docid\ fk2go6ofqplvvovxpbo7nabout the fromclass class docid\ fk2go6ofqplvvovxpbo7nabout the selectclass class docid\ fk2go6ofqplvvovxpbo7nabout the ruleclass class docid\ fk2go6ofqplvvovxpbo7nabout the orderbyclass class docid\ fk2go6ofqplvvovxpbo7n about the objectquerydefinition class the objectquerydefinition class is defined as follows class objectquerydefinition { int top; bool distinct; fromclass from; selectclass select; list\<ruleclass> where; list\<orderbyclass> orderby; } the objectquerydefinition class is used to model the various portions of a typical microsoft sql select statement, specifically from class fromclass select class selectclass where class ruleclass (implemented as a list) order by class orderbyclass (implemented as a list) with the exception of the ruleclass class (which is used to model the where clause in the microsoft sql select statement), the other classes are named according to the corresponding clause in the microsoft sql select statement besides these classes, there is also an integer member called top this can be used to constrain the number of records being returned by the search web method for example, you may want to only return the first 1000 matching results there is also a boolean member called distinct this can be used to return the distinct results, to eliminate the repeated values in the search results about the fromclass class the fromclass class is used to model the from clause in a typical microsoft sql select statement, and is defined as follows class fromclass { string object; list\<fromlinkclass> links; } the object member needs to be populated with the name of the business object to search against query from = new fromclass(); query from object = "incident"; if the saved search needs to be performed relative to specific child objects, the links member also needs to be populated, using a list of fromlinkclass objects class fromlinkclass { string relation; string object; } the fromlinkclass class contains two member variables relation specifies the internal reference name of the relationship between the parent and child object for example, for the incidentcontainsjournal relationship, the internal reference name of the relationship is blank, so to use this relationship, populate the object member with the name of the child business object, and leave the relation member as an empty string object specifies the name of the child business object (such as journal#email) to search for journal email records related to the current business object, the links member of the fromclass class needs to be populated as follows query from links = new fromlinkclass\[] { new fromlinkclass { relation = "", object = "journal#email" } }; about the selectclass class use the selectclass class to model the select clause in a typical microsoft sql select statement it is defined as follows class selectclass { bool all; list\<fieldclass> fields; } to select all the fields in the business object, create a new selectclass object and set the all member variable of the object to true query select = new selectclass(); query select all = true; if the search is against the main business object (incident) and its related child business objects (journal email), setting the all member variable to true returns all the fields in the main business object and all the fields in the child business object to restrict the set of fields to be returned by the search web method, create a new list of fieldclass objects and initialize it with fieldclass objects that correspond to the fields of interest to return the incident number field of the incident business object, and the category field of the child journal email object, use the following statements fieldclass\[] fieldobjects = new fieldclass\[] { new fieldclass() { name = "incidentnumber", type = "text" }, new fieldclass() { name = "journal category", type = "text" } }; query select = new selectclass(); query select fields = fieldobjects; for fields from the main business object, the names of the fields can be provided as is, whereas for fields in the child business objects, the name of the field needs to be prefixed with the name of the child business object in the relationship for example, if you use the incidentcontainsjournal relationship, the relationship is defined against the incident and journal (base) object specify the category field as "journal category" about the ruleclass class the ruleclass class is used to model the where clause in a typical microsoft sql select statement, and is defined as follows class ruleclass { string join; string condition; searchconditiontype conditiontype; string field; bool isclosingbracket(); int bracketlevel; string value; list\<ruleclass> rules; } isclosingbracket the isclosingbracket function is used to check if a character is a closing bracket this function typically returns a boolean value true if the character is a closing bracket (like ), }, or ]), and false otherwise bracketlevel the bracketlevel function is used to track the depth of square brackets in a string when bracketlevel is 0, it means the current character is outside of any brackets the field member specifies the name of the field and the value member specifies the value corresponding to the field for fields from the main business object, the names of the fields can be provided as is, whereas for fields in the child business objects, the name of the field needs to be prefixed with the name of the child business object in the relationship for example, if you use the incidentcontainsjournal relationship, the relationship is defined against the incident and journal (base) object specify the category field as "journal category" for example, use the following statement to search for incident records with a priority value equal to 1, where the category value of the related journal email records is equal to "incoming email" query where = new ruleclass\[] { new ruleclass() { join = "and", condition = "=", field = "priority", value = "1" }, new ruleclass() { join = "and", condition = "=", field = "journal category", value = "incoming email" } }; the join property can contain a value of either "and" / "or", for specifying how the ruleclass objects are to be related to one another the condition member specifies the comparison operator used for relating the field and the specified value the allowable values for the condition member include the following operator meaning = equal to != not equal to > greater than < less than >= greater than or equal to <= less than or equal to for grouping the rule criteria together, within the ruleclass class, there is a rules member that can optionally hold a list of ruleclass objects you can use the rules member to group related ruleclass objects together, by composing the ruleclass objects query where = new ruleclass\[] { new ruleclass { join = "and", field = "incidentnumber", condition = "<=", value = "10010" }, new ruleclass { rules = new ruleclass\[] { new ruleclass { field = "journal category", condition = "=", value = "outgoing email" }, new ruleclass { join = "or", field = "journal subject", condition = "=", value = "urgent request" } } } }; inside the second ruleclass class at the top level, the rules member is initialized with another, inner list of ruleclass objects, where the criteria for journal email is expressed normal microsoft sql style searches are performed, where the condition type is set to the enumeration value of searchconditiontype byfield this is the default mode for searches and does not need to be explicitly specified in the ruleclass instantiation to support full text searches, set the condition type to the enumeration value of searchconditiontype bytext and do not include the field member when instantiating the rule class about the orderbyclass class the orderbyclass class is used to model the order by clause in a typical microsoft sql select statement, and is defined as follows class orderbyclass { public string name; public string direction; } the name member specifies the field to be ordered against, and the direction member specifies whether the records should be specified in ascending or descending order, using the values of "asc" or "desc", respectively for example, assume that the search returns the incident and related journal email records if the incident records should be sorted in ascending order based on the incident number, and the related journal subject records should be sorted in ascending order based on subject, the following code can be used for this query orderby = new orderbyclass\[] { new orderbyclass() { name = "incidentnumber", direction = "asc" }, new orderbyclass() { name = "journal subject", direction = "asc" } };