[Treebase-guts] [ treebase-Bugs-2846456 ] Need PhyloWS API search by date-time-stamp

[SourceForge.net <no...@so...>]

Bugs item #2846456, was opened at 2009-08-28 15:28
Message generated for change (Tracker Item Submitted) made by sfrgpiel
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1126676&aid=2846456&group_id=248804

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: data
Group: None
Status: Open
Priority: 6
Private: No
Submitted By: William Piel (sfrgpiel)
Assigned to: Mark Dominus (mjdominus)
Summary: Need PhyloWS API search by date-time-stamp

Initial Comment:
We need to be sure that our API can search using data-time-stamps. i.e. "find all studies that were modified since Jan 23, 2010." (and separately, "find all studies that were made public after Jan 23, 2010"). This may require investigating how and where TreeBASE2 is currently tracking modification stamps. If it does not do so yet, we should probably add modification stamp fields on some key tables -- and it's probably easier to do this with a postgresql-level trigger or part of the schema. At any rate, any of the following modifications should stamped and searchable by the API: modifications to the citation, matrix metadata (including row-segment additions/subtractions), tree metadata (including re-rooting a tree), taxon labels, and mapping between taxon labels and taxon variants, and mapping between taxon variants and taxa. i.e., if a study contains a matrix for which a taxon label gets re-mapped to a different taxon variant or taxon at time/date x, then the whole study should be considered changed at time/date x. 

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1126676&aid=2846456&group_id=248804