Similar to a problem we were having a few weeks back (working from
hyb->sample) we'd now like to go back in the other direction. However
whereas before we were going from a Hyb itemquery, linking to a
labelled extract and using "l.parent.parent.id" to jump to sample I
can't see any way to go in the other direction ("child.child" is
essentially the function we need).
Am I missing something in the API? surely there must be a way to do
something like this:
> ItemQuery<net.sf.basedb.core.Sample> sampleQuery =
> net.sf.basedb.core.Sample.getQuery();
> sampleQuery.include(Include.SHARED);
> sampleQuery.setDistinct(true);
>
>
> sampleQuery.join(Hql.innerJoin("sourceEvents",
> Item.BIOMATERIALEVENT.getAlias()));
>
> sampleQuery.restrict(
> new Restriction() {
> public String toQl(Query query, DbControl dc) {
> return
> "index("+Item.BIOMATERIALEVENT.getAlias()+") IN " +
> "(SELECT b.id FROM
> BioMaterialEventData b " +
> " WHERE b.hybridization.id =
> "+hybID+")";
>
>
> }
>
> public Collection<? extends QueryElement>
> getChildren() {
> return null;
> }
> }
> );
>
thanks
-s
--
Seth Redmond
Scientific Programmer, VectorBase
Kafatos / Christophides Groups
Div. Cell and Molecular Biology
Imperial College, London
[EMAIL PROTECTED]
--
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
basedb-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/basedb-devel
