I can not get my filter to work on datasets.
Here is a link to my editor if any Wix admins want to take a look: https://editor.wix.com/html/editor/web/renderer/edit/6829c53e-13c8-4435-8422-f9123d87be29?metaSiteId=4647b62d-d504-4fad-b62e-fbc7f65955ce&editorSessionId=0f98e953-37ca-4b97-bd14-6c12ed8b9f77&referralInfo=dashboard
I have a site setup with one database. In my backend data.js i have this setup screenshot: http://prntscr.com/lpyfwk
this populate a column in my database that is called attKopa with a calculated value. this seems to work very good and i get the expected results in this column.
then go to a page and opens either a table/list or a repeater and populate them with a dataset and the column attKopa and someone else. Then i set a filter that looks like this:
A filter that says "greater than: 0"
When i then run the site i get 3 results out of 10 from my database.
Those 3 results are correct... but it misses several other values that are greater than 0.... For example in screenshot2 you can see me selecting what values it picks out to display (2,6,2). But it misses 42,1,2... why? screenshot1: http://prntscr.com/lpyien screenshot2: http://prntscr.com/lpyj0k
Why does the filter not work for all values in the column?