resources/segments/search - Examples
Example - Two language columns
The result of a query and with 2 language columns might look as follows:
CODE
{
"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
}
]
}