var Tracker = persistence.define('Tracker', {
Name: 'TEXT'
});
var TrackerType = persistence.define('TrackerType', {
Name: 'TEXT',
Description: 'TEXT'
});
var TrackerLog = persistence.define('TrackerLog', {
DateOccurred: 'DATE',
TimeofDayId: 'INT',
SeverityId: 'INT',
Saved: 'INT',
Note: 'TEXT'
});
Tracker.hasMany('trackerType', TrackerType, 'tracker');
TrackerType.hasMany('trackerLog', TrackerLog, 'trackerType');
Is it possible to filter on a prefetched table?
I have relational table and want to retrieve a record based on the id of the prefetched table.
e.g., I'd like to do the following but it does not work :
var mtracker = Tracker.all().filter('id', '=', trackerId);
var allLogs = TrackerLog.all().prefetch("trackerType").filter('trackerType.tracker', '=', mtracker);
If it is possible, in this case would mtracker be the string Id of the record or would it have to be the actual object obtained from a separate query as I did here ?