Calling functions can pass a where SQL statement in order to filter records in the database.

Comments

danithaca’s picture

danithaca commented
Priority: Critical » Normal
Status: Active » Closed (won't fix)

this probably can't be done because there might be duplicate table fields names. For example, in user's table, there's a field called "created". Then it's duplicate with {recommender_prediction}.created, and therefore requires a table alias in the WHERE statement. It would be quite confusing to users.

Also, if there's a need to use WHERE, it might be better to populate data to the staging table first to improve performance.