re: Aliasing and Querying Pick_me_to_call

Article View: bionet.software.acedb

Article #136

Back to bionet.software.acedb Previous Next

#136

From: Dave Matthews
Date: Fri, 13 Jun 2003 06:26

36 lines
3091 bytes

Hi Mark,

I think I can answer your second question.

> The following query:
> 
> find Allele IS cho ; follow Phenotype_picture ; >Pick_me_to_call
> 
> Doesn't work, though 
> 
> find Allele IS cho ; follow Phenotype_picture ; >Description
> 
> does work... 

">" is the same thing as "follow".  You can't follow to a value of type
Text, though you can follow to a value of type ?Text.  I'll bet your model
for Pick_me_to_call is using Text instead of ?Text.  Mine does.


> Is there a different way to query Pick_me_to_call values?

Not with this simple query language.  Possibly with AcePerl, I'm not sure, I
don't use it enough.  Definitely with Tablemaker or AQL.  The AQL query
would be this:

select Gif from Gif in object("Allele","cho") -> Phenotype_picture -> Pick_me_to_call[2]

Or using an alternative syntax, this:

select Gif
from A in class Allele,
     P in A->Phenotype_picture,
     Gif in P->Pick_me_to_call[2]
where A = "cho"

---

Technical Details

Message-ID: <200306121716.h5CHGA8G008395@greengenes.cit.cornell.edu>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!bloom-beacon.mit.edu!hgmp.mrc.ac.uk!net.bio.net

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f6d40,423fb7c54e246011
X-Google-Attributes: gidf6d40,public
X-Google-ArrivalTime: 2003-06-12 23:26:07 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!bloom-beacon.mit.edu!hgmp.mrc.ac.uk!net.bio.net
From: matthews@greengenes.cit.cornell.edu (Dave Matthews)
Newsgroups: bionet.software.acedb
Subject: re: Aliasing and Querying Pick_me_to_call
Date: 13 Jun 2003 07:26:05 +0100
Organization: BIOSCI/MRC Human Genome Mapping Project Resource Centre
Lines: 37
Sender: mod-ace@hgmp.mrc.ac.uk
Approved: BIOSCI Approval Key <biosci-approval-key@net.bio.net>
Message-ID: <200306121716.h5CHGA8G008395@greengenes.cit.cornell.edu>
NNTP-Posting-Host: mercury.hgmp.mrc.ac.uk
X-Trace: niobium.hgmp.mrc.ac.uk 1055485566 26734 193.62.192.80 (13 Jun 2003 06:26:06 GMT)
X-Complaints-To: news@net.bio.net
NNTP-Posting-Date: Fri, 13 Jun 2003 06:26:06 +0000 (UTC)
X-Original-To: bionet-software-acedb@net.bio.net
X-Original-To: acedb@net.bio.net
X-Received: from localhost (localhost [127.0.0.1])
 by mercury.hgmp.mrc.ac.uk (Postfix) with ESMTP id 17A287D101
 for <acedb@net.bio.net>; Thu, 12 Jun 2003 18:16:14 +0100 (BST)
X-Received: from greengenes.cit.cornell.edu (greengenes.cit.cornell.edu [128.253.246.43])
 by mercury.hgmp.mrc.ac.uk (Postfix) with ESMTP id 2B8A67D0E3
 for <acedb@net.bio.net>; Thu, 12 Jun 2003 18:16:13 +0100 (BST)
X-Received: from greengenes.cit.cornell.edu (localhost [127.0.0.1])
 by greengenes.cit.cornell.edu (8.12.9/8.12.9) with ESMTP id h5CHGArf008396;
 Thu, 12 Jun 2003 13:16:10 -0400 (EDT)
X-Received: (from matthews@localhost)
 by greengenes.cit.cornell.edu (8.12.9/8.12.9/Submit) id h5CHGA8G008395;
 Thu, 12 Jun 2003 13:16:10 -0400 (EDT)
X-To: markw@illuminae.com
X-Cc: ACEDB newsgroup <acedb@net.bio.net>
X-Auth: PGPMoose V1.1 PGP bionet.software.acedb
 iQCVAwUAPulufKCIqsWvyF5FAQHh1AQAnU5+MfESlGtmHcTxB6AN4fqSUw7JNK3a
 3sKe82R+p7YC0l9/x+EqrTy2r8dujb0DlfXe7Jt9ycK5cker6tteFZb6maFVFZZc
 qFAINgGA0GbG68XLwZ4Ir4iqgC7WHuQ/G13ydLr4GuG1CtK5CZ8q0toicpZ9bAo7
 NEKTPmsgTtk=
 =mmjf