Query

Some of available methods that could be used to query the business component:

• query(obj, cb, checkQueryMode, controlName). The query method accepts the objects where keys are controls' names, and values are search criterion written in Siebel Query Language:

  • nexus.query({Status: 'A*', Stage: 'A*'})

  • nexus.query({Status: 'A*', Stage: 'A*', 'Sub Status': 'IS NOT NULL'})

  • nexus.query({Status: 'A*', Stage: 'A*', InfoChanged: true})

  • nexus.query({ClosedDate: '>11/15/2018'}). The date criterion accepts the Siebel formatted date. Do we need to do the date conversion inside the helper class or is it should be done in the external application?

  • nexus.query({'Last Name': 'LIKE A* OR [First Name] LIKE A*'}) - an example of query with the OR condition.

    Send the empty literal object ({}) to make the "empty" query (similar result as ClearToQuery/ExecuteQuery without search specification in eScript).

    Returns promise, and the resolved promise returns the amount of the records in the result recordset.

    If the controlName input parameter is given, it will be used for entering the constructed search expression, and NB will not try to find another control for entering the search expression.

• queryById(id, cb, checkQueryMode, controlName). The first parameter is the value of row id of the record to be found. Send the empty string to make the "empty" query (similar result as ClearToQuery/ExecuteQuery without search specification in eScript). Returns promise, and the resolved promise returns the amount of the records in the result recordset. If the controlName input parameter is given, it will be used for entering the constructed search expression, and NB will not try to find another control for entering the search expression.

• queryByIdSync(id, checkQueryMode, controlName). The input parameter is the value of row id or the array of the row id of the records to be found. Returns the amount of found records. If the controlName input parameter is given, it will be used for entering the constructed search expression, and NB will not try to find another control for entering the search expression.

• queryBySearchExprSync(expr, checkQueryMode, controlName) and queryBySearchExpr(expr, checkQueryMode). Does the query using the input parameter as search expression. The search expression could be any valid search expression written in Siebel Query Language, e.g. Status LIKE 'A*' OR Stage LIKE 'A*'. Note that the fields' names should be used for the expr input parameter. Returns the amount of found records. If the controlName input parameter is given, it will be used for entering the constructed search expression, and NB will not try to find another control for entering the search expression.

• requery(name) and refresh(name) - methods to requery and refresh the business component on the Server. Uses the Nexus BS Siebel business service.

• getMVF returns the values of Multi-Value fields. Uses the Nexus BS Siebel business service.