is there a way to populate pre-computed table view ?

[mirsella]

hello

i have a computed table view defined like this DEFINE TABLE fr_feed AS SELECT * FROM news WHERE date >= time::now() - 1w AND array::find_index(tags, "fr") != none PERMISSIONS FOR select WHERE $auth.activated == true;.
adding new news in the news table will populate the table, but i would like the news already in the news table to be also populated into this computed view.

i hope it was understandable. explainned another way:
when creating the computed table with the define statement above, its empty, while doing the select manually return results.

is it possible ?

thanks !

[mirsella]

for now, im creating another table, moving all data to it, and then moving it back to re create the row, but this isn't ideal especially with large data