Should I use App Maker's Server Script, Calculated Client, or Relations to filter data for display

Question

I think I'm missing a core concept in how to filter and display App Maker data.

Goal

1) I'd like to maintain two manual-mode data models.

Persons:
  PrimaryEmail
  personName
Vehicles:
  PrimaryEmail
  vehicleColor

2) I'd like to display two tables side by side on the same page.

Showing all the vehicles in one table and only the user's vehicles in the second table. PrimaryEmail is the key they share.

---

What I've Tried

Server Script

This query script for a third datasource, UserVehicles, returns the records I want to display in the second table.

function getUserVehicleData() {
  var uE = Session.getActiveUser().getEmail();
  var q = app.models.Vehicle.newQuery();
  q.filters.PrimaryEmail._equals = uE;
  var d = q.run();
  return d;
}

But, I found it necessary for the client to frequently call app.datasources.UserVehicle.load(); but even still the second table would not show the updated/added record from (table one uses the Vehicle datasource, table two is using UserVehicles). I think I need to also work inside the load() callback, but I do not see how to tell the second table there is refreshed data in UserVehicles.

Client Calculated

This option sounds right. I'd like the client to query the server for the records where the Vehicle's PrimaryEmail matches the current user.

I do not see how records from the server are filtered on the client. Unlike the server script API, var data = app.models.Vehicle.newQuery(); is not valid client script. So, one does not load data into variables in which to loop/filter/create new records in the client calculated script?

Relations

I replicated a tutorial and created a ONE to MANY relations between People and Vehicles. This introduced errors around deprecated foreign keys. Also, I couldn't reason how to use this relation to the filter for the current user. (I'm not 100% grasping the UI).

Question

I want to understand how to display updated and filtered data and how that data should be filtered (server, client calculated, relations). I must be missing something, this must be simple to do.

Answer 1

Solved

I used a server script to solve this.

function getUserVehicleData() {
  var uE = Session.getActiveUser().getEmail();
  var q = app.models.Vehicle.newQuery();
  q.filters.PrimaryEmail._equals = uE;
  var d = q.run();
  return d;
}

The piece I was missing was this bit of Client Script.

app.pages.UserVehicles.createChildren();

Without it, the UI would not refresh the list to use the updated data from the datasource.

Thanks Markus!