Part 7: Retrieve and cache existing users – Pathify Admin Help Center

Retrieve and cache all users from Pathify. This step is important so you can identify which users ARE actually in the system.

Time: 17:06

In the mapUsersToUserQueries step in Part 7, there is a tidbit of SQL and a series of nested Scala objects. As promised, this is the code snippet:

var query = \"select DISTINCT id, name, first_name, last_name, alternate_id from users_user where alternate_id = ANY(?);\";
return [
    new code_model_flows_processors_db_ParameterizedDbQuery(emptyConfig,query,newList([
         new code_model_flows_processors_db_DbQueryParameter(1, new code_model_flows_processors_db_DbArray(newList(_.map(altIds, function(alt_id) {
              return new code_model_flows_processors_db_DbString(alt_id);
         }))))
    ]))
];

Click to copy

Related articles