You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to get multiple rows via Database Access API in Custom Code

edited Feb 23, 2017 8:00AM in Digital Assistant & Mobile 3 comments

Summary

How to get multiple rows via Database Access API in Custom Code

Content

Hi Experts,

    we want to retrieve multiple rows from one table from MCS internal database, i go thru the APIs but seem just have get a row or get all rows

       database.get(table, keys, options, httpOptions): Retrieves a row from a table.

       database.getAll(table, options, httpOptions): Retrieves specified fields from all rows in a table.

    in bellowing response , we just need to get these rows ( 'employeename = owen') rather than all rows.

{

  "items": [

    {

      "id": 2,

      "status": "PENDING",

      "description": "Zhiyu水泵保修",

      "employeename": "zhiyu",

      "createdatatime": "2017-02-21T09:51:45.699+00:00"

    },

    {

      "id": 3,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!