Search/filter on more columns in a table
Summary
How to search/filter on multiple columns in VBCSContent
I have managed to filter data in a table based on one attribute, which was pretty simple. Now I wonder if it is possible to filter from more columns and if so, how I have to define it? For now I have this:
{
"filterCriterion": {
"op": "{{ \"$or\" }}",
"criteria": [
{
"attribute": "{{ \"asset\" }}",
"op": "{{ \"$co\" }}",
"value": "{{ $page.variables.searchAsset }}"
}
]
}
}
I have tried the following to, but it gave me 'no results':
{
"filterCriterion": {
"op": "{{ \"$or\" }}",
"criteria": [
{
"attribute": "{{ \"asset\" }}",
"op": "{{ \"$co\" }}",
"value": "{{ $page.variables.searchAsset }}"
},
{
"attribute": "{{ \"serialNumber\" }}",
"op": "{{ \"$co\" }}",
"value": "{{ $page.variables.searchAsset }}"
}
]
}
}
Thanks in advance!