resources/segments/search - Examples

Example - Two language columns

The result of a query and with 2 language columns might look as follows:

{ "result": { "total": 4, "skip": 0, "take": 25, "rows": [ { "no": "1", "ts": "2022-07-21T10:49:12.5230243Z", "sid": 8271158, "did": 7054, "dsid": 2232, "cty": 1, "sdid": 1, "bsid": 1, "bssid": 0, "edit": true, "tags": null, "tmx": [], "split": true, "comp": null, "ctx": null, "ctx_edit": true, "chmin": null, "chmax": null, "ch_edit": true, "lbls": [], "lbls_edit": true, "cfs": [], "cfs_edit": true, "tbx": [], "cdt": "2020-07-27T22:51:48.4373876Z", "cuid": 111, "udt": "2022-07-21T10:49:12.4970246Z", "uuid": 139, "cols": { "_0": { "column": 0, "txt": { "val": "HELLO THERE", "st": 0, "bk": 0, "tsk": null, "loc": "en", "cmc": 0, "ed": 0, "rep": 0, "ap": false, "usid": null, "usdt": "2020-07-27T22:51:48.4373876Z", "hh": false, "sim": 0, "mtid": null, "err": null, "qa": { "dt": "0001-01-01T00:00:00Z", "active": false, "issues": [] }, "lck": false, "lck_edit": true, "hn": 806990909, "hp": 0, "cfs": [], "cfs_edit": true, "lbls": [], "lbls_edit": true, "usfid": null, "usfdt": null, "tbx": [], "sent": null, "sentdt": null, "cdt": "2020-07-27T22:51:48.4373876Z", "cuid": 111, "udt": "2020-07-27T22:51:48.4373876Z", "uuid": 111, "tmx": [] }, "txt_edit": true }, "_1": { "column": 1, "txt": { "val": "HALLO", "st": 0, "bk": 0, "tsk": null, "loc": "de", "cmc": 0, "ed": 1, "rep": 0, "ap": false, "usid": 139, "usdt": "2022-07-21T10:49:12.4970246Z", "hh": false, "sim": 0, "mtid": null, "err": null, "qa": { "dt": "0001-01-01T00:00:00Z", "active": false, "issues": [] }, "lck": false, "lck_edit": true, "hn": null, "hp": null, "cfs": [], "cfs_edit": true, "lbls": [], "lbls_edit": true, "usfid": null, "usfdt": null, "tbx": [], "sent": null, "sentdt": null, "cdt": "2022-07-21T10:49:12.4970246Z", "cuid": 139, "udt": "2022-07-21T10:49:12.4970246Z", "uuid": 139, "tmx": [] }, "txt_edit": true } } }, { "no": "2", "ts": "2022-07-21T10:49:12.5230243Z", "sid": 8271159, "did": 7054, "dsid": 2232, "cty": 1, "sdid": 1, "bsid": 2, "bssid": 0, "edit": true, "tags": null, "tmx": [], "split": true, "comp": null, "ctx": null, "ctx_edit": true, "chmin": null, "chmax": null, "ch_edit": true, "lbls": [], "lbls_edit": true, "cfs": [], "cfs_edit": true, "tbx": [], "cdt": "2020-07-27T22:51:48.4373876Z", "cuid": 111, "udt": "2022-07-21T10:49:12.520024Z", "uuid": 139, "cols": { "_0": { "column": 0, "txt": { "val": "Our response to out client is always impeccable", "st": 0, "bk": 0, "tsk": null, "loc": "en", "cmc": 0, "ed": 0, "rep": 0, "ap": false, "usid": null, "usdt": "2020-07-27T22:51:48.4373876Z", "hh": false, "sim": 0, "mtid": null, "err": null, "qa": { "dt": "0001-01-01T00:00:00Z", "active": false, "issues": [] }, "lck": false, "lck_edit": true, "hn": 167197947, "hp": 500076978, "cfs": [], "cfs_edit": true, "lbls": [], "lbls_edit": true, "usfid": null, "usfdt": null, "tbx": [], "sent": null, "sentdt": null, "cdt": "2020-07-27T22:51:48.4373876Z", "cuid": 111, "udt": "2020-07-27T22:51:48.4373876Z", "uuid": 111, "tmx": [] }, "txt_edit": true }, "_1": { "column": 1, "txt": { "val": "Unsere Nachricht ist immer super", "st": 0, "bk": 0, "tsk": null, "loc": "de", "cmc": 0, "ed": 1, "rep": 0, "ap": false, "usid": 139, "usdt": "2022-07-21T10:49:12.520024Z", "hh": false, "sim": 0, "mtid": null, "err": null, "qa": { "dt": "0001-01-01T00:00:00Z", "active": false, "issues": [] }, "lck": false, "lck_edit": true, "hn": null, "hp": null, "cfs": [], "cfs_edit": true, "lbls": [], "lbls_edit": true, "usfid": null, "usfdt": null, "tbx": [], "sent": null, "sentdt": null, "cdt": "2022-07-21T10:49:12.520024Z", "cuid": 139, "udt": "2022-07-21T10:49:12.520024Z", "uuid": 139, "tmx": [] }, "txt_edit": true } } }, { "no": "3", "ts": "2020-07-27T22:56:11.5384693Z", "sid": 8271160, "did": 7054, "dsid": 2232, "cty": 1, "sdid": 1, "bsid": 3, "bssid": 0, "edit": true, "tags": null, "tmx": [], "split": true, "comp": null, "ctx": null, "ctx_edit": true, "chmin": null, "chmax": null, "ch_edit": true, "lbls": [], "lbls_edit": true, "cfs": [], "cfs_edit": true, "tbx": [], "cdt": "2020-07-27T22:51:48.4373876Z", "cuid": 111, "udt": "2020-07-27T22:56:11.5384693Z", "uuid": 111, "cols": { "_0": { "column": 0, "txt": { "val": "The quick brown fox jumps over the lazy dog", "st": 0, "bk": 0, "tsk": null, "loc": "en", "cmc": 0, "ed": 0, "rep": 0, "ap": false, "usid": null, "usdt": "2020-07-27T22:51:48.4373876Z", "hh": false, "sim": 0, "mtid": null, "err": null, "qa": { "dt": "0001-01-01T00:00:00Z", "active": false, "issues": [] }, "lck": false, "lck_edit": true, "hn": -1136391875, "hp": 806990909, "cfs": [], "cfs_edit": true, "lbls": [], "lbls_edit": true, "usfid": null, "usfdt": null, "tbx": [], "sent": null, "sentdt": null, "cdt": "2020-07-27T22:51:48.4373876Z", "cuid": 111, "udt": "2020-07-27T22:51:48.4373876Z", "uuid": 111, "tmx": [] }, "txt_edit": true }, "_1": { "column": 1, "txt": { "val": null, "st": 0, "bk": 0, "tsk": null, "loc": "de", "cmc": null, "ed": 0, "rep": 0, "ap": false, "usid": null, "usdt": null, "hh": false, "sim": 0, "mtid": null, "err": null, "qa": null, "lck": false, "lck_edit": true, "hn": null, "hp": null, "cfs": [], "cfs_edit": true, "lbls": [], "lbls_edit": true, "usfid": null, "usfdt": null, "tbx": [], "sent": null, "sentdt": null, "cdt": null, "cuid": null, "udt": null, "uuid": null }, "txt_edit": true } } }, { "no": "4", "ts": "2020-07-27T22:56:11.5384693Z", "sid": 8271161, "did": 7054, "dsid": 2232, "cty": 1, "sdid": 2, "bsid": 4, "bssid": 0, "edit": true, "tags": null, "tmx": [], "split": true, "comp": null, "ctx": "User defined", "ctx_edit": true, "chmin": null, "chmax": null, "ch_edit": true, "lbls": [], "lbls_edit": true, "cfs": [], "cfs_edit": true, "tbx": [], "cdt": "2020-07-27T22:51:48.4373876Z", "cuid": 111, "udt": "2020-07-27T22:56:11.5384693Z", "uuid": 111, "cols": { "_0": { "column": 0, "txt": { "val": "1033-10.2.0.7636", "st": 0, "bk": 0, "tsk": null, "loc": "en", "cmc": 0, "ed": 0, "rep": 0, "ap": false, "usid": null, "usdt": "2020-07-27T22:51:48.4373876Z", "hh": false, "sim": 0, "mtid": null, "err": null, "qa": { "dt": "0001-01-01T00:00:00Z", "active": false, "issues": [] }, "lck": false, "lck_edit": true, "hn": 0, "hp": 167197947, "cfs": [], "cfs_edit": true, "lbls": [], "lbls_edit": true, "usfid": null, "usfdt": null, "tbx": [], "sent": null, "sentdt": null, "cdt": "2020-07-27T22:51:48.4373876Z", "cuid": 111, "udt": "2020-07-27T22:51:48.4373876Z", "uuid": 111, "tmx": [] }, "txt_edit": true }, "_1": { "column": 1, "txt": { "val": null, "st": 0, "bk": 0, "tsk": null, "loc": "de", "cmc": null, "ed": 0, "rep": 0, "ap": false, "usid": null, "usdt": null, "hh": false, "sim": 0, "mtid": null, "err": null, "qa": null, "lck": false, "lck_edit": true, "hn": null, "hp": null, "cfs": [], "cfs_edit": true, "lbls": [], "lbls_edit": true, "usfid": null, "usfdt": null, "tbx": [], "sent": null, "sentdt": null, "cdt": null, "cuid": null, "udt": null, "uuid": null }, "txt_edit": true } } } ], "docs": { "_7054": { "did": 7054, "dsid": 2232, "name": "Hello There (1).docx", "pmax": null, "pmin": null, "ptype": 4, "pdomain": "MSWORD", "previewapp": null, "previewurl": null, "previewtf": null, "edit": true, "ctags": [ "[b]", "[/b]", "[i]", "[/i]", "[u]", "[/u]", "[sup]", "[/sup]", "[sub]", "[/sub]" ], "sub": [ { "sdid": 1, "sdnm": "Word document" }, { "sdid": 2, "sdnm": "Custom document properties" } ] } }, "users": { "_111": { "id": 111, "nm": "Anna Karina", "cid": 1, "cnm": "Headquarters" }, "_139": { "id": 139, "nm": "Moho Maha", "cid": 1, "cnm": "Headquarters" } } }, "rights": null, "layout": null, "columns": [ { "index": 0, "fkey": "1~en~0", "fkeyLayout": "1~en~0", "ftype": 1, "fqualifier": 0, "name": "English", "loc": "en", "loc_rtl": false, "loc_cmplx": false, "loc_ea": false }, { "index": 1, "fkey": "1~de~0", "fkeyLayout": "1~de~0", "ftype": 1, "fqualifier": 0, "name": "German", "loc": "de", "loc_rtl": false, "loc_cmplx": false, "loc_ea": false } ] }

 

 

Copyright Wordbee - Buzzin' Outside the Box since 2008