Data Retrieval: getting study effects

From ICISWiki

Jump to: navigation, search

Study Effects Queries: (datatype id: StudyBaseConstants.EFFECTS_DATATYPE_ID)

Getting by Study ID:

Searchable attribute id: StudyBaseConstants.UNIQUE_IDENTIFIER_DATATYPE_ATTRIBUTE_ID

SQL query:

SELECT DISTINCT e.effectid, s.sname, s.studyid, s.title FROM study s, effect e, factor f WHERE s.studyid=? and s.studyid = f.studyid and e.factorid = f.factorid


Getting by Study Name:

Searchable attribute id: StudyBaseConstants.NAME_DATATYPE_ATTRIBUTE_ID

SQL query:

Using Operator.EQUAL

SELECT DISTINCT e.effectid, s.sname, s.studyid, s.title FROM study s, effect e, factor f WHERE s.sname=? and s.studyid = f.studyid and e.factorid = f.factorid

Using Operator.LIKE

SELECT DISTINCT e.effectid, s.sname, s.studyid, s.title FROM study s, effect e, factor f
WHERE s.sname like ? and s.studyid = f.studyid and e.factorid = f.factorid

Getting by Representations (Effect.getRepresentations()):

SQL query:

SELECT DISTINCT e.represno, rn.represname FROM effect e, represtn rn WHERE e.effectid=? and e.represno = rn.represno

Retrieved from "http://www.cropinfo.org/icis/index.php/Data_Retrieval:_getting_study_effects"
Personal tools