I have a budget database (dbBudget) that includes:
1. project name (projectName) - a reference to a projects table
2. category (category)- a reference to a categories table
3. budget (budget)- a number
I want to present a table with all data and filter according to the project name, but because of the use in references, the normal filter would not work.
$w('#dbBudget').setFilter(wixData.filter().eq('projectName', 'Project 1'));
How to create a collection from the database that can be filtered?