Filtering on a prefetched table

103 views
Skip to first unread message

bamerza

unread,
Oct 14, 2013, 3:21:01 PM10/14/13
to persis...@googlegroups.com
My model:
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 ?

bamerza

unread,
Jan 9, 2014, 12:01:12 PM1/9/14
to persis...@googlegroups.com
In case anyone is interested, I used the following patch which worked great - https://gist.github.com/kommander/1256787
Reply all
Reply to author
Forward
0 new messages