Skip to main content

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
		}
	]
}

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.