How can I filter on more than one field when using Data View?
I have to filter on the Data View (and NOT the Server Connect) because I am viewing a Folder List and not a Database Query.
Here is my Data View
<dmx-data-view id="view_msword_files" dmx-bind:data="sc_reports_msword_pq.data.msword_reports_list" dmx-bind:sorton="query1.data.sort" dmx-bind:sortdir="query1.data.dir" dmx-bind:page="query1.data.page" dmx-bind:pagesize="15" filter="name.lowercase().replace(' ', '').contains(filter_reports_msword.value.lowercase().replace(' ', ''))"></dmx-data-view>
And a screenshot of a portion of the Data View result
Currently my filter filters on the ‘name’ field, but I also want to filter on the ‘size’ and ‘created’ fields as well.
I have tried
<dmx-data-view ... filter="condition1;condition2;condition3"></dmx-data-view>
<dmx-data-view ... filter="condition1 && condition2 && condition3"></dmx-data-view>
but neither of these seem to work.
As an example, I am trying to find all files that
- name CONTAINS “Qdos”
- size GREATER THAN “400000”
- created AFTER “13/07/2020”
Can anyone advise?
Current set-up : SPA Pages, Windows 10, MySQL, PHP
Community Page
Last updated:
Last updated: