You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Search/filter on more columns in a table

edited Nov 8, 2018 1:29PM in Visual Builder 4 comments

Summary

How to search/filter on multiple columns in VBCS

Content

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!

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!