Can i display record list based on joining tables


I have a specific requirements where i need to display records of a certain table on a page, but with checking conditions on other tables.
Prefilter records are not having those capabilities.

Or could i call a workflow to provide me results.
and then display it.

I tried using automation block on page, but to no avail.

Is that possible in corteza?

Would the suggestion discussed over here cover your needs?