2 Datasets Filtering Problem

Ask the community
,
1

I have 2 datasets

  • ArrivalDB

  • Arrivals Database
    I have a similar column in both named fileNumber which contain the same values

On my page I have a table displaying information from the Arrivals Database and I have applied a Filter to show only those rows whose fileNumber exists in both Databases

293×572 30.9 KB

The Filter works fine but is only displaying the 1st value from the ArrivalsDB

For Instance I have the following fileNumber in the ArrivalsDB

  1. XXX //Matching

  2. 736738 //Matching

  3. 0000

  4. 760456

  5. 98541

  6. 12345 //Matching

  7. 534864864

  8. 778890 //Matching
    & The Following fileNumber in the Arrivals Database

  9. 123456

  10. 5121864

  11. 6541

  12. 6451135

  13. 56153165

  14. 65165165113541

  15. 56151351

  16. 6456864

  17. XXX //Matching

  18. 736738 //Matching

  19. 12345 //Matching

  20. 778890 //Matching
    The table should show the 4 rows that have the same fileNumber in both Databases but it is showing only the First one

2

Hi,

Can you provide the url of your site so we may check further ?

Thanks,

Itay Koren

3

https://dudelemonweb.wixsite.com/concordeportal/dataset-test

Live site won’t work because of Database Permission issues

Thanks Itay

4

Hi,

Thanks.
I wanted to verify which problem you wish us to check - The original issue or the permissions issue.

Itay

5

Original Issue…

If you can find a solution, Mikhail will be stunned :smiley: https://www.wix.com/code/home/forum/questions-answers/filtering-sorting-a-table-or-a-list (Check the last 3-4 comments)

6

Hi,

Indeed it’s very strange…
I couldn’t get it to show more than the first row.
It’s interesting to see if it happens on the live site as well (once the permissions issue is resolved).
Also, are you sure you don’t have any custom code that only displays one row ?

Itay