bheyde
8/14/2018 - 5:26 PM

Parenthentical Comparison

Parenthetical comparisons can be accomplished using the "SUBWHERE" operator and special field names "search", "search_AND" and "search_OR"

"Filter":
[
	{
		"name": "search",
		"value":
		[
			{
				"field": "ship_lname",
				"operator": "EQ",
				"value": "Burchmore"
			},
			{
				"field": "search_OR",
				"operator": "SUBWHERE",
				"value":
				[
					{
						"field": "ship_fname",
						"operator": "EQ",
						"value": "Ryan"
					},
					{
						"field": "ship_lname",
						"operator": "EQ",
						"value": "Guisewite"
					}
				]
			}
		]
	}
]