Accession

From ICISWiki

Jump to: navigation, search

(This is a copy of the original usecase xml with added information on how to get the needed data for a particular attribute).

Use Case Id: GetAccessionsByFeatures
Description: This use case requests the accession IDs that match the search simple features. Each such simple feature contains one search criterion. The ID and the name of the simple feature is left blank (or ignored by the data source), and the ID of the feature type specifies an ontology term whose value is in the feature's valueString. The term's ID and the valueString establish what to search for.

It is possible to specify more simple features as search criteria.
It is also possible to specify what data resource (database) to search

by the searchable attribute "NameSpaceBaseConstants.UNIQUE_IDENTIFIER_DATATYPE_ATTRIBUTE_ID".

The output consists of the accession IDs that match search

criteria. The returned IDs are constructed in a way that they indicates also the data resource (database) where they were found in. This allows to use this output immediately as an input of the related use case "GetFeaturesByAccessionId".


DataType: Accession Unique Identifier Reference AccessionBaseConstants.DATATYPE_ID
Name Accession Unique Identifier
Searchable Attributes
Reference AccessionBaseConstants.PASSPORT_DATATYPE_ATTRIBUTE_ID + LSID.ATTRIBUTE_DELIMITER+PassportBaseConstants.FEATURES_DATATYPE_ATTRIBUTE_ID + LSID.ATTRIBUTE_DELIMITER + SimpleFeatureBaseConstants.TYPE_DATATYPE_ATTRIBUTE_ID
Operators Operator.LIKE, Operator.EQUAL, Operator.GT, Operator.LT
Queries Query used is dynamically created based from the searchfilters used. Here is an example, seach by Country of Origin = PHILIPPINES. Country of Origin is an OntologyTerm from udlfds whose fldno = 224.
e.g. SELECT DISTINCT a0.gid, n.nval FROM atributs a0 LEFT JOIN names n ON n.gid = a0.gid WHERE n.nstat = 1 AND a0.atype=224 AND ( a0.aval = 'PHILIPPINES')




Personal tools