I'm using the table-component in Servoy 2020.03 and it it woking really well when I bind it to the form foundset or a related foundset.
However, I have a table where I'd like to load news stories. To generate the list I use the following query:
- Code: Select all
var query = "SELECT id FROM news_articles WHERE news_articles.tsv @@ to_tsquery(?) ORDER BY pub_date";
on a normal form I can simply do
- Code: Select all
forms.news.foundset.loadRecords(query, args);
The table component has a foundset but this looks like a foundset setter, not a full foundset node.
The component also has what seems to be a callback,
- Code: Select all
onViewPortChanged(start, end)
How do I put this together? What kind of foundset do I need to use?
Does anyone have a snippet of sample code showing how this is all put together?
Thanks,
Christian