svndigest - svndigest

src/core/common-queries.xml

: Code
: Comments
: Other

Rev	Date	Author	Line
4889	06 Apr 09	nicklas	1	<?xml version="1.0" encoding="UTF-8" ?>
29	22 Feb 05	nicklas	2	<!DOCTYPE predefined-queries SYSTEM "predefined-queries.dtd" >
29	22 Feb 05	nicklas	3	<!--
2053	22 Feb 06	jari	4	$Id$
29	22 Feb 05	nicklas	5
3675	16 Aug 07	jari	6	Copyright (C) 2005 Samuel Andersson, Johan Enell, Nicklas Nordborg
4889	06 Apr 09	nicklas	7	Copyright (C) 2006 Jari Häkkinen, Nicklas Nordborg, Martin Svensson
3675	16 Aug 07	jari	8	Copyright (C) 2007 Johan Enell, Nicklas Nordborg, Martin Svensson
29	22 Feb 05	nicklas	9
2304	22 May 06	jari	10	This file is part of BASE - BioArray Software Environment.
2304	22 May 06	jari	11	Available at http://base.thep.lu.se/
29	22 Feb 05	nicklas	12
29	22 Feb 05	nicklas	13	BASE is free software; you can redistribute it and/or
29	22 Feb 05	nicklas	14	modify it under the terms of the GNU General Public License
4479	05 Sep 08	jari	15	as published by the Free Software Foundation; either version 3
29	22 Feb 05	nicklas	16	of the License, or (at your option) any later version.
29	22 Feb 05	nicklas	17
29	22 Feb 05	nicklas	18	BASE is distributed in the hope that it will be useful,
29	22 Feb 05	nicklas	19	but WITHOUT ANY WARRANTY; without even the implied warranty of
29	22 Feb 05	nicklas	20	MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
29	22 Feb 05	nicklas	21	GNU General Public License for more details.
29	22 Feb 05	nicklas	22
29	22 Feb 05	nicklas	23	You should have received a copy of the GNU General Public License
4517	11 Sep 08	jari	24	along with BASE. If not, see <http://www.gnu.org/licenses/>.
29	22 Feb 05	nicklas	25	-->
29	22 Feb 05	nicklas	26	<!--
29	22 Feb 05	nicklas	27	This XML file contains HQL and SQL queries that are common
29	22 Feb 05	nicklas	28	to all databases. If one of them happens to fail on your
29	22 Feb 05	nicklas	29	particular database, do not modify this file. Instead, you
29	22 Feb 05	nicklas	30	should add an entry into the file that is specific for your
29	22 Feb 05	nicklas	31	particular database that overrides the query in this file.
7997	09 Aug 21	nicklas	32	For example, for PostgreSQL modify the postgresql-queries.xml.
29	22 Feb 05	nicklas	33	-->
29	22 Feb 05	nicklas	34	<predefined-queries>
29	22 Feb 05	nicklas	35
29	22 Feb 05	nicklas	36	<query id="LOAD_SYSTEM_ITEMS" type="HQL">
29	22 Feb 05	nicklas	37	<sql>
29	22 Feb 05	nicklas	38	SELECT item.id, item.systemId
29	22 Feb 05	nicklas	39	FROM net.sf.basedb.core.data.SystemData item
171	16 Mar 05	nicklas	40	WHERE NOT item.systemId IS NULL
29	22 Feb 05	nicklas	41	</sql>
29	22 Feb 05	nicklas	42	<description>
29	22 Feb 05	nicklas	43	Load the ID and systemID, in that order, of all SystemData
29	22 Feb 05	nicklas	44	items.
29	22 Feb 05	nicklas	45	</description>
29	22 Feb 05	nicklas	46	</query>
29	22 Feb 05	nicklas	47
29	22 Feb 05	nicklas	48	<query id="LOAD_ROLE_KEY_IDS" type="HQL">
29	22 Feb 05	nicklas	49	<sql>
29	22 Feb 05	nicklas	50	SELECT rk.id, rk.itemType
29	22 Feb 05	nicklas	51	FROM RoleKeyData rk
29	22 Feb 05	nicklas	52	</sql>
29	22 Feb 05	nicklas	53	<description>
29	22 Feb 05	nicklas	54	Load the ID and itemType, in that order, of all RoleKeyData
29	22 Feb 05	nicklas	55	items.
29	22 Feb 05	nicklas	56	</description>
29	22 Feb 05	nicklas	57	</query>
29	22 Feb 05	nicklas	58
92	07 Mar 05	nicklas	59	<query id="GET_USER_FOR_LOGIN" type="HQL">
92	07 Mar 05	nicklas	60	<sql>
92	07 Mar 05	nicklas	61	SELECT usr
92	07 Mar 05	nicklas	62	FROM UserData usr
92	07 Mar 05	nicklas	63	WHERE usr.login = :login
92	07 Mar 05	nicklas	64	</sql>
92	07 Mar 05	nicklas	65	<description>
92	07 Mar 05	nicklas	66	Load a user when you know the login.
92	07 Mar 05	nicklas	67	</description>
92	07 Mar 05	nicklas	68	</query>
96	07 Mar 05	nicklas	69
246	23 Mar 05	nicklas	70	<query id="GET_USER_FOR_EXTERNAL_ID" type="HQL">
246	23 Mar 05	nicklas	71	<sql>
246	23 Mar 05	nicklas	72	SELECT usr
246	23 Mar 05	nicklas	73	FROM UserData usr
246	23 Mar 05	nicklas	74	WHERE usr.externalId = :externalId
246	23 Mar 05	nicklas	75	</sql>
246	23 Mar 05	nicklas	76	<description>
246	23 Mar 05	nicklas	77	Load a user when you know the external id.
246	23 Mar 05	nicklas	78	</description>
246	23 Mar 05	nicklas	79	</query>
246	23 Mar 05	nicklas	80
96	07 Mar 05	nicklas	81	<query id="GET_CLIENT_FOR_EXTERNAL_ID" type="HQL">
96	07 Mar 05	nicklas	82	<sql>
96	07 Mar 05	nicklas	83	SELECT cli
96	07 Mar 05	nicklas	84	FROM ClientData cli
96	07 Mar 05	nicklas	85	WHERE cli.externalId = :externalId
96	07 Mar 05	nicklas	86	</sql>
96	07 Mar 05	nicklas	87	<description>
96	07 Mar 05	nicklas	88	Load a client when you know the external ID.
96	07 Mar 05	nicklas	89	</description>
96	07 Mar 05	nicklas	90	</query>
176	16 Mar 05	nicklas	91
176	16 Mar 05	nicklas	92	<query id="GET_ROLE_IDS_FOR_USER" type="HQL">
176	16 Mar 05	nicklas	93	<sql>
176	16 Mar 05	nicklas	94	SELECT ur.roleId
176	16 Mar 05	nicklas	95	FROM UserRoles ur
176	16 Mar 05	nicklas	96	WHERE ur.userId = :userId
176	16 Mar 05	nicklas	97	</sql>
176	16 Mar 05	nicklas	98	<description>
176	16 Mar 05	nicklas	99	Load the ID of all roles where the given user is a member.
176	16 Mar 05	nicklas	100	</description>
176	16 Mar 05	nicklas	101	</query>
29	22 Feb 05	nicklas	102
103	08 Mar 05	nicklas	103	<query id="GET_GROUP_IDS_FOR_USER" type="HQL">
103	08 Mar 05	nicklas	104	<sql>
103	08 Mar 05	nicklas	105	SELECT ug.groupId
103	08 Mar 05	nicklas	106	FROM UserGroups ug
103	08 Mar 05	nicklas	107	WHERE ug.userId = :userId
103	08 Mar 05	nicklas	108	</sql>
103	08 Mar 05	nicklas	109	<description>
103	08 Mar 05	nicklas	110	Load the ID of all groups where the given user is a direct member.
103	08 Mar 05	nicklas	111	</description>
103	08 Mar 05	nicklas	112	</query>
2240	11 May 06	nicklas	113
2240	11 May 06	nicklas	114	<query id="GET_QUOTA_GROUP_ID_FOR_USER" type="HQL">
2240	11 May 06	nicklas	115	<sql>
2240	11 May 06	nicklas	116	SELECT usr.quotaGroup.id
2240	11 May 06	nicklas	117	FROM UserData usr
2240	11 May 06	nicklas	118	WHERE usr.id = :userId
2240	11 May 06	nicklas	119	</sql>
2240	11 May 06	nicklas	120	<description>
2240	11 May 06	nicklas	121	Load the ID of a user's quota group.
2240	11 May 06	nicklas	122	</description>
2240	11 May 06	nicklas	123	</query>
92	07 Mar 05	nicklas	124
103	08 Mar 05	nicklas	125	<query id="GET_PARENTGROUPS_IDS_FOR_GROUPS" type="HQL">
103	08 Mar 05	nicklas	126	<sql>
103	08 Mar 05	nicklas	127	SELECT DISTINCT gg.parentId
103	08 Mar 05	nicklas	128	FROM GroupGroups gg
103	08 Mar 05	nicklas	129	WHERE gg.childId IN (:groups)
103	08 Mar 05	nicklas	130	AND gg.parentId NOT IN (:groups)
103	08 Mar 05	nicklas	131	</sql>
103	08 Mar 05	nicklas	132	<description>
103	08 Mar 05	nicklas	133	Load the ID of all groups that are parents to at least one of
103	08 Mar 05	nicklas	134	the given groups, excluding the given groups.
103	08 Mar 05	nicklas	135	</description>
103	08 Mar 05	nicklas	136	</query>
2648	19 Sep 06	nicklas	137
2648	19 Sep 06	nicklas	138	<query id="GET_CHILDGROUPS_IDS_FOR_GROUPS" type="HQL">
2648	19 Sep 06	nicklas	139	<sql>
2648	19 Sep 06	nicklas	140	SELECT DISTINCT gg.childId
2648	19 Sep 06	nicklas	141	FROM GroupGroups gg
2648	19 Sep 06	nicklas	142	WHERE gg.parentId IN (:groups)
2648	19 Sep 06	nicklas	143	AND gg.childId NOT IN (:groups)
2648	19 Sep 06	nicklas	144	</sql>
2648	19 Sep 06	nicklas	145	<description>
2648	19 Sep 06	nicklas	146	Load the ID of all groups that are children to at least one of
2648	19 Sep 06	nicklas	147	the given groups, excluding the given groups.
2648	19 Sep 06	nicklas	148	</description>
2648	19 Sep 06	nicklas	149	</query>
103	08 Mar 05	nicklas	150
103	08 Mar 05	nicklas	151	<query id="GET_PROJECT_IDS_FOR_OWNER" type="HQL">
103	08 Mar 05	nicklas	152	<sql>
103	08 Mar 05	nicklas	153	SELECT p.id
103	08 Mar 05	nicklas	154	FROM ProjectData p
103	08 Mar 05	nicklas	155	WHERE p.owner = :userId
103	08 Mar 05	nicklas	156	</sql>
103	08 Mar 05	nicklas	157	<description>
103	08 Mar 05	nicklas	158	Load the ID of all projects where the given user is the owner.
103	08 Mar 05	nicklas	159	</description>
103	08 Mar 05	nicklas	160	</query>
103	08 Mar 05	nicklas	161
623	19 May 05	nicklas	162	<query id="GET_PROJECTINFO_FOR_USER" type="HQL">
103	08 Mar 05	nicklas	163	<sql>
623	19 May 05	nicklas	164	SELECT up
103	08 Mar 05	nicklas	165	FROM UserProjects up
103	08 Mar 05	nicklas	166	WHERE up.userId = :userId
103	08 Mar 05	nicklas	167	</sql>
103	08 Mar 05	nicklas	168	<description>
623	19 May 05	nicklas	169	Load the UserProjects of all projects where the given user is a member.
103	08 Mar 05	nicklas	170	</description>
103	08 Mar 05	nicklas	171	</query>
103	08 Mar 05	nicklas	172
623	19 May 05	nicklas	173	<query id="GET_PROJECTINFO_FOR_GROUPS" type="HQL">
103	08 Mar 05	nicklas	174	<sql>
623	19 May 05	nicklas	175	SELECT DISTINCT gp
103	08 Mar 05	nicklas	176	FROM GroupProjects gp
103	08 Mar 05	nicklas	177	WHERE gp.groupId IN (:groups)
103	08 Mar 05	nicklas	178	</sql>
103	08 Mar 05	nicklas	179	<description>
623	19 May 05	nicklas	180	Load the GroupProjects of all projects where at least one of the given groups
103	08 Mar 05	nicklas	181	is a member.
103	08 Mar 05	nicklas	182	</description>
103	08 Mar 05	nicklas	183	</query>
103	08 Mar 05	nicklas	184
103	08 Mar 05	nicklas	185	<query id="GET_USER_IDS_FOR_GROUPS" type="HQL">
103	08 Mar 05	nicklas	186	<sql>
103	08 Mar 05	nicklas	187	SELECT ug.userId
103	08 Mar 05	nicklas	188	FROM UserGroups ug
103	08 Mar 05	nicklas	189	WHERE ug.groupId IN (:groups)
103	08 Mar 05	nicklas	190	</sql>
103	08 Mar 05	nicklas	191	<description>
103	08 Mar 05	nicklas	192	Load the ID of all users which is a member of at least one of the given groups.
103	08 Mar 05	nicklas	193	</description>
103	08 Mar 05	nicklas	194	</query>
103	08 Mar 05	nicklas	195
2240	11 May 06	nicklas	196	<query id="GET_USER_IDS_FOR_QUOTAGROUPS" type="HQL">
2240	11 May 06	nicklas	197	<sql>
2240	11 May 06	nicklas	198	SELECT usr.id
2240	11 May 06	nicklas	199	FROM UserData usr
2240	11 May 06	nicklas	200	WHERE usr.quotaGroup.id IN (:groups)
2240	11 May 06	nicklas	201	</sql>
2240	11 May 06	nicklas	202	<description>
2240	11 May 06	nicklas	203	Load the ID of all users which has a quota group from one of the given groups.
2240	11 May 06	nicklas	204	</description>
2240	11 May 06	nicklas	205	</query>
2240	11 May 06	nicklas	206
3190	13 Mar 07	enell	207	<query id="GET_USER_IDS_FOR_PROJECT" type="HQL">
3190	13 Mar 07	enell	208	<sql>
3190	13 Mar 07	enell	209	SELECT up.userId
3190	13 Mar 07	enell	210	FROM UserProjects up
3190	13 Mar 07	enell	211	WHERE up.projectId = :projectId
3190	13 Mar 07	enell	212	</sql>
3190	13 Mar 07	enell	213	<description>
3190	13 Mar 07	enell	214	Load the ID of all users which are direct member of the given project
3190	13 Mar 07	enell	215	</description>
3190	13 Mar 07	enell	216	</query>
3190	13 Mar 07	enell	217
3190	13 Mar 07	enell	218	<query id="GET_GROUP_IDS_FOR_PROJECT" type="HQL">
3190	13 Mar 07	enell	219	<sql>
3190	13 Mar 07	enell	220	SELECT gp.groupId
3190	13 Mar 07	enell	221	FROM GroupProjects gp
3190	13 Mar 07	enell	222	WHERE gp.projectId = :projectId
3190	13 Mar 07	enell	223	</sql>
3190	13 Mar 07	enell	224	<description>
3190	13 Mar 07	enell	225	Load the ID of all groups which are direct member of the given project
3190	13 Mar 07	enell	226	</description>
3190	13 Mar 07	enell	227	</query>
3190	13 Mar 07	enell	228
103	08 Mar 05	nicklas	229	<query id="GET_USERKEYS_FOR_USER" type="HQL">
103	08 Mar 05	nicklas	230	<sql>
103	08 Mar 05	nicklas	231	SELECT uk
103	08 Mar 05	nicklas	232	FROM UserKeys uk
103	08 Mar 05	nicklas	233	WHERE uk.userId = :userId
103	08 Mar 05	nicklas	234	</sql>
103	08 Mar 05	nicklas	235	<description>
103	08 Mar 05	nicklas	236	Load the UserKeys for the given user.
103	08 Mar 05	nicklas	237	</description>
103	08 Mar 05	nicklas	238	</query>
103	08 Mar 05	nicklas	239
103	08 Mar 05	nicklas	240	<query id="GET_GROUPKEYS_FOR_GROUPS" type="HQL">
103	08 Mar 05	nicklas	241	<sql>
103	08 Mar 05	nicklas	242	SELECT gk
103	08 Mar 05	nicklas	243	FROM GroupKeys gk
103	08 Mar 05	nicklas	244	WHERE gk.groupId IN (:groups)
103	08 Mar 05	nicklas	245	</sql>
103	08 Mar 05	nicklas	246	<description>
103	08 Mar 05	nicklas	247	Load the GroupKeys for the given groups.
103	08 Mar 05	nicklas	248	</description>
103	08 Mar 05	nicklas	249	</query>
103	08 Mar 05	nicklas	250
103	08 Mar 05	nicklas	251	<query id="GET_ROLEKEYS_FOR_USER" type="HQL">
103	08 Mar 05	nicklas	252	<sql>
103	08 Mar 05	nicklas	253	SELECT rk
103	08 Mar 05	nicklas	254	FROM RoleKeys rk, UserRoles ur
103	08 Mar 05	nicklas	255	WHERE rk.roleId = ur.roleId AND ur.userId = :userId
103	08 Mar 05	nicklas	256	ORDER BY rk.keyId
103	08 Mar 05	nicklas	257	</sql>
103	08 Mar 05	nicklas	258	<description>
103	08 Mar 05	nicklas	259	Load the RoleKeys for the roles where the given user is a member.
103	08 Mar 05	nicklas	260	</description>
103	08 Mar 05	nicklas	261	</query>
103	08 Mar 05	nicklas	262
103	08 Mar 05	nicklas	263	<query id="GET_PROJECTKEYS_FOR_PROJECT" type="HQL">
103	08 Mar 05	nicklas	264	<sql>
103	08 Mar 05	nicklas	265	SELECT pk
103	08 Mar 05	nicklas	266	FROM ProjectKeys pk
103	08 Mar 05	nicklas	267	WHERE pk.projectId = :projectId
103	08 Mar 05	nicklas	268	ORDER BY pk.keyId
103	08 Mar 05	nicklas	269	</sql>
103	08 Mar 05	nicklas	270	<description>
2218	05 May 06	nicklas	271	Load the ProjectKeys for the given project. Sort by
2218	05 May 06	nicklas	272	keyId for fast lookup in array (Keyring class).
103	08 Mar 05	nicklas	273	</description>
103	08 Mar 05	nicklas	274	</query>
2218	05 May 06	nicklas	275
2218	05 May 06	nicklas	276	<query id="GET_PROJECTKEYIDS_FOR_PROJECT" type="HQL">
2218	05 May 06	nicklas	277	<sql>
2218	05 May 06	nicklas	278	SELECT pk.keyId
2218	05 May 06	nicklas	279	FROM ProjectKeys pk
2218	05 May 06	nicklas	280	WHERE pk.projectId = :projectId
2218	05 May 06	nicklas	281	</sql>
2218	05 May 06	nicklas	282	<description>
2218	05 May 06	nicklas	283	Load the ID of ProjectKeys for the given project.
2218	05 May 06	nicklas	284	</description>
2218	05 May 06	nicklas	285	</query>
103	08 Mar 05	nicklas	286
151	11 Mar 05	nicklas	287	<query id="GET_PROJECTKEY_IDS_FOR_COUNT" type="HQL">
151	11 Mar 05	nicklas	288	<sql>
151	11 Mar 05	nicklas	289	SELECT pk.keyId FROM ProjectKeys pk
151	11 Mar 05	nicklas	290	GROUP BY pk.keyId
187	17 Mar 05	nicklas	291	HAVING count(pk.projectId) = :numPermissions
151	11 Mar 05	nicklas	292	</sql>
151	11 Mar 05	nicklas	293	<description>
162	15 Mar 05	nicklas	294	Load the ID of all project keys which have permissions for the
162	15 Mar 05	nicklas	295	specified number of projects.
151	11 Mar 05	nicklas	296	</description>
151	11 Mar 05	nicklas	297	</query>
103	08 Mar 05	nicklas	298
171	16 Mar 05	nicklas	299	<query id="FIND_USED_PROJECTKEY_IDS" type="HQL">
162	15 Mar 05	nicklas	300	<sql>
171	16 Mar 05	nicklas	301	SELECT DISTINCT sd.projectKey.id
162	15 Mar 05	nicklas	302	FROM net.sf.basedb.core.data.ShareableData sd
162	15 Mar 05	nicklas	303	WHERE NOT sd.projectKey IS NULL
162	15 Mar 05	nicklas	304	</sql>
162	15 Mar 05	nicklas	305	<description>
171	16 Mar 05	nicklas	306	Load the ID of all project keys which are used by at least one
162	15 Mar 05	nicklas	307	shareable item.
162	15 Mar 05	nicklas	308	</description>
162	15 Mar 05	nicklas	309	</query>
162	15 Mar 05	nicklas	310
171	16 Mar 05	nicklas	311	<query id="SELECT_UNUSED_PROJECTKEYS" type="HQL">
162	15 Mar 05	nicklas	312	<sql>
171	16 Mar 05	nicklas	313	SELECT pk FROM ProjectKeyData pk
171	16 Mar 05	nicklas	314	WHERE pk.id NOT IN (:used)
162	15 Mar 05	nicklas	315	</sql>
162	15 Mar 05	nicklas	316	<description>
171	16 Mar 05	nicklas	317	Load all unused project keys given a list of the ID:s of all used
171	16 Mar 05	nicklas	318	keys.
162	15 Mar 05	nicklas	319	</description>
162	15 Mar 05	nicklas	320	</query>
103	08 Mar 05	nicklas	321
162	15 Mar 05	nicklas	322	<query id="GET_ITEMKEY_IDS_FOR_USERCOUNT" type="HQL">
162	15 Mar 05	nicklas	323	<sql>
162	15 Mar 05	nicklas	324	SELECT ik.id FROM ItemKeyData ik
162	15 Mar 05	nicklas	325	LEFT JOIN ik.users u
162	15 Mar 05	nicklas	326	GROUP BY ik.id
171	16 Mar 05	nicklas	327	HAVING COUNT(u.index) = :numPermissions
162	15 Mar 05	nicklas	328	</sql>
162	15 Mar 05	nicklas	329	<description>
162	15 Mar 05	nicklas	330	Load the ID of all item keys which have permissions for the
162	15 Mar 05	nicklas	331	specified number of users.
162	15 Mar 05	nicklas	332	</description>
162	15 Mar 05	nicklas	333	</query>
162	15 Mar 05	nicklas	334
162	15 Mar 05	nicklas	335	<query id="GET_ITEMKEY_IDS_FOR_GROUPCOUNT" type="HQL">
162	15 Mar 05	nicklas	336	<sql>
162	15 Mar 05	nicklas	337	SELECT ik.id FROM ItemKeyData ik
171	16 Mar 05	nicklas	338	LEFT JOIN ik.groups g
162	15 Mar 05	nicklas	339	WHERE ik.id IN (:candidates)
162	15 Mar 05	nicklas	340	GROUP BY ik.id
187	17 Mar 05	nicklas	341	HAVING count(g.index) = :numPermissions
162	15 Mar 05	nicklas	342	</sql>
162	15 Mar 05	nicklas	343	<description>
162	15 Mar 05	nicklas	344	Load the ID of all item keys which have permissions for the
162	15 Mar 05	nicklas	345	specified number of groups and are among the list of candidates.
162	15 Mar 05	nicklas	346	</description>
162	15 Mar 05	nicklas	347	</query>
171	16 Mar 05	nicklas	348
171	16 Mar 05	nicklas	349	<query id="FIND_USED_ITEMKEY_IDS" type="HQL">
171	16 Mar 05	nicklas	350	<sql>
171	16 Mar 05	nicklas	351	SELECT DISTINCT sd.itemKey.id
171	16 Mar 05	nicklas	352	FROM net.sf.basedb.core.data.ShareableData sd
171	16 Mar 05	nicklas	353	WHERE NOT sd.itemKey IS NULL
171	16 Mar 05	nicklas	354	</sql>
171	16 Mar 05	nicklas	355	<description>
171	16 Mar 05	nicklas	356	Load the ID of all item keys which are used by at least one
171	16 Mar 05	nicklas	357	shareable item.
171	16 Mar 05	nicklas	358	</description>
171	16 Mar 05	nicklas	359	</query>
171	16 Mar 05	nicklas	360
171	16 Mar 05	nicklas	361	<query id="SELECT_UNUSED_ITEMKEYS" type="HQL">
171	16 Mar 05	nicklas	362	<sql>
171	16 Mar 05	nicklas	363	SELECT ik FROM ItemKeyData ik
171	16 Mar 05	nicklas	364	WHERE ik.id NOT IN (:used)
171	16 Mar 05	nicklas	365	</sql>
171	16 Mar 05	nicklas	366	<description>
171	16 Mar 05	nicklas	367	Load all unused item keys given a list of the ID:s of all used
171	16 Mar 05	nicklas	368	keys.
171	16 Mar 05	nicklas	369	</description>
171	16 Mar 05	nicklas	370	</query>
162	15 Mar 05	nicklas	371
2898	13 Nov 06	nicklas	372	<query id="GET_USERS_FOR_QUOTAGROUP" type="HQL">
182	17 Mar 05	nicklas	373	<sql>
2898	13 Nov 06	nicklas	374	SELECT {1}
182	17 Mar 05	nicklas	375	FROM UserData usr
187	17 Mar 05	nicklas	376	WHERE usr.quotaGroup = :theGroup
182	17 Mar 05	nicklas	377	</sql>
182	17 Mar 05	nicklas	378	<description>
2898	13 Nov 06	nicklas	379	Get users having the specified group as
182	17 Mar 05	nicklas	380	their quota group.
182	17 Mar 05	nicklas	381	</description>
182	17 Mar 05	nicklas	382	</query>
400	15 Apr 05	enell	383
2898	13 Nov 06	nicklas	384	<query id="GET_USERS_FOR_QUOTA" type="HQL">
400	15 Apr 05	enell	385	<sql>
2898	13 Nov 06	nicklas	386	SELECT {1}
400	15 Apr 05	enell	387	FROM UserData u
400	15 Apr 05	enell	388	WHERE u.quota = :quota
400	15 Apr 05	enell	389	</sql>
400	15 Apr 05	enell	390	<description>
2898	13 Nov 06	nicklas	391	A Hibernate query that gets users
400	15 Apr 05	enell	392	that has been assigned a given quota.
400	15 Apr 05	enell	393	</description>
400	15 Apr 05	enell	394	</query>
400	15 Apr 05	enell	395
2898	13 Nov 06	nicklas	396	<query id="GET_GROUPS_FOR_QUOTA" type="HQL">
400	15 Apr 05	enell	397	<sql>
2898	13 Nov 06	nicklas	398	SELECT {1}
400	15 Apr 05	enell	399	FROM GroupData g
400	15 Apr 05	enell	400	WHERE g.quota = :quota
400	15 Apr 05	enell	401	</sql>
400	15 Apr 05	enell	402	<description>
2898	13 Nov 06	nicklas	403	A Hibernate query that gets groups
400	15 Apr 05	enell	404	that has been assigned a given quota.
400	15 Apr 05	enell	405	</description>
400	15 Apr 05	enell	406	</query>
162	15 Mar 05	nicklas	407
182	17 Mar 05	nicklas	408	<query id="GET_SHAREABLE_ITEMS_FOR_ITEMKEY" type="HQL">
182	17 Mar 05	nicklas	409	<sql>
182	17 Mar 05	nicklas	410	SELECT s
182	17 Mar 05	nicklas	411	FROM net.sf.basedb.core.data.ShareableData s
182	17 Mar 05	nicklas	412	WHERE s.itemKey = :itemKey
182	17 Mar 05	nicklas	413	</sql>
182	17 Mar 05	nicklas	414	<description>
182	17 Mar 05	nicklas	415	Get all items beeing shared to the specified item key.
182	17 Mar 05	nicklas	416	</description>
182	17 Mar 05	nicklas	417	</query>
171	16 Mar 05	nicklas	418
182	17 Mar 05	nicklas	419	<query id="GET_SHAREABLE_ITEMS_FOR_PROJECTKEY" type="HQL">
182	17 Mar 05	nicklas	420	<sql>
182	17 Mar 05	nicklas	421	SELECT s
182	17 Mar 05	nicklas	422	FROM net.sf.basedb.core.data.ShareableData s
182	17 Mar 05	nicklas	423	WHERE s.projectKey = :projectKey
182	17 Mar 05	nicklas	424	</sql>
182	17 Mar 05	nicklas	425	<description>
182	17 Mar 05	nicklas	426	Get all items beeing shared to the specified project key.
182	17 Mar 05	nicklas	427	</description>
182	17 Mar 05	nicklas	428	</query>
2218	05 May 06	nicklas	429
182	17 Mar 05	nicklas	430	<query id="GET_OWNABLE_ITEMS_FOR_USER" type="HQL">
182	17 Mar 05	nicklas	431	<sql>
182	17 Mar 05	nicklas	432	SELECT o
182	17 Mar 05	nicklas	433	FROM net.sf.basedb.core.data.OwnableData o
182	17 Mar 05	nicklas	434	WHERE o.owner = :user
182	17 Mar 05	nicklas	435	</sql>
182	17 Mar 05	nicklas	436	<description>
182	17 Mar 05	nicklas	437	Get all items that are owned by the specified user.
182	17 Mar 05	nicklas	438	</description>
182	17 Mar 05	nicklas	439	</query>
213	22 Mar 05	nicklas	440
213	22 Mar 05	nicklas	441	<query id="LOAD_USER_CLIENT_SETTINGS" type="HQL">
213	22 Mar 05	nicklas	442	<sql>
213	22 Mar 05	nicklas	443	SELECT s
213	22 Mar 05	nicklas	444	FROM UserClientSettingData s
213	22 Mar 05	nicklas	445	WHERE s.user = :user AND s.client = :client
213	22 Mar 05	nicklas	446	</sql>
213	22 Mar 05	nicklas	447	<description>
213	22 Mar 05	nicklas	448	Load all settings for the specified user and client application.
213	22 Mar 05	nicklas	449	</description>
213	22 Mar 05	nicklas	450	</query>
213	22 Mar 05	nicklas	451
213	22 Mar 05	nicklas	452	<query id="LOAD_USER_DEFAULT_SETTINGS" type="HQL">
213	22 Mar 05	nicklas	453	<sql>
213	22 Mar 05	nicklas	454	SELECT s
213	22 Mar 05	nicklas	455	FROM UserDefaultSettingData s
213	22 Mar 05	nicklas	456	WHERE s.user = :user
213	22 Mar 05	nicklas	457	</sql>
213	22 Mar 05	nicklas	458	<description>
213	22 Mar 05	nicklas	459	Load all default settings for the specified user.
213	22 Mar 05	nicklas	460	</description>
213	22 Mar 05	nicklas	461	</query>
182	17 Mar 05	nicklas	462
213	22 Mar 05	nicklas	463	<query id="LOAD_CLIENT_DEFAULT_SETTINGS" type="HQL">
213	22 Mar 05	nicklas	464	<sql>
213	22 Mar 05	nicklas	465	SELECT s
213	22 Mar 05	nicklas	466	FROM ClientDefaultSettingData s
213	22 Mar 05	nicklas	467	WHERE s.client = :client
213	22 Mar 05	nicklas	468	</sql>
213	22 Mar 05	nicklas	469	<description>
213	22 Mar 05	nicklas	470	Load all default settings for the specified client application.
213	22 Mar 05	nicklas	471	</description>
213	22 Mar 05	nicklas	472	</query>
343	01 Apr 05	enell	473
343	01 Apr 05	enell	474	<query id="GET_MIME_TYPE_FROM_EXTENSION" type="HQL">
343	01 Apr 05	enell	475	<sql>
343	01 Apr 05	enell	476	SELECT s
343	01 Apr 05	enell	477	FROM net.sf.basedb.core.data.MimeTypeData s
4095	21 Jan 08	enell	478	WHERE LOWER(s.extension) = LOWER(:extension)
343	01 Apr 05	enell	479	</sql>
343	01 Apr 05	enell	480	<description>
343	01 Apr 05	enell	481	A Hibernate query that returns a MimeType given an extension.
343	01 Apr 05	enell	482	</description>
343	01 Apr 05	enell	483	</query>
410	15 Apr 05	enell	484
410	15 Apr 05	enell	485	<query id="GET_TOTAL_DISKUSAGE_FOR_USER" type="HQL">
410	15 Apr 05	enell	486	<sql>
410	15 Apr 05	enell	487	SELECT sum(du.bytes)
410	15 Apr 05	enell	488	FROM DiskUsageData du
410	15 Apr 05	enell	489	WHERE du.user = :user
410	15 Apr 05	enell	490	AND du.location = :location
410	15 Apr 05	enell	491	</sql>
410	15 Apr 05	enell	492	<description>
410	15 Apr 05	enell	493	A Hibernate query that returns the total used quota
484	28 Apr 05	nicklas	494	for the specified user at the specified location.
410	15 Apr 05	enell	495	</description>
410	15 Apr 05	enell	496	</query>
410	15 Apr 05	enell	497
410	15 Apr 05	enell	498	<query id="GET_SPECIFIC_DISKUSAGE_FOR_USER" type="HQL">
410	15 Apr 05	enell	499	<sql>
410	15 Apr 05	enell	500	SELECT sum(du.bytes)
410	15 Apr 05	enell	501	FROM DiskUsageData du
410	15 Apr 05	enell	502	WHERE du.user = :user
410	15 Apr 05	enell	503	AND du.location = :location
410	15 Apr 05	enell	504	AND du.quotaType = :quotaType
410	15 Apr 05	enell	505	</sql>
410	15 Apr 05	enell	506	<description>
410	15 Apr 05	enell	507	A Hibernate query that returns the used quota for the
410	15 Apr 05	enell	508	specific quota type for the specified user at the
484	28 Apr 05	nicklas	509	specified location.
410	15 Apr 05	enell	510	</description>
410	15 Apr 05	enell	511	</query>
473	27 Apr 05	enell	512
485	28 Apr 05	nicklas	513	<query id="GET_TOTAL_DISKUSAGE_FOR_GROUP" type="HQL">
485	28 Apr 05	nicklas	514	<sql>
485	28 Apr 05	nicklas	515	SELECT sum(du.bytes)
485	28 Apr 05	nicklas	516	FROM DiskUsageData du
485	28 Apr 05	nicklas	517	WHERE du.group = :group
485	28 Apr 05	nicklas	518	AND du.location = :location
485	28 Apr 05	nicklas	519	</sql>
485	28 Apr 05	nicklas	520	<description>
485	28 Apr 05	nicklas	521	A Hibernate query that returns the total used quota
485	28 Apr 05	nicklas	522	for the specified group at the specified location.
485	28 Apr 05	nicklas	523	</description>
485	28 Apr 05	nicklas	524	</query>
478	27 Apr 05	enell	525
485	28 Apr 05	nicklas	526	<query id="GET_SPECIFIC_DISKUSAGE_FOR_GROUP" type="HQL">
485	28 Apr 05	nicklas	527	<sql>
485	28 Apr 05	nicklas	528	SELECT sum(du.bytes)
485	28 Apr 05	nicklas	529	FROM DiskUsageData du
485	28 Apr 05	nicklas	530	WHERE du.group = :group
485	28 Apr 05	nicklas	531	AND du.location = :location
485	28 Apr 05	nicklas	532	AND du.quotaType = :quotaType
485	28 Apr 05	nicklas	533	</sql>
485	28 Apr 05	nicklas	534	<description>
485	28 Apr 05	nicklas	535	A Hibernate query that returns the used quota for the
485	28 Apr 05	nicklas	536	specific quota type for the specified group at the
485	28 Apr 05	nicklas	537	specified location.
485	28 Apr 05	nicklas	538	</description>
485	28 Apr 05	nicklas	539	</query>
485	28 Apr 05	nicklas	540
2927	16 Nov 06	nicklas	541	<query id="GET_TOTAL_DISKUSAGE_SUMMARY" type="HQL">
2927	16 Nov 06	nicklas	542	<sql>
2927	16 Nov 06	nicklas	543	SELECT SUM(du.bytes), du.location, du.quotaType.systemId
2927	16 Nov 06	nicklas	544	FROM DiskUsageData du
2927	16 Nov 06	nicklas	545	GROUP BY du.location, du.quotaType.systemId
2927	16 Nov 06	nicklas	546	</sql>
2927	16 Nov 06	nicklas	547	<description>
2927	16 Nov 06	nicklas	548	A Hibernate query that returns the total disk usage grouped
2927	16 Nov 06	nicklas	549	by location and quota type system id.
2927	16 Nov 06	nicklas	550	</description>
2927	16 Nov 06	nicklas	551	</query>
2927	16 Nov 06	nicklas	552
2927	16 Nov 06	nicklas	553	<query id="GET_DISKUSAGE_SUMMARY_FOR_USER" type="HQL">
2927	16 Nov 06	nicklas	554	<sql>
2927	16 Nov 06	nicklas	555	SELECT SUM(du.bytes), du.location, du.quotaType.systemId
2927	16 Nov 06	nicklas	556	FROM DiskUsageData du
2927	16 Nov 06	nicklas	557	WHERE du.user = :user
2927	16 Nov 06	nicklas	558	GROUP BY du.location, du.quotaType.systemId
2927	16 Nov 06	nicklas	559	</sql>
2927	16 Nov 06	nicklas	560	<description>
2927	16 Nov 06	nicklas	561	A Hibernate query that returns the disk usage for a user grouped
2927	16 Nov 06	nicklas	562	by location and quota type system id.
2927	16 Nov 06	nicklas	563	</description>
2927	16 Nov 06	nicklas	564	</query>
2927	16 Nov 06	nicklas	565
2927	16 Nov 06	nicklas	566	<query id="GET_DISKUSAGE_SUMMARY_FOR_GROUP" type="HQL">
2927	16 Nov 06	nicklas	567	<sql>
2927	16 Nov 06	nicklas	568	SELECT SUM(du.bytes), du.location, du.quotaType.systemId
2927	16 Nov 06	nicklas	569	FROM DiskUsageData du
2927	16 Nov 06	nicklas	570	WHERE du.group = :group
2927	16 Nov 06	nicklas	571	GROUP BY du.location, du.quotaType.systemId
2927	16 Nov 06	nicklas	572	</sql>
2927	16 Nov 06	nicklas	573	<description>
2927	16 Nov 06	nicklas	574	A Hibernate query that returns the disk usage for a group grouped
2927	16 Nov 06	nicklas	575	by location and quota type system id.
2927	16 Nov 06	nicklas	576	</description>
2927	16 Nov 06	nicklas	577	</query>
2927	16 Nov 06	nicklas	578
2898	13 Nov 06	nicklas	579	<query id="GET_FILES_IN_DIRECTORY" type="HQL">
473	27 Apr 05	enell	580	<sql>
2898	13 Nov 06	nicklas	581	SELECT {1}
473	27 Apr 05	enell	582	FROM FileData f
473	27 Apr 05	enell	583	WHERE f.directory = :directory
473	27 Apr 05	enell	584	</sql>
473	27 Apr 05	enell	585	<description>
2898	13 Nov 06	nicklas	586	A Hibernate query that gets the files
473	27 Apr 05	enell	587	in a given directory.
473	27 Apr 05	enell	588	</description>
473	27 Apr 05	enell	589	</query>
473	27 Apr 05	enell	590
5360	11 Jun 10	nicklas	591	<query id="GET_FILES_FOR_FILESERVER" type="HQL">
5360	11 Jun 10	nicklas	592	<sql>
5360	11 Jun 10	nicklas	593	SELECT {1}
5360	11 Jun 10	nicklas	594	FROM FileData f
5360	11 Jun 10	nicklas	595	WHERE f.fileServer = :fileServer
5360	11 Jun 10	nicklas	596	</sql>
5360	11 Jun 10	nicklas	597	<description>
5360	11 Jun 10	nicklas	598	A Hibernate query that gets the files
5360	11 Jun 10	nicklas	599	with a given file server.
5360	11 Jun 10	nicklas	600	</description>
5360	11 Jun 10	nicklas	601	</query>
5360	11 Jun 10	nicklas	602
5360	11 Jun 10	nicklas	603
2898	13 Nov 06	nicklas	604	<query id="GET_SUBDIRECTORIES_IN_DIRECTORY" type="HQL">
473	27 Apr 05	enell	605	<sql>
2898	13 Nov 06	nicklas	606	SELECT {1}
473	27 Apr 05	enell	607	FROM DirectoryData d
473	27 Apr 05	enell	608	WHERE d.parent = :directory
473	27 Apr 05	enell	609	</sql>
473	27 Apr 05	enell	610	<description>
2898	13 Nov 06	nicklas	611	A Hibernate query that gets the subdirectories
473	27 Apr 05	enell	612	in a given directory.
473	27 Apr 05	enell	613	</description>
473	27 Apr 05	enell	614	</query>
678	30 May 05	nicklas	615
2898	13 Nov 06	nicklas	616	<query id="GET_HOME_DIRECTORIES" type="HQL">
678	30 May 05	nicklas	617	<sql>
2898	13 Nov 06	nicklas	618	SELECT {1}
678	30 May 05	nicklas	619	FROM UserData usr
678	30 May 05	nicklas	620	WHERE usr.homeDirectory = :directory
678	30 May 05	nicklas	621	</sql>
678	30 May 05	nicklas	622	<description>
2898	13 Nov 06	nicklas	623	A Hibernate query that gets the users having
678	30 May 05	nicklas	624	the specified directory as home directory.
678	30 May 05	nicklas	625	</description>
678	30 May 05	nicklas	626	</query>
2694	03 Oct 06	nicklas	627
2898	13 Nov 06	nicklas	628	<query id="GET_EXPERIMENT_DIRECTORIES" type="HQL">
2694	03 Oct 06	nicklas	629	<sql>
2898	13 Nov 06	nicklas	630	SELECT {1}
2694	03 Oct 06	nicklas	631	FROM ExperimentData xpr
2694	03 Oct 06	nicklas	632	WHERE xpr.directory = :directory
2694	03 Oct 06	nicklas	633	</sql>
2694	03 Oct 06	nicklas	634	<description>
2898	13 Nov 06	nicklas	635	A Hibernate query that gets the experiments having
2694	03 Oct 06	nicklas	636	the specified directory as the plugin directory.
2694	03 Oct 06	nicklas	637	</description>
2694	03 Oct 06	nicklas	638	</query>
474	27 Apr 05	enell	639
676	30 May 05	nicklas	640	<query id="GET_SUBDIRECTORIES" type="HQL">
676	30 May 05	nicklas	641	<sql>
676	30 May 05	nicklas	642	SELECT dir
676	30 May 05	nicklas	643	FROM DirectoryData dir
676	30 May 05	nicklas	644	WHERE dir.parent = :parent
676	30 May 05	nicklas	645	</sql>
676	30 May 05	nicklas	646	<description>
676	30 May 05	nicklas	647	A Hibernate query that returns all subdirectories in a directory.
676	30 May 05	nicklas	648	</description>
676	30 May 05	nicklas	649	</query>
676	30 May 05	nicklas	650
676	30 May 05	nicklas	651	<query id="GET_SUBDIRECTORY_WITH_NAME" type="HQL">
676	30 May 05	nicklas	652	<sql>
676	30 May 05	nicklas	653	SELECT dir
677	30 May 05	nicklas	654	FROM DirectoryData dir
676	30 May 05	nicklas	655	WHERE dir.name = :name
676	30 May 05	nicklas	656	AND dir.parent = :parent
676	30 May 05	nicklas	657	</sql>
676	30 May 05	nicklas	658	<description>
676	30 May 05	nicklas	659	A Hibernate query that returns the a subdirectory with the
680	31 May 05	nicklas	660	specified name in a given directory.
676	30 May 05	nicklas	661	</description>
676	30 May 05	nicklas	662	</query>
2021	17 Feb 06	nicklas	663
2021	17 Feb 06	nicklas	664	<query id="GET_QUOTA_TYPE_WITH_NAME" type="HQL">
2021	17 Feb 06	nicklas	665	<sql>
2021	17 Feb 06	nicklas	666	SELECT qt
2021	17 Feb 06	nicklas	667	FROM QuotaTypeData qt
2021	17 Feb 06	nicklas	668	WHERE qt.name = :name
2021	17 Feb 06	nicklas	669	</sql>
2021	17 Feb 06	nicklas	670	<description>
2021	17 Feb 06	nicklas	671	A Hibernate query that returns the quota type with the specified
2021	17 Feb 06	nicklas	672	name.
2021	17 Feb 06	nicklas	673	</description>
2021	17 Feb 06	nicklas	674	</query>
2021	17 Feb 06	nicklas	675
2021	17 Feb 06	nicklas	676	<query id="GET_QUOTA_WITH_NAME" type="HQL">
2021	17 Feb 06	nicklas	677	<sql>
2021	17 Feb 06	nicklas	678	SELECT q
2021	17 Feb 06	nicklas	679	FROM QuotaData q
2021	17 Feb 06	nicklas	680	WHERE q.name = :name
2021	17 Feb 06	nicklas	681	</sql>
2021	17 Feb 06	nicklas	682	<description>
2021	17 Feb 06	nicklas	683	A Hibernate query that returns the quota with the specified
2021	17 Feb 06	nicklas	684	name.
2021	17 Feb 06	nicklas	685	</description>
2021	17 Feb 06	nicklas	686	</query>
2021	17 Feb 06	nicklas	687
2021	17 Feb 06	nicklas	688	<query id="GET_GROUP_WITH_NAME" type="HQL">
2021	17 Feb 06	nicklas	689	<sql>
2021	17 Feb 06	nicklas	690	SELECT grp
2021	17 Feb 06	nicklas	691	FROM GroupData grp
2021	17 Feb 06	nicklas	692	WHERE grp.name = :name
2021	17 Feb 06	nicklas	693	</sql>
2021	17 Feb 06	nicklas	694	<description>
2021	17 Feb 06	nicklas	695	A Hibernate query that returns the group with the specified
2021	17 Feb 06	nicklas	696	name.
2021	17 Feb 06	nicklas	697	</description>
2021	17 Feb 06	nicklas	698	</query>
2021	17 Feb 06	nicklas	699
2021	17 Feb 06	nicklas	700	<query id="GET_ROLE_WITH_NAME" type="HQL">
2021	17 Feb 06	nicklas	701	<sql>
2021	17 Feb 06	nicklas	702	SELECT rle
2021	17 Feb 06	nicklas	703	FROM RoleData rle
2021	17 Feb 06	nicklas	704	WHERE rle.name = :name
2021	17 Feb 06	nicklas	705	</sql>
2021	17 Feb 06	nicklas	706	<description>
2021	17 Feb 06	nicklas	707	A Hibernate query that returns the role with the specified
2021	17 Feb 06	nicklas	708	name.
2021	17 Feb 06	nicklas	709	</description>
2021	17 Feb 06	nicklas	710	</query>
2021	17 Feb 06	nicklas	711
2021	17 Feb 06	nicklas	712	<query id="GET_SOFTWARE_WITH_NAME" type="HQL">
2021	17 Feb 06	nicklas	713	<sql>
2021	17 Feb 06	nicklas	714	SELECT sw
2021	17 Feb 06	nicklas	715	FROM SoftwareData sw
2021	17 Feb 06	nicklas	716	WHERE sw.name = :name
2021	17 Feb 06	nicklas	717	</sql>
2021	17 Feb 06	nicklas	718	<description>
2021	17 Feb 06	nicklas	719	A Hibernate query that returns the software with the specified
2021	17 Feb 06	nicklas	720	name.
2021	17 Feb 06	nicklas	721	</description>
2021	17 Feb 06	nicklas	722	</query>
2021	17 Feb 06	nicklas	723
2021	17 Feb 06	nicklas	724	<query id="GET_HARDWARE_WITH_NAME" type="HQL">
2021	17 Feb 06	nicklas	725	<sql>
2021	17 Feb 06	nicklas	726	SELECT hw
2021	17 Feb 06	nicklas	727	FROM HardwareData hw
2021	17 Feb 06	nicklas	728	WHERE hw.name = :name
2021	17 Feb 06	nicklas	729	</sql>
2021	17 Feb 06	nicklas	730	<description>
2021	17 Feb 06	nicklas	731	A Hibernate query that returns the hardware with the specified
2021	17 Feb 06	nicklas	732	name.
2021	17 Feb 06	nicklas	733	</description>
2021	17 Feb 06	nicklas	734	</query>
2021	17 Feb 06	nicklas	735
5355	04 Jun 10	nicklas	736	<query id="GET_PLATE_GEOMETRY_WITH_SIZE" type="HQL">
5355	04 Jun 10	nicklas	737	<sql>
5355	04 Jun 10	nicklas	738	SELECT pg
5355	04 Jun 10	nicklas	739	FROM PlateGeometryData pg
5355	04 Jun 10	nicklas	740	WHERE pg.rows = :rows AND pg.columns = :columns
5355	04 Jun 10	nicklas	741	</sql>
5355	04 Jun 10	nicklas	742	<description>
5355	04 Jun 10	nicklas	743	A Hibernate query that returns the plate geometry with the specified
5355	04 Jun 10	nicklas	744	size (rows and columns).
5355	04 Jun 10	nicklas	745	</description>
5355	04 Jun 10	nicklas	746	</query>
5355	04 Jun 10	nicklas	747
5355	04 Jun 10	nicklas	748	<query id="GET_PLATE_MAPPING_WITH_PROPERTIES" type="HQL">
5355	04 Jun 10	nicklas	749	<sql>
5355	04 Jun 10	nicklas	750	SELECT pm
5355	04 Jun 10	nicklas	751	FROM PlateMappingData pm
5355	04 Jun 10	nicklas	752	WHERE pm.sourceCount = :sourceCount AND pm.sourceGeometry = :sourceGeometry
5355	04 Jun 10	nicklas	753	AND pm.destinationCount = :destinationCount AND pm.destinationGeometry = :destinationGeometry
5355	04 Jun 10	nicklas	754	</sql>
5355	04 Jun 10	nicklas	755	<description>
5355	04 Jun 10	nicklas	756	A Hibernate query that returns the plate mapping with the specified
5355	04 Jun 10	nicklas	757	source and destination properties.
5355	04 Jun 10	nicklas	758	</description>
5355	04 Jun 10	nicklas	759	</query>
5355	04 Jun 10	nicklas	760
5632	17 May 11	nicklas	761	<query id="GET_TAG_WITH_NAME" type="HQL">
2021	17 Feb 06	nicklas	762	<sql>
5632	17 May 11	nicklas	763	SELECT tag
5632	17 May 11	nicklas	764	FROM TagData tag
5632	17 May 11	nicklas	765	WHERE tag.name = :name
2021	17 Feb 06	nicklas	766	</sql>
2021	17 Feb 06	nicklas	767	<description>
5632	17 May 11	nicklas	768	A Hibernate query that returns the tag with the specified
2021	17 Feb 06	nicklas	769	name.
2021	17 Feb 06	nicklas	770	</description>
2021	17 Feb 06	nicklas	771	</query>
2021	17 Feb 06	nicklas	772
2021	17 Feb 06	nicklas	773	<query id="GET_ANNOTATION_TYPE_WITH_NAME" type="HQL">
2021	17 Feb 06	nicklas	774	<sql>
2021	17 Feb 06	nicklas	775	SELECT at
2021	17 Feb 06	nicklas	776	FROM AnnotationTypeData at
2021	17 Feb 06	nicklas	777	WHERE at.name = :name
2021	17 Feb 06	nicklas	778	</sql>
2021	17 Feb 06	nicklas	779	<description>
2021	17 Feb 06	nicklas	780	A Hibernate query that returns the annotation type with the specified
2021	17 Feb 06	nicklas	781	name.
2021	17 Feb 06	nicklas	782	</description>
2021	17 Feb 06	nicklas	783	</query>
2021	17 Feb 06	nicklas	784
2021	17 Feb 06	nicklas	785	<query id="GET_NEWS_WITH_NAME" type="HQL">
2021	17 Feb 06	nicklas	786	<sql>
2021	17 Feb 06	nicklas	787	SELECT nws
2021	17 Feb 06	nicklas	788	FROM NewsData nws
2021	17 Feb 06	nicklas	789	WHERE nws.name = :name
2021	17 Feb 06	nicklas	790	</sql>
2021	17 Feb 06	nicklas	791	<description>
2021	17 Feb 06	nicklas	792	A Hibernate query that returns the news with the specified
2021	17 Feb 06	nicklas	793	name.
2021	17 Feb 06	nicklas	794	</description>
2021	17 Feb 06	nicklas	795	</query>
2021	17 Feb 06	nicklas	796
680	31 May 05	nicklas	797	<query id="GET_FILE_IN_DIRECTORY" type="HQL">
672	29 May 05	nicklas	798	<sql>
680	31 May 05	nicklas	799	SELECT f
672	29 May 05	nicklas	800	FROM FileData f
672	29 May 05	nicklas	801	WHERE f.directory = :directory
672	29 May 05	nicklas	802	AND f.name = :name
672	29 May 05	nicklas	803	</sql>
672	29 May 05	nicklas	804	<description>
680	31 May 05	nicklas	805	A Hibernate query that returns the file with the specified
680	31 May 05	nicklas	806	name in a given directory.
672	29 May 05	nicklas	807	</description>
672	29 May 05	nicklas	808	</query>
496	29 Apr 05	enell	809
2898	13 Nov 06	nicklas	810	<query id="GET_PLATEEVENTTYPES_FOR_PROTOCOLTYPE" type="HQL">
876	05 Jul 05	nicklas	811	<sql>
2898	13 Nov 06	nicklas	812	SELECT {1}
876	05 Jul 05	nicklas	813	FROM PlateEventTypeData pet
5630	13 May 11	nicklas	814	WHERE pet.protocolType = :subtype
876	05 Jul 05	nicklas	815	</sql>
876	05 Jul 05	nicklas	816	<description>
2898	13 Nov 06	nicklas	817	Get the plate events types that uses a protocol type.
876	05 Jul 05	nicklas	818	</description>
876	05 Jul 05	nicklas	819	</query>
546	10 May 05	enell	820
2898	13 Nov 06	nicklas	821	<query id="GET_BIOMATERIALEVENTS_FOR_PROTOCOL" type="HQL">
882	06 Jul 05	nicklas	822	<sql>
2898	13 Nov 06	nicklas	823	SELECT {1}
882	06 Jul 05	nicklas	824	FROM BioMaterialEventData bme
882	06 Jul 05	nicklas	825	WHERE bme.protocol = :protocol
882	06 Jul 05	nicklas	826	</sql>
882	06 Jul 05	nicklas	827	<description>
2898	13 Nov 06	nicklas	828	A Hibernate query that gets biomaterial
882	06 Jul 05	nicklas	829	events using a protocol.
882	06 Jul 05	nicklas	830	</description>
882	06 Jul 05	nicklas	831	</query>
882	06 Jul 05	nicklas	832
2898	13 Nov 06	nicklas	833	<query id="GET_PLATEEVENTS_FOR_PROTOCOL" type="HQL">
882	06 Jul 05	nicklas	834	<sql>
2898	13 Nov 06	nicklas	835	SELECT {1}
882	06 Jul 05	nicklas	836	FROM PlateEventData pe
882	06 Jul 05	nicklas	837	WHERE pe.protocol = :protocol
882	06 Jul 05	nicklas	838	</sql>
882	06 Jul 05	nicklas	839	<description>
2898	13 Nov 06	nicklas	840	A Hibernate query thatgets plate events
882	06 Jul 05	nicklas	841	using a protocol.
882	06 Jul 05	nicklas	842	</description>
882	06 Jul 05	nicklas	843	</query>
882	06 Jul 05	nicklas	844
2898	13 Nov 06	nicklas	845	<query id="GET_ARRAYBATCHES_FOR_PROTOCOL" type="HQL">
882	06 Jul 05	nicklas	846	<sql>
2898	13 Nov 06	nicklas	847	SELECT {1}
882	06 Jul 05	nicklas	848	FROM ArrayBatchData ab
882	06 Jul 05	nicklas	849	WHERE ab.protocol = :protocol
882	06 Jul 05	nicklas	850	</sql>
882	06 Jul 05	nicklas	851	<description>
2898	13 Nov 06	nicklas	852	A Hibernate query that gets array batches
882	06 Jul 05	nicklas	853	using a protocol.
882	06 Jul 05	nicklas	854	</description>
882	06 Jul 05	nicklas	855	</query>
882	06 Jul 05	nicklas	856
5685	04 Aug 11	nicklas	857	<query id="GET_DERIVEDBIOASSAY_FOR_PROTOCOL" type="HQL">
882	06 Jul 05	nicklas	858	<sql>
2898	13 Nov 06	nicklas	859	SELECT {1}
5685	04 Aug 11	nicklas	860	FROM DerivedBioAssayData dba
5685	04 Aug 11	nicklas	861	WHERE dba.protocol = :protocol
882	06 Jul 05	nicklas	862	</sql>
882	06 Jul 05	nicklas	863	<description>
5685	04 Aug 11	nicklas	864	A Hibernate query that gets derived bioassays
882	06 Jul 05	nicklas	865	using a protocol.
882	06 Jul 05	nicklas	866	</description>
882	06 Jul 05	nicklas	867	</query>
882	06 Jul 05	nicklas	868
2898	13 Nov 06	nicklas	869	<query id="GET_RAWBIOASSAYS_FOR_PROTOCOL" type="HQL">
882	06 Jul 05	nicklas	870	<sql>
2898	13 Nov 06	nicklas	871	SELECT {1}
882	06 Jul 05	nicklas	872	FROM RawBioAssayData rba
882	06 Jul 05	nicklas	873	WHERE rba.protocol = :protocol
882	06 Jul 05	nicklas	874	</sql>
882	06 Jul 05	nicklas	875	<description>
2898	13 Nov 06	nicklas	876	A Hibernate query that gets raw bioassays
882	06 Jul 05	nicklas	877	using a protocol.
882	06 Jul 05	nicklas	878	</description>
882	06 Jul 05	nicklas	879	</query>
882	06 Jul 05	nicklas	880
6990	02 Nov 15	nicklas	881	<query id="GET_BIOMATERIALEVENTS_FOR_KIT" type="HQL">
6990	02 Nov 15	nicklas	882	<sql>
6990	02 Nov 15	nicklas	883	SELECT {1}
6990	02 Nov 15	nicklas	884	FROM BioMaterialEventData bme
6990	02 Nov 15	nicklas	885	WHERE bme.kit = :kit
6990	02 Nov 15	nicklas	886	</sql>
6990	02 Nov 15	nicklas	887	<description>
6990	02 Nov 15	nicklas	888	A Hibernate query that gets biomaterial
6990	02 Nov 15	nicklas	889	events using a kit.
6990	02 Nov 15	nicklas	890	</description>
6990	02 Nov 15	nicklas	891	</query>
6990	02 Nov 15	nicklas	892
6990	02 Nov 15	nicklas	893	<query id="GET_BIOPLATEEVENTS_FOR_KIT" type="HQL">
6990	02 Nov 15	nicklas	894	<sql>
6990	02 Nov 15	nicklas	895	SELECT {1}
6990	02 Nov 15	nicklas	896	FROM BioPlateEventData bpe
6990	02 Nov 15	nicklas	897	WHERE bpe.kit = :kit
6990	02 Nov 15	nicklas	898	</sql>
6990	02 Nov 15	nicklas	899	<description>
6990	02 Nov 15	nicklas	900	A Hibernate query that gets bioplate events
6990	02 Nov 15	nicklas	901	events using a kit.
6990	02 Nov 15	nicklas	902	</description>
6990	02 Nov 15	nicklas	903	</query>
6996	03 Nov 15	nicklas	904
6996	03 Nov 15	nicklas	905	<query id="GET_DERIVEDBIOASSAYS_FOR_KIT" type="HQL">
6996	03 Nov 15	nicklas	906	<sql>
6996	03 Nov 15	nicklas	907	SELECT {1}
6996	03 Nov 15	nicklas	908	FROM DerivedBioAssayData dba
6996	03 Nov 15	nicklas	909	WHERE dba.kit = :kit
6996	03 Nov 15	nicklas	910	</sql>
6996	03 Nov 15	nicklas	911	<description>
6996	03 Nov 15	nicklas	912	A Hibernate query that gets derived bioassays using a kit.
6996	03 Nov 15	nicklas	913	</description>
6996	03 Nov 15	nicklas	914	</query>
6990	02 Nov 15	nicklas	915
496	29 Apr 05	enell	916	<query id="FIND_USED_FILES" type="HQL">
496	29 Apr 05	enell	917	<sql>
496	29 Apr 05	enell	918	SELECT fad
496	29 Apr 05	enell	919	FROM net.sf.basedb.core.data.FileAttachableData fad
496	29 Apr 05	enell	920	WHERE fad.file = :file
496	29 Apr 05	enell	921	</sql>
496	29 Apr 05	enell	922	<description>
496	29 Apr 05	enell	923	Load the files that is used by any FileAttachableData.
496	29 Apr 05	enell	924	</description>
496	29 Apr 05	enell	925	</query>
1102	22 Aug 05	nicklas	926
4006	27 Nov 07	nicklas	927	<query id="GET_FILESETMEMBERS_FOR_FILE" type="HQL">
4006	27 Nov 07	nicklas	928	<sql>
4006	27 Nov 07	nicklas	929	SELECT {1}
4006	27 Nov 07	nicklas	930	FROM FileSetMemberData fsm
4006	27 Nov 07	nicklas	931	WHERE fsm.file = :file
4006	27 Nov 07	nicklas	932	</sql>
4006	27 Nov 07	nicklas	933	<description>
4006	27 Nov 07	nicklas	934	A Hibernate query that gets file set membership
4006	27 Nov 07	nicklas	935	for a given file
4006	27 Nov 07	nicklas	936	</description>
4006	27 Nov 07	nicklas	937	</query>
4006	27 Nov 07	nicklas	938
5685	04 Aug 11	nicklas	939	<query id="GET_DERIVEDBIOASSAYS_FOR_HARDWARE" type="HQL">
1102	22 Aug 05	nicklas	940	<sql>
5652	10 Jun 11	nicklas	941	SELECT {1}
5685	04 Aug 11	nicklas	942	FROM DerivedBioAssayData dba
5685	04 Aug 11	nicklas	943	WHERE dba.hardware = :hardware
1102	22 Aug 05	nicklas	944	</sql>
1102	22 Aug 05	nicklas	945	<description>
5652	10 Jun 11	nicklas	946	A Hibernate query that gets derived bioassays which
5652	10 Jun 11	nicklas	947	uses a given hardware.
1102	22 Aug 05	nicklas	948	</description>
1102	22 Aug 05	nicklas	949	</query>
622	19 May 05	samuel	950
2898	13 Nov 06	nicklas	951	<query id="GET_ARRAYBATCHES_FOR_PRINTROBOT" type="HQL">
1152	30 Aug 05	nicklas	952	<sql>
2898	13 Nov 06	nicklas	953	SELECT {1}
1152	30 Aug 05	nicklas	954	FROM ArrayBatchData ab
1152	30 Aug 05	nicklas	955	WHERE ab.printRobot = :printrobot
1152	30 Aug 05	nicklas	956	</sql>
1152	30 Aug 05	nicklas	957	<description>
2898	13 Nov 06	nicklas	958	A Hibernate query that gets array batches which
1152	30 Aug 05	nicklas	959	uses a given print robot (hardware).
1152	30 Aug 05	nicklas	960	</description>
1152	30 Aug 05	nicklas	961	</query>
2898	13 Nov 06	nicklas	962
2898	13 Nov 06	nicklas	963	<query id="GET_BIOMATERIALEVENTS_FOR_HARDWARE" type="HQL">
2898	13 Nov 06	nicklas	964	<sql>
2898	13 Nov 06	nicklas	965	SELECT {1}
2898	13 Nov 06	nicklas	966	FROM BioMaterialEventData bme
2898	13 Nov 06	nicklas	967	WHERE bme.hardware = :hardware
2898	13 Nov 06	nicklas	968	</sql>
2898	13 Nov 06	nicklas	969	<description>
2898	13 Nov 06	nicklas	970	A Hibernate query that gets biomaterial events which
2898	13 Nov 06	nicklas	971	uses a given hardware.
2898	13 Nov 06	nicklas	972	</description>
2898	13 Nov 06	nicklas	973	</query>
2898	13 Nov 06	nicklas	974
2898	13 Nov 06	nicklas	975	<query id="GET_PLATEEVENTS_FOR_HARDWARE" type="HQL">
2898	13 Nov 06	nicklas	976	<sql>
2898	13 Nov 06	nicklas	977	SELECT {1}
2898	13 Nov 06	nicklas	978	FROM PlateEventData ple
2898	13 Nov 06	nicklas	979	WHERE ple.hardware = :hardware
2898	13 Nov 06	nicklas	980	</sql>
2898	13 Nov 06	nicklas	981	<description>
2898	13 Nov 06	nicklas	982	A Hibernate query that gets plates events which
2898	13 Nov 06	nicklas	983	uses a given hardware.
2898	13 Nov 06	nicklas	984	</description>
2898	13 Nov 06	nicklas	985	</query>
1152	30 Aug 05	nicklas	986
2898	13 Nov 06	nicklas	987	<query id="GET_REPORTERS_FOR_REPORTERTYPE" type="HQL">
622	19 May 05	samuel	988	<sql>
2898	13 Nov 06	nicklas	989	SELECT {1}
626	20 May 05	samuel	990	FROM ReporterData rpt
1122	24 Aug 05	nicklas	991	WHERE rpt.reporterType = :reporterType
622	19 May 05	samuel	992	</sql>
622	19 May 05	samuel	993	<description>
2898	13 Nov 06	nicklas	994	A Hibernate query that gets reporter items
622	19 May 05	samuel	995	of the given reporter type.
622	19 May 05	samuel	996	</description>
622	19 May 05	samuel	997	</query>
1122	24 Aug 05	nicklas	998
1122	24 Aug 05	nicklas	999	<query id="GET_REPORTER_FOR_EXTERNAL_ID" type="HQL">
1122	24 Aug 05	nicklas	1000	<sql>
1122	24 Aug 05	nicklas	1001	SELECT rpt
1122	24 Aug 05	nicklas	1002	FROM ReporterData rpt
1122	24 Aug 05	nicklas	1003	WHERE rpt.externalId = :externalId
1122	24 Aug 05	nicklas	1004	</sql>
1122	24 Aug 05	nicklas	1005	<description>
1122	24 Aug 05	nicklas	1006	A Hibernate query that finds the reporter with a given external id.
1122	24 Aug 05	nicklas	1007	</description>
1122	24 Aug 05	nicklas	1008	</query>
726	07 Jun 05	nicklas	1009
2898	13 Nov 06	nicklas	1010	<query id="GET_RAWBIOASSAYS_FOR_SOFTWARE" type="HQL">
1102	22 Aug 05	nicklas	1011	<sql>
2898	13 Nov 06	nicklas	1012	SELECT {1}
1102	22 Aug 05	nicklas	1013	FROM RawBioAssayData rba
1102	22 Aug 05	nicklas	1014	WHERE rba.software = :software
1102	22 Aug 05	nicklas	1015	</sql>
1102	22 Aug 05	nicklas	1016	<description>
2898	13 Nov 06	nicklas	1017	A Hibernate query that gets the raw bioassays
1102	22 Aug 05	nicklas	1018	produced from a given software.
1102	22 Aug 05	nicklas	1019	</description>
1102	22 Aug 05	nicklas	1020	</query>
1102	22 Aug 05	nicklas	1021
5685	04 Aug 11	nicklas	1022	<query id="GET_DERIVEDBIOASSAYS_FOR_SOFTWARE" type="HQL">
5652	10 Jun 11	nicklas	1023	<sql>
5652	10 Jun 11	nicklas	1024	SELECT {1}
5685	04 Aug 11	nicklas	1025	FROM DerivedBioAssayData dba
5685	04 Aug 11	nicklas	1026	WHERE dba.software = :software
5652	10 Jun 11	nicklas	1027	</sql>
5652	10 Jun 11	nicklas	1028	<description>
5685	04 Aug 11	nicklas	1029	A Hibernate query that gets the derived bioassay
5652	10 Jun 11	nicklas	1030	using a given software.
5652	10 Jun 11	nicklas	1031	</description>
5652	10 Jun 11	nicklas	1032	</query>
5652	10 Jun 11	nicklas	1033
5652	10 Jun 11	nicklas	1034
2898	13 Nov 06	nicklas	1035	<query id="GET_ANNOTATIONS_FOR_ANNOTATIONTYPE" type="HQL">
726	07 Jun 05	nicklas	1036	<sql>
2898	13 Nov 06	nicklas	1037	SELECT {1}
726	07 Jun 05	nicklas	1038	FROM AnnotationData a
726	07 Jun 05	nicklas	1039	WHERE a.annotationType = :annotationType
726	07 Jun 05	nicklas	1040	</sql>
726	07 Jun 05	nicklas	1041	<description>
2898	13 Nov 06	nicklas	1042	A Hibernate query that gets annotations
726	07 Jun 05	nicklas	1043	of the given annotation type.
726	07 Jun 05	nicklas	1044	</description>
726	07 Jun 05	nicklas	1045	</query>
2164	18 Apr 06	nicklas	1046
2898	13 Nov 06	nicklas	1047	<query id="GET_EXPERIMENTS_FOR_ANNOTATIONTYPE" type="HQL">
2164	18 Apr 06	nicklas	1048	<sql>
2898	13 Nov 06	nicklas	1049	SELECT {1}
2164	18 Apr 06	nicklas	1050	FROM ExperimentData exp
2164	18 Apr 06	nicklas	1051	JOIN exp.experimentalFactors ef
2164	18 Apr 06	nicklas	1052	WHERE ef = :annotationType
2164	18 Apr 06	nicklas	1053	</sql>
2164	18 Apr 06	nicklas	1054	<description>
2898	13 Nov 06	nicklas	1055	A Hibernate query that gets experiments
2164	18 Apr 06	nicklas	1056	where the given annotation type is used as an experimental factor.
2164	18 Apr 06	nicklas	1057	</description>
2164	18 Apr 06	nicklas	1058	</query>
2875	08 Nov 06	nicklas	1059
2898	13 Nov 06	nicklas	1060	<query id="GET_PROTOCOLS_FOR_ANNOTATIONTYPE" type="HQL">
2875	08 Nov 06	nicklas	1061	<sql>
2898	13 Nov 06	nicklas	1062	SELECT {1}
2875	08 Nov 06	nicklas	1063	FROM ProtocolData prt
2875	08 Nov 06	nicklas	1064	JOIN prt.parameters pp
2875	08 Nov 06	nicklas	1065	WHERE pp = :annotationType
2875	08 Nov 06	nicklas	1066	</sql>
2875	08 Nov 06	nicklas	1067	<description>
2898	13 Nov 06	nicklas	1068	A Hibernate query that gets protocols
2875	08 Nov 06	nicklas	1069	where the given annotation type is used as a protocol parameter.
2875	08 Nov 06	nicklas	1070	</description>
2875	08 Nov 06	nicklas	1071	</query>
726	07 Jun 05	nicklas	1072
2898	13 Nov 06	nicklas	1073	<query id="GET_SAMPLES_FOR_BIOSOURCE" type="HQL">
802	21 Jun 05	nicklas	1074	<sql>
2898	13 Nov 06	nicklas	1075	SELECT {1}
802	21 Jun 05	nicklas	1076	FROM SampleData s
802	21 Jun 05	nicklas	1077	WHERE s.parent = :biosource
802	21 Jun 05	nicklas	1078	</sql>
802	21 Jun 05	nicklas	1079	<description>
2898	13 Nov 06	nicklas	1080	A Hibernate query that gets samples
802	21 Jun 05	nicklas	1081	created from a given biosource.
802	21 Jun 05	nicklas	1082	</description>
802	21 Jun 05	nicklas	1083	</query>
802	21 Jun 05	nicklas	1084
2898	13 Nov 06	nicklas	1085	<query id="GET_EXTRACTS_FOR_SAMPLE" type="HQL">
802	21 Jun 05	nicklas	1086	<sql>
2898	13 Nov 06	nicklas	1087	SELECT {1}
802	21 Jun 05	nicklas	1088	FROM ExtractData e
802	21 Jun 05	nicklas	1089	WHERE e.parent = :sample
802	21 Jun 05	nicklas	1090	</sql>
802	21 Jun 05	nicklas	1091	<description>
2898	13 Nov 06	nicklas	1092	A Hibernate query that gets extracts
802	21 Jun 05	nicklas	1093	created from a given sample.
802	21 Jun 05	nicklas	1094	</description>
802	21 Jun 05	nicklas	1095	</query>
802	21 Jun 05	nicklas	1096
5632	17 May 11	nicklas	1097	<query id="GET_EXTRACTS_FOR_TAG" type="HQL">
802	21 Jun 05	nicklas	1098	<sql>
2898	13 Nov 06	nicklas	1099	SELECT {1}
5632	17 May 11	nicklas	1100	FROM ExtractData ext
5632	17 May 11	nicklas	1101	WHERE ext.tag = :tag
802	21 Jun 05	nicklas	1102	</sql>
802	21 Jun 05	nicklas	1103	<description>
5632	17 May 11	nicklas	1104	A Hibernate query that gets extracts with a given tag.
802	21 Jun 05	nicklas	1105	</description>
802	21 Jun 05	nicklas	1106	</query>
802	21 Jun 05	nicklas	1107
2898	13 Nov 06	nicklas	1108	<query id="GET_SOURCEEVENTS_FOR_BIOMATERIAL" type="HQL">
814	23 Jun 05	nicklas	1109	<sql>
2898	13 Nov 06	nicklas	1110	SELECT {1}
814	23 Jun 05	nicklas	1111	FROM BioMaterialEventData bme
814	23 Jun 05	nicklas	1112	JOIN bme.sources src
5663	22 Jun 11	nicklas	1113	WHERE src.bioMaterial = :bioMaterial
814	23 Jun 05	nicklas	1114	</sql>
814	23 Jun 05	nicklas	1115	<description>
2898	13 Nov 06	nicklas	1116	A Hibernate query that gets the events where a given
814	23 Jun 05	nicklas	1117	biomaterial has been part of as a source biomaterial, ie. the number
814	23 Jun 05	nicklas	1118	of pooled biomaterials that have been created from it.
814	23 Jun 05	nicklas	1119	</description>
814	23 Jun 05	nicklas	1120	</query>
814	23 Jun 05	nicklas	1121
5695	12 Aug 11	nicklas	1122	<query id="GET_DERIVEDBIOASSAYS_FOR_EXTRACT" type="HQL">
5695	12 Aug 11	nicklas	1123	<sql>
5695	12 Aug 11	nicklas	1124	SELECT {1}
5695	12 Aug 11	nicklas	1125	FROM DerivedBioAssayData dba
5695	12 Aug 11	nicklas	1126	WHERE dba.extract = :extract
5695	12 Aug 11	nicklas	1127	</sql>
5695	12 Aug 11	nicklas	1128	<description>
5695	12 Aug 11	nicklas	1129	A Hibernate query that gets the derived bioassays
5695	12 Aug 11	nicklas	1130	that are referencing a given extract.
5695	12 Aug 11	nicklas	1131	</description>
5695	12 Aug 11	nicklas	1132	</query>
5695	12 Aug 11	nicklas	1133
5695	12 Aug 11	nicklas	1134	<query id="GET_RAWBIOASSAYS_FOR_EXTRACT" type="HQL">
5695	12 Aug 11	nicklas	1135	<sql>
5695	12 Aug 11	nicklas	1136	SELECT {1}
5695	12 Aug 11	nicklas	1137	FROM RawBioAssayData rba
5695	12 Aug 11	nicklas	1138	WHERE rba.parentExtract = :extract
5695	12 Aug 11	nicklas	1139	</sql>
5695	12 Aug 11	nicklas	1140	<description>
5695	12 Aug 11	nicklas	1141	A Hibernate query that gets the raw bioassays
5695	12 Aug 11	nicklas	1142	that are referencing a given extract.
5695	12 Aug 11	nicklas	1143	</description>
5695	12 Aug 11	nicklas	1144	</query>
5695	12 Aug 11	nicklas	1145
830	27 Jun 05	nicklas	1146	<query id="COUNT_UNREAD_MESSAGES_FOR_USER" type="HQL">
830	27 Jun 05	nicklas	1147	<sql>
830	27 Jun 05	nicklas	1148	SELECT count(*)
830	27 Jun 05	nicklas	1149	FROM MessageData msg
7015	17 Nov 15	nicklas	1150	WHERE msg.to = :user AND msg.read = false AND msg.removedBy IS NULL
830	27 Jun 05	nicklas	1151	</sql>
830	27 Jun 05	nicklas	1152	<description>
830	27 Jun 05	nicklas	1153	A Hibernate query that counts the number of
830	27 Jun 05	nicklas	1154	unread messages for a given user
830	27 Jun 05	nicklas	1155	</description>
830	27 Jun 05	nicklas	1156	</query>
874	05 Jul 05	nicklas	1157
2898	13 Nov 06	nicklas	1158	<query id="GET_PLATETYPES_FOR_PLATEGEOMETRY" type="HQL">
874	05 Jul 05	nicklas	1159	<sql>
2898	13 Nov 06	nicklas	1160	SELECT {1}
874	05 Jul 05	nicklas	1161	FROM PlateTypeData pt
874	05 Jul 05	nicklas	1162	WHERE pt.plateGeometry = :plateGeometry
874	05 Jul 05	nicklas	1163	</sql>
874	05 Jul 05	nicklas	1164	<description>
2898	13 Nov 06	nicklas	1165	A Hibernate query that gets the
874	05 Jul 05	nicklas	1166	plate types using a given plate geometry
874	05 Jul 05	nicklas	1167	</description>
874	05 Jul 05	nicklas	1168	</query>
874	05 Jul 05	nicklas	1169
2898	13 Nov 06	nicklas	1170	<query id="GET_PLATEMAPPINGS_FOR_PLATEGEOMETRY" type="HQL">
874	05 Jul 05	nicklas	1171	<sql>
2898	13 Nov 06	nicklas	1172	SELECT {1}
874	05 Jul 05	nicklas	1173	FROM PlateMappingData pm
874	05 Jul 05	nicklas	1174	WHERE pm.sourceGeometry = :plateGeometry
874	05 Jul 05	nicklas	1175	OR pm.destinationGeometry = :plateGeometry
874	05 Jul 05	nicklas	1176	</sql>
874	05 Jul 05	nicklas	1177	<description>
2898	13 Nov 06	nicklas	1178	A Hibernate query that gets the
874	05 Jul 05	nicklas	1179	plate mappings using a given plate geometry as source or destination
874	05 Jul 05	nicklas	1180	</description>
874	05 Jul 05	nicklas	1181	</query>
874	05 Jul 05	nicklas	1182
5339	07 May 10	nicklas	1183	<query id="GET_BIOPLATES_FOR_PLATEGEOMETRY" type="HQL">
5339	07 May 10	nicklas	1184	<sql>
5339	07 May 10	nicklas	1185	SELECT {1}
5339	07 May 10	nicklas	1186	FROM BioPlateData bp
5339	07 May 10	nicklas	1187	WHERE bp.plateGeometry = :plateGeometry
5339	07 May 10	nicklas	1188	</sql>
5339	07 May 10	nicklas	1189	<description>
5339	07 May 10	nicklas	1190	A Hibernate query that gets the
5339	07 May 10	nicklas	1191	bioplates using of given plate geometry
5339	07 May 10	nicklas	1192	</description>
5339	07 May 10	nicklas	1193	</query>
5339	07 May 10	nicklas	1194
2898	13 Nov 06	nicklas	1195	<query id="GET_PLATES_FOR_PLATETYPE" type="HQL">
874	05 Jul 05	nicklas	1196	<sql>
2898	13 Nov 06	nicklas	1197	SELECT {1}
874	05 Jul 05	nicklas	1198	FROM PlateData p
874	05 Jul 05	nicklas	1199	WHERE p.plateType = :plateType
874	05 Jul 05	nicklas	1200	</sql>
874	05 Jul 05	nicklas	1201	<description>
2898	13 Nov 06	nicklas	1202	A Hibernate query that gets
874	05 Jul 05	nicklas	1203	plates of a specific plate type.
874	05 Jul 05	nicklas	1204	</description>
874	05 Jul 05	nicklas	1205	</query>
874	05 Jul 05	nicklas	1206
2898	13 Nov 06	nicklas	1207	<query id="GET_PLATEEVENTS_FOR_PLATEEVENTTYPE" type="HQL">
874	05 Jul 05	nicklas	1208	<sql>
2898	13 Nov 06	nicklas	1209	SELECT {1}
874	05 Jul 05	nicklas	1210	FROM PlateEventData pe
874	05 Jul 05	nicklas	1211	WHERE pe.plateEventType = :plateEventType
874	05 Jul 05	nicklas	1212	</sql>
874	05 Jul 05	nicklas	1213	<description>
2898	13 Nov 06	nicklas	1214	A Hibernate query that gets
874	05 Jul 05	nicklas	1215	plate events of the given plate event type.
874	05 Jul 05	nicklas	1216	</description>
874	05 Jul 05	nicklas	1217	</query>
874	05 Jul 05	nicklas	1218
2898	13 Nov 06	nicklas	1219	<query id="GET_CHILDPLATES_FOR_PLATE" type="HQL">
881	06 Jul 05	nicklas	1220	<sql>
2898	13 Nov 06	nicklas	1221	SELECT {1}
881	06 Jul 05	nicklas	1222	FROM PlateData p
881	06 Jul 05	nicklas	1223	JOIN p.parents pp
881	06 Jul 05	nicklas	1224	WHERE pp = :plate
881	06 Jul 05	nicklas	1225	</sql>
881	06 Jul 05	nicklas	1226	<description>
2898	13 Nov 06	nicklas	1227	A Hibernate query that gets the
881	06 Jul 05	nicklas	1228	child plates for a given plate.
881	06 Jul 05	nicklas	1229	</description>
881	06 Jul 05	nicklas	1230	</query>
881	06 Jul 05	nicklas	1231
2898	13 Nov 06	nicklas	1232	<query id="GET_ARRAYDESIGNS_FOR_PLATE" type="HQL">
1148	30 Aug 05	nicklas	1233	<sql>
2898	13 Nov 06	nicklas	1234	SELECT {1}
1148	30 Aug 05	nicklas	1235	FROM ArrayDesignData ad
1148	30 Aug 05	nicklas	1236	JOIN ad.plates p
1148	30 Aug 05	nicklas	1237	WHERE p = :plate
1148	30 Aug 05	nicklas	1238	</sql>
1148	30 Aug 05	nicklas	1239	<description>
2898	13 Nov 06	nicklas	1240	A Hibernate query that gets the
1148	30 Aug 05	nicklas	1241	array designs that has used a given plate.
1148	30 Aug 05	nicklas	1242	</description>
1148	30 Aug 05	nicklas	1243	</query>
1148	30 Aug 05	nicklas	1244
2898	13 Nov 06	nicklas	1245	<query id="GET_PLATES_FOR_PLATEMAPPING" type="HQL">
881	06 Jul 05	nicklas	1246	<sql>
2898	13 Nov 06	nicklas	1247	SELECT {1}
881	06 Jul 05	nicklas	1248	FROM PlateData p
881	06 Jul 05	nicklas	1249	WHERE p.plateMapping = :plateMapping
881	06 Jul 05	nicklas	1250	</sql>
881	06 Jul 05	nicklas	1251	<description>
2898	13 Nov 06	nicklas	1252	A Hibernate query that gets the
881	06 Jul 05	nicklas	1253	plates that has been created from a given plate mapping.
881	06 Jul 05	nicklas	1254	</description>
881	06 Jul 05	nicklas	1255	</query>
901	08 Jul 05	samuel	1256
2898	13 Nov 06	nicklas	1257	<query id="GET_FEATURES_FOR_WELL" type="HQL">
1149	30 Aug 05	nicklas	1258	<sql>
2898	13 Nov 06	nicklas	1259	SELECT {1}
1149	30 Aug 05	nicklas	1260	FROM FeatureData f
1149	30 Aug 05	nicklas	1261	WHERE f.well = :well
1149	30 Aug 05	nicklas	1262	</sql>
1149	30 Aug 05	nicklas	1263	<description>
2898	13 Nov 06	nicklas	1264	A Hibernate query that gets the
1149	30 Aug 05	nicklas	1265	features using a given well.
1149	30 Aug 05	nicklas	1266	</description>
1149	30 Aug 05	nicklas	1267	</query>
1149	30 Aug 05	nicklas	1268
2809	26 Oct 06	nicklas	1269	<query id="COUNT_FEATURES_FOR_ARRAYDESIGN" type="HQL">
2809	26 Oct 06	nicklas	1270	<sql>
2809	26 Oct 06	nicklas	1271	SELECT count(*)
2809	26 Oct 06	nicklas	1272	FROM FeatureData f
2809	26 Oct 06	nicklas	1273	WHERE f.arrayDesignBlock.arrayDesign = :arrayDesign
2809	26 Oct 06	nicklas	1274	</sql>
2809	26 Oct 06	nicklas	1275	<description>
2809	26 Oct 06	nicklas	1276	A Hibernate query that counts the number of
2809	26 Oct 06	nicklas	1277	features on a given array design
2809	26 Oct 06	nicklas	1278	</description>
2809	26 Oct 06	nicklas	1279	</query>
2809	26 Oct 06	nicklas	1280
2809	26 Oct 06	nicklas	1281
2898	13 Nov 06	nicklas	1282	<query id="GET_CHILDWELLS_FOR_WELL" type="HQL">
1149	30 Aug 05	nicklas	1283	<sql>
2898	13 Nov 06	nicklas	1284	SELECT {1}
1149	30 Aug 05	nicklas	1285	FROM Well w
1149	30 Aug 05	nicklas	1286	WHERE w.parent = :well
1149	30 Aug 05	nicklas	1287	</sql>
1149	30 Aug 05	nicklas	1288	<description>
2898	13 Nov 06	nicklas	1289	A Hibernate query that gets the
1149	30 Aug 05	nicklas	1290	child wells of a given well.
1149	30 Aug 05	nicklas	1291	</description>
1149	30 Aug 05	nicklas	1292	</query>
1149	30 Aug 05	nicklas	1293
2898	13 Nov 06	nicklas	1294	<query id="GET_PLUGINCONFIGURATIONS_FOR_PLUGINDEFINITION" type="HQL">
901	08 Jul 05	samuel	1295	<sql>
2898	13 Nov 06	nicklas	1296	SELECT {1}
930	13 Jul 05	samuel	1297	FROM PluginConfigurationData pc
901	08 Jul 05	samuel	1298	WHERE pc.pluginDefinition = :pluginDefinition
901	08 Jul 05	samuel	1299	</sql>
901	08 Jul 05	samuel	1300	<description>
2898	13 Nov 06	nicklas	1301	A Hibernate query that gets plugin configurations
901	08 Jul 05	samuel	1302	using a plugin definition.
901	08 Jul 05	samuel	1303	</description>
901	08 Jul 05	samuel	1304	</query>
1238	05 Sep 05	nicklas	1305
2898	13 Nov 06	nicklas	1306	<query id="GET_JOBS_FOR_PLUGINCONFIGURATION" type="HQL">
1238	05 Sep 05	nicklas	1307	<sql>
2898	13 Nov 06	nicklas	1308	SELECT {1}
1238	05 Sep 05	nicklas	1309	FROM JobData j
1238	05 Sep 05	nicklas	1310	WHERE j.pluginConfiguration = :pluginConfiguration
1238	05 Sep 05	nicklas	1311	</sql>
1238	05 Sep 05	nicklas	1312	<description>
2898	13 Nov 06	nicklas	1313	A Hibernate query that gets the jobs
2898	13 Nov 06	nicklas	1314	using a specific plugin configuration.
1238	05 Sep 05	nicklas	1315	</description>
1238	05 Sep 05	nicklas	1316	</query>
3999	26 Nov 07	nicklas	1317
3999	26 Nov 07	nicklas	1318	<query id="GET_JOBS_FOR_PLUGINDEFINITION" type="HQL">
3999	26 Nov 07	nicklas	1319	<sql>
3999	26 Nov 07	nicklas	1320	SELECT {1}
3999	26 Nov 07	nicklas	1321	FROM JobData j
3999	26 Nov 07	nicklas	1322	WHERE j.pluginDefinition = :pluginDefinition
3999	26 Nov 07	nicklas	1323	</sql>
3999	26 Nov 07	nicklas	1324	<description>
3999	26 Nov 07	nicklas	1325	A Hibernate query that gets the jobs
3999	26 Nov 07	nicklas	1326	using a specific plugin definition.
3999	26 Nov 07	nicklas	1327	</description>
3999	26 Nov 07	nicklas	1328	</query>
881	06 Jul 05	nicklas	1329
1629	17 Nov 05	nicklas	1330	<query id="FIND_JOBS_IN_QUEUE" type="HQL">
1629	17 Nov 05	nicklas	1331	<sql>
1629	17 Nov 05	nicklas	1332	SELECT job
1629	17 Nov 05	nicklas	1333	FROM JobData job
1629	17 Nov 05	nicklas	1334	WHERE job.status = :status
1629	17 Nov 05	nicklas	1335	AND job.type = :type
7015	17 Nov 15	nicklas	1336	AND job.removedBy IS NULL
5406	13 Sep 10	nicklas	1337	ORDER BY job.priority ASC, job.scheduled ASC
1629	17 Nov 05	nicklas	1338	</sql>
1629	17 Nov 05	nicklas	1339	<description>
1629	17 Nov 05	nicklas	1340	A Hibernate query that loads plugin jobs in the job queue waiting to be
5406	13 Sep 10	nicklas	1341	executed sorted by priority and waiting time. The query should return all
4311	23 May 08	nicklas	1342	jobs, ignoring all settings specifying that the internal job queue should
4311	23 May 08	nicklas	1343	not be used.
1629	17 Nov 05	nicklas	1344	</description>
1629	17 Nov 05	nicklas	1345	</query>
1629	17 Nov 05	nicklas	1346
3871	22 Oct 07	nicklas	1347	<query id="FIND_INTERNAL_JOBS_IN_QUEUE" type="HQL">
3871	22 Oct 07	nicklas	1348	<sql>
3871	22 Oct 07	nicklas	1349	SELECT job
3871	22 Oct 07	nicklas	1350	FROM JobData job
3871	22 Oct 07	nicklas	1351	WHERE job.status = :status
3871	22 Oct 07	nicklas	1352	AND job.type = :type
7015	17 Nov 15	nicklas	1353	AND job.removedBy IS NULL
3871	22 Oct 07	nicklas	1354	AND job.pluginDefinition.useInternalJobQueue = true
4311	23 May 08	nicklas	1355	AND job.jobAgentId IS NULL
5406	13 Sep 10	nicklas	1356	ORDER BY job.priority ASC, job.scheduled ASC
3871	22 Oct 07	nicklas	1357	</sql>
3871	22 Oct 07	nicklas	1358	<description>
3871	22 Oct 07	nicklas	1359	A Hibernate query that loads plugin jobs in the job queue waiting to be
4804	10 Mar 09	nicklas	1360	executed sorted by priority and waiting time. It should only return
4311	23 May 08	nicklas	1361	jobs where the plug-in setting useInternalJobQueue=true and no
4311	23 May 08	nicklas	1362	specific job agent has been selected for the job.
3871	22 Oct 07	nicklas	1363	</description>
3871	22 Oct 07	nicklas	1364	</query>
3871	22 Oct 07	nicklas	1365
6439	31 Mar 14	nicklas	1366	<query id="FIND_EXTERNAL_JOBS_FOR_STATUS_UPDATE" type="HQL">
6439	31 Mar 14	nicklas	1367	<sql>
6439	31 Mar 14	nicklas	1368	SELECT job
6439	31 Mar 14	nicklas	1369	FROM JobData job
6439	31 Mar 14	nicklas	1370	WHERE job.type = :type
7015	17 Nov 15	nicklas	1371	AND job.removedBy IS NULL
6439	31 Mar 14	nicklas	1372	AND NOT job.signalTransporter IS NULL
6439	31 Mar 14	nicklas	1373	</sql>
6439	31 Mar 14	nicklas	1374	<description>
6439	31 Mar 14	nicklas	1375	A Hibernate query that loads external jobs in the job queue that
6439	31 Mar 14	nicklas	1376	has a non-null signal transporter so that it may be possible to
6439	31 Mar 14	nicklas	1377	send a signal request for status update to them,
6439	31 Mar 14	nicklas	1378	</description>
6439	31 Mar 14	nicklas	1379	</query>
6439	31 Mar 14	nicklas	1380
2898	13 Nov 06	nicklas	1381	<query id="GET_ARRAYSLIDES_FOR_BATCH" type="HQL">
974	20 Jul 05	enell	1382	<sql>
2898	13 Nov 06	nicklas	1383	SELECT {1}
982	21 Jul 05	enell	1384	FROM ArraySlideData a
974	20 Jul 05	enell	1385	WHERE a.arrayBatch = :arrayBatch
974	20 Jul 05	enell	1386	</sql>
974	20 Jul 05	enell	1387	<description>
2898	13 Nov 06	nicklas	1388	A Hibernate query that gets the array slides
2898	13 Nov 06	nicklas	1389	in an array batch.
974	20 Jul 05	enell	1390	</description>
974	20 Jul 05	enell	1391	</query>
974	20 Jul 05	enell	1392
4220	14 Apr 08	nicklas	1393	<query id="GET_ARRAYSLIDES_WITH_BARCODE" type="HQL">
4220	14 Apr 08	nicklas	1394	<sql>
4220	14 Apr 08	nicklas	1395	SELECT {1}
4220	14 Apr 08	nicklas	1396	FROM ArraySlideData ars
4220	14 Apr 08	nicklas	1397	WHERE ars.barcode = :barcode
4220	14 Apr 08	nicklas	1398	</sql>
4220	14 Apr 08	nicklas	1399	<description>
4220	14 Apr 08	nicklas	1400	A Hibernate query that gets the array slides
4220	14 Apr 08	nicklas	1401	with a given barcode.
4220	14 Apr 08	nicklas	1402	</description>
4220	14 Apr 08	nicklas	1403	</query>
4220	14 Apr 08	nicklas	1404
4220	14 Apr 08	nicklas	1405
2898	13 Nov 06	nicklas	1406	<query id="GET_ARRAYBATCHES_FOR_ARRAYDESIGN" type="HQL">
974	20 Jul 05	enell	1407	<sql>
2898	13 Nov 06	nicklas	1408	SELECT {1}
982	21 Jul 05	enell	1409	FROM ArrayBatchData a
974	20 Jul 05	enell	1410	WHERE a.arrayDesign = :arrayDesign
974	20 Jul 05	enell	1411	</sql>
974	20 Jul 05	enell	1412	<description>
2898	13 Nov 06	nicklas	1413	A Hibernate query that gets array batches
974	20 Jul 05	enell	1414	that uses a specific array design.
974	20 Jul 05	enell	1415	</description>
974	20 Jul 05	enell	1416	</query>
974	20 Jul 05	enell	1417
2898	13 Nov 06	nicklas	1418	<query id="GET_RAWBIOASSAYS_FOR_ARRAYDESIGN" type="HQL">
974	20 Jul 05	enell	1419	<sql>
2898	13 Nov 06	nicklas	1420	SELECT {1}
1116	23 Aug 05	nicklas	1421	FROM RawBioAssayData rba
1116	23 Aug 05	nicklas	1422	WHERE rba.arrayDesign = :arrayDesign
974	20 Jul 05	enell	1423	</sql>
974	20 Jul 05	enell	1424	<description>
2898	13 Nov 06	nicklas	1425	A Hibernate query that gets raw bioassays
974	20 Jul 05	enell	1426	that uses a specific array design.
974	20 Jul 05	enell	1427	</description>
974	20 Jul 05	enell	1428	</query>
1116	23 Aug 05	nicklas	1429
5685	04 Aug 11	nicklas	1430	<query id="GET_ROOT_DERIVEDBIOASSAYS_FOR_PHYSICALBIOASSAY" type="HQL">
1116	23 Aug 05	nicklas	1431	<sql>
2898	13 Nov 06	nicklas	1432	SELECT {1}
5685	04 Aug 11	nicklas	1433	FROM DerivedBioAssayData dba
6082	14 Aug 12	nicklas	1434	INNER JOIN dba.physicalBioAssays pba
6082	14 Aug 12	nicklas	1435	WHERE pba = :bioAssay
6082	14 Aug 12	nicklas	1436	AND dba.root = true
1116	23 Aug 05	nicklas	1437	</sql>
1116	23 Aug 05	nicklas	1438	<description>
5685	04 Aug 11	nicklas	1439	A Hibernate query that gets root derived bioassays
5685	04 Aug 11	nicklas	1440	created from a specific physical bioassay.
1116	23 Aug 05	nicklas	1441	</description>
1116	23 Aug 05	nicklas	1442	</query>
1116	23 Aug 05	nicklas	1443
5695	12 Aug 11	nicklas	1444	<query id="GET_CHILD_DERIVEDBIOASSAYS_FOR_DERIVEDBIOASSAY" type="HQL">
5695	12 Aug 11	nicklas	1445	<sql>
5695	12 Aug 11	nicklas	1446	SELECT {1}
5695	12 Aug 11	nicklas	1447	FROM DerivedBioAssayData dba
6082	14 Aug 12	nicklas	1448	INNER JOIN dba.parents p
6082	14 Aug 12	nicklas	1449	WHERE p = :bioAssay
5695	12 Aug 11	nicklas	1450	</sql>
5695	12 Aug 11	nicklas	1451	<description>
5695	12 Aug 11	nicklas	1452	A Hibernate query that gets child derived bioassays
5695	12 Aug 11	nicklas	1453	created from a specific derived bioassay.
5695	12 Aug 11	nicklas	1454	</description>
5695	12 Aug 11	nicklas	1455	</query>
5695	12 Aug 11	nicklas	1456
5695	12 Aug 11	nicklas	1457
5685	04 Aug 11	nicklas	1458	<query id="GET_RAWBIOASSAYS_FOR_DERIVEDBIOASSAY" type="HQL">
1117	23 Aug 05	nicklas	1459	<sql>
2898	13 Nov 06	nicklas	1460	SELECT {1}
1117	23 Aug 05	nicklas	1461	FROM RawBioAssayData rba
5685	04 Aug 11	nicklas	1462	WHERE rba.parentBioAssay = :bioAssay
1117	23 Aug 05	nicklas	1463	</sql>
1117	23 Aug 05	nicklas	1464	<description>
2898	13 Nov 06	nicklas	1465	A Hibernate query that gets raw bioassays
5685	04 Aug 11	nicklas	1466	created from a specific derived bioassay.
1117	23 Aug 05	nicklas	1467	</description>
1117	23 Aug 05	nicklas	1468	</query>
1117	23 Aug 05	nicklas	1469
2459	30 Jun 06	nicklas	1470	<query id="PRELOAD_FEATURES" type="HQL">
2459	30 Jun 06	nicklas	1471	<sql>
2459	30 Jun 06	nicklas	1472	SELECT f
2459	30 Jun 06	nicklas	1473	FROM FeatureData f
2459	30 Jun 06	nicklas	1474	JOIN FETCH f.arrayDesignBlock b
2459	30 Jun 06	nicklas	1475	LEFT JOIN FETCH f.reporter
2459	30 Jun 06	nicklas	1476	WHERE b.arrayDesign = :arrayDesign
2459	30 Jun 06	nicklas	1477	</sql>
2459	30 Jun 06	nicklas	1478	<description>
2459	30 Jun 06	nicklas	1479	A Hibernate query that loads features, blocks and reporters
2459	30 Jun 06	nicklas	1480	for a single array design.
2459	30 Jun 06	nicklas	1481	</description>
2459	30 Jun 06	nicklas	1482	</query>
2459	30 Jun 06	nicklas	1483
2314	23 May 06	nicklas	1484	<query id="DELETE_FEATURES_FOR_ARRAYDESIGN" type="HQL">
1549	01 Nov 05	nicklas	1485	<sql>
2314	23 May 06	nicklas	1486	DELETE FROM Features f, ArrayDesignBlocks adb
2314	23 May 06	nicklas	1487	WHERE adb.id = f.arraydesignblock_id AND adb.arraydesign_id = ?
1549	01 Nov 05	nicklas	1488	</sql>
1549	01 Nov 05	nicklas	1489	<description>
2314	23 May 06	nicklas	1490	A Hibernate query that deletes all features for an array design.
1549	01 Nov 05	nicklas	1491	</description>
1549	01 Nov 05	nicklas	1492	</query>
1549	01 Nov 05	nicklas	1493
1373	21 Sep 05	nicklas	1494	<query id="GET_PLUGINTYPE_FOR_INTERFACENAME" type="HQL">
1373	21 Sep 05	nicklas	1495	<sql>
1373	21 Sep 05	nicklas	1496	SELECT plt
1373	21 Sep 05	nicklas	1497	FROM PluginTypeData plt
1373	21 Sep 05	nicklas	1498	WHERE plt.interfaceName = :interfaceName
1373	21 Sep 05	nicklas	1499	</sql>
1373	21 Sep 05	nicklas	1500	<description>
1373	21 Sep 05	nicklas	1501	Load a plugin type when you know the interface name.
1373	21 Sep 05	nicklas	1502	</description>
1373	21 Sep 05	nicklas	1503	</query>
1135	25 Aug 05	nicklas	1504
1869	31 Jan 06	nicklas	1505	<query id="GET_PLUGINDEFINITION_FOR_CLASSNAME" type="HQL">
1869	31 Jan 06	nicklas	1506	<sql>
1869	31 Jan 06	nicklas	1507	SELECT pd
1869	31 Jan 06	nicklas	1508	FROM PluginDefinitionData pd
1869	31 Jan 06	nicklas	1509	WHERE pd.className = :className
1869	31 Jan 06	nicklas	1510	</sql>
1869	31 Jan 06	nicklas	1511	<description>
1869	31 Jan 06	nicklas	1512	Load a plugin definition when you know the class name.
1869	31 Jan 06	nicklas	1513	</description>
1869	31 Jan 06	nicklas	1514	</query>
1869	31 Jan 06	nicklas	1515
3627	03 Aug 07	nicklas	1516	<query id="GET_PLUGINCONFIGURATION_FOR_PLUGIN_WITH_NAME" type="HQL">
3627	03 Aug 07	nicklas	1517	<sql>
3627	03 Aug 07	nicklas	1518	SELECT pc
3627	03 Aug 07	nicklas	1519	FROM PluginConfigurationData pc
3627	03 Aug 07	nicklas	1520	WHERE pc.pluginDefinition.className = :className
3627	03 Aug 07	nicklas	1521	AND pc.name = :name
3627	03 Aug 07	nicklas	1522	</sql>
3627	03 Aug 07	nicklas	1523	<description>
3627	03 Aug 07	nicklas	1524	Load a plugin configuration for a given plug-in and with a given name
3627	03 Aug 07	nicklas	1525	</description>
3627	03 Aug 07	nicklas	1526	</query>
3627	03 Aug 07	nicklas	1527
3627	03 Aug 07	nicklas	1528
2898	13 Nov 06	nicklas	1529	<query id="GET_EXPERIMENTS_FOR_RAWBIOASSAY" type="HQL">
1480	19 Oct 05	nicklas	1530	<sql>
2898	13 Nov 06	nicklas	1531	SELECT {1}
1480	19 Oct 05	nicklas	1532	FROM ExperimentData xp
1480	19 Oct 05	nicklas	1533	JOIN xp.rawBioAssays rba
1480	19 Oct 05	nicklas	1534	WHERE rba = :rawBioAssay
1480	19 Oct 05	nicklas	1535	</sql>
1480	19 Oct 05	nicklas	1536	<description>
2898	13 Nov 06	nicklas	1537	A Hibernate query that gets the experiments
2898	13 Nov 06	nicklas	1538	using a specific raw bioassay.
1480	19 Oct 05	nicklas	1539	</description>
1480	19 Oct 05	nicklas	1540	</query>
1499	20 Oct 05	nicklas	1541
2898	13 Nov 06	nicklas	1542	<query id="GET_TRANSFORMATIONS_FOR_RAWBIOASSAY" type="HQL">
1499	20 Oct 05	nicklas	1543	<sql>
2898	13 Nov 06	nicklas	1544	SELECT {1}
1537	27 Oct 05	nicklas	1545	FROM TransformationData trf
1537	27 Oct 05	nicklas	1546	JOIN trf.rawSources rba
1537	27 Oct 05	nicklas	1547	WHERE rba = :rawBioAssay
1499	20 Oct 05	nicklas	1548	</sql>
1499	20 Oct 05	nicklas	1549	<description>
2898	13 Nov 06	nicklas	1550	A Hibernate query that gets the transformations
1499	20 Oct 05	nicklas	1551	using a specifiec raw bioassay.
1499	20 Oct 05	nicklas	1552	</description>
1499	20 Oct 05	nicklas	1553	</query>
2213	04 May 06	nicklas	1554
2898	13 Nov 06	nicklas	1555	<query id="GET_TRANSFORMATIONS_FOR_JOB" type="HQL">
2213	04 May 06	nicklas	1556	<sql>
2898	13 Nov 06	nicklas	1557	SELECT {1}
2213	04 May 06	nicklas	1558	FROM TransformationData trf
2213	04 May 06	nicklas	1559	WHERE trf.job = :job
2213	04 May 06	nicklas	1560	</sql>
2213	04 May 06	nicklas	1561	<description>
2898	13 Nov 06	nicklas	1562	A Hibernate query that gets transformations
2898	13 Nov 06	nicklas	1563	linked to a job.
2213	04 May 06	nicklas	1564	</description>
2213	04 May 06	nicklas	1565	</query>
4256	29 Apr 08	nicklas	1566
4256	29 Apr 08	nicklas	1567	<query id="GET_RAWBIOASSAYS_FOR_JOB" type="HQL">
4256	29 Apr 08	nicklas	1568	<sql>
4256	29 Apr 08	nicklas	1569	SELECT {1}
4256	29 Apr 08	nicklas	1570	FROM RawBioAssayData rba
4256	29 Apr 08	nicklas	1571	WHERE rba.job = :job
4256	29 Apr 08	nicklas	1572	</sql>
4256	29 Apr 08	nicklas	1573	<description>
4256	29 Apr 08	nicklas	1574	A Hibernate query that gets raw bioassays
4256	29 Apr 08	nicklas	1575	linked to a job.
4256	29 Apr 08	nicklas	1576	</description>
4256	29 Apr 08	nicklas	1577	</query>
4257	29 Apr 08	nicklas	1578
4257	29 Apr 08	nicklas	1579	<query id="GET_ARRAYDESIGNS_FOR_JOB" type="HQL">
4257	29 Apr 08	nicklas	1580	<sql>
4257	29 Apr 08	nicklas	1581	SELECT {1}
4257	29 Apr 08	nicklas	1582	FROM ArrayDesignData ad
4257	29 Apr 08	nicklas	1583	WHERE ad.job = :job
4257	29 Apr 08	nicklas	1584	</sql>
4257	29 Apr 08	nicklas	1585	<description>
4257	29 Apr 08	nicklas	1586	A Hibernate query that gets array designs
4257	29 Apr 08	nicklas	1587	linked to a job.
4257	29 Apr 08	nicklas	1588	</description>
4257	29 Apr 08	nicklas	1589	</query>
6442	04 Apr 14	nicklas	1590
6442	04 Apr 14	nicklas	1591	<query id="GET_DERIVEDBIOASSAYS_FOR_JOB" type="HQL">
6442	04 Apr 14	nicklas	1592	<sql>
6442	04 Apr 14	nicklas	1593	SELECT {1}
6442	04 Apr 14	nicklas	1594	FROM DerivedBioAssayData dba
6442	04 Apr 14	nicklas	1595	WHERE dba.job = :job
6442	04 Apr 14	nicklas	1596	</sql>
6442	04 Apr 14	nicklas	1597	<description>
6442	04 Apr 14	nicklas	1598	A Hibernate query that gets derived bioassays
6442	04 Apr 14	nicklas	1599	linked to a job.
6442	04 Apr 14	nicklas	1600	</description>
6442	04 Apr 14	nicklas	1601	</query>
1480	19 Oct 05	nicklas	1602
1537	27 Oct 05	nicklas	1603	<query id="FIND_CHILD_BIOASSAYSETS" type="HQL">
1537	27 Oct 05	nicklas	1604	<sql>
1537	27 Oct 05	nicklas	1605	SELECT bas
1537	27 Oct 05	nicklas	1606	FROM BioAssaySetData bas
1537	27 Oct 05	nicklas	1607	WHERE bas.transformation.source = :parent
1537	27 Oct 05	nicklas	1608	</sql>
1537	27 Oct 05	nicklas	1609	<description>
1537	27 Oct 05	nicklas	1610	A Hibernate query that returns all bioassaysets that are
1537	27 Oct 05	nicklas	1611	children to a specified parent bioassayset.
1537	27 Oct 05	nicklas	1612	</description>
1537	27 Oct 05	nicklas	1613	</query>
1537	27 Oct 05	nicklas	1614
1538	28 Oct 05	nicklas	1615	<query id="FIND_DATACUBES_FOR_BIOASSAYSETS" type="HQL">
1537	27 Oct 05	nicklas	1616	<sql>
1538	28 Oct 05	nicklas	1617	SELECT DISTINCT cbe
1538	28 Oct 05	nicklas	1618	FROM BioAssaySetData bas
1538	28 Oct 05	nicklas	1619	JOIN bas.dataCubeLayer.dataCube cbe
1538	28 Oct 05	nicklas	1620	WHERE bas IN (:basList)
1537	27 Oct 05	nicklas	1621	</sql>
1537	27 Oct 05	nicklas	1622	<description>
1538	28 Oct 05	nicklas	1623	A Hibernate query that returns all data cubes that are
1538	28 Oct 05	nicklas	1624	used by the specified list of bioassaysets
1537	27 Oct 05	nicklas	1625	</description>
1537	27 Oct 05	nicklas	1626	</query>
1538	28 Oct 05	nicklas	1627
1538	28 Oct 05	nicklas	1628	<query id="FIND_DATACUBES_USED_BY_OTHERS" type="HQL">
1538	28 Oct 05	nicklas	1629	<sql>
1538	28 Oct 05	nicklas	1630	SELECT DISTINCT cbe
1538	28 Oct 05	nicklas	1631	FROM BioAssaySetData bas
1538	28 Oct 05	nicklas	1632	JOIN bas.dataCubeLayer.dataCube cbe
1538	28 Oct 05	nicklas	1633	WHERE bas NOT IN (:basList)
1538	28 Oct 05	nicklas	1634	AND cbe IN (:possibleCubes)
1538	28 Oct 05	nicklas	1635	</sql>
1538	28 Oct 05	nicklas	1636	<description>
1538	28 Oct 05	nicklas	1637	A Hibernate query that, given a list of data cubes and bioassaysets,
1538	28 Oct 05	nicklas	1638	returns all of those data cubes that are also used by other bioassaysets.
1538	28 Oct 05	nicklas	1639	</description>
1538	28 Oct 05	nicklas	1640	</query>
1537	27 Oct 05	nicklas	1641
1538	28 Oct 05	nicklas	1642	<query id="FIND_DATACUBELAYERS_FOR_BIOASSAYSETS" type="HQL">
1537	27 Oct 05	nicklas	1643	<sql>
1538	28 Oct 05	nicklas	1644	SELECT lay
1538	28 Oct 05	nicklas	1645	FROM BioAssaySetData bas
1538	28 Oct 05	nicklas	1646	JOIN bas.dataCubeLayer lay
1538	28 Oct 05	nicklas	1647	WHERE bas IN (:basList)
1537	27 Oct 05	nicklas	1648	</sql>
1537	27 Oct 05	nicklas	1649	<description>
1538	28 Oct 05	nicklas	1650	A Hibernate query that returns all data cube layers that are
1538	28 Oct 05	nicklas	1651	used by the specified list of bioassaysets
1537	27 Oct 05	nicklas	1652	</description>
1537	27 Oct 05	nicklas	1653	</query>
1538	28 Oct 05	nicklas	1654
1538	28 Oct 05	nicklas	1655	<query id="FIND_DATACUBELAYERS_FOR_BIOASSAYSETS_IGNORE_DELETED_DATACUBES" type="HQL">
1538	28 Oct 05	nicklas	1656	<sql>
1538	28 Oct 05	nicklas	1657	SELECT lay
1538	28 Oct 05	nicklas	1658	FROM BioAssaySetData bas
1538	28 Oct 05	nicklas	1659	JOIN bas.dataCubeLayer lay
1538	28 Oct 05	nicklas	1660	WHERE bas IN (:basList)
1538	28 Oct 05	nicklas	1661	AND lay.dataCube NOT IN (:deletedCubes)
1538	28 Oct 05	nicklas	1662	</sql>
1538	28 Oct 05	nicklas	1663	<description>
1538	28 Oct 05	nicklas	1664	A Hibernate query that returns all data cube layers that are
1538	28 Oct 05	nicklas	1665	used by the specified list of bioassaysets but not are part of the
1538	28 Oct 05	nicklas	1666	list of already deleted data cubes.
1538	28 Oct 05	nicklas	1667	</description>
1538	28 Oct 05	nicklas	1668	</query>
1537	27 Oct 05	nicklas	1669
1538	28 Oct 05	nicklas	1670	<query id="FIND_DATACUBELAYERS_USED_BY_OTHERS" type="HQL">
1538	28 Oct 05	nicklas	1671	<sql>
1538	28 Oct 05	nicklas	1672	SELECT lay
1538	28 Oct 05	nicklas	1673	FROM BioAssaySetData bas
1538	28 Oct 05	nicklas	1674	JOIN bas.dataCubeLayer lay
1538	28 Oct 05	nicklas	1675	WHERE bas NOT IN (:basList)
1538	28 Oct 05	nicklas	1676	AND lay IN (:possibleLayers)
1538	28 Oct 05	nicklas	1677	</sql>
1538	28 Oct 05	nicklas	1678	<description>
1538	28 Oct 05	nicklas	1679	A Hibernate query that, given a list of data cube layers and bioassaysets,
1538	28 Oct 05	nicklas	1680	returns all of those data cube layers that are also used by other bioassaysets.
1538	28 Oct 05	nicklas	1681	</description>
1538	28 Oct 05	nicklas	1682	</query>
1538	28 Oct 05	nicklas	1683
1538	28 Oct 05	nicklas	1684	<query id="FIND_DATACUBEFILTERS_FOR_BIOASSAYSETS" type="HQL">
1538	28 Oct 05	nicklas	1685	<sql>
1538	28 Oct 05	nicklas	1686	SELECT flt
1538	28 Oct 05	nicklas	1687	FROM BioAssaySetData bas
1538	28 Oct 05	nicklas	1688	JOIN bas.dataCubeFilter flt
1538	28 Oct 05	nicklas	1689	WHERE bas IN (:basList)
1538	28 Oct 05	nicklas	1690	</sql>
1538	28 Oct 05	nicklas	1691	<description>
1538	28 Oct 05	nicklas	1692	A Hibernate query that returns all data cube filters that are
1538	28 Oct 05	nicklas	1693	used by the specified list of bioassaysets
1538	28 Oct 05	nicklas	1694	</description>
1538	28 Oct 05	nicklas	1695	</query>
1538	28 Oct 05	nicklas	1696
1538	28 Oct 05	nicklas	1697	<query id="FIND_DATACUBEFILTERS_FOR_BIOASSAYSETS_IGNORE_DELETED_DATACUBES" type="HQL">
1538	28 Oct 05	nicklas	1698	<sql>
1538	28 Oct 05	nicklas	1699	SELECT flt
1538	28 Oct 05	nicklas	1700	FROM BioAssaySetData bas
1538	28 Oct 05	nicklas	1701	JOIN bas.dataCubeFilter flt
1538	28 Oct 05	nicklas	1702	WHERE bas IN (:basList)
1538	28 Oct 05	nicklas	1703	AND flt.dataCube NOT IN (:deletedCubes)
1538	28 Oct 05	nicklas	1704	</sql>
1538	28 Oct 05	nicklas	1705	<description>
1538	28 Oct 05	nicklas	1706	A Hibernate query that returns all data cube filters that are
1538	28 Oct 05	nicklas	1707	used by the specified list of bioassaysets but not are part of the
1538	28 Oct 05	nicklas	1708	list of already deleted data cubes.
1538	28 Oct 05	nicklas	1709	</description>
1538	28 Oct 05	nicklas	1710	</query>
1538	28 Oct 05	nicklas	1711
1538	28 Oct 05	nicklas	1712	<query id="FIND_DATACUBEFILTERS_USED_BY_OTHERS" type="HQL">
1538	28 Oct 05	nicklas	1713	<sql>
1538	28 Oct 05	nicklas	1714	SELECT flt
1538	28 Oct 05	nicklas	1715	FROM BioAssaySetData bas
1538	28 Oct 05	nicklas	1716	JOIN bas.dataCubeFilter flt
1538	28 Oct 05	nicklas	1717	WHERE bas NOT IN (:basList)
1538	28 Oct 05	nicklas	1718	AND flt IN (:possibleFilters)
1538	28 Oct 05	nicklas	1719	</sql>
1538	28 Oct 05	nicklas	1720	<description>
1538	28 Oct 05	nicklas	1721	A Hibernate query that, given a list of data cube filters and bioassaysets,
1538	28 Oct 05	nicklas	1722	returns all of those data cube filters that are also used by other bioassaysets.
1538	28 Oct 05	nicklas	1723	</description>
1538	28 Oct 05	nicklas	1724	</query>
1538	28 Oct 05	nicklas	1725
1555	02 Nov 05	nicklas	1726	<query id="FIND_DATACUBEEXTRAVALUES_FOR_BIOASSAYSETS" type="HQL">
1555	02 Nov 05	nicklas	1727	<sql>
1565	03 Nov 05	nicklas	1728	SELECT dcev
1555	02 Nov 05	nicklas	1729	FROM BioAssaySetData bas
1555	02 Nov 05	nicklas	1730	JOIN bas.extraValues ev
1565	03 Nov 05	nicklas	1731	JOIN ev.dataCubeExtraValue dcev
1555	02 Nov 05	nicklas	1732	WHERE bas IN (:basList)
1555	02 Nov 05	nicklas	1733	</sql>
1555	02 Nov 05	nicklas	1734	<description>
1555	02 Nov 05	nicklas	1735	A Hibernate query that returns all data cube extra values that are
1555	02 Nov 05	nicklas	1736	used by the specified list of bioassaysets
1555	02 Nov 05	nicklas	1737	</description>
1555	02 Nov 05	nicklas	1738	</query>
1555	02 Nov 05	nicklas	1739
1555	02 Nov 05	nicklas	1740	<query id="FIND_DATACUBEEXTRAVALUES_FOR_BIOASSAYSETS_IGNORE_DELETED_DATACUBES" type="HQL">
1555	02 Nov 05	nicklas	1741	<sql>
1565	03 Nov 05	nicklas	1742	SELECT dcev
1555	02 Nov 05	nicklas	1743	FROM BioAssaySetData bas
1555	02 Nov 05	nicklas	1744	JOIN bas.extraValues ev
1565	03 Nov 05	nicklas	1745	JOIN ev.dataCubeExtraValue dcev
1555	02 Nov 05	nicklas	1746	WHERE bas IN (:basList)
1565	03 Nov 05	nicklas	1747	AND dcev.dataCube NOT IN (:deletedCubes)
1555	02 Nov 05	nicklas	1748	</sql>
1555	02 Nov 05	nicklas	1749	<description>
1555	02 Nov 05	nicklas	1750	A Hibernate query that returns all data cube extra values that are
1555	02 Nov 05	nicklas	1751	used by the specified list of bioassaysets but not are part of the
1555	02 Nov 05	nicklas	1752	list of already deleted data cubes.
1555	02 Nov 05	nicklas	1753	</description>
1555	02 Nov 05	nicklas	1754	</query>
1555	02 Nov 05	nicklas	1755
1555	02 Nov 05	nicklas	1756	<query id="FIND_DATACUBEEXTRAVALUES_USED_BY_OTHERS" type="HQL">
1555	02 Nov 05	nicklas	1757	<sql>
1565	03 Nov 05	nicklas	1758	SELECT dcev
1555	02 Nov 05	nicklas	1759	FROM BioAssaySetData bas
1555	02 Nov 05	nicklas	1760	JOIN bas.extraValues ev
1565	03 Nov 05	nicklas	1761	JOIN ev.dataCubeExtraValue dcev
1555	02 Nov 05	nicklas	1762	WHERE bas NOT IN (:basList)
1565	03 Nov 05	nicklas	1763	AND dcev IN (:possibleExtraValues)
1555	02 Nov 05	nicklas	1764	</sql>
1555	02 Nov 05	nicklas	1765	<description>
1555	02 Nov 05	nicklas	1766	A Hibernate query that, given a list of data cube extra values and bioassaysets,
1555	02 Nov 05	nicklas	1767	returns all of those data cube extra values that are also used by other bioassaysets.
1555	02 Nov 05	nicklas	1768	</description>
1555	02 Nov 05	nicklas	1769	</query>
1555	02 Nov 05	nicklas	1770
1556	02 Nov 05	nicklas	1771	<query id="GET_EXTRAVALUETYPE_FOR_EXTERNAL_ID" type="HQL">
1556	02 Nov 05	nicklas	1772	<sql>
1556	02 Nov 05	nicklas	1773	SELECT evt
1556	02 Nov 05	nicklas	1774	FROM ExtraValueTypeData evt
1556	02 Nov 05	nicklas	1775	WHERE evt.externalId = :externalId
1556	02 Nov 05	nicklas	1776	</sql>
1556	02 Nov 05	nicklas	1777	<description>
1556	02 Nov 05	nicklas	1778	Load an extra value type when you know the external id.
1556	02 Nov 05	nicklas	1779	</description>
1556	02 Nov 05	nicklas	1780	</query>
1556	02 Nov 05	nicklas	1781
2898	13 Nov 06	nicklas	1782	<query id="GET_EXTRAVALUES_FOR_EXTRAVALUETYPE" type="HQL">
1566	04 Nov 05	nicklas	1783	<sql>
2898	13 Nov 06	nicklas	1784	SELECT {1}
1566	04 Nov 05	nicklas	1785	FROM ExtraValueData ev
1566	04 Nov 05	nicklas	1786	WHERE ev.extraValueType = :extraValueType
1566	04 Nov 05	nicklas	1787	</sql>
1566	04 Nov 05	nicklas	1788	<description>
2898	13 Nov 06	nicklas	1789	A Hibernate query that gets extra values
1566	04 Nov 05	nicklas	1790	of a specific type.
1566	04 Nov 05	nicklas	1791	</description>
1566	04 Nov 05	nicklas	1792	</query>
1701	09 Dec 05	nicklas	1793
1701	09 Dec 05	nicklas	1794	<query id="LOAD_CONTEXT_NAMES" type="HQL">
1701	09 Dec 05	nicklas	1795	<sql>
1726	19 Dec 05	nicklas	1796	SELECT ctx.id, ctx.name
1701	09 Dec 05	nicklas	1797	FROM ContextData ctx
1726	19 Dec 05	nicklas	1798	WHERE ctx.client = :client AND
1726	19 Dec 05	nicklas	1799	(ctx.user = :user OR ctx.public = true)
1933	07 Feb 06	nicklas	1800	AND ctx.itemType = :itemType
1933	07 Feb 06	nicklas	1801	AND ctx.subContext = :subContext
1701	09 Dec 05	nicklas	1802	ORDER BY ctx.name
1701	09 Dec 05	nicklas	1803	</sql>
1701	09 Dec 05	nicklas	1804	<description>
1726	19 Dec 05	nicklas	1805	A Hibernate query that selects the id and name of all contexts for
1701	09 Dec 05	nicklas	1806	a user and item type. The names should be sorted in ascending order.
1701	09 Dec 05	nicklas	1807	</description>
1701	09 Dec 05	nicklas	1808	</query>
1727	19 Dec 05	nicklas	1809
1979	14 Feb 06	nicklas	1810	<query id="LOAD_CONTEXT_BY_NAME" type="HQL">
1979	14 Feb 06	nicklas	1811	<sql>
1979	14 Feb 06	nicklas	1812	SELECT ctx
1979	14 Feb 06	nicklas	1813	FROM ContextData ctx
1979	14 Feb 06	nicklas	1814	WHERE ctx.user = :user
1979	14 Feb 06	nicklas	1815	AND ctx.client = :client
1979	14 Feb 06	nicklas	1816	AND ctx.itemType = :itemType
1979	14 Feb 06	nicklas	1817	AND ctx.subContext = :subContext
1979	14 Feb 06	nicklas	1818	AND ctx.name = :name
1979	14 Feb 06	nicklas	1819	</sql>
1979	14 Feb 06	nicklas	1820	<description>
1979	14 Feb 06	nicklas	1821	A Hibernate query that load a context given the user, client,
1979	14 Feb 06	nicklas	1822	item type, subcontext and name of the context.
1979	14 Feb 06	nicklas	1823	</description>
1979	14 Feb 06	nicklas	1824	</query>
1979	14 Feb 06	nicklas	1825
4376	04 Jul 08	nicklas	1826	<query id="LOAD_USER_CONTEXTS" type="HQL">
4376	04 Jul 08	nicklas	1827	<sql>
4376	04 Jul 08	nicklas	1828	SELECT ctx
4376	04 Jul 08	nicklas	1829	FROM ContextData ctx
4376	04 Jul 08	nicklas	1830	WHERE ctx.user.id = :user
4376	04 Jul 08	nicklas	1831	AND ctx.client.id = :client
4376	04 Jul 08	nicklas	1832	AND ctx.name = :name
4376	04 Jul 08	nicklas	1833	</sql>
4376	04 Jul 08	nicklas	1834	<description>
4376	04 Jul 08	nicklas	1835	A Hibernate query that loads all saved context information
4376	04 Jul 08	nicklas	1836	with a given name for a specific user/client.
4376	04 Jul 08	nicklas	1837	</description>
4376	04 Jul 08	nicklas	1838	</query>
4376	04 Jul 08	nicklas	1839
1727	19 Dec 05	nicklas	1840	<query id="COUNT_PLUGINS_BY_TYPE_FOR_CONTEXT" type="HQL">
1727	19 Dec 05	nicklas	1841	<sql>
2817	30 Oct 06	nicklas	1842	SELECT plg.mainType, count(DISTINCT plg.id)
1727	19 Dec 05	nicklas	1843	FROM PluginDefinitionData plg
1727	19 Dec 05	nicklas	1844	JOIN plg.guiContexts gcx
2817	30 Oct 06	nicklas	1845	LEFT JOIN plg.configurations cfg
3074	22 Jan 07	nicklas	1846	WITH true = :hasConfigPermission OR cfg.owner.id = :owner
3074	22 Jan 07	nicklas	1847	OR cfg.itemKey.id IN (:itemKeys) OR cfg.projectKey.id IN (:projectKeys)
2817	30 Oct 06	nicklas	1848	WHERE
3074	22 Jan 07	nicklas	1849	(true = :hasPluginPermission OR plg.owner.id = :owner
3074	22 Jan 07	nicklas	1850	OR plg.itemKey.id IN (:itemKeys) OR plg.projectKey.id IN (:projectKeys))
2817	30 Oct 06	nicklas	1851	AND gcx.itemType = :itemType AND gcx.contextType = :contextType
2817	30 Oct 06	nicklas	1852	AND (
2817	30 Oct 06	nicklas	1853	(plg.requiresConfiguration = false)
2817	30 Oct 06	nicklas	1854	OR
5629	09 May 11	nicklas	1855	(plg.requiresConfiguration = true AND cfg.parameterVersion > 0)
2817	30 Oct 06	nicklas	1856	)
5615	19 Apr 11	nicklas	1857	AND plg.disabled = false
8107	23 Jan 23	nicklas	1858	AND (cfg.id IS NULL OR cfg.disabled = false)
1727	19 Dec 05	nicklas	1859	GROUP BY plg.mainType
1727	19 Dec 05	nicklas	1860	</sql>
1727	19 Dec 05	nicklas	1861	<description>
2817	30 Oct 06	nicklas	1862	A Hibernate query that counts the number of plugins available for a
2817	30 Oct 06	nicklas	1863	given GUI context grouped by the main type of the plugins taking
3050	08 Jan 07	nicklas	1864	the requirement of configurations and user permissions into account.
1727	19 Dec 05	nicklas	1865	</description>
1727	19 Dec 05	nicklas	1866	</query>
2104	23 Mar 06	nicklas	1867
2104	23 Mar 06	nicklas	1868	<query id="GET_FORMULA_WITH_NAME_AND_CHANNELS" type="HQL">
2104	23 Mar 06	nicklas	1869	<sql>
2104	23 Mar 06	nicklas	1870	SELECT fml
2104	23 Mar 06	nicklas	1871	FROM FormulaData fml
2104	23 Mar 06	nicklas	1872	WHERE fml.name = :name
2104	23 Mar 06	nicklas	1873	AND fml.channels = :channels
2104	23 Mar 06	nicklas	1874	</sql>
2104	23 Mar 06	nicklas	1875	<description>
2104	23 Mar 06	nicklas	1876	A Hibernate query that loads a formula with a given name and number
2104	23 Mar 06	nicklas	1877	of channels.
2104	23 Mar 06	nicklas	1878	</description>
2104	23 Mar 06	nicklas	1879	</query>
1566	04 Nov 05	nicklas	1880
2104	23 Mar 06	nicklas	1881	<query id="GET_FORMULA_WITH_NAME_AND_TYPE" type="HQL">
2104	23 Mar 06	nicklas	1882	<sql>
2104	23 Mar 06	nicklas	1883	SELECT fml
2104	23 Mar 06	nicklas	1884	FROM FormulaData fml
2104	23 Mar 06	nicklas	1885	WHERE fml.name = :name
2104	23 Mar 06	nicklas	1886	AND fml.rawDataType = :rawDataType
2104	23 Mar 06	nicklas	1887	</sql>
2104	23 Mar 06	nicklas	1888	<description>
2104	23 Mar 06	nicklas	1889	A Hibernate query that loads a formula with a given name and raw data type.
2104	23 Mar 06	nicklas	1890	</description>
2104	23 Mar 06	nicklas	1891	</query>
2129	30 Mar 06	martin	1892
2129	30 Mar 06	martin	1893	<query id="GET_HELP_FOR_EXTERNAL_ID" type="HQL">
2129	30 Mar 06	martin	1894	<sql>
2129	30 Mar 06	martin	1895	SELECT hlp
2129	30 Mar 06	martin	1896	FROM HelpData hlp
2129	30 Mar 06	martin	1897	WHERE hlp.externalId = :externalId AND hlp.client = :client
2129	30 Mar 06	martin	1898	</sql>
2129	30 Mar 06	martin	1899	<description>
2129	30 Mar 06	martin	1900	A Hibernate query that loads a help text.
2129	30 Mar 06	martin	1901	</description>
2129	30 Mar 06	martin	1902	</query>
2142	03 Apr 06	nicklas	1903
6631	27 Nov 14	nicklas	1904	<query id="GET_SCHEMA_VERSION_FOR_APP" type="HQL">
2142	03 Apr 06	nicklas	1905	<sql>
2142	03 Apr 06	nicklas	1906	SELECT sv
2142	03 Apr 06	nicklas	1907	FROM SchemaVersionData sv
6631	27 Nov 14	nicklas	1908	WHERE sv.appId = :appId
2142	03 Apr 06	nicklas	1909	</sql>
2142	03 Apr 06	nicklas	1910	<description>
6631	27 Nov 14	nicklas	1911	A Hibernate query that loads the schema version for a
6631	27 Nov 14	nicklas	1912	given application (there should only be one record since appId is unique).
2142	03 Apr 06	nicklas	1913	</description>
2142	03 Apr 06	nicklas	1914	</query>
2142	03 Apr 06	nicklas	1915
6631	27 Nov 14	nicklas	1916	<query id="SET_SCHEMA_VERSION_FOR_APP" type="HQL">
2142	03 Apr 06	nicklas	1917	<sql>
2142	03 Apr 06	nicklas	1918	UPDATE SchemaVersionData sv
2142	03 Apr 06	nicklas	1919	SET sv.schemaVersion = :schemaVersion,
2142	03 Apr 06	nicklas	1920	sv.build = :build
6631	27 Nov 14	nicklas	1921	WHERE sv.appId = :appId
2142	03 Apr 06	nicklas	1922	</sql>
2142	03 Apr 06	nicklas	1923	<description>
2142	03 Apr 06	nicklas	1924	A Hibernate query that updates the schema version and build number.
2142	03 Apr 06	nicklas	1925	</description>
2142	03 Apr 06	nicklas	1926	</query>
2142	03 Apr 06	nicklas	1927
2164	18 Apr 06	nicklas	1928	<query id="GET_PRIMARY_ANNOTATION" type="HQL">
2164	18 Apr 06	nicklas	1929	<sql>
2164	18 Apr 06	nicklas	1930	SELECT ad
2164	18 Apr 06	nicklas	1931	FROM AnnotationData ad
2164	18 Apr 06	nicklas	1932	WHERE ad.annotationType = :annotationType
2164	18 Apr 06	nicklas	1933	AND ad.annotationSet = :annotationSet
6920	26 May 15	nicklas	1934	AND ad.source = 0
2164	18 Apr 06	nicklas	1935	</sql>
2164	18 Apr 06	nicklas	1936	<description>
2164	18 Apr 06	nicklas	1937	A Hibernate query that loads the primary annotation of a specific
2164	18 Apr 06	nicklas	1938	annotation type for a given annotation set.
2164	18 Apr 06	nicklas	1939	</description>
2164	18 Apr 06	nicklas	1940	</query>
2164	18 Apr 06	nicklas	1941
6728	13 Feb 15	nicklas	1942	<query id="LOAD_ANNOTATIONSET_INHERITING_ANNOTATIONTYPE" type="SQL">
6728	13 Feb 15	nicklas	1943	<sql>
6920	26 May 15	nicklas	1944	SELECT [a].[annotationset_id] FROM [Annotations] [a]
6728	13 Feb 15	nicklas	1945	WHERE [a].[annotationtype_id] = :annotationType
6920	26 May 15	nicklas	1946	AND [a].[source] != 0
6728	13 Feb 15	nicklas	1947	</sql>
6728	13 Feb 15	nicklas	1948	<description>
6728	13 Feb 15	nicklas	1949	An SQL query that load the ID of all annotation sets that
6728	13 Feb 15	nicklas	1950	are inheriting a given annotation type.
6728	13 Feb 15	nicklas	1951	</description>
6728	13 Feb 15	nicklas	1952	</query>
6728	13 Feb 15	nicklas	1953
6728	13 Feb 15	nicklas	1954	<query id="DELETE_INHERITED_ANNOTATIONS" type="SQL">
6728	13 Feb 15	nicklas	1955	<sql>
6920	26 May 15	nicklas	1956	DELETE FROM [Annotations]
6920	26 May 15	nicklas	1957	WHERE [annotationtype_id] = :annotationType
6920	26 May 15	nicklas	1958	AND [source] != 0
6728	13 Feb 15	nicklas	1959	</sql>
6728	13 Feb 15	nicklas	1960	<description>
6920	26 May 15	nicklas	1961	An SQL query that delete all inherited annotations of the specified
6728	13 Feb 15	nicklas	1962	annotation type.
6728	13 Feb 15	nicklas	1963	</description>
6728	13 Feb 15	nicklas	1964	</query>
6728	13 Feb 15	nicklas	1965
6937	07 Aug 15	nicklas	1966	<query id="NULLIFY_LINK_FROM_CLONES" type="HQL">
6937	07 Aug 15	nicklas	1967	<sql>
6937	07 Aug 15	nicklas	1968	UPDATE AnnotationData ad
6937	07 Aug 15	nicklas	1969	SET ad.inheritedFrom = null
6937	07 Aug 15	nicklas	1970	WHERE ad.inheritedFrom = :targetId
6937	07 Aug 15	nicklas	1971	AND ad.source = 2
6937	07 Aug 15	nicklas	1972	</sql>
6937	07 Aug 15	nicklas	1973	<description>
6937	07 Aug 15	nicklas	1974	A HQL query that nullify the link from all cloned annotations
6937	07 Aug 15	nicklas	1975	to a specified target annotation.
6937	07 Aug 15	nicklas	1976	</description>
6937	07 Aug 15	nicklas	1977	</query>
6937	07 Aug 15	nicklas	1978
2194	26 Apr 06	nicklas	1979	<query id="UPDATE_BYTES_FOR_EXPERIMENT" type="HQL">
2194	26 Apr 06	nicklas	1980	<sql>
2194	26 Apr 06	nicklas	1981	UPDATE ExperimentData xpm
2194	26 Apr 06	nicklas	1982	SET xpm.bytes = xpm.bytes + :addedBytes
2387	16 Jun 06	nicklas	1983	WHERE xpm.id = :experiment
2194	26 Apr 06	nicklas	1984	</sql>
2194	26 Apr 06	nicklas	1985	<description>
2194	26 Apr 06	nicklas	1986	A Hibernate query that updates the number of bytes used by an experiment.
2194	26 Apr 06	nicklas	1987	</description>
2194	26 Apr 06	nicklas	1988	</query>
2387	16 Jun 06	nicklas	1989
2387	16 Jun 06	nicklas	1990	<query id="UPDATE_BYTES_FOR_DATACUBE" type="HQL">
2387	16 Jun 06	nicklas	1991	<sql>
2387	16 Jun 06	nicklas	1992	UPDATE DataCubeData dcd
2387	16 Jun 06	nicklas	1993	SET dcd.bytes = dcd.bytes + :addedBytes
2387	16 Jun 06	nicklas	1994	WHERE dcd.id = :dataCube
2387	16 Jun 06	nicklas	1995	</sql>
2387	16 Jun 06	nicklas	1996	<description>
2387	16 Jun 06	nicklas	1997	A Hibernate query that updates the number of bytes used by a data cube.
2387	16 Jun 06	nicklas	1998	</description>
2387	16 Jun 06	nicklas	1999	</query>
2213	04 May 06	nicklas	2000
2213	04 May 06	nicklas	2001	<query id="GET_REMOVED_ITEMS" type="HQL">
2213	04 May 06	nicklas	2002	<sql>
2213	04 May 06	nicklas	2003	SELECT trash
2213	04 May 06	nicklas	2004	FROM net.sf.basedb.core.data.RemovableData trash
7015	17 Nov 15	nicklas	2005	WHERE NOT trash.removedBy IS NULL
2213	04 May 06	nicklas	2006	</sql>
2213	04 May 06	nicklas	2007	<description>
2213	04 May 06	nicklas	2008	A Hibernate query that loads all items flagged for deletion.
2213	04 May 06	nicklas	2009	</description>
2213	04 May 06	nicklas	2010	</query>
2254	15 May 06	nicklas	2011
2254	15 May 06	nicklas	2012	<query id="UPDATE_REMAINING_QUANTITY" type="HQL">
2254	15 May 06	nicklas	2013	<sql>
2254	15 May 06	nicklas	2014	UPDATE MeasuredBioMaterialData mbm
2254	15 May 06	nicklas	2015	SET mbm.remainingQuantity = mbm.remainingQuantity - :used
2254	15 May 06	nicklas	2016	WHERE mbm = :bioMaterial
2254	15 May 06	nicklas	2017	</sql>
2254	15 May 06	nicklas	2018	<description>
3086	29 Jan 07	nicklas	2019	A Hibernate query that adds/removes the remaining quantity on a
2254	15 May 06	nicklas	2020	measuered biomaterial.
2254	15 May 06	nicklas	2021	</description>
2254	15 May 06	nicklas	2022	</query>
6357	26 Nov 13	nicklas	2023
6357	26 Nov 13	nicklas	2024	<query id="GET_REMAINING_QUANTITY" type="HQL">
6357	26 Nov 13	nicklas	2025	<sql>
6357	26 Nov 13	nicklas	2026	SELECT mbm.remainingQuantity
6357	26 Nov 13	nicklas	2027	FROM MeasuredBioMaterialData mbm
6357	26 Nov 13	nicklas	2028	WHERE mbm = :bioMaterial
6357	26 Nov 13	nicklas	2029	</sql>
6357	26 Nov 13	nicklas	2030	<description>
6357	26 Nov 13	nicklas	2031	A Hibernate query that load the remaining quantity for a
6357	26 Nov 13	nicklas	2032	measuered biomaterial.
6357	26 Nov 13	nicklas	2033	</description>
6357	26 Nov 13	nicklas	2034	</query>
2164	18 Apr 06	nicklas	2035
2382	14 Jun 06	nicklas	2036	<query id="GET_ANYTOANY_FOR_NAME" type="HQL">
2382	14 Jun 06	nicklas	2037	<sql>
2384	15 Jun 06	nicklas	2038	SELECT ata
2384	15 Jun 06	nicklas	2039	FROM AnyToAnyData ata
2384	15 Jun 06	nicklas	2040	WHERE ata.fromId = :fromId AND ata.fromType = :fromType AND ata.name = :name
2382	14 Jun 06	nicklas	2041	</sql>
2382	14 Jun 06	nicklas	2042	<description>
2382	14 Jun 06	nicklas	2043	A Hibernate query that loads the any-to-any link with the specified name
2382	14 Jun 06	nicklas	2044	for an item.
2382	14 Jun 06	nicklas	2045	</description>
2382	14 Jun 06	nicklas	2046	</query>
2382	14 Jun 06	nicklas	2047
2384	15 Jun 06	nicklas	2048	<query id="DELETE_ANYTOANY_FROM" type="HQL">
2384	15 Jun 06	nicklas	2049	<sql>
2384	15 Jun 06	nicklas	2050	DELETE FROM AnyToAnyData ata
2384	15 Jun 06	nicklas	2051	WHERE ata.fromId = :fromId AND ata.fromType = :fromType AND ata.name = :name
2384	15 Jun 06	nicklas	2052	</sql>
2384	15 Jun 06	nicklas	2053	<description>
2384	15 Jun 06	nicklas	2054	A Hibernate query that deletes a names any-to-any link leading out from
2384	15 Jun 06	nicklas	2055	an item.
2384	15 Jun 06	nicklas	2056	</description>
2384	15 Jun 06	nicklas	2057	</query>
2384	15 Jun 06	nicklas	2058
2384	15 Jun 06	nicklas	2059
2382	14 Jun 06	nicklas	2060	<query id="DELETE_ALL_ANYTOANY_FROM" type="HQL">
2382	14 Jun 06	nicklas	2061	<sql>
2382	14 Jun 06	nicklas	2062	DELETE FROM AnyToAnyData ata
2382	14 Jun 06	nicklas	2063	WHERE ata.fromId = :fromId AND ata.fromType = :fromType
2382	14 Jun 06	nicklas	2064	</sql>
2382	14 Jun 06	nicklas	2065	<description>
2382	14 Jun 06	nicklas	2066	A Hibernate query that deletes all any-to-any links leading out from
2382	14 Jun 06	nicklas	2067	an item.
2382	14 Jun 06	nicklas	2068	</description>
2382	14 Jun 06	nicklas	2069	</query>
7082	26 Feb 16	nicklas	2070
7082	26 Feb 16	nicklas	2071	<query id="DELETE_ALL_ANYTOANY_TO" type="HQL">
7082	26 Feb 16	nicklas	2072	<sql>
7082	26 Feb 16	nicklas	2073	DELETE FROM AnyToAnyData ata
7082	26 Feb 16	nicklas	2074	WHERE ata.toId = :toId AND ata.toType = :toType
7082	26 Feb 16	nicklas	2075	</sql>
7082	26 Feb 16	nicklas	2076	<description>
7082	26 Feb 16	nicklas	2077	A Hibernate query that deletes all any-to-any links leading in to an item.
7082	26 Feb 16	nicklas	2078	</description>
7082	26 Feb 16	nicklas	2079	</query>
2382	14 Jun 06	nicklas	2080
2382	14 Jun 06	nicklas	2081	<query id="DELETE_UNUSED_ANYTOANY_TO" type="HQL">
2382	14 Jun 06	nicklas	2082	<sql>
2382	14 Jun 06	nicklas	2083	DELETE FROM AnyToAnyData ata
2382	14 Jun 06	nicklas	2084	WHERE ata.toId = :toId AND ata.toType = :toType AND ata.usingTo = false
2382	14 Jun 06	nicklas	2085	</sql>
2382	14 Jun 06	nicklas	2086	<description>
2382	14 Jun 06	nicklas	2087	A Hibernate query that deletes all any-to-any links leading in to
2382	14 Jun 06	nicklas	2088	an item that doesn't count as using the item.
2382	14 Jun 06	nicklas	2089	</description>
2382	14 Jun 06	nicklas	2090	</query>
2382	14 Jun 06	nicklas	2091
2382	14 Jun 06	nicklas	2092	<query id="COUNT_USED_ANYTOANY_TO" type="HQL">
2382	14 Jun 06	nicklas	2093	<sql>
2382	14 Jun 06	nicklas	2094	SELECT count(*)
2384	15 Jun 06	nicklas	2095	FROM AnyToAnyData ata
2384	15 Jun 06	nicklas	2096	WHERE ata.toId = :toId AND ata.toType = :toType AND ata.usingTo = true
2382	14 Jun 06	nicklas	2097	</sql>
2382	14 Jun 06	nicklas	2098	<description>
2382	14 Jun 06	nicklas	2099	A Hibernate query that counts the number of any-to-any links
2382	14 Jun 06	nicklas	2100	to a given item that counts as using the item.
2382	14 Jun 06	nicklas	2101	</description>
2382	14 Jun 06	nicklas	2102	</query>
2898	13 Nov 06	nicklas	2103
2898	13 Nov 06	nicklas	2104	<query id="FIND_USING_ANYTOANY" type="HQL">
2898	13 Nov 06	nicklas	2105	<sql>
2898	13 Nov 06	nicklas	2106	SELECT ana.fromId, ana.fromType
2898	13 Nov 06	nicklas	2107	FROM AnyToAnyData ana
2898	13 Nov 06	nicklas	2108	WHERE ana.toId = :toId AND ana.toType = :toType AND ana.usingTo = true
2898	13 Nov 06	nicklas	2109	</sql>
2898	13 Nov 06	nicklas	2110	<description>
2898	13 Nov 06	nicklas	2111	A Hibernate query that finds the any-to-any links
2898	13 Nov 06	nicklas	2112	to a given item that counts as using the item.
2898	13 Nov 06	nicklas	2113	</description>
2898	13 Nov 06	nicklas	2114	</query>
2898	13 Nov 06	nicklas	2115
2387	16 Jun 06	nicklas	2116
2387	16 Jun 06	nicklas	2117	<query id="UPDATE_DATACUBENO_FOR_VIRTUALDB" type="HQL">
2387	16 Jun 06	nicklas	2118	<sql>
2387	16 Jun 06	nicklas	2119	UPDATE VirtualDbData vdb
2387	16 Jun 06	nicklas	2120	SET vdb.cubes = vdb.cubes + 1
2387	16 Jun 06	nicklas	2121	WHERE vdb.id = :virtualDb
2387	16 Jun 06	nicklas	2122	</sql>
2387	16 Jun 06	nicklas	2123	<description>
2387	16 Jun 06	nicklas	2124	A Hibernate query that updates the number of data cubes
2387	16 Jun 06	nicklas	2125	for the specified virtual database.
2387	16 Jun 06	nicklas	2126	</description>
2387	16 Jun 06	nicklas	2127	</query>
2382	14 Jun 06	nicklas	2128
2387	16 Jun 06	nicklas	2129	<query id="GET_DATACUBENO_FOR_VIRTUALDB" type="HQL">
2387	16 Jun 06	nicklas	2130	<sql>
2387	16 Jun 06	nicklas	2131	SELECT vdb.cubes
2387	16 Jun 06	nicklas	2132	FROM VirtualDbData vdb
2387	16 Jun 06	nicklas	2133	WHERE vdb.id = :virtualDb
2387	16 Jun 06	nicklas	2134	</sql>
2387	16 Jun 06	nicklas	2135	<description>
2387	16 Jun 06	nicklas	2136	A Hibernate query that gets the current number of data cubes
2387	16 Jun 06	nicklas	2137	for the specified virtual database.
2387	16 Jun 06	nicklas	2138	</description>
2387	16 Jun 06	nicklas	2139	</query>
2387	16 Jun 06	nicklas	2140
2387	16 Jun 06	nicklas	2141	<query id="UPDATE_FILTERNO_FOR_DATACUBE" type="HQL">
2387	16 Jun 06	nicklas	2142	<sql>
2387	16 Jun 06	nicklas	2143	UPDATE DataCubeData dcb
2387	16 Jun 06	nicklas	2144	SET dcb.numFilters = dcb.numFilters + 1
2387	16 Jun 06	nicklas	2145	WHERE dcb.id = :dataCube
2387	16 Jun 06	nicklas	2146	</sql>
2387	16 Jun 06	nicklas	2147	<description>
2387	16 Jun 06	nicklas	2148	A Hibernate query that updates the number of filters
2387	16 Jun 06	nicklas	2149	for the specified data cube.
2387	16 Jun 06	nicklas	2150	</description>
2387	16 Jun 06	nicklas	2151	</query>
2387	16 Jun 06	nicklas	2152
2387	16 Jun 06	nicklas	2153	<query id="GET_FILTERNO_FOR_DATACUBE" type="HQL">
2387	16 Jun 06	nicklas	2154	<sql>
2387	16 Jun 06	nicklas	2155	SELECT dcb.numFilters
2387	16 Jun 06	nicklas	2156	FROM DataCubeData dcb
2387	16 Jun 06	nicklas	2157	WHERE dcb.id = :dataCube
2387	16 Jun 06	nicklas	2158	</sql>
2387	16 Jun 06	nicklas	2159	<description>
2387	16 Jun 06	nicklas	2160	A Hibernate query that gets the current number of filters
2387	16 Jun 06	nicklas	2161	for the specified data cube.
2387	16 Jun 06	nicklas	2162	</description>
2387	16 Jun 06	nicklas	2163	</query>
2387	16 Jun 06	nicklas	2164
2387	16 Jun 06	nicklas	2165	<query id="UPDATE_EXTRAVALUENO_FOR_DATACUBE" type="HQL">
2387	16 Jun 06	nicklas	2166	<sql>
2387	16 Jun 06	nicklas	2167	UPDATE DataCubeData dcb
2387	16 Jun 06	nicklas	2168	SET dcb.numExtraValues = dcb.numExtraValues + 1
2387	16 Jun 06	nicklas	2169	WHERE dcb.id = :dataCube
2387	16 Jun 06	nicklas	2170	</sql>
2387	16 Jun 06	nicklas	2171	<description>
2387	16 Jun 06	nicklas	2172	A Hibernate query that updates the number of extra values
2387	16 Jun 06	nicklas	2173	for the specified data cube.
2387	16 Jun 06	nicklas	2174	</description>
2387	16 Jun 06	nicklas	2175	</query>
2387	16 Jun 06	nicklas	2176
2387	16 Jun 06	nicklas	2177	<query id="GET_EXTRAVALUENO_FOR_DATACUBE" type="HQL">
2387	16 Jun 06	nicklas	2178	<sql>
2387	16 Jun 06	nicklas	2179	SELECT dcb.numExtraValues
2387	16 Jun 06	nicklas	2180	FROM DataCubeData dcb
2387	16 Jun 06	nicklas	2181	WHERE dcb.id = :dataCube
2387	16 Jun 06	nicklas	2182	</sql>
2387	16 Jun 06	nicklas	2183	<description>
2387	16 Jun 06	nicklas	2184	A Hibernate query that gets the current number of extra values
2387	16 Jun 06	nicklas	2185	for the specified data cube.
2387	16 Jun 06	nicklas	2186	</description>
2387	16 Jun 06	nicklas	2187	</query>
2387	16 Jun 06	nicklas	2188
2387	16 Jun 06	nicklas	2189	<query id="UPDATE_LAYERNO_FOR_DATACUBE" type="HQL">
2387	16 Jun 06	nicklas	2190	<sql>
2387	16 Jun 06	nicklas	2191	UPDATE DataCubeData dcb
2387	16 Jun 06	nicklas	2192	SET dcb.numLayers = dcb.numLayers + 1
2387	16 Jun 06	nicklas	2193	WHERE dcb.id = :dataCube
2387	16 Jun 06	nicklas	2194	</sql>
2387	16 Jun 06	nicklas	2195	<description>
2387	16 Jun 06	nicklas	2196	A Hibernate query that updates the number of layers
2387	16 Jun 06	nicklas	2197	for the specified data cube.
2387	16 Jun 06	nicklas	2198	</description>
2387	16 Jun 06	nicklas	2199	</query>
2387	16 Jun 06	nicklas	2200
2387	16 Jun 06	nicklas	2201	<query id="GET_LAYERNO_FOR_DATACUBE" type="HQL">
2387	16 Jun 06	nicklas	2202	<sql>
2387	16 Jun 06	nicklas	2203	SELECT dcb.numLayers
2387	16 Jun 06	nicklas	2204	FROM DataCubeData dcb
2387	16 Jun 06	nicklas	2205	WHERE dcb.id = :dataCube
2387	16 Jun 06	nicklas	2206	</sql>
2387	16 Jun 06	nicklas	2207	<description>
2387	16 Jun 06	nicklas	2208	A Hibernate query that gets the current number of layers
2387	16 Jun 06	nicklas	2209	for the specified data cube.
2387	16 Jun 06	nicklas	2210	</description>
2387	16 Jun 06	nicklas	2211	</query>
2387	16 Jun 06	nicklas	2212
2387	16 Jun 06	nicklas	2213	<query id="UPDATE_COLUMNNO_FOR_DATACUBE" type="HQL">
2387	16 Jun 06	nicklas	2214	<sql>
2387	16 Jun 06	nicklas	2215	UPDATE DataCubeData dcb
2387	16 Jun 06	nicklas	2216	SET dcb.numColumns = dcb.numColumns + 1
2387	16 Jun 06	nicklas	2217	WHERE dcb.id = :dataCube
2387	16 Jun 06	nicklas	2218	</sql>
2387	16 Jun 06	nicklas	2219	<description>
2387	16 Jun 06	nicklas	2220	A Hibernate query that updates the number of columns
2387	16 Jun 06	nicklas	2221	for the specified data cube.
2387	16 Jun 06	nicklas	2222	</description>
2387	16 Jun 06	nicklas	2223	</query>
2387	16 Jun 06	nicklas	2224
2387	16 Jun 06	nicklas	2225	<query id="GET_COLUMNNO_FOR_DATACUBE" type="HQL">
2387	16 Jun 06	nicklas	2226	<sql>
2387	16 Jun 06	nicklas	2227	SELECT dcb.numColumns
2387	16 Jun 06	nicklas	2228	FROM DataCubeData dcb
2387	16 Jun 06	nicklas	2229	WHERE dcb.id = :dataCube
2387	16 Jun 06	nicklas	2230	</sql>
2387	16 Jun 06	nicklas	2231	<description>
2387	16 Jun 06	nicklas	2232	A Hibernate query that gets the current number of columns
2387	16 Jun 06	nicklas	2233	for the specified data cube.
2387	16 Jun 06	nicklas	2234	</description>
2387	16 Jun 06	nicklas	2235	</query>
2387	16 Jun 06	nicklas	2236
2627	07 Sep 06	nicklas	2237	<query id="GET_JOBAGENT_FOR_EXTERNALID" type="HQL">
2627	07 Sep 06	nicklas	2238	<sql>
2627	07 Sep 06	nicklas	2239	SELECT jag
2627	07 Sep 06	nicklas	2240	FROM JobAgentData jag
2627	07 Sep 06	nicklas	2241	WHERE jag.externalId = :externalId
2627	07 Sep 06	nicklas	2242	</sql>
2627	07 Sep 06	nicklas	2243	<description>
2627	07 Sep 06	nicklas	2244	A Hibernate query that loads the job agent with the specified external ID.
2627	07 Sep 06	nicklas	2245	</description>
2627	07 Sep 06	nicklas	2246	</query>
2613	31 Aug 06	nicklas	2247
2646	18 Sep 06	martin	2248	<query id="GET_KEYS_FOR_PLUGIN" type="HQL">
2646	18 Sep 06	martin	2249	<sql>
2657	22 Sep 06	martin	2250	SELECT pdk
2722	11 Oct 06	nicklas	2251	FROM PluginKeys pdk
2657	22 Sep 06	martin	2252	WHERE pdk.pluginDefinitionId = :pluginId
2722	11 Oct 06	nicklas	2253	ORDER BY pdk.keyId
2646	18 Sep 06	martin	2254	</sql>
2646	18 Sep 06	martin	2255	<description>
2657	22 Sep 06	martin	2256	A Hibernate query that loads all PluginDefinitionKeys for a specified plugin ID.
2646	18 Sep 06	martin	2257	</description>
2646	18 Sep 06	martin	2258	</query>
2646	18 Sep 06	martin	2259
3467	08 Jun 07	nicklas	2260	<query id="LOAD_DEFAULT_GROUPS" type="HQL">
3467	08 Jun 07	nicklas	2261	<sql>
3467	08 Jun 07	nicklas	2262	SELECT grp
3467	08 Jun 07	nicklas	2263	FROM GroupData grp
3467	08 Jun 07	nicklas	2264	WHERE grp.default = true
3467	08 Jun 07	nicklas	2265	</sql>
3467	08 Jun 07	nicklas	2266	<description>
3467	08 Jun 07	nicklas	2267	A HQL query that loads all groups which are marked as default
3467	08 Jun 07	nicklas	2268	groups.
3467	08 Jun 07	nicklas	2269	</description>
3467	08 Jun 07	nicklas	2270	</query>
3467	08 Jun 07	nicklas	2271
3467	08 Jun 07	nicklas	2272	<query id="LOAD_DEFAULT_ROLES" type="HQL">
3467	08 Jun 07	nicklas	2273	<sql>
3467	08 Jun 07	nicklas	2274	SELECT rle
3467	08 Jun 07	nicklas	2275	FROM RoleData rle
3467	08 Jun 07	nicklas	2276	WHERE rle.default = true
3467	08 Jun 07	nicklas	2277	</sql>
3467	08 Jun 07	nicklas	2278	<description>
3467	08 Jun 07	nicklas	2279	A HQL query that loads all roles which are marked as default
3467	08 Jun 07	nicklas	2280	roles.
3467	08 Jun 07	nicklas	2281	</description>
3467	08 Jun 07	nicklas	2282	</query>
3467	08 Jun 07	nicklas	2283
3820	12 Oct 07	nicklas	2284	<query id="GET_RAWBIOASSAYS_FOR_PLATFORM" type="HQL">
3820	12 Oct 07	nicklas	2285	<sql>
3820	12 Oct 07	nicklas	2286	SELECT {1}
3820	12 Oct 07	nicklas	2287	FROM RawBioAssayData rba
3820	12 Oct 07	nicklas	2288	WHERE rba.platform = :platform
3820	12 Oct 07	nicklas	2289	</sql>
3820	12 Oct 07	nicklas	2290	<description>
3820	12 Oct 07	nicklas	2291	A Hibernate query that gets raw bioassays
3820	12 Oct 07	nicklas	2292	with a given platform.
3820	12 Oct 07	nicklas	2293	</description>
3820	12 Oct 07	nicklas	2294	</query>
3820	12 Oct 07	nicklas	2295
3820	12 Oct 07	nicklas	2296	<query id="GET_ARRAYDESIGNS_FOR_PLATFORM" type="HQL">
3820	12 Oct 07	nicklas	2297	<sql>
3820	12 Oct 07	nicklas	2298	SELECT {1}
3820	12 Oct 07	nicklas	2299	FROM ArrayDesignData ad
3820	12 Oct 07	nicklas	2300	WHERE ad.platform = :platform
3820	12 Oct 07	nicklas	2301	</sql>
3820	12 Oct 07	nicklas	2302	<description>
3820	12 Oct 07	nicklas	2303	A Hibernate query that gets array designs
3820	12 Oct 07	nicklas	2304	with a given platform.
3820	12 Oct 07	nicklas	2305	</description>
3820	12 Oct 07	nicklas	2306	</query>
3820	12 Oct 07	nicklas	2307
3820	12 Oct 07	nicklas	2308	<query id="GET_RAWBIOASSAYS_FOR_VARIANT" type="HQL">
3820	12 Oct 07	nicklas	2309	<sql>
3820	12 Oct 07	nicklas	2310	SELECT {1}
3820	12 Oct 07	nicklas	2311	FROM RawBioAssayData rba
3820	12 Oct 07	nicklas	2312	WHERE rba.variant = :variant
3820	12 Oct 07	nicklas	2313	</sql>
3820	12 Oct 07	nicklas	2314	<description>
3820	12 Oct 07	nicklas	2315	A Hibernate query that gets raw bioassays
3820	12 Oct 07	nicklas	2316	with a given platform variant.
3820	12 Oct 07	nicklas	2317	</description>
3820	12 Oct 07	nicklas	2318	</query>
3820	12 Oct 07	nicklas	2319
3820	12 Oct 07	nicklas	2320	<query id="GET_ARRAYDESIGNS_FOR_VARIANT" type="HQL">
3820	12 Oct 07	nicklas	2321	<sql>
3820	12 Oct 07	nicklas	2322	SELECT {1}
3820	12 Oct 07	nicklas	2323	FROM ArrayDesignData ad
3820	12 Oct 07	nicklas	2324	WHERE ad.variant = :variant
3820	12 Oct 07	nicklas	2325	</sql>
3820	12 Oct 07	nicklas	2326	<description>
3820	12 Oct 07	nicklas	2327	A Hibernate query that gets array designs
3820	12 Oct 07	nicklas	2328	with a given platform variant.
3820	12 Oct 07	nicklas	2329	</description>
3820	12 Oct 07	nicklas	2330	</query>
3820	12 Oct 07	nicklas	2331
3820	12 Oct 07	nicklas	2332	<query id="GET_PLATFORM_FOR_EXTERNAL_ID" type="HQL">
3820	12 Oct 07	nicklas	2333	<sql>
3820	12 Oct 07	nicklas	2334	SELECT plf
3820	12 Oct 07	nicklas	2335	FROM PlatformData plf
3820	12 Oct 07	nicklas	2336	WHERE plf.externalId = :externalId
3820	12 Oct 07	nicklas	2337	</sql>
3820	12 Oct 07	nicklas	2338	<description>
3820	12 Oct 07	nicklas	2339	A Hibernate query that loads a platform by external ID.
3820	12 Oct 07	nicklas	2340	</description>
3820	12 Oct 07	nicklas	2341	</query>
3820	12 Oct 07	nicklas	2342
3820	12 Oct 07	nicklas	2343	<query id="GET_PLATFORMVARIANT_FOR_EXTERNAL_ID" type="HQL">
3820	12 Oct 07	nicklas	2344	<sql>
3820	12 Oct 07	nicklas	2345	SELECT plv
3820	12 Oct 07	nicklas	2346	FROM PlatformVariantData plv
3820	12 Oct 07	nicklas	2347	WHERE plv.externalId = :externalId
3820	12 Oct 07	nicklas	2348	</sql>
3820	12 Oct 07	nicklas	2349	<description>
3820	12 Oct 07	nicklas	2350	A Hibernate query that loads a platform variant by external ID.
3820	12 Oct 07	nicklas	2351	</description>
3820	12 Oct 07	nicklas	2352	</query>
3820	12 Oct 07	nicklas	2353
3820	12 Oct 07	nicklas	2354	<query id="GET_DATAFILETYPE_FOR_EXTERNAL_ID" type="HQL">
3820	12 Oct 07	nicklas	2355	<sql>
3820	12 Oct 07	nicklas	2356	SELECT dft
3820	12 Oct 07	nicklas	2357	FROM DataFileTypeData dft
3820	12 Oct 07	nicklas	2358	WHERE dft.externalId = :externalId
3820	12 Oct 07	nicklas	2359	</sql>
3820	12 Oct 07	nicklas	2360	<description>
3820	12 Oct 07	nicklas	2361	A Hibernate query that loads a data file type by external ID.
3820	12 Oct 07	nicklas	2362	</description>
3820	12 Oct 07	nicklas	2363	</query>
3820	12 Oct 07	nicklas	2364
3820	12 Oct 07	nicklas	2365	<query id="GET_FILESETMEMBERS_FOR_DATAFILETYPE" type="HQL">
3820	12 Oct 07	nicklas	2366	<sql>
3820	12 Oct 07	nicklas	2367	SELECT {1}
3820	12 Oct 07	nicklas	2368	FROM FileSetMemberData mbr
3820	12 Oct 07	nicklas	2369	WHERE mbr.dataFileType = :dataFileType
3820	12 Oct 07	nicklas	2370	</sql>
3820	12 Oct 07	nicklas	2371	<description>
3820	12 Oct 07	nicklas	2372	A Hibernate query that gets file set members of a specific
3820	12 Oct 07	nicklas	2373	data file type.
3820	12 Oct 07	nicklas	2374	</description>
3820	12 Oct 07	nicklas	2375	</query>
3820	12 Oct 07	nicklas	2376
3820	12 Oct 07	nicklas	2377	<query id="GET_PLATFORMFILETYPE_FOR_DATAFILETYPE" type="HQL">
3820	12 Oct 07	nicklas	2378	<sql>
3820	12 Oct 07	nicklas	2379	SELECT {1}
3820	12 Oct 07	nicklas	2380	FROM PlatformFileTypeData pft
3820	12 Oct 07	nicklas	2381	WHERE pft.dataFileType = :dataFileType
3820	12 Oct 07	nicklas	2382	</sql>
3820	12 Oct 07	nicklas	2383	<description>
3820	12 Oct 07	nicklas	2384	A Hibernate query that gets platform file types of a specific
3820	12 Oct 07	nicklas	2385	data file type.
3820	12 Oct 07	nicklas	2386	</description>
3820	12 Oct 07	nicklas	2387	</query>
3820	12 Oct 07	nicklas	2388
7312	21 Mar 17	nicklas	2389	<query id="GET_ITEMSUBTYPES_FOR_DATAFILETYPE" type="HQL">
7312	21 Mar 17	nicklas	2390	<sql>
7312	21 Mar 17	nicklas	2391	SELECT {1}
7312	21 Mar 17	nicklas	2392	FROM ItemSubtypeFileTypeData sft
7312	21 Mar 17	nicklas	2393	WHERE sft.dataFileType = :dataFileType
7312	21 Mar 17	nicklas	2394	</sql>
7312	21 Mar 17	nicklas	2395	<description>
7312	21 Mar 17	nicklas	2396	A Hibernate query that gets item subtype file types for a specific
7312	21 Mar 17	nicklas	2397	data file type.
7312	21 Mar 17	nicklas	2398	</description>
7312	21 Mar 17	nicklas	2399	</query>
7312	21 Mar 17	nicklas	2400
7312	21 Mar 17	nicklas	2401
3820	12 Oct 07	nicklas	2402	<query id="GET_FILESETMEMBER_FOR_DATAFILETYPE" type="HQL">
3820	12 Oct 07	nicklas	2403	<sql>
3820	12 Oct 07	nicklas	2404	SELECT mbr
3820	12 Oct 07	nicklas	2405	FROM FileSetMemberData mbr
3820	12 Oct 07	nicklas	2406	WHERE mbr.dataFileType.externalId = :externalId
3820	12 Oct 07	nicklas	2407	AND mbr.fileSet = :fileSet
3820	12 Oct 07	nicklas	2408	</sql>
3820	12 Oct 07	nicklas	2409	<description>
3820	12 Oct 07	nicklas	2410	A Hibernate query that loads a member in a given file set
3820	12 Oct 07	nicklas	2411	if we know the external ID of the data file type.
3820	12 Oct 07	nicklas	2412	</description>
3820	12 Oct 07	nicklas	2413	</query>
3820	12 Oct 07	nicklas	2414
3820	12 Oct 07	nicklas	2415
4127	05 Feb 08	nicklas	2416	<query id="UPDATE_JOB_STATUS" type="HQL">
4127	05 Feb 08	nicklas	2417	<sql>
4127	05 Feb 08	nicklas	2418	UPDATE JobData job
4127	05 Feb 08	nicklas	2419	SET
4127	05 Feb 08	nicklas	2420	job.percentComplete = :percent,
4127	05 Feb 08	nicklas	2421	job.statusMessage = :statusMessage
4127	05 Feb 08	nicklas	2422	WHERE job.id = :id
4127	05 Feb 08	nicklas	2423	</sql>
4127	05 Feb 08	nicklas	2424	<description>
4127	05 Feb 08	nicklas	2425	A HQL query that updates the progress information on a specific job.
4127	05 Feb 08	nicklas	2426	</description>
4127	05 Feb 08	nicklas	2427	</query>
4127	05 Feb 08	nicklas	2428
4127	05 Feb 08	nicklas	2429	<query id="APPEND_JOB_STATUS" type="HQL">
4127	05 Feb 08	nicklas	2430	<sql>
4127	05 Feb 08	nicklas	2431	UPDATE JobData job
4127	05 Feb 08	nicklas	2432	SET
4127	05 Feb 08	nicklas	2433	job.statusMessage = job.statusMessage \|\| :statusMessage
4127	05 Feb 08	nicklas	2434	WHERE job.id = :id
4127	05 Feb 08	nicklas	2435	</sql>
4127	05 Feb 08	nicklas	2436	<description>
4127	05 Feb 08	nicklas	2437	A HQL query that appends a string to the status message on a specific job.
4127	05 Feb 08	nicklas	2438	</description>
4127	05 Feb 08	nicklas	2439	</query>
3850	17 Oct 07	nicklas	2440
4256	29 Apr 08	nicklas	2441	<query id="LOAD_RAWBIOASSAY_JOBS_IN_EXPERIMENT" type="HQL">
4256	29 Apr 08	nicklas	2442	<sql>
4256	29 Apr 08	nicklas	2443	SELECT DISTINCT rba.job.id
4256	29 Apr 08	nicklas	2444	FROM RawBioAssayData rba
4256	29 Apr 08	nicklas	2445	WHERE rba.job.experiment = :experiment
4256	29 Apr 08	nicklas	2446	</sql>
4256	29 Apr 08	nicklas	2447	<description>
4256	29 Apr 08	nicklas	2448	A HQL query that loads the ID:s of all jobs that are part
4256	29 Apr 08	nicklas	2449	of a given experiment and also has been assigned to at
4256	29 Apr 08	nicklas	2450	least one raw bioassay.
4256	29 Apr 08	nicklas	2451	</description>
4256	29 Apr 08	nicklas	2452	</query>
4257	29 Apr 08	nicklas	2453
4257	29 Apr 08	nicklas	2454	<query id="LOAD_ARRAYDESIGN_JOBS_IN_EXPERIMENT" type="HQL">
4257	29 Apr 08	nicklas	2455	<sql>
4257	29 Apr 08	nicklas	2456	SELECT ad.job.id
4257	29 Apr 08	nicklas	2457	FROM ArrayDesignData ad
4257	29 Apr 08	nicklas	2458	WHERE ad.job.experiment = :experiment
4257	29 Apr 08	nicklas	2459	</sql>
4257	29 Apr 08	nicklas	2460	<description>
4257	29 Apr 08	nicklas	2461	A HQL query that loads the ID:s of all jobs that are part
4257	29 Apr 08	nicklas	2462	of a given experiment and also has been assigned to at
4257	29 Apr 08	nicklas	2463	least one array design.
4257	29 Apr 08	nicklas	2464	</description>
4257	29 Apr 08	nicklas	2465	</query>
4131	08 Feb 08	nicklas	2466
4256	29 Apr 08	nicklas	2467	<query id="UNLINK_JOBS_FROM_EXPERIMENT" type="HQL">
4256	29 Apr 08	nicklas	2468	<sql>
4256	29 Apr 08	nicklas	2469	UPDATE JobData job
4256	29 Apr 08	nicklas	2470	SET job.experiment = null
4256	29 Apr 08	nicklas	2471	WHERE job.id IN (:list)
4256	29 Apr 08	nicklas	2472	</sql>
4256	29 Apr 08	nicklas	2473	<description>
4256	29 Apr 08	nicklas	2474	A HQL query that set the experiment property to null for
4256	29 Apr 08	nicklas	2475	a given set of jobs.
4256	29 Apr 08	nicklas	2476	</description>
4256	29 Apr 08	nicklas	2477	</query>
4299	14 May 08	nicklas	2478
4541	22 Sep 08	nicklas	2479	<query id="GET_UNIT_WITH_NAME_FOR_QUANTITY" type="HQL">
4541	22 Sep 08	nicklas	2480	<sql>
4541	22 Sep 08	nicklas	2481	SELECT unt
4541	22 Sep 08	nicklas	2482	FROM UnitData unt
4541	22 Sep 08	nicklas	2483	WHERE unt.quantity = :quantity
4541	22 Sep 08	nicklas	2484	AND unt.name = :name
4541	22 Sep 08	nicklas	2485	</sql>
4541	22 Sep 08	nicklas	2486	<description>
4541	22 Sep 08	nicklas	2487	A HQL query that finds the unit for a quantity
4541	22 Sep 08	nicklas	2488	with a given name.
4541	22 Sep 08	nicklas	2489	</description>
4541	22 Sep 08	nicklas	2490	</query>
4314	26 May 08	nicklas	2491
4541	22 Sep 08	nicklas	2492	<query id="GET_UNITS_FOR_QUANTITY" type="HQL">
4541	22 Sep 08	nicklas	2493	<sql>
4541	22 Sep 08	nicklas	2494	SELECT {1}
4541	22 Sep 08	nicklas	2495	FROM UnitData unt
4541	22 Sep 08	nicklas	2496	WHERE unt.quantity = :quantity
4541	22 Sep 08	nicklas	2497	</sql>
4541	22 Sep 08	nicklas	2498	<description>
4541	22 Sep 08	nicklas	2499	A Hibernate query that gets units
4541	22 Sep 08	nicklas	2500	for a given quantity.
4541	22 Sep 08	nicklas	2501	</description>
4541	22 Sep 08	nicklas	2502	</query>
4334	17 Jun 08	nicklas	2503
4541	22 Sep 08	nicklas	2504	<query id="GET_ANNOTATIONTYPES_FOR_QUANTITY" type="HQL">
4541	22 Sep 08	nicklas	2505	<sql>
4541	22 Sep 08	nicklas	2506	SELECT {1}
4541	22 Sep 08	nicklas	2507	FROM AnnotationTypeData at
4541	22 Sep 08	nicklas	2508	WHERE at.quantity = :quantity
4541	22 Sep 08	nicklas	2509	</sql>
4541	22 Sep 08	nicklas	2510	<description>
4541	22 Sep 08	nicklas	2511	A Hibernate query that gets annotation types
4541	22 Sep 08	nicklas	2512	that are using a given quantity.
4541	22 Sep 08	nicklas	2513	</description>
4541	22 Sep 08	nicklas	2514	</query>
4541	22 Sep 08	nicklas	2515
4541	22 Sep 08	nicklas	2516	<query id="GET_ANNOTATIONTYPES_FOR_UNIT" type="HQL">
4541	22 Sep 08	nicklas	2517	<sql>
4541	22 Sep 08	nicklas	2518	SELECT {1}
4541	22 Sep 08	nicklas	2519	FROM AnnotationTypeData at
4541	22 Sep 08	nicklas	2520	WHERE at.defaultUnit = :unit
4541	22 Sep 08	nicklas	2521	</sql>
4541	22 Sep 08	nicklas	2522	<description>
4541	22 Sep 08	nicklas	2523	A Hibernate query that gets annotation types
4541	22 Sep 08	nicklas	2524	that are using a given unit as default unit.
4541	22 Sep 08	nicklas	2525	</description>
4541	22 Sep 08	nicklas	2526	</query>
4541	22 Sep 08	nicklas	2527
4541	22 Sep 08	nicklas	2528	<query id="GET_ANNOTATIONS_FOR_UNIT" type="HQL">
4541	22 Sep 08	nicklas	2529	<sql>
4541	22 Sep 08	nicklas	2530	SELECT {1}
4541	22 Sep 08	nicklas	2531	FROM AnnotationData a
4541	22 Sep 08	nicklas	2532	WHERE a.unit = :unit
4541	22 Sep 08	nicklas	2533	</sql>
4541	22 Sep 08	nicklas	2534	<description>
4541	22 Sep 08	nicklas	2535	A Hibernate query that gets annotations
4541	22 Sep 08	nicklas	2536	that are using a given unit.
4541	22 Sep 08	nicklas	2537	</description>
4541	22 Sep 08	nicklas	2538	</query>
4541	22 Sep 08	nicklas	2539
4541	22 Sep 08	nicklas	2540	<query id="GET_UNIT_WITH_SYMBOL_FOR_QUANTITY" type="HQL">
4541	22 Sep 08	nicklas	2541	<sql>
4541	22 Sep 08	nicklas	2542	SELECT unt
4541	22 Sep 08	nicklas	2543	FROM UnitData unt
4541	22 Sep 08	nicklas	2544	JOIN unt.symbols smb
4541	22 Sep 08	nicklas	2545	WHERE unt.quantity = :quantity
4541	22 Sep 08	nicklas	2546	AND smb.symbol = :symbol
4541	22 Sep 08	nicklas	2547	</sql>
4541	22 Sep 08	nicklas	2548	<description>
4541	22 Sep 08	nicklas	2549	A HQL query that finds the unit for a quantity
4541	22 Sep 08	nicklas	2550	with a given symbol.
4541	22 Sep 08	nicklas	2551	</description>
4541	22 Sep 08	nicklas	2552	</query>
4555	02 Oct 08	nicklas	2553
4555	02 Oct 08	nicklas	2554	<query id="GET_UNIT_WITH_SYMBOL_FOR_UNIT" type="HQL">
4555	02 Oct 08	nicklas	2555	<sql>
4555	02 Oct 08	nicklas	2556	SELECT smb.unit
4555	02 Oct 08	nicklas	2557	FROM UnitSymbolData smb
4555	02 Oct 08	nicklas	2558	JOIN smb.quantity qnt
4555	02 Oct 08	nicklas	2559	JOIN qnt.units unt
4555	02 Oct 08	nicklas	2560	WHERE unt = :unit
4555	02 Oct 08	nicklas	2561	AND smb.symbol = :symbol
4555	02 Oct 08	nicklas	2562	</sql>
4555	02 Oct 08	nicklas	2563	<description>
4555	02 Oct 08	nicklas	2564	A HQL query that finds the unit with a given symbol
4555	02 Oct 08	nicklas	2565	that has the same quantity as another unit.
4555	02 Oct 08	nicklas	2566	</description>
4555	02 Oct 08	nicklas	2567	</query>
4555	02 Oct 08	nicklas	2568
4555	02 Oct 08	nicklas	2569	<query id="SET_UNIT_TO_NULL_ON_PROPERTY_FILTERS" type="SQL">
4555	02 Oct 08	nicklas	2570	<sql>
4555	02 Oct 08	nicklas	2571	UPDATE [PropertyFilters]
4555	02 Oct 08	nicklas	2572	SET [unit_id] = null
4555	02 Oct 08	nicklas	2573	WHERE [unit_id] = :unit
4555	02 Oct 08	nicklas	2574	</sql>
4555	02 Oct 08	nicklas	2575	<description>
4555	02 Oct 08	nicklas	2576	A SQL query that sets the unit to null for all properties
4555	02 Oct 08	nicklas	2577	with a given unit (about to be deleted).
4555	02 Oct 08	nicklas	2578	</description>
4555	02 Oct 08	nicklas	2579	</query>
4555	02 Oct 08	nicklas	2580
4556	03 Oct 08	nicklas	2581	<query id="RECALCULATE_ANNOTATIONS_WITH_ANNOTATIONTYPE" type="SQL">
4556	03 Oct 08	nicklas	2582	<sql>
5518	22 Nov 10	nicklas	2583	UPDATE [{1}]
5518	22 Nov 10	nicklas	2584	SET [value] = [value] * :factor + :offset
5518	22 Nov 10	nicklas	2585	WHERE [id] IN
4556	03 Oct 08	nicklas	2586	(
4556	03 Oct 08	nicklas	2587	SELECT [value_id]
4556	03 Oct 08	nicklas	2588	FROM [Annotations]
4556	03 Oct 08	nicklas	2589	WHERE [annotationtype_id] = :annotationType
4556	03 Oct 08	nicklas	2590	)
4556	03 Oct 08	nicklas	2591	</sql>
4556	03 Oct 08	nicklas	2592	<description>
4556	03 Oct 08	nicklas	2593	A SQL query that recalculates the annotation values for
4556	03 Oct 08	nicklas	2594	a given annotation type.
4556	03 Oct 08	nicklas	2595	</description>
4556	03 Oct 08	nicklas	2596	</query>
4556	03 Oct 08	nicklas	2597
4556	03 Oct 08	nicklas	2598	<query id="SET_UNIT_ON_ANNOTATIONS_WITH_ANNOTATIONTYPE" type="HQL">
4556	03 Oct 08	nicklas	2599	<sql>
4556	03 Oct 08	nicklas	2600	UPDATE AnnotationData a
4556	03 Oct 08	nicklas	2601	SET a.unit = :unit
4556	03 Oct 08	nicklas	2602	WHERE a.annotationType = :annotationType
4556	03 Oct 08	nicklas	2603	</sql>
4556	03 Oct 08	nicklas	2604	<description>
4556	03 Oct 08	nicklas	2605	A HQL query that changes the unit for all annotations with a given
4556	03 Oct 08	nicklas	2606	annotation type.
4556	03 Oct 08	nicklas	2607	</description>
4556	03 Oct 08	nicklas	2608	</query>
4556	03 Oct 08	nicklas	2609
4556	03 Oct 08	nicklas	2610	<query id="RECALCULATE_ANNOTATIONS_FOR_UNIT" type="SQL">
4556	03 Oct 08	nicklas	2611	<sql>
5518	22 Nov 10	nicklas	2612	UPDATE [{1}] SET [value] = [value] * :factor + :offset
5518	22 Nov 10	nicklas	2613	WHERE [id] IN
4556	03 Oct 08	nicklas	2614	(
4556	03 Oct 08	nicklas	2615	SELECT [a].[value_id]
4556	03 Oct 08	nicklas	2616	FROM [Annotations] [a]
4556	03 Oct 08	nicklas	2617	JOIN [AnnotationTypes] [at] ON [at].[id] = [a].[annotationtype_id]
4556	03 Oct 08	nicklas	2618	WHERE [at].[value_type] = :valueType
4556	03 Oct 08	nicklas	2619	AND
4556	03 Oct 08	nicklas	2620	(
4556	03 Oct 08	nicklas	2621	(:case = 1 AND [a].[unit_id] = :unit AND [at].[default_unit_id] <> :unit)
4556	03 Oct 08	nicklas	2622	OR
4556	03 Oct 08	nicklas	2623	(:case = 2 AND [a].[unit_id] <> :unit AND [at].[default_unit_id] = :unit)
4556	03 Oct 08	nicklas	2624	)
4556	03 Oct 08	nicklas	2625	)
4556	03 Oct 08	nicklas	2626	</sql>
4556	03 Oct 08	nicklas	2627	<description>
4556	03 Oct 08	nicklas	2628	A SQL query that recalculates the annotation values for
4556	03 Oct 08	nicklas	2629	when reference factor and/or offset changes. The query must handle
4556	03 Oct 08	nicklas	2630	two cases where either the annotation type's default unit
4556	03 Oct 08	nicklas	2631	or the annotation's unit matched. More info in doc for the
4556	03 Oct 08	nicklas	2632	Unit.changeReferenceFactorAndOffset() method.
4556	03 Oct 08	nicklas	2633	</description>
4556	03 Oct 08	nicklas	2634	</query>
6776	17 Mar 15	nicklas	2635
6741	17 Feb 15	nicklas	2636	<query id="UPDATE_ITEMLIST_SIZE" type="SQL">
6741	17 Feb 15	nicklas	2637	<sql>
6741	17 Feb 15	nicklas	2638	UPDATE [ItemLists]
6741	17 Feb 15	nicklas	2639	SET [size] = [size] + :delta
6741	17 Feb 15	nicklas	2640	WHERE [member_type] = :memberType
6741	17 Feb 15	nicklas	2641	AND [id] = ANY(
6741	17 Feb 15	nicklas	2642	SELECT [list_id]
6741	17 Feb 15	nicklas	2643	FROM [ItemListMembers]
6741	17 Feb 15	nicklas	2644	WHERE [item_id] = :itemId
6741	17 Feb 15	nicklas	2645	)
6741	17 Feb 15	nicklas	2646	</sql>
6741	17 Feb 15	nicklas	2647	<description>
6741	17 Feb 15	nicklas	2648	An update query that changes the size for all item lists
6741	17 Feb 15	nicklas	2649	where a given item is a member. Mainly used to decrease
6741	17 Feb 15	nicklas	2650	the size when an item is deleted.
6741	17 Feb 15	nicklas	2651	</description>
6741	17 Feb 15	nicklas	2652	</query>
6741	17 Feb 15	nicklas	2653
6741	17 Feb 15	nicklas	2654	<query id="DELETE_ITEMLIST_MEMBER" type="SQL">
6741	17 Feb 15	nicklas	2655	<sql>
6741	17 Feb 15	nicklas	2656	DELETE FROM [ItemListMembers]
6741	17 Feb 15	nicklas	2657	WHERE [item_id] = :itemId
6741	17 Feb 15	nicklas	2658	AND [list_id] = ANY(
6741	17 Feb 15	nicklas	2659	SELECT [id]
6741	17 Feb 15	nicklas	2660	FROM [ItemLists]
6741	17 Feb 15	nicklas	2661	WHERE [member_type] = :memberType
6741	17 Feb 15	nicklas	2662	)
6741	17 Feb 15	nicklas	2663	</sql>
6741	17 Feb 15	nicklas	2664	<description>
6741	17 Feb 15	nicklas	2665	An update query that delete the list member entries
6741	17 Feb 15	nicklas	2666	for all lists where the given item is a member.
6741	17 Feb 15	nicklas	2667	</description>
6741	17 Feb 15	nicklas	2668	</query>
6741	17 Feb 15	nicklas	2669
4685	04 Dec 08	martin	2670	<query id="GET_BIOMATERIAL_ON_PLATE" type="HQL">
4685	04 Dec 08	martin	2671	<sql>
4685	04 Dec 08	martin	2672	SELECT {1}
4685	04 Dec 08	martin	2673	FROM MeasuredBioMaterialData mbm
4685	04 Dec 08	martin	2674	JOIN mbm.bioWell bw
4685	04 Dec 08	martin	2675	WHERE bw.bioPlate = :bioPlate
4685	04 Dec 08	martin	2676	</sql>
4685	04 Dec 08	martin	2677	<description>
4685	04 Dec 08	martin	2678	A HQL query that gets MeasuredBioMaterial:s
4685	04 Dec 08	martin	2679	located on a given bioplate.
4685	04 Dec 08	martin	2680	</description>
4685	04 Dec 08	martin	2681	</query>
5021	26 Jun 09	nicklas	2682	<query id="FIND_USED_TYPES_IN_ANYTOANY" type="SQL">
4910	29 Apr 09	nicklas	2683	<sql>
5021	26 Jun 09	nicklas	2684	SELECT [a].[from_type] FROM [AnyToAny] [a]
5021	26 Jun 09	nicklas	2685	UNION
5021	26 Jun 09	nicklas	2686	SELECT [a].[to_type] FROM [AnyToAny] [a]
4910	29 Apr 09	nicklas	2687	</sql>
4910	29 Apr 09	nicklas	2688	<description>
5021	26 Jun 09	nicklas	2689	An SQL query that selects all used item types in any-to-any
5021	26 Jun 09	nicklas	2690	links. It must select both the the 'from' and 'to' item type.
4910	29 Apr 09	nicklas	2691	</description>
4910	29 Apr 09	nicklas	2692	</query>
5021	26 Jun 09	nicklas	2693	<query id="SELECT_STRAY_ANYTOANY" type="SQL">
5021	26 Jun 09	nicklas	2694	<sql>
5021	26 Jun 09	nicklas	2695	SELECT [a].[id]
5021	26 Jun 09	nicklas	2696	FROM [AnyToAny] [a]
5021	26 Jun 09	nicklas	2697	LEFT JOIN [{1}] [t]
5021	26 Jun 09	nicklas	2698	ON ([t].[id] = [a].[from_id] AND [a].[from_type] = :type)
5021	26 Jun 09	nicklas	2699	OR ([t].[id] = [a].[to_id] AND [a].[to_type] = :type)
5021	26 Jun 09	nicklas	2700	WHERE [t].[id] IS NULL
5021	26 Jun 09	nicklas	2701	AND ([a].[from_type] = :type OR [a].[to_type] = :type)
5021	26 Jun 09	nicklas	2702	</sql>
5021	26 Jun 09	nicklas	2703	<description>
5021	26 Jun 09	nicklas	2704	An SQL query that selects the ID of all any-to-any links were
5021	26 Jun 09	nicklas	2705	either the 'from' or 'to' item is missing. A single query
5021	26 Jun 09	nicklas	2706	is used to delete all items of a specific type (both
5021	26 Jun 09	nicklas	2707	'from' and 'to).
5021	26 Jun 09	nicklas	2708	</description>
5021	26 Jun 09	nicklas	2709	</query>
5021	26 Jun 09	nicklas	2710	<query id="DELETE_STRAY_ANYTOANY" type="HQL">
5021	26 Jun 09	nicklas	2711	<sql>
5021	26 Jun 09	nicklas	2712	DELETE FROM AnyToAnyData
5021	26 Jun 09	nicklas	2713	WHERE id IN (:ids)
5021	26 Jun 09	nicklas	2714	</sql>
5021	26 Jun 09	nicklas	2715	<description>
5021	26 Jun 09	nicklas	2716	A HQL query that deletes all any-to-any links with the
5021	26 Jun 09	nicklas	2717	id's given in the list.
5021	26 Jun 09	nicklas	2718	</description>
5021	26 Jun 09	nicklas	2719	</query>
5039	10 Aug 09	nicklas	2720	<query id="FIND_USED_TYPES_IN_CHANGEHISTORY" type="HQL">
5039	10 Aug 09	nicklas	2721	<sql>
5039	10 Aug 09	nicklas	2722	SELECT DISTINCT ch.itemType FROM ChangeHistoryDetailData ch
5039	10 Aug 09	nicklas	2723	</sql>
5039	10 Aug 09	nicklas	2724	<description>
5039	10 Aug 09	nicklas	2725	An HQL query that selects all used item types in the change
5039	10 Aug 09	nicklas	2726	history table.
5039	10 Aug 09	nicklas	2727	</description>
5039	10 Aug 09	nicklas	2728	</query>
5039	10 Aug 09	nicklas	2729	<query id="DELETE_STRAY_CHANGEHISTORY" type="HQL">
5039	10 Aug 09	nicklas	2730	<sql>
5039	10 Aug 09	nicklas	2731	DELETE FROM ChangeHistoryDetailData
5039	10 Aug 09	nicklas	2732	WHERE id IN (:ids)
5039	10 Aug 09	nicklas	2733	</sql>
5039	10 Aug 09	nicklas	2734	<description>
5039	10 Aug 09	nicklas	2735	A HQL query that deletes all change history entries with the
5039	10 Aug 09	nicklas	2736	id's given in the list.
5039	10 Aug 09	nicklas	2737	</description>
5039	10 Aug 09	nicklas	2738	</query>
5039	10 Aug 09	nicklas	2739	<query id="SELECT_STRAY_CHANGEHISTORY" type="SQL">
5039	10 Aug 09	nicklas	2740	<sql>
5039	10 Aug 09	nicklas	2741	SELECT [ch].[id]
5039	10 Aug 09	nicklas	2742	FROM [ChangeHistoryDetails] [ch]
5039	10 Aug 09	nicklas	2743	LEFT JOIN [{1}] [t]
5039	10 Aug 09	nicklas	2744	ON ([t].[id] = [ch].[item_id] AND [ch].[item_type] = :type)
5039	10 Aug 09	nicklas	2745	WHERE [t].[id] IS NULL
5039	10 Aug 09	nicklas	2746	AND [ch].[item_type] = :type
5039	10 Aug 09	nicklas	2747	</sql>
5039	10 Aug 09	nicklas	2748	<description>
5039	10 Aug 09	nicklas	2749	An SQL query that selects the ID of all change history entries
5039	10 Aug 09	nicklas	2750	that references a missing item of a specified type.
5039	10 Aug 09	nicklas	2751	</description>
5039	10 Aug 09	nicklas	2752	</query>
6354	25 Nov 13	nicklas	2753	<query id="DBLOG_GET_ANNOTATIONTYPE_INFO" type="HQL">
5054	18 Aug 09	nicklas	2754	<sql>
8083	20 Oct 22	nicklas	2755	SELECT at.name, at.valueType, at.disableLogOfValues, at.projectAnnotations
5054	18 Aug 09	nicklas	2756	FROM AnnotationTypeData at
5054	18 Aug 09	nicklas	2757	WHERE at.id = :annotationTypeId
5054	18 Aug 09	nicklas	2758	</sql>
5054	18 Aug 09	nicklas	2759	<description>
8083	20 Oct 22	nicklas	2760	An HQL query that loads the 'name', 'valueType', 'disableLogOfValues' and
8083	20 Oct 22	nicklas	2761	the 'projectAnnotations' flag for an annotation type given the ID.
5054	18 Aug 09	nicklas	2762	</description>
5054	18 Aug 09	nicklas	2763	</query>
5054	18 Aug 09	nicklas	2764	<query id="DBLOG_GET_ANNOTATION_ITEMTYPE" type="HQL">
5054	18 Aug 09	nicklas	2765	<sql>
6918	26 May 15	nicklas	2766	SELECT a.itemType
6918	26 May 15	nicklas	2767	FROM AnnotationSetData a
6918	26 May 15	nicklas	2768	WHERE a.id = :annotationSetId
5054	18 Aug 09	nicklas	2769	</sql>
5054	18 Aug 09	nicklas	2770	<description>
5054	18 Aug 09	nicklas	2771	An HQL query that loads the item type value an annotation
5054	18 Aug 09	nicklas	2772	set with a given ID belongs to.
5054	18 Aug 09	nicklas	2773	</description>
5054	18 Aug 09	nicklas	2774	</query>
5054	18 Aug 09	nicklas	2775	<query id="DBLOG_GET_ITEMID_WITH_ANNOTATION" type="HQL">
5054	18 Aug 09	nicklas	2776	<sql>
5054	18 Aug 09	nicklas	2777	SELECT i.id
5054	18 Aug 09	nicklas	2778	FROM {1} i
5054	18 Aug 09	nicklas	2779	WHERE i.annotationSet = :annotationSetId
5054	18 Aug 09	nicklas	2780	</sql>
5054	18 Aug 09	nicklas	2781	<description>
5054	18 Aug 09	nicklas	2782	An HQL query that loads the ID of the item that
5054	18 Aug 09	nicklas	2783	is associated with a given annotation set.
5054	18 Aug 09	nicklas	2784	</description>
5054	18 Aug 09	nicklas	2785	</query>
6359	27 Nov 13	nicklas	2786	<query id="DBLOG_GET_NAME_FOR_ITEM" type="HQL">
5063	19 Aug 09	nicklas	2787	<sql>
6359	27 Nov 13	nicklas	2788	SELECT i.name
6359	27 Nov 13	nicklas	2789	FROM {1} i
6359	27 Nov 13	nicklas	2790	WHERE i.id = :id
5063	19 Aug 09	nicklas	2791	</sql>
5063	19 Aug 09	nicklas	2792	<description>
6359	27 Nov 13	nicklas	2793	An HQL query that loads the name of a an item.
5063	19 Aug 09	nicklas	2794	</description>
5063	19 Aug 09	nicklas	2795	</query>
5063	19 Aug 09	nicklas	2796	<query id="DBLOG_GET_FILESET_ITEMTYPE" type="HQL">
5063	19 Aug 09	nicklas	2797	<sql>
5063	19 Aug 09	nicklas	2798	SELECT fs.itemType
5063	19 Aug 09	nicklas	2799	FROM FileSetData fs
5063	19 Aug 09	nicklas	2800	WHERE fs.id = :fileSetId
5063	19 Aug 09	nicklas	2801	</sql>
5063	19 Aug 09	nicklas	2802	<description>
5063	19 Aug 09	nicklas	2803	An HQL query that loads the item type value a file set
5063	19 Aug 09	nicklas	2804	set with a given ID belongs to.
5063	19 Aug 09	nicklas	2805	</description>
5063	19 Aug 09	nicklas	2806	</query>
5063	19 Aug 09	nicklas	2807	<query id="DBLOG_GET_ITEMID_WITH_FILESET" type="HQL">
5063	19 Aug 09	nicklas	2808	<sql>
5063	19 Aug 09	nicklas	2809	SELECT i.id
5063	19 Aug 09	nicklas	2810	FROM {1} i
5063	19 Aug 09	nicklas	2811	WHERE i.fileSet = :fileSetId
5063	19 Aug 09	nicklas	2812	</sql>
5063	19 Aug 09	nicklas	2813	<description>
5063	19 Aug 09	nicklas	2814	An HQL query that loads the ID of the item that
5063	19 Aug 09	nicklas	2815	is associated with a given file set.
5063	19 Aug 09	nicklas	2816	</description>
5063	19 Aug 09	nicklas	2817	</query>
7132	21 Apr 16	nicklas	2818	<query id="DBLOG_INSERT_INTO_CHANGEHISTORYDETAILS" type="SQL">
7132	21 Apr 16	nicklas	2819	<sql>
7132	21 Apr 16	nicklas	2820	INSERT INTO [ChangeHistoryDetails]
7132	21 Apr 16	nicklas	2821	([id], [version], [history_id], [change_type], [item_id], [item_type], [change_info], [old_value], [new_value])
7132	21 Apr 16	nicklas	2822	VALUES (nextval('hibernate_sequence'), 0, ?, ?, ?, ?, ?, ?, ?)
7132	21 Apr 16	nicklas	2823	</sql>
7132	21 Apr 16	nicklas	2824	<description>
7132	21 Apr 16	nicklas	2825	SQL query for inserting rows into the ChangeHistoryDetails table.
7132	21 Apr 16	nicklas	2826	The primary key (id) must be auto-generated.
7132	21 Apr 16	nicklas	2827	Parameters: history_id, change_type, item_id, item_type, change_info, old_value, new_value
7132	21 Apr 16	nicklas	2828	</description>
7132	21 Apr 16	nicklas	2829	</query>
5077	26 Aug 09	nicklas	2830	<query id="GET_GROUPS_WITH_NONHIDDENMEMBERS" type="HQL">
5077	26 Aug 09	nicklas	2831	<sql>
5077	26 Aug 09	nicklas	2832	SELECT grp.id
5077	26 Aug 09	nicklas	2833	FROM GroupData grp
5077	26 Aug 09	nicklas	2834	WHERE grp.hiddenMembers = false
5077	26 Aug 09	nicklas	2835	AND grp.id IN (:groups)
5077	26 Aug 09	nicklas	2836	</sql>
5077	26 Aug 09	nicklas	2837	<description>
5077	26 Aug 09	nicklas	2838	A HQL query that selects the ID of the groups among a given set of
5077	26 Aug 09	nicklas	2839	groups that has 'hiddenMembers=false'
5077	26 Aug 09	nicklas	2840	</description>
5077	26 Aug 09	nicklas	2841	</query>
5260	04 Mar 10	nicklas	2842	<query id="GET_BIOPLATES_FOR_BIOPLATETYPE" type="HQL">
5260	04 Mar 10	nicklas	2843	<sql>
5260	04 Mar 10	nicklas	2844	SELECT {1}
5260	04 Mar 10	nicklas	2845	FROM BioPlateData bpl
5260	04 Mar 10	nicklas	2846	WHERE bpl.bioPlateType = :bioPlateType
5260	04 Mar 10	nicklas	2847	</sql>
5260	04 Mar 10	nicklas	2848	<description>
5260	04 Mar 10	nicklas	2849	A HQL query that gets the bioplates using a given type.
5260	04 Mar 10	nicklas	2850	</description>
5260	04 Mar 10	nicklas	2851	</query>
5339	07 May 10	nicklas	2852
5260	04 Mar 10	nicklas	2853	<query id="GET_BIOPLATETYPE_WITH_NAME" type="HQL">
5260	04 Mar 10	nicklas	2854	<sql>
5260	04 Mar 10	nicklas	2855	SELECT bpt
5260	04 Mar 10	nicklas	2856	FROM BioPlateTypeData bpt
5260	04 Mar 10	nicklas	2857	WHERE bpt.name = :name
5260	04 Mar 10	nicklas	2858	</sql>
5260	04 Mar 10	nicklas	2859	<description>
5260	04 Mar 10	nicklas	2860	A HQL query that gets the bioplate type with a given name.
5260	04 Mar 10	nicklas	2861	</description>
5260	04 Mar 10	nicklas	2862	</query>
5368	22 Jun 10	nicklas	2863	<query id="GET_PROJECTS_FOR_PERMISSION_TEMPLATE" type="HQL">
5368	22 Jun 10	nicklas	2864	<sql>
5368	22 Jun 10	nicklas	2865	SELECT {1}
5368	22 Jun 10	nicklas	2866	FROM ProjectData prj
5368	22 Jun 10	nicklas	2867	WHERE prj.permissionTemplate = :permissionTemplate
5368	22 Jun 10	nicklas	2868	</sql>
5368	22 Jun 10	nicklas	2869	<description>
5368	22 Jun 10	nicklas	2870	A HQL query that gets the projects that are using a given permission
5368	22 Jun 10	nicklas	2871	template.
5368	22 Jun 10	nicklas	2872	</description>
5368	22 Jun 10	nicklas	2873	</query>
5054	18 Aug 09	nicklas	2874
5403	06 Sep 10	martin	2875	<query id="SET_GROUP_TO_NULL_ON_DISK_USAGE" type="HQL">
5403	06 Sep 10	martin	2876	<sql>
5403	06 Sep 10	martin	2877	UPDATE DiskUsageData du
5403	06 Sep 10	martin	2878	SET du.group = null
5403	06 Sep 10	martin	2879	WHERE du.group = :group
5403	06 Sep 10	martin	2880	</sql>
5403	06 Sep 10	martin	2881	<description>
5403	06 Sep 10	martin	2882	An HQL update-query that sets group to null on all
5403	06 Sep 10	martin	2883	diskusage that are associated with a given group.
5403	06 Sep 10	martin	2884	</description>
5403	06 Sep 10	martin	2885	</query>
5390	17 Aug 10	nicklas	2886
5456	28 Oct 10	nicklas	2887	<query id="CLEAR_ORIGINAL_BIOMATERIAL_ON_BIOWELLS" type="HQL">
5456	28 Oct 10	nicklas	2888	<sql>
5456	28 Oct 10	nicklas	2889	UPDATE BioWellData bw
5456	28 Oct 10	nicklas	2890	SET bw.originalBioMaterial = null
5456	28 Oct 10	nicklas	2891	WHERE bw.originalBioMaterial = :bioMaterial
5456	28 Oct 10	nicklas	2892	</sql>
5456	28 Oct 10	nicklas	2893	<description>
5456	28 Oct 10	nicklas	2894	An HQL update-query that for a given biomaterial clears the
5456	28 Oct 10	nicklas	2895	link on all biowells were it is set as the original biomaterial.
5456	28 Oct 10	nicklas	2896	</description>
5456	28 Oct 10	nicklas	2897	</query>
5456	28 Oct 10	nicklas	2898
5523	02 Dec 10	nicklas	2899	<query id="CLEAR_PARTICIPANT_ON_BIOMATERIALEVENTS_FOR_BIOPLATEEVENT" type="HQL">
5523	02 Dec 10	nicklas	2900	<sql>
5523	02 Dec 10	nicklas	2901	UPDATE BioMaterialEventData bme
5523	02 Dec 10	nicklas	2902	SET bme.bioPlateEventParticipant = null
5523	02 Dec 10	nicklas	2903	WHERE bme.bioPlateEventParticipant =ANY (
5523	02 Dec 10	nicklas	2904	SELECT bep FROM BioPlateEventParticipantData bep
5523	02 Dec 10	nicklas	2905	WHERE bep.event = :event
5523	02 Dec 10	nicklas	2906	)
5523	02 Dec 10	nicklas	2907	</sql>
5523	02 Dec 10	nicklas	2908	<description>
5523	02 Dec 10	nicklas	2909	An HQL update-query that clears the references to a given
5523	02 Dec 10	nicklas	2910	bioplate event on all biomaterial events that links to it
5523	02 Dec 10	nicklas	2911	(via the bioplate event participant table).
5523	02 Dec 10	nicklas	2912	</description>
5523	02 Dec 10	nicklas	2913	</query>
5523	02 Dec 10	nicklas	2914
5525	06 Dec 10	nicklas	2915	<query id="CLEAR_PARTICIPANT_ON_BIOMATERIALEVENTS_FOR_BIOPLATE" type="HQL">
5525	06 Dec 10	nicklas	2916	<sql>
5525	06 Dec 10	nicklas	2917	UPDATE BioMaterialEventData bme
5525	06 Dec 10	nicklas	2918	SET bme.bioPlateEventParticipant = null
5525	06 Dec 10	nicklas	2919	WHERE bme.bioPlateEventParticipant =ANY (
5525	06 Dec 10	nicklas	2920	SELECT bep FROM BioPlateEventParticipantData bep
5525	06 Dec 10	nicklas	2921	WHERE bep.bioPlate = :bioPlate
5525	06 Dec 10	nicklas	2922	)
5525	06 Dec 10	nicklas	2923	</sql>
5525	06 Dec 10	nicklas	2924	<description>
5525	06 Dec 10	nicklas	2925	An HQL update-query that clears the references to all bioplate
5525	06 Dec 10	nicklas	2926	event participants on biomaterial events for a given bioplate.
5525	06 Dec 10	nicklas	2927	</description>
5525	06 Dec 10	nicklas	2928	</query>
5523	02 Dec 10	nicklas	2929
5523	02 Dec 10	nicklas	2930	<query id="CLEAR_PARTICIPANT_ON_BIOMATERIALEVENTS_FOR_PARTICIPANT" type="HQL">
5523	02 Dec 10	nicklas	2931	<sql>
5523	02 Dec 10	nicklas	2932	UPDATE BioMaterialEventData bme
5523	02 Dec 10	nicklas	2933	SET bme.bioPlateEventParticipant = null
5523	02 Dec 10	nicklas	2934	WHERE bme.bioPlateEventParticipant = :participant
5523	02 Dec 10	nicklas	2935	</sql>
5523	02 Dec 10	nicklas	2936	<description>
5523	02 Dec 10	nicklas	2937	An HQL update-query that clears the references to a given bioplate
5523	02 Dec 10	nicklas	2938	event participant on all related biomaterial events.
5523	02 Dec 10	nicklas	2939	</description>
5523	02 Dec 10	nicklas	2940	</query>
5523	02 Dec 10	nicklas	2941
5525	06 Dec 10	nicklas	2942	<query id="GET_BIOPLATEEVENTS_FOR_BIOPLATEEVENTTYPE" type="HQL">
5525	06 Dec 10	nicklas	2943	<sql>
5525	06 Dec 10	nicklas	2944	SELECT {1}
5525	06 Dec 10	nicklas	2945	FROM BioPlateEventData bpe
5525	06 Dec 10	nicklas	2946	WHERE bpe.eventType = :eventType
5525	06 Dec 10	nicklas	2947	</sql>
5525	06 Dec 10	nicklas	2948	<description>
5525	06 Dec 10	nicklas	2949	An HQL update-query that gets the bioplate events that are
5525	06 Dec 10	nicklas	2950	of a given bioplate event type.
5525	06 Dec 10	nicklas	2951	</description>
5525	06 Dec 10	nicklas	2952	</query>
5621	03 May 11	nicklas	2953
5621	03 May 11	nicklas	2954	<query id="GET_JAR_PATH_FROM_TABLE" type="SQL">
5566	09 Feb 11	nicklas	2955	<sql>
5621	03 May 11	nicklas	2956	SELECT [id], [jar_path] FROM [{1}] [t]
5621	03 May 11	nicklas	2957	where [t].[jar_file] IS NULL AND NOT [t].[jar_path] IS NULL
5566	09 Feb 11	nicklas	2958	</sql>
5566	09 Feb 11	nicklas	2959	<description>
5621	03 May 11	nicklas	2960	An SQL query that selects the ID and JAR_PATH column from a given table
5621	03 May 11	nicklas	2961	where the existing JAR_PATH has a value and the existing JAR_FILE is
5621	03 May 11	nicklas	2962	null.
5566	09 Feb 11	nicklas	2963	</description>
5566	09 Feb 11	nicklas	2964	</query>
5566	09 Feb 11	nicklas	2965
5621	03 May 11	nicklas	2966	<query id="SET_JAR_FILE_IN_TABLE" type="SQL">
5566	09 Feb 11	nicklas	2967	<sql>
5621	03 May 11	nicklas	2968	UPDATE [{1}] SET [jar_file] = :file WHERE id = :id
5566	09 Feb 11	nicklas	2969	</sql>
5566	09 Feb 11	nicklas	2970	<description>
5621	03 May 11	nicklas	2971	An SQL query that updates the JAR_FILE with the given value.
5566	09 Feb 11	nicklas	2972	</description>
5566	09 Feb 11	nicklas	2973	</query>
5621	03 May 11	nicklas	2974
5621	03 May 11	nicklas	2975	<query id="DROP_COLUMN" type="SQL">
5621	03 May 11	nicklas	2976	<sql>
5621	03 May 11	nicklas	2977	ALTER TABLE [{1}] DROP COLUMN [{2}]
5621	03 May 11	nicklas	2978	</sql>
5621	03 May 11	nicklas	2979	<description>
5730	12 Sep 11	nicklas	2980	An SQL query that drops a column (2) from a table (1).
5621	03 May 11	nicklas	2981	</description>
5621	03 May 11	nicklas	2982	</query>
6917	25 May 15	nicklas	2983
6917	25 May 15	nicklas	2984	<query id="DROP_NOT_NULL_CONSTRAINT" type="SQL">
6917	25 May 15	nicklas	2985	<sql>
6917	25 May 15	nicklas	2986	ALTER TABLE [{1}] ALTER COLUMN [{2}] DROP NOT NULL
6917	25 May 15	nicklas	2987	</sql>
6917	25 May 15	nicklas	2988	<description>
6917	25 May 15	nicklas	2989	An SQL query that drops a NOT NULL contraint from column (2) in a table (1).
6917	25 May 15	nicklas	2990	</description>
6917	25 May 15	nicklas	2991	</query>
5630	13 May 11	nicklas	2992
5703	19 Aug 11	nicklas	2993	<query id="DROP_TABLE" type="SQL">
5703	19 Aug 11	nicklas	2994	<sql>
5703	19 Aug 11	nicklas	2995	DROP TABLE [{1}]
5703	19 Aug 11	nicklas	2996	</sql>
5703	19 Aug 11	nicklas	2997	<description>
5730	12 Sep 11	nicklas	2998	An SQL query that drops a table (1).
5703	19 Aug 11	nicklas	2999	</description>
5703	19 Aug 11	nicklas	3000	</query>
5703	19 Aug 11	nicklas	3001
5703	19 Aug 11	nicklas	3002	<query id="CONVERT_LABELEDEXTRACTS_TO_EXTRACTS" type="SQL">
5703	19 Aug 11	nicklas	3003	<sql>
5703	19 Aug 11	nicklas	3004	UPDATE [BioMaterials]
5703	19 Aug 11	nicklas	3005	SET [discriminator] = 3
5703	19 Aug 11	nicklas	3006	WHERE [discriminator] = 4
5703	19 Aug 11	nicklas	3007	</sql>
5703	19 Aug 11	nicklas	3008	<description>
5703	19 Aug 11	nicklas	3009	An SQL query that convert labeled extract to extract.
5703	19 Aug 11	nicklas	3010	</description>
5703	19 Aug 11	nicklas	3011	</query>
5703	19 Aug 11	nicklas	3012
5703	19 Aug 11	nicklas	3013	<query id="GET_HYBRIDIZATIONS" type="SQL">
5703	19 Aug 11	nicklas	3014	<sql>
5703	19 Aug 11	nicklas	3015	SELECT
5703	19 Aug 11	nicklas	3016	[id], [version],
5703	19 Aug 11	nicklas	3017	[arrayslide_id], [num_arrays],
5703	19 Aug 11	nicklas	3018	[annotationset_id], [name],
5703	19 Aug 11	nicklas	3019	[description], [removed],
5703	19 Aug 11	nicklas	3020	[itemkey_id], [projectkey_id],
5703	19 Aug 11	nicklas	3021	[owner]
5703	19 Aug 11	nicklas	3022	FROM
5703	19 Aug 11	nicklas	3023	[Hybridizations]
5703	19 Aug 11	nicklas	3024	</sql>
5703	19 Aug 11	nicklas	3025	<description>
5703	19 Aug 11	nicklas	3026	An SQL query that load all BASE 2.17 hybridizations.
5703	19 Aug 11	nicklas	3027	</description>
5703	19 Aug 11	nicklas	3028	</query>
5703	19 Aug 11	nicklas	3029
5703	19 Aug 11	nicklas	3030	<query id="UPDATE_BIOASSAYID_FROM_HYBID" type="SQL">
5703	19 Aug 11	nicklas	3031	<sql>
5703	19 Aug 11	nicklas	3032	UPDATE [BioMaterialEvents]
5703	19 Aug 11	nicklas	3033	SET [physicalbioassay_id] = :bioAssayId
5703	19 Aug 11	nicklas	3034	WHERE [hybridization_id] = :hybId
5703	19 Aug 11	nicklas	3035	</sql>
5703	19 Aug 11	nicklas	3036	<description>
5703	19 Aug 11	nicklas	3037	An SQL query that sets the physicalbioassay_id
5703	19 Aug 11	nicklas	3038	for a given hybridization_id
5703	19 Aug 11	nicklas	3039	</description>
5703	19 Aug 11	nicklas	3040	</query>
5703	19 Aug 11	nicklas	3041
5703	19 Aug 11	nicklas	3042	<query id="GET_SCANS" type="SQL">
5703	19 Aug 11	nicklas	3043	<sql>
5703	19 Aug 11	nicklas	3044	SELECT
5703	19 Aug 11	nicklas	3045	[id], [version],
5703	19 Aug 11	nicklas	3046	[entry_date], [hybridization_id],
5703	19 Aug 11	nicklas	3047	[hardware_id], [protocol_id],
5703	19 Aug 11	nicklas	3048	[annotationset_id], [name],
5703	19 Aug 11	nicklas	3049	[description], [removed],
5703	19 Aug 11	nicklas	3050	[itemkey_id], [projectkey_id],
5703	19 Aug 11	nicklas	3051	[owner]
5703	19 Aug 11	nicklas	3052	FROM
5703	19 Aug 11	nicklas	3053	[Scans]
5703	19 Aug 11	nicklas	3054	</sql>
5703	19 Aug 11	nicklas	3055	<description>
5703	19 Aug 11	nicklas	3056	An SQL query that load all BASE 2.17 scans.
5703	19 Aug 11	nicklas	3057	</description>
5703	19 Aug 11	nicklas	3058	</query>
5703	19 Aug 11	nicklas	3059
5730	12 Sep 11	nicklas	3060	<query id="GET_IMAGES" type="SQL">
5730	12 Sep 11	nicklas	3061	<sql>
5730	12 Sep 11	nicklas	3062	SELECT
5730	12 Sep 11	nicklas	3063	[id], [version],
5730	12 Sep 11	nicklas	3064	[file_id]
5730	12 Sep 11	nicklas	3065	FROM
5730	12 Sep 11	nicklas	3066	[Images]
5730	12 Sep 11	nicklas	3067	WHERE [scan_id] = :scanId
5730	12 Sep 11	nicklas	3068	</sql>
5730	12 Sep 11	nicklas	3069	<description>
5730	12 Sep 11	nicklas	3070	An SQL query that load BASE 2.17 image files for a given scan.
5730	12 Sep 11	nicklas	3071	</description>
5730	12 Sep 11	nicklas	3072	</query>
5730	12 Sep 11	nicklas	3073
5730	12 Sep 11	nicklas	3074	<query id="GET_PROTOCOLTYPES" type="SQL">
5730	12 Sep 11	nicklas	3075	<sql>
5730	12 Sep 11	nicklas	3076	SELECT
5730	12 Sep 11	nicklas	3077	[id], [version],
5730	12 Sep 11	nicklas	3078	[entry_date], [name],
5730	12 Sep 11	nicklas	3079	[description], [removed],
5730	12 Sep 11	nicklas	3080	[system_id]
5730	12 Sep 11	nicklas	3081	FROM
5730	12 Sep 11	nicklas	3082	[ProtocolTypes]
5730	12 Sep 11	nicklas	3083	</sql>
5730	12 Sep 11	nicklas	3084	<description>
5730	12 Sep 11	nicklas	3085	An SQL query that load all BASE 2.17 protocol types.
5730	12 Sep 11	nicklas	3086	</description>
5730	12 Sep 11	nicklas	3087	</query>
5730	12 Sep 11	nicklas	3088
5730	12 Sep 11	nicklas	3089	<query id="GET_HARDWARETYPES" type="SQL">
5730	12 Sep 11	nicklas	3090	<sql>
5730	12 Sep 11	nicklas	3091	SELECT
5730	12 Sep 11	nicklas	3092	[id], [version],
5730	12 Sep 11	nicklas	3093	[entry_date], [name],
5730	12 Sep 11	nicklas	3094	[description], [removed],
5730	12 Sep 11	nicklas	3095	[system_id]
5730	12 Sep 11	nicklas	3096	FROM
5730	12 Sep 11	nicklas	3097	[HardwareTypes]
5730	12 Sep 11	nicklas	3098	</sql>
5730	12 Sep 11	nicklas	3099	<description>
5730	12 Sep 11	nicklas	3100	An SQL query that load all BASE 2.17 hardware types.
5730	12 Sep 11	nicklas	3101	</description>
5730	12 Sep 11	nicklas	3102	</query>
5730	12 Sep 11	nicklas	3103
5730	12 Sep 11	nicklas	3104	<query id="GET_SOFTWARETYPES" type="SQL">
5730	12 Sep 11	nicklas	3105	<sql>
5730	12 Sep 11	nicklas	3106	SELECT
5730	12 Sep 11	nicklas	3107	[id], [version],
5730	12 Sep 11	nicklas	3108	[entry_date], [name],
5730	12 Sep 11	nicklas	3109	[description], [system_id]
5730	12 Sep 11	nicklas	3110	FROM
5730	12 Sep 11	nicklas	3111	[SoftwareTypes]
5730	12 Sep 11	nicklas	3112	</sql>
5730	12 Sep 11	nicklas	3113	<description>
5730	12 Sep 11	nicklas	3114	An SQL query that load all BASE 2.17 software types.
5730	12 Sep 11	nicklas	3115	</description>
5730	12 Sep 11	nicklas	3116	</query>
5730	12 Sep 11	nicklas	3117
5730	12 Sep 11	nicklas	3118	<query id="GET_FILETYPES" type="SQL">
5730	12 Sep 11	nicklas	3119	<sql>
5730	12 Sep 11	nicklas	3120	SELECT
5730	12 Sep 11	nicklas	3121	[id], [version],
5730	12 Sep 11	nicklas	3122	[entry_date], [name],
5730	12 Sep 11	nicklas	3123	[description], [system_id]
5730	12 Sep 11	nicklas	3124	FROM
5730	12 Sep 11	nicklas	3125	[FileTypes]
5730	12 Sep 11	nicklas	3126	</sql>
5730	12 Sep 11	nicklas	3127	<description>
5730	12 Sep 11	nicklas	3128	An SQL query that load all BASE 2.17 file types.
5730	12 Sep 11	nicklas	3129	</description>
5730	12 Sep 11	nicklas	3130	</query>
5730	12 Sep 11	nicklas	3131
5733	12 Sep 11	nicklas	3132	<query id="GET_RAWBIOASSAYS" type="SQL">
5733	12 Sep 11	nicklas	3133	<sql>
5733	12 Sep 11	nicklas	3134	SELECT
5733	12 Sep 11	nicklas	3135	[id], [scan_id],
5733	12 Sep 11	nicklas	3136	[array_num]
5733	12 Sep 11	nicklas	3137	FROM [RawBioAssays]
5733	12 Sep 11	nicklas	3138	WHERE NOT [scan_id] IS NULL
5733	12 Sep 11	nicklas	3139	</sql>
5733	12 Sep 11	nicklas	3140	<description>
5733	12 Sep 11	nicklas	3141	An SQL query that load scan and array num for all raw bioassays
5733	12 Sep 11	nicklas	3142	that has a scan parent.
5733	12 Sep 11	nicklas	3143	</description>
5733	12 Sep 11	nicklas	3144	</query>
5730	12 Sep 11	nicklas	3145
5733	12 Sep 11	nicklas	3146	<query id="FIND_EXTRACT_FOR_RAWBIOASSAY_POSITION" type="SQL">
5733	12 Sep 11	nicklas	3147	<sql>
6124	13 Sep 12	nicklas	3148	SELECT bm2.[biomaterial_id]
5733	12 Sep 11	nicklas	3149	FROM [DerivedBioAssays] dba
6124	13 Sep 12	nicklas	3150	INNER JOIN [ParentPhysicalBioAssays] pba ON pba.[derivedbioassay_id] = dba.[id]
6124	13 Sep 12	nicklas	3151	INNER JOIN [BioMaterialEvents] bme ON bme.[physicalbioassay_id] = pba.[physicalbioassay_id]
5733	12 Sep 11	nicklas	3152	INNER JOIN [BioMaterialEventSources2] bm2 ON bm2.[event_id]=bme.[id]
5733	12 Sep 11	nicklas	3153	WHERE bm2.[position] = :position AND dba.[id] = :derivedBioAssayId
5733	12 Sep 11	nicklas	3154	</sql>
5733	12 Sep 11	nicklas	3155	<description>
5733	12 Sep 11	nicklas	3156	An SQL query that tries to find the extract id given a
5733	12 Sep 11	nicklas	3157	derived bioassay and the bioassay position.
5733	12 Sep 11	nicklas	3158	</description>
5733	12 Sep 11	nicklas	3159	</query>
5733	12 Sep 11	nicklas	3160
5733	12 Sep 11	nicklas	3161	<query id="UPDATE_RAWBIOASSAY" type="SQL">
5733	12 Sep 11	nicklas	3162	<sql>
5733	12 Sep 11	nicklas	3163	UPDATE [RawBioAssays]
5733	12 Sep 11	nicklas	3164	SET [bioassay_id] = :parentBioAssayId,
5733	12 Sep 11	nicklas	3165	[extract_id] = :extractId
5733	12 Sep 11	nicklas	3166	WHERE [id] = :rawBioAssayId
5733	12 Sep 11	nicklas	3167	</sql>
5733	12 Sep 11	nicklas	3168	<description>
5733	12 Sep 11	nicklas	3169	An SQL query that update the parent bioassay and extract
5733	12 Sep 11	nicklas	3170	for a given raw bioassay.
5733	12 Sep 11	nicklas	3171	</description>
5733	12 Sep 11	nicklas	3172	</query>
5733	12 Sep 11	nicklas	3173
5733	12 Sep 11	nicklas	3174
5703	19 Aug 11	nicklas	3175	<query id="COPY_BIOMATERIALEVENTSOURCES" type="SQL">
5703	19 Aug 11	nicklas	3176	<sql>
5703	19 Aug 11	nicklas	3177	INSERT INTO [BioMaterialEventSources2]
5703	19 Aug 11	nicklas	3178	(
5756	22 Sep 11	nicklas	3179	[id], [version],
5703	19 Aug 11	nicklas	3180	[biomaterial_id], [event_id],
5703	19 Aug 11	nicklas	3181	[used_quantity], [position]
5703	19 Aug 11	nicklas	3182	)
5703	19 Aug 11	nicklas	3183	SELECT
5756	22 Sep 11	nicklas	3184	{1}, 0,
5703	19 Aug 11	nicklas	3185	[biomaterial_id], [event_id],
5703	19 Aug 11	nicklas	3186	[used_quantity], [dummy]
5703	19 Aug 11	nicklas	3187	FROM [BioMaterialEventSources]
5703	19 Aug 11	nicklas	3188	</sql>
5703	19 Aug 11	nicklas	3189	<description>
5730	12 Sep 11	nicklas	3190	An SQL query that load copy BASE 2.17 biomaterial
5730	12 Sep 11	nicklas	3191	event sources to the new table.
5703	19 Aug 11	nicklas	3192	</description>
5703	19 Aug 11	nicklas	3193	</query>
5703	19 Aug 11	nicklas	3194
5730	12 Sep 11	nicklas	3195	<query id="COPY_SAMPLE_BIOSOURCE_PARENT_LINK" type="SQL">
5703	19 Aug 11	nicklas	3196	<sql>
5730	12 Sep 11	nicklas	3197	INSERT INTO [BioMaterialEventSources2]
5730	12 Sep 11	nicklas	3198	(
5756	22 Sep 11	nicklas	3199	[id], [version],
5730	12 Sep 11	nicklas	3200	[biomaterial_id], [event_id],
5730	12 Sep 11	nicklas	3201	[used_quantity], [position]
5730	12 Sep 11	nicklas	3202	)
5730	12 Sep 11	nicklas	3203	SELECT
5756	22 Sep 11	nicklas	3204	{1}, 0,
5730	12 Sep 11	nicklas	3205	bm.[parent_id], evt.[id],
5730	12 Sep 11	nicklas	3206	null, 1
5730	12 Sep 11	nicklas	3207	FROM [BioMaterials] bm
5730	12 Sep 11	nicklas	3208	INNER JOIN [BioMaterialEvents] evt ON bm.[id]=evt.[biomaterial_id] AND evt.[event_type]=1
5730	12 Sep 11	nicklas	3209	WHERE bm.[discriminator] = 2 AND NOT bm.[parent_id] IS NULL
5703	19 Aug 11	nicklas	3210	</sql>
5703	19 Aug 11	nicklas	3211	<description>
5730	12 Sep 11	nicklas	3212	An SQL query that copy Sample--BioSource parent
5730	12 Sep 11	nicklas	3213	links to the BioMaterialEventSources2 table.
5703	19 Aug 11	nicklas	3214	</description>
5703	19 Aug 11	nicklas	3215	</query>
5703	19 Aug 11	nicklas	3216
5730	12 Sep 11	nicklas	3217	<query id="NULLIFY_ALL_BIOMATERIAL_PARENTS" type="SQL">
5730	12 Sep 11	nicklas	3218	<sql>
5730	12 Sep 11	nicklas	3219	UPDATE [BioMaterials]
5730	12 Sep 11	nicklas	3220	SET [parent_type] = NULL, [parent_id] = NULL
5730	12 Sep 11	nicklas	3221	</sql>
5730	12 Sep 11	nicklas	3222	<description>
5730	12 Sep 11	nicklas	3223	An SQL query that nullify all biomaterial parent
5730	12 Sep 11	nicklas	3224	information.
5730	12 Sep 11	nicklas	3225	</description>
5730	12 Sep 11	nicklas	3226	</query>
5730	12 Sep 11	nicklas	3227
5730	12 Sep 11	nicklas	3228	<query id="GET_BIOMATERIAL_PARENT_INFO" type="SQL">
5730	12 Sep 11	nicklas	3229	<sql>
5730	12 Sep 11	nicklas	3230	SELECT bm.[id], bm.[discriminator], evt.[biomaterial_id]
5730	12 Sep 11	nicklas	3231	FROM [BioMaterialEventSources2] bm2
5730	12 Sep 11	nicklas	3232	INNER JOIN [BioMaterialEvents] evt ON bm2.[event_id]=evt.[id] AND evt.[event_type]=1
5730	12 Sep 11	nicklas	3233	INNER JOIN [BioMaterials] bm ON bm2.[biomaterial_id]=bm.[id]
5730	12 Sep 11	nicklas	3234	ORDER BY evt.[biomaterial_id]
5730	12 Sep 11	nicklas	3235	</sql>
5730	12 Sep 11	nicklas	3236	<description>
5730	12 Sep 11	nicklas	3237	An SQL query that get parent biomaterial information. We need
5730	12 Sep 11	nicklas	3238	parent_id, parent_type and child_id ordered by child_id
5730	12 Sep 11	nicklas	3239	</description>
5730	12 Sep 11	nicklas	3240	</query>
5730	12 Sep 11	nicklas	3241
5730	12 Sep 11	nicklas	3242
5730	12 Sep 11	nicklas	3243	<query id="SET_BIOMATERIAL_PARENT" type="SQL">
5730	12 Sep 11	nicklas	3244	<sql>
5730	12 Sep 11	nicklas	3245	UPDATE [BioMaterials]
5730	12 Sep 11	nicklas	3246	SET [parent_type] = :parentType, [parent_id] = :parentId
5730	12 Sep 11	nicklas	3247	WHERE [id] = :childId
5730	12 Sep 11	nicklas	3248	</sql>
5730	12 Sep 11	nicklas	3249	<description>
5730	12 Sep 11	nicklas	3250	An SQL query that set the biomaterial parent info for a single
5730	12 Sep 11	nicklas	3251	biomaterial.
5730	12 Sep 11	nicklas	3252	</description>
5730	12 Sep 11	nicklas	3253	</query>
5730	12 Sep 11	nicklas	3254
5703	19 Aug 11	nicklas	3255	<query id="SET_LABELEDEXTRACT_SUBTYPE" type="SQL">
5703	19 Aug 11	nicklas	3256	<sql>
5703	19 Aug 11	nicklas	3257	UPDATE [BioMaterials]
5703	19 Aug 11	nicklas	3258	SET [subtype_id]=:subtype
5703	19 Aug 11	nicklas	3259	WHERE [label_id] IS NOT NULL
5703	19 Aug 11	nicklas	3260	</sql>
5703	19 Aug 11	nicklas	3261	<description>
5703	19 Aug 11	nicklas	3262	An SQL query that sets the subtype of labeled extracts
5703	19 Aug 11	nicklas	3263	</description>
5703	19 Aug 11	nicklas	3264	</query>
5703	19 Aug 11	nicklas	3265
5703	19 Aug 11	nicklas	3266	<query id="SET_SUBTYPE_ON_ALL" type="SQL">
5703	19 Aug 11	nicklas	3267	<sql>
5703	19 Aug 11	nicklas	3268	UPDATE [{1}]
5703	19 Aug 11	nicklas	3269	SET [subtype_id]=:subtype
5703	19 Aug 11	nicklas	3270	</sql>
5703	19 Aug 11	nicklas	3271	<description>
5703	19 Aug 11	nicklas	3272	An SQL query that sets the subtype
5703	19 Aug 11	nicklas	3273	of all items in a table
5703	19 Aug 11	nicklas	3274	</description>
5703	19 Aug 11	nicklas	3275	</query>
5703	19 Aug 11	nicklas	3276
5703	19 Aug 11	nicklas	3277	<query id="UPDATE_ANNOTATIONSET_ITEM" type="SQL">
5703	19 Aug 11	nicklas	3278	<sql>
5703	19 Aug 11	nicklas	3279	UPDATE [AnnotationSets]
5753	22 Sep 11	nicklas	3280	SET [item_id] = :newId, [item_type] = {1}
5753	22 Sep 11	nicklas	3281	WHERE [id] = :id
5703	19 Aug 11	nicklas	3282	</sql>
5703	19 Aug 11	nicklas	3283	<description>
5703	19 Aug 11	nicklas	3284	An SQL query that update the item_type and item_id
5703	19 Aug 11	nicklas	3285	on annotation set.
5703	19 Aug 11	nicklas	3286	</description>
5703	19 Aug 11	nicklas	3287	</query>
5703	19 Aug 11	nicklas	3288
5703	19 Aug 11	nicklas	3289	<query id="UPDATE_ANYTOANY_FROMITEM" type="SQL">
5703	19 Aug 11	nicklas	3290	<sql>
5703	19 Aug 11	nicklas	3291	UPDATE [AnyToAny]
5703	19 Aug 11	nicklas	3292	SET [from_id] = :newId, [from_type] = {2}
5703	19 Aug 11	nicklas	3293	WHERE [from_id] = :oldId AND [from_type] = {1}
5703	19 Aug 11	nicklas	3294	</sql>
5703	19 Aug 11	nicklas	3295	<description>
5703	19 Aug 11	nicklas	3296	An SQL query that update the from_type and from_id
5703	19 Aug 11	nicklas	3297	on any-to-any.
5703	19 Aug 11	nicklas	3298	</description>
5703	19 Aug 11	nicklas	3299	</query>
5703	19 Aug 11	nicklas	3300
5703	19 Aug 11	nicklas	3301	<query id="UPDATE_ANYTOANY_TOITEM" type="SQL">
5703	19 Aug 11	nicklas	3302	<sql>
5703	19 Aug 11	nicklas	3303	UPDATE [AnyToAny]
5703	19 Aug 11	nicklas	3304	SET [to_id] = :newId, [to_type] = {2}
5703	19 Aug 11	nicklas	3305	WHERE [to_id] = :oldId AND [to_type] = {1}
5703	19 Aug 11	nicklas	3306	</sql>
5703	19 Aug 11	nicklas	3307	<description>
5703	19 Aug 11	nicklas	3308	An SQL query that update the to_type and to_id
5703	19 Aug 11	nicklas	3309	on any-to-any.
5703	19 Aug 11	nicklas	3310	</description>
5703	19 Aug 11	nicklas	3311	</query>
5703	19 Aug 11	nicklas	3312
5703	19 Aug 11	nicklas	3313	<query id="UPDATE_CHANGEHISTORYDETAILS_ITEM" type="SQL">
5703	19 Aug 11	nicklas	3314	<sql>
5703	19 Aug 11	nicklas	3315	UPDATE [ChangeHistoryDetails]
5703	19 Aug 11	nicklas	3316	SET [item_id] = :newId, [item_type] = {2}
5703	19 Aug 11	nicklas	3317	WHERE [item_id] = :oldId AND [item_type] = {1}
5703	19 Aug 11	nicklas	3318	</sql>
5703	19 Aug 11	nicklas	3319	<description>
5703	19 Aug 11	nicklas	3320	An SQL query that update the item_type and item_id
5703	19 Aug 11	nicklas	3321	on change history details.
5703	19 Aug 11	nicklas	3322	</description>
5703	19 Aug 11	nicklas	3323	</query>
5703	19 Aug 11	nicklas	3324
5703	19 Aug 11	nicklas	3325	<query id="UPDATE_ITEMVALUES_ITEM" type="SQL">
5703	19 Aug 11	nicklas	3326	<sql>
5703	19 Aug 11	nicklas	3327	UPDATE [ItemValues]
5703	19 Aug 11	nicklas	3328	SET [data_class_id] = :newId, [data_class] = :newClass
5703	19 Aug 11	nicklas	3329	WHERE [data_class_id] = :oldId AND [data_class] = :oldClass
5703	19 Aug 11	nicklas	3330	</sql>
5703	19 Aug 11	nicklas	3331	<description>
5703	19 Aug 11	nicklas	3332	An SQL query that update the data_class_id and data_class
5703	19 Aug 11	nicklas	3333	on item values.
5703	19 Aug 11	nicklas	3334	</description>
5703	19 Aug 11	nicklas	3335	</query>
5703	19 Aug 11	nicklas	3336
5703	19 Aug 11	nicklas	3337	<query id="UPDATE_ITEMVALUES_CLASS" type="SQL">
5703	19 Aug 11	nicklas	3338	<sql>
5703	19 Aug 11	nicklas	3339	UPDATE [ItemValues]
5703	19 Aug 11	nicklas	3340	SET [data_class] = :newClass
5703	19 Aug 11	nicklas	3341	WHERE [data_class] = :oldClass
5703	19 Aug 11	nicklas	3342	</sql>
5703	19 Aug 11	nicklas	3343	<description>
5703	19 Aug 11	nicklas	3344	An SQL query that update the data_class
5703	19 Aug 11	nicklas	3345	on item values.
5703	19 Aug 11	nicklas	3346	</description>
5703	19 Aug 11	nicklas	3347	</query>
5703	19 Aug 11	nicklas	3348
5703	19 Aug 11	nicklas	3349	<query id="UPDATE_ITEMTYPE" type="SQL">
5703	19 Aug 11	nicklas	3350	<sql>
5703	19 Aug 11	nicklas	3351	UPDATE [{1}]
5703	19 Aug 11	nicklas	3352	SET [{2}] = {4}
5703	19 Aug 11	nicklas	3353	WHERE [{2}] = {3}
5703	19 Aug 11	nicklas	3354	</sql>
5703	19 Aug 11	nicklas	3355	<description>
5703	19 Aug 11	nicklas	3356	An SQL query that update the item-type column on
5703	19 Aug 11	nicklas	3357	a generic table.
5703	19 Aug 11	nicklas	3358	</description>
5703	19 Aug 11	nicklas	3359	</query>
5703	19 Aug 11	nicklas	3360
5730	12 Sep 11	nicklas	3361	<query id="UPDATE_SUBTYPEID_FROM_OLDTYPEID" type="SQL">
5730	12 Sep 11	nicklas	3362	<sql>
5730	12 Sep 11	nicklas	3363	UPDATE [{1}]
5730	12 Sep 11	nicklas	3364	SET [{2}] = :subtypeId
5730	12 Sep 11	nicklas	3365	WHERE [{3}] = :oldTypeId
5730	12 Sep 11	nicklas	3366	</sql>
5730	12 Sep 11	nicklas	3367	<description>
5730	12 Sep 11	nicklas	3368	An SQL query that update the subtype_id column on
5730	12 Sep 11	nicklas	3369	a generic table.
5730	12 Sep 11	nicklas	3370	</description>
5730	12 Sep 11	nicklas	3371	</query>
5730	12 Sep 11	nicklas	3372
5730	12 Sep 11	nicklas	3373
5734	13 Sep 11	nicklas	3374	<query id="DELETE_PLUGINGUICONTEXTS_FOR_ITEMTYPE" type="SQL">
5703	19 Aug 11	nicklas	3375	<sql>
5734	13 Sep 11	nicklas	3376	DELETE FROM [PluginDefinitionGuiContexts]
5734	13 Sep 11	nicklas	3377	WHERE [item_type] = :itemType
5703	19 Aug 11	nicklas	3378	</sql>
5703	19 Aug 11	nicklas	3379	<description>
5703	19 Aug 11	nicklas	3380	An SQL query that delete plug-in gui contexts for
5703	19 Aug 11	nicklas	3381	a given item type.
5703	19 Aug 11	nicklas	3382	</description>
5703	19 Aug 11	nicklas	3383	</query>
5703	19 Aug 11	nicklas	3384
5734	13 Sep 11	nicklas	3385	<query id="DELETE_PLUGINKEYS_FOR_ITEMTYPE" type="SQL">
5734	13 Sep 11	nicklas	3386	<sql>
5734	13 Sep 11	nicklas	3387	DELETE FROM [PluginKeys]
5734	13 Sep 11	nicklas	3388	WHERE [key_id] IN (
5734	13 Sep 11	nicklas	3389	SELECT k.[id]
5734	13 Sep 11	nicklas	3390	FROM [Keys] k
5734	13 Sep 11	nicklas	3391	WHERE k.[item_type] = :itemType
5734	13 Sep 11	nicklas	3392	)
5734	13 Sep 11	nicklas	3393	</sql>
5734	13 Sep 11	nicklas	3394	<description>
5734	13 Sep 11	nicklas	3395	An SQL query that delete plug-in keys referencing keys
5734	13 Sep 11	nicklas	3396	for a given item type.
5734	13 Sep 11	nicklas	3397	</description>
5734	13 Sep 11	nicklas	3398	</query>
5734	13 Sep 11	nicklas	3399
5734	13 Sep 11	nicklas	3400
5630	13 May 11	nicklas	3401	<query id="GET_SUBTYPABLE_ITEMS_FOR_SUBTYPE_OF_CLASS" type="HQL">
5630	13 May 11	nicklas	3402	<sql>
5630	13 May 11	nicklas	3403	SELECT {1}
5630	13 May 11	nicklas	3404	FROM {2} sub
5630	13 May 11	nicklas	3405	WHERE sub.itemSubtype = :subtype
5630	13 May 11	nicklas	3406	</sql>
5630	13 May 11	nicklas	3407	<description>
5630	13 May 11	nicklas	3408	Get all items that are subtyped with a subtype for a given class.
5630	13 May 11	nicklas	3409	</description>
5630	13 May 11	nicklas	3410	</query>
5621	03 May 11	nicklas	3411
6752	20 Feb 15	nicklas	3412	<query id="GET_ITEMLISTS_FOR_SUBTYPE" type="HQL">
6752	20 Feb 15	nicklas	3413	<sql>
6752	20 Feb 15	nicklas	3414	SELECT {1}
6752	20 Feb 15	nicklas	3415	FROM ItemListData il
6752	20 Feb 15	nicklas	3416	WHERE il.itemSubtype = :subtype
6752	20 Feb 15	nicklas	3417	</sql>
6752	20 Feb 15	nicklas	3418	<description>
6752	20 Feb 15	nicklas	3419	A Hibernate query that gets ITEMLISTS for a given item subtype.
6752	20 Feb 15	nicklas	3420	</description>
6752	20 Feb 15	nicklas	3421	</query>
6752	20 Feb 15	nicklas	3422
5630	13 May 11	nicklas	3423	<query id="GET_MIMETYPES_FOR_FILETYPE" type="HQL">
5630	13 May 11	nicklas	3424	<sql>
5630	13 May 11	nicklas	3425	SELECT {1}
5630	13 May 11	nicklas	3426	FROM MimeTypeData mt
5630	13 May 11	nicklas	3427	WHERE mt.fileType = :subtype
5630	13 May 11	nicklas	3428	</sql>
5630	13 May 11	nicklas	3429	<description>
5630	13 May 11	nicklas	3430	A Hibernate query that gets MIME types for a given item subtype.
5630	13 May 11	nicklas	3431	</description>
5630	13 May 11	nicklas	3432	</query>
5630	13 May 11	nicklas	3433
5630	13 May 11	nicklas	3434	<query id="GET_DATAFILETYPES_FOR_FILETYPE" type="HQL">
5630	13 May 11	nicklas	3435	<sql>
5630	13 May 11	nicklas	3436	SELECT {1}
5630	13 May 11	nicklas	3437	FROM DataFileTypeData dft
5630	13 May 11	nicklas	3438	WHERE dft.genericType = :subtype
5630	13 May 11	nicklas	3439	</sql>
5630	13 May 11	nicklas	3440	<description>
5630	13 May 11	nicklas	3441	A Hibernate query that gets Data file types for a given item subtype.
5630	13 May 11	nicklas	3442	</description>
5630	13 May 11	nicklas	3443	</query>
5630	13 May 11	nicklas	3444
5730	12 Sep 11	nicklas	3445	<query id="UPDATE_FILESETMEMBER_FILETYPE" type="HQL">
5730	12 Sep 11	nicklas	3446	<sql>
5730	12 Sep 11	nicklas	3447	UPDATE FileSetMemberData mbr
5730	12 Sep 11	nicklas	3448	SET mbr.dataFileType = :newType
5730	12 Sep 11	nicklas	3449	WHERE mbr.dataFileType = :oldType
5730	12 Sep 11	nicklas	3450	</sql>
5730	12 Sep 11	nicklas	3451	<description>
5730	12 Sep 11	nicklas	3452	A Hibernate query that update the data file type of all
5730	12 Sep 11	nicklas	3453	file set members with a given old data file type.
5730	12 Sep 11	nicklas	3454	</description>
5730	12 Sep 11	nicklas	3455	</query>
5730	12 Sep 11	nicklas	3456
5736	14 Sep 11	nicklas	3457	<query id="DISABLE_ALL_PLUGINS" type="HQL">
5736	14 Sep 11	nicklas	3458	<sql>
5736	14 Sep 11	nicklas	3459	UPDATE PluginDefinitionData pl
5736	14 Sep 11	nicklas	3460	SET pl.disabled = true
5736	14 Sep 11	nicklas	3461	</sql>
5736	14 Sep 11	nicklas	3462	<description>
5736	14 Sep 11	nicklas	3463	A Hibernate query that disable all plug-ins.
5736	14 Sep 11	nicklas	3464	</description>
5736	14 Sep 11	nicklas	3465	</query>
5736	14 Sep 11	nicklas	3466
5803	12 Oct 11	nicklas	3467	<query id="GET_PROJECT_DEFAULT_ANYTOANY" type="HQL">
5803	12 Oct 11	nicklas	3468	<sql>
5803	12 Oct 11	nicklas	3469	SELECT a FROM AnyToAnyData a
5803	12 Oct 11	nicklas	3470	WHERE a.fromType = 24 AND a.name LIKE 'default_%'
5803	12 Oct 11	nicklas	3471	</sql>
5803	12 Oct 11	nicklas	3472	<description>
5803	12 Oct 11	nicklas	3473	A Hibernate query that load all any-to-any links containing
5803	12 Oct 11	nicklas	3474	project default items.
5803	12 Oct 11	nicklas	3475	</description>
5803	12 Oct 11	nicklas	3476	</query>
5736	14 Sep 11	nicklas	3477
5828	26 Oct 11	nicklas	3478	<query id="GET_MD5_PASSWORDS" type="SQL">
5828	26 Oct 11	nicklas	3479	<sql>
5828	26 Oct 11	nicklas	3480	SELECT [id], [md5password] FROM [Passwords]
5828	26 Oct 11	nicklas	3481	</sql>
5828	26 Oct 11	nicklas	3482	<description>
5828	26 Oct 11	nicklas	3483	An SQL query that load all md5 passwords.
5828	26 Oct 11	nicklas	3484	</description>
5828	26 Oct 11	nicklas	3485	</query>
5828	26 Oct 11	nicklas	3486
5828	26 Oct 11	nicklas	3487	<query id="SET_ENCRYPTED_PASSWORD" type="SQL">
5828	26 Oct 11	nicklas	3488	<sql>
5828	26 Oct 11	nicklas	3489	UPDATE [Passwords]
5828	26 Oct 11	nicklas	3490	SET [crypted_password] = :cryptedPassword
5828	26 Oct 11	nicklas	3491	WHERE [id] = :id
5828	26 Oct 11	nicklas	3492	</sql>
5828	26 Oct 11	nicklas	3493	<description>
5828	26 Oct 11	nicklas	3494	An SQL query that set the encrypted password for a given entry.
5828	26 Oct 11	nicklas	3495	</description>
5828	26 Oct 11	nicklas	3496	</query>
5876	15 Nov 11	nicklas	3497
5876	15 Nov 11	nicklas	3498	<query id="GET_VIRTUALDBS_FOR_REPORTERCLONETEMPLATE" type="HQL">
5876	15 Nov 11	nicklas	3499	<sql>
5876	15 Nov 11	nicklas	3500	SELECT {1}
5876	15 Nov 11	nicklas	3501	FROM VirtualDbData vdb
5876	15 Nov 11	nicklas	3502	WHERE vdb.reporterCloneTemplate = :reporterCloneTemplate
5876	15 Nov 11	nicklas	3503	</sql>
5876	15 Nov 11	nicklas	3504	<description>
5876	15 Nov 11	nicklas	3505	A Hibernate query that get virtual databases
5876	15 Nov 11	nicklas	3506	that are using a given reporter clone template.
5876	15 Nov 11	nicklas	3507	</description>
5876	15 Nov 11	nicklas	3508	</query>
5828	26 Oct 11	nicklas	3509
6037	29 Mar 12	nicklas	3510	<query id="GET_ALL_ANNOTATIONTYPE_IDS_FOR_USER" type="SQL">
6037	29 Mar 12	nicklas	3511	<sql>
6037	29 Mar 12	nicklas	3512	SELECT [at].[id]
6037	29 Mar 12	nicklas	3513	FROM [AnnotationTypes] [at]
6037	29 Mar 12	nicklas	3514	WHERE [at].[owner] = :owner
6037	29 Mar 12	nicklas	3515	OR [at].[itemkey_id] IN (:itemKeys)
6037	29 Mar 12	nicklas	3516	OR [at].[projectkey_id] IN (:projectKeys)
6037	29 Mar 12	nicklas	3517	</sql>
6037	29 Mar 12	nicklas	3518	<description>
6037	29 Mar 12	nicklas	3519	An SQL query that load the ID of all the annotation types
6037	29 Mar 12	nicklas	3520	that the current user has access to. We need to set owner,
6037	29 Mar 12	nicklas	3521	item keys and project keys as parameters.
6037	29 Mar 12	nicklas	3522	</description>
6037	29 Mar 12	nicklas	3523	</query>
6084	16 Aug 12	nicklas	3524
6084	16 Aug 12	nicklas	3525	<query id="COPY_PARENT_PHYSICAL_BIOASSAYS" type="SQL">
6084	16 Aug 12	nicklas	3526	<sql>
6084	16 Aug 12	nicklas	3527	INSERT INTO [ParentPhysicalBioAssays] ([physicalbioassay_id], [derivedbioassay_id])
6084	16 Aug 12	nicklas	3528	SELECT [bioassay_id], [id] FROM [DerivedBioAssays]
6084	16 Aug 12	nicklas	3529	</sql>
6084	16 Aug 12	nicklas	3530	<description>
6084	16 Aug 12	nicklas	3531	An SQL query that copy the parent physical bioassays
6084	16 Aug 12	nicklas	3532	to the new (in BASE 3.2) ParentPhysicalBioAssays table
6084	16 Aug 12	nicklas	3533	</description>
6084	16 Aug 12	nicklas	3534	</query>
6084	16 Aug 12	nicklas	3535
6084	16 Aug 12	nicklas	3536
6084	16 Aug 12	nicklas	3537	<query id="COPY_PARENT_DERIVED_BIOASSAYS" type="SQL">
6084	16 Aug 12	nicklas	3538	<sql>
6084	16 Aug 12	nicklas	3539	INSERT INTO [ParentDerivedBioAssays] ([parentbioassay_id], [derivedbioassay_id])
6084	16 Aug 12	nicklas	3540	SELECT [parent_id], [id] FROM [DerivedBioAssays] WHERE NOT [parent_id] IS NULL
6084	16 Aug 12	nicklas	3541	</sql>
6084	16 Aug 12	nicklas	3542	<description>
6084	16 Aug 12	nicklas	3543	An SQL query that copy the parent derived bioassays
6084	16 Aug 12	nicklas	3544	to the new (in BASE 3.2) ParentDerivedBioAssays table
6084	16 Aug 12	nicklas	3545	</description>
6084	16 Aug 12	nicklas	3546	</query>
6084	16 Aug 12	nicklas	3547
6084	16 Aug 12	nicklas	3548	<query id="SET_ISROOT_ON_DERIVED_BIOASSAYS" type="SQL">
6084	16 Aug 12	nicklas	3549	<sql>
6084	16 Aug 12	nicklas	3550	UPDATE [DerivedBioAssays] SET [is_root] = ([parent_id] IS NULL)
6084	16 Aug 12	nicklas	3551	</sql>
6084	16 Aug 12	nicklas	3552	<description>
6084	16 Aug 12	nicklas	3553	An SQL query that set the is_root property on DerivedBioAssays table.
6084	16 Aug 12	nicklas	3554	</description>
6084	16 Aug 12	nicklas	3555	</query>
6214	13 Dec 12	nicklas	3556
6214	13 Dec 12	nicklas	3557	<query id="GET_ITEMSUBTYPE_WITH_NAME_AND_ITEMTYPE" type="HQL">
6214	13 Dec 12	nicklas	3558	<sql>
6214	13 Dec 12	nicklas	3559	SELECT st FROM ItemSubtypeData st
6214	13 Dec 12	nicklas	3560	WHERE st.name = :name AND st.itemType = :itemType
6214	13 Dec 12	nicklas	3561	</sql>
6214	13 Dec 12	nicklas	3562	<description>
6214	13 Dec 12	nicklas	3563	A Hibernate query that load an item subtype given the name
6214	13 Dec 12	nicklas	3564	and main item type.
6214	13 Dec 12	nicklas	3565	</description>
6214	13 Dec 12	nicklas	3566	</query>
6358	27 Nov 13	nicklas	3567
6358	27 Nov 13	nicklas	3568	<query id="SET_DISABLE_LOG_FOR_ANNOTATION_TYPES" type="HQL">
6358	27 Nov 13	nicklas	3569	<sql>
6358	27 Nov 13	nicklas	3570	UPDATE AnnotationTypeData at
6358	27 Nov 13	nicklas	3571	SET at.disableLogOfValues = false
6358	27 Nov 13	nicklas	3572	WHERE at.disableLogOfValues IS NULL
6358	27 Nov 13	nicklas	3573	</sql>
6358	27 Nov 13	nicklas	3574	<description>
6358	27 Nov 13	nicklas	3575	An HQL query that set the disableLogOfValues=false for all annotation types
6358	27 Nov 13	nicklas	3576	with a null value.
6358	27 Nov 13	nicklas	3577	</description>
6358	27 Nov 13	nicklas	3578	</query>
6084	16 Aug 12	nicklas	3579
7121	19 Apr 16	nicklas	3580	<query id="AB_LOAD_ANNOTATION_INFO" type="SQL">
7121	19 Apr 16	nicklas	3581	<sql>
7259	09 Dec 16	nicklas	3582	SELECT [annotationtype_id], [id], [version], [unit_id], [value_id], [last_update], [project_id], [override_id]
7121	19 Apr 16	nicklas	3583	FROM [Annotations]
7298	21 Feb 17	nicklas	3584	WHERE [annotationset_id] = :annotationSet AND [source] = 0 AND ([project_id] = :defaultProject OR [project_id] = :activeProject)
7121	19 Apr 16	nicklas	3585	</sql>
7121	19 Apr 16	nicklas	3586	<description>
7121	19 Apr 16	nicklas	3587	SQL query for loading current (primary) annotations for
7259	09 Dec 16	nicklas	3588	a given item.
7121	19 Apr 16	nicklas	3589	Used by the AnnotationBatcher as a SQL query via Hibernate.
7121	19 Apr 16	nicklas	3590	</description>
7121	19 Apr 16	nicklas	3591	</query>
7121	19 Apr 16	nicklas	3592
7121	19 Apr 16	nicklas	3593	<query id="AB_LOAD_ANNOTATION_VALUES" type="SQL">
7121	19 Apr 16	nicklas	3594	<sql>
7121	19 Apr 16	nicklas	3595	SELECT [id], [value]
7121	19 Apr 16	nicklas	3596	FROM [{1}]
7121	19 Apr 16	nicklas	3597	WHERE [id] IN (:listOfIds)
7121	19 Apr 16	nicklas	3598	</sql>
7121	19 Apr 16	nicklas	3599	<description>
7121	19 Apr 16	nicklas	3600	SQL query for loading current annotation values
7121	19 Apr 16	nicklas	3601	for a given list of annotation value IDs.
7121	19 Apr 16	nicklas	3602	Used by the AnnotationBatcher as a SQL query via Hibernate.
7121	19 Apr 16	nicklas	3603	</description>
7121	19 Apr 16	nicklas	3604	</query>
7121	19 Apr 16	nicklas	3605
7121	19 Apr 16	nicklas	3606	<query id="AB_INSERT_INTO_PARAMETERVALUES" type="SQL">
7121	19 Apr 16	nicklas	3607	<sql>
7121	19 Apr 16	nicklas	3608	INSERT INTO [ParameterValues] ([id], [discriminator], [version])
7121	19 Apr 16	nicklas	3609	VALUES (nextval('hibernate_sequence'), ?, 0)
7121	19 Apr 16	nicklas	3610	</sql>
7121	19 Apr 16	nicklas	3611	<description>
7121	19 Apr 16	nicklas	3612	SQL query for inserting rows into the ParameterValues table.
7121	19 Apr 16	nicklas	3613	The primary key (id) must be auto-generated.
7121	19 Apr 16	nicklas	3614	Parameters: discriminator
7121	19 Apr 16	nicklas	3615	</description>
7121	19 Apr 16	nicklas	3616	</query>
7121	19 Apr 16	nicklas	3617
7121	19 Apr 16	nicklas	3618	<query id="AB_INSERT_INTO_ANNOTATIONS" type="SQL">
7121	19 Apr 16	nicklas	3619	<sql>
7259	09 Dec 16	nicklas	3620	INSERT INTO [Annotations] ([id], [version], [annotationset_id], [annotationtype_id], [unit_id], [value_id], [last_update], [source], [project_id], [override_id])
7259	09 Dec 16	nicklas	3621	VALUES (nextval('hibernate_sequence'), 0, ?, ?, ?, ?, ?, 0, ?, ?)
7121	19 Apr 16	nicklas	3622	</sql>
7121	19 Apr 16	nicklas	3623	<description>
7121	19 Apr 16	nicklas	3624	SQL query for inserting rows into the Annotations table.
7121	19 Apr 16	nicklas	3625	The primary key (id) must be auto-generated.
7259	09 Dec 16	nicklas	3626	Parameters: annotationset_id, annotationtype_id, unit_id, value_id, last_updated, project_id, override_id
7121	19 Apr 16	nicklas	3627	</description>
7121	19 Apr 16	nicklas	3628	</query>
7121	19 Apr 16	nicklas	3629
7121	19 Apr 16	nicklas	3630	<query id="AB_UPDATE_ANNOTATIONS" type="SQL">
7121	19 Apr 16	nicklas	3631	<sql>
7121	19 Apr 16	nicklas	3632	UPDATE [Annotations]
7121	19 Apr 16	nicklas	3633	SET [version] = ?, [unit_id] = ?, [last_update] = ?
7121	19 Apr 16	nicklas	3634	WHERE [id] = ? AND [version] = ?
7121	19 Apr 16	nicklas	3635	</sql>
7121	19 Apr 16	nicklas	3636	<description>
7121	19 Apr 16	nicklas	3637	SQL query for updating rows into the Annotations table.
7121	19 Apr 16	nicklas	3638	Parameters: version (new), unit_id, last_updated, id, version (old)
7121	19 Apr 16	nicklas	3639	</description>
7121	19 Apr 16	nicklas	3640	</query>
7121	19 Apr 16	nicklas	3641
7121	19 Apr 16	nicklas	3642	<query id="AB_INSERT_INTO_ANNOTATIONSETS" type="SQL">
7121	19 Apr 16	nicklas	3643	<sql>
7121	19 Apr 16	nicklas	3644	INSERT INTO [AnnotationSets] ([id], [version], [item_type], [item_id])
7121	19 Apr 16	nicklas	3645	VALUES (nextval('hibernate_sequence'), 0, {1}, ?)
7121	19 Apr 16	nicklas	3646	</sql>
7121	19 Apr 16	nicklas	3647	<description>
7121	19 Apr 16	nicklas	3648	SQL query for inserting rows into the AnnotationSets table.
7121	19 Apr 16	nicklas	3649	The primary key (id) must be auto-generated.
7121	19 Apr 16	nicklas	3650	Parameters: item_id
7121	19 Apr 16	nicklas	3651	</description>
7121	19 Apr 16	nicklas	3652	</query>
5828	26 Oct 11	nicklas	3653
7121	19 Apr 16	nicklas	3654	<query id="AB_UPDATE_ITEMTABLE" type="SQL">
7121	19 Apr 16	nicklas	3655	<sql>
7121	19 Apr 16	nicklas	3656	UPDATE [{1}]
7121	19 Apr 16	nicklas	3657	SET [annotationset_id] = ?
7121	19 Apr 16	nicklas	3658	WHERE [id] = ?
7121	19 Apr 16	nicklas	3659	</sql>
7121	19 Apr 16	nicklas	3660	<description>
7121	19 Apr 16	nicklas	3661	SQL query for updating the annotationset_id column in any
7121	19 Apr 16	nicklas	3662	table it exists in.
7121	19 Apr 16	nicklas	3663	Parameters: annotationset_id, item_id
7121	19 Apr 16	nicklas	3664	</description>
7121	19 Apr 16	nicklas	3665	</query>
7121	19 Apr 16	nicklas	3666
7121	19 Apr 16	nicklas	3667	<query id="AB_NULLIFY_CLONED_ANNOTATIONS" type="SQL">
7121	19 Apr 16	nicklas	3668	<sql>
7121	19 Apr 16	nicklas	3669	UPDATE [Annotations]
7121	19 Apr 16	nicklas	3670	SET [inherited_id] = null
7121	19 Apr 16	nicklas	3671	WHERE [inherited_id] = ? and [source] = 2
7121	19 Apr 16	nicklas	3672	</sql>
7121	19 Apr 16	nicklas	3673	<description>
7121	19 Apr 16	nicklas	3674	SQL query for setting the 'inherited_id' column to null
7121	19 Apr 16	nicklas	3675	for cloned annotations that reference the annotation that
7121	19 Apr 16	nicklas	3676	is about to be deleted.
7121	19 Apr 16	nicklas	3677	Parameters: inherited_id
7121	19 Apr 16	nicklas	3678	</description>
7121	19 Apr 16	nicklas	3679	</query>
7121	19 Apr 16	nicklas	3680
7121	19 Apr 16	nicklas	3681	<query id="AB_DELETE_INHERITED_ANNOTATIONS" type="SQL">
7121	19 Apr 16	nicklas	3682	<sql>
7121	19 Apr 16	nicklas	3683	DELETE FROM [Annotations]
7121	19 Apr 16	nicklas	3684	WHERE [inherited_id] = ? and [source] = 1
7121	19 Apr 16	nicklas	3685	</sql>
7121	19 Apr 16	nicklas	3686	<description>
7121	19 Apr 16	nicklas	3687	SQL query for deleting inherited annotations that reference
7121	19 Apr 16	nicklas	3688	the annotation that is about to be deleted.
7121	19 Apr 16	nicklas	3689	Parameters: inherited_id
7121	19 Apr 16	nicklas	3690	</description>
7121	19 Apr 16	nicklas	3691	</query>
7121	19 Apr 16	nicklas	3692
7121	19 Apr 16	nicklas	3693	<query id="AB_DELETE_FROM_ANNOTATIONS" type="SQL">
7121	19 Apr 16	nicklas	3694	<sql>
7121	19 Apr 16	nicklas	3695	DELETE FROM [Annotations]
7121	19 Apr 16	nicklas	3696	WHERE [id] = ?
7121	19 Apr 16	nicklas	3697	</sql>
7121	19 Apr 16	nicklas	3698	<description>
7121	19 Apr 16	nicklas	3699	SQL query for deleting an annotation with a given id.
7121	19 Apr 16	nicklas	3700	Used by the AnnotationBatcher as a PreparedStatement.
7121	19 Apr 16	nicklas	3701	Parameters: id
7121	19 Apr 16	nicklas	3702	</description>
7121	19 Apr 16	nicklas	3703	</query>
7121	19 Apr 16	nicklas	3704
7121	19 Apr 16	nicklas	3705	<query id="AB_DELETE_FROM_PARAMETERVALUES" type="SQL">
7121	19 Apr 16	nicklas	3706	<sql>
7121	19 Apr 16	nicklas	3707	DELETE FROM [ParameterValues] WHERE [id] = ?
7121	19 Apr 16	nicklas	3708	</sql>
7121	19 Apr 16	nicklas	3709	<description>
7121	19 Apr 16	nicklas	3710	SQL query for deleting a parameter value with a given id.
7121	19 Apr 16	nicklas	3711	Used by the AnnotationBatcher as a PreparedStatement.
7121	19 Apr 16	nicklas	3712	</description>
7121	19 Apr 16	nicklas	3713	</query>
7121	19 Apr 16	nicklas	3714
7121	19 Apr 16	nicklas	3715	<query id="AB_DELETE_FROM_VALUES" type="SQL">
7121	19 Apr 16	nicklas	3716	<sql>
7121	19 Apr 16	nicklas	3717	DELETE FROM [{1}] WHERE [id] = ?
7121	19 Apr 16	nicklas	3718	</sql>
7121	19 Apr 16	nicklas	3719	<description>
7121	19 Apr 16	nicklas	3720	SQL query for deleting all actual annotation values with a given id.
7121	19 Apr 16	nicklas	3721	The {1} parameter is the table the value are stored in, eg. StringValues,
7121	19 Apr 16	nicklas	3722	IntegerValues, FloatValues, etc.
7121	19 Apr 16	nicklas	3723	Used by the AnnotationBatcher as a PreparedStatement.
7121	19 Apr 16	nicklas	3724	</description>
7121	19 Apr 16	nicklas	3725	</query>
7121	19 Apr 16	nicklas	3726
7121	19 Apr 16	nicklas	3727	<query id="AB_INSERT_INTO_VALUES" type="SQL">
7121	19 Apr 16	nicklas	3728	<sql>
7121	19 Apr 16	nicklas	3729	INSERT INTO [{1}] ([id], [value]) VALUES (?, ?)
7121	19 Apr 16	nicklas	3730	</sql>
7121	19 Apr 16	nicklas	3731	<description>
7121	19 Apr 16	nicklas	3732	SQL query for inserting annotation values in their respective
7121	19 Apr 16	nicklas	3733	table (eg. StringValues, IntegerValues, FloatValues, etc.).
7121	19 Apr 16	nicklas	3734	Used by the AnnotationBatcher as a PreparedStatement.
7121	19 Apr 16	nicklas	3735	</description>
7121	19 Apr 16	nicklas	3736	</query>
7121	19 Apr 16	nicklas	3737
7259	09 Dec 16	nicklas	3738	<query id="AB_UPDATE_OVERRIDE_ID" type="SQL">
7249	02 Dec 16	nicklas	3739	<sql>
7255	08 Dec 16	nicklas	3740	UPDATE [Annotations]
7259	09 Dec 16	nicklas	3741	SET [override_id] = ?
7259	09 Dec 16	nicklas	3742	WHERE [annotationset_id] = ?
7259	09 Dec 16	nicklas	3743	AND [annotationtype_id] = ?
7259	09 Dec 16	nicklas	3744	AND [source] = 0
7259	09 Dec 16	nicklas	3745	AND [project_id] <> 0
7259	09 Dec 16	nicklas	3746	</sql>
7259	09 Dec 16	nicklas	3747	<description>
7259	09 Dec 16	nicklas	3748	Updates the "override_id" column on project-specific annotations
7259	09 Dec 16	nicklas	3749	to point to a newly created default annotation of the same
7259	09 Dec 16	nicklas	3750	annotation type (PRIMARY annotations only).
7259	09 Dec 16	nicklas	3751	Used by the AnnotationBatcher as a PreparedStatement.
7259	09 Dec 16	nicklas	3752	Parameters: override_id, annotationset_id, annotationtype_id
7259	09 Dec 16	nicklas	3753	</description>
7259	09 Dec 16	nicklas	3754	</query>
7259	09 Dec 16	nicklas	3755
8166	06 Oct 23	nicklas	3756	<query id="FAST_ANNOTATION_LOADER" type="SQL">
8166	06 Oct 23	nicklas	3757	<sql>
8166	06 Oct 23	nicklas	3758	SELECT v.[value], s.[item_id], a.[id], a.[project_id], a.[override_id], a.[unit_id]
8166	06 Oct 23	nicklas	3759	FROM [{1}] v
8166	06 Oct 23	nicklas	3760	INNER JOIN [Annotations] a
8166	06 Oct 23	nicklas	3761	ON a.[value_id] = v.[id] AND a.[annotationtype_id] = {2}
8166	06 Oct 23	nicklas	3762	AND a.[source] = 0
8166	06 Oct 23	nicklas	3763	AND (a.[project_id] = {3} OR a.[project_id] = {4})
8166	06 Oct 23	nicklas	3764	INNER JOIN [AnnotationSets] s
8166	06 Oct 23	nicklas	3765	ON s.[id] = a.[annotationset_id]
8166	06 Oct 23	nicklas	3766	AND s.[item_type] = {5}
8166	06 Oct 23	nicklas	3767	WHERE s.[item_id] IN (:listOfIds)
8166	06 Oct 23	nicklas	3768	</sql>
8166	06 Oct 23	nicklas	3769	<description>
8166	06 Oct 23	nicklas	3770	SQL query for faster and simple loading of annotation values. The query need the following
8166	06 Oct 23	nicklas	3771	parameters: {1} = name of table where the values are stored (eg. StringValues, IntegerValues, FloatValues, etc.)
8166	06 Oct 23	nicklas	3772	{2} = ID of annotation type, {3} = ID of project, {4} = 0\|-1 for including/excluding default values, {5} = code for item type
8166	06 Oct 23	nicklas	3773	</description>
8166	06 Oct 23	nicklas	3774	</query>
7259	09 Dec 16	nicklas	3775
7259	09 Dec 16	nicklas	3776	<query id="PS_UPDATE_PROJECT_ANNOTATION_OVERRIDE_REF" type="SQL">
7259	09 Dec 16	nicklas	3777	<sql>
7259	09 Dec 16	nicklas	3778	UPDATE [Annotations]
7255	08 Dec 16	nicklas	3779	SET [override_id] = :annotationId
7255	08 Dec 16	nicklas	3780	WHERE [annotationset_id] = :annotationSetId
7255	08 Dec 16	nicklas	3781	AND [annotationtype_id] = :annotationTypeId
7255	08 Dec 16	nicklas	3782	AND [source] = 0
7255	08 Dec 16	nicklas	3783	AND [project_id] <> 0
7249	02 Dec 16	nicklas	3784	</sql>
7249	02 Dec 16	nicklas	3785	<description>
7254	07 Dec 16	nicklas	3786	Updates the "override_id" column on project-specific annotations
7249	02 Dec 16	nicklas	3787	to point to a newly created default annotation of the same
7254	07 Dec 16	nicklas	3788	annotation type (PRIMARY annotations only).
7249	02 Dec 16	nicklas	3789	</description>
7249	02 Dec 16	nicklas	3790	</query>
7249	02 Dec 16	nicklas	3791
7256	08 Dec 16	nicklas	3792	<query id="PS_FIND_OVERRIDE_ID_FOR_PROJECT_ANNOTATION" type="SQL">
7255	08 Dec 16	nicklas	3793	<sql>
7255	08 Dec 16	nicklas	3794	UPDATE [Annotations]
7255	08 Dec 16	nicklas	3795	SET [override_id] = COALESCE(
7255	08 Dec 16	nicklas	3796	(SELECT [id] FROM [Annotations]
7255	08 Dec 16	nicklas	3797	WHERE [annotationset_id] = :annotationSetId
7255	08 Dec 16	nicklas	3798	AND [annotationtype_id] = :annotationTypeId
7255	08 Dec 16	nicklas	3799	AND [source] = 0 AND [project_id] = 0)
7255	08 Dec 16	nicklas	3800	, 0)
7255	08 Dec 16	nicklas	3801	WHERE id = :annotationId
7255	08 Dec 16	nicklas	3802	</sql>
7255	08 Dec 16	nicklas	3803	<description>
7255	08 Dec 16	nicklas	3804	Updates the "override_id" column on a newly created project-specific
7255	08 Dec 16	nicklas	3805	(PRIMARY) annotation to point to the existing default annotation id
7255	08 Dec 16	nicklas	3806	or 0 if no default annotation exists.
7255	08 Dec 16	nicklas	3807	</description>
7255	08 Dec 16	nicklas	3808	</query>
7255	08 Dec 16	nicklas	3809
7256	08 Dec 16	nicklas	3810	<query id="PS_UPDATE_PROJECT_ANNOTATION_OVERRIDE_REF_INHERITED" type="HQL">
7254	07 Dec 16	nicklas	3811	<sql>
7255	08 Dec 16	nicklas	3812	UPDATE [Annotations]
7255	08 Dec 16	nicklas	3813	SET [override_id] = :annotationId
7255	08 Dec 16	nicklas	3814	WHERE [annotationset_id] = :annotationSetId
7255	08 Dec 16	nicklas	3815	AND [inherited_id] IN (
7255	08 Dec 16	nicklas	3816	SELECT [id] FROM [Annotations]
7255	08 Dec 16	nicklas	3817	WHERE [annotationset_id] = :parentSetId
7255	08 Dec 16	nicklas	3818	AND [override_id] = :parentId
7254	07 Dec 16	nicklas	3819	)
7254	07 Dec 16	nicklas	3820	</sql>
7254	07 Dec 16	nicklas	3821	<description>
7254	07 Dec 16	nicklas	3822	Updates the "override_id" column on project-specific annotations
7254	07 Dec 16	nicklas	3823	to point to a newly created default annotation (INHERITED and
7254	07 Dec 16	nicklas	3824	CLONED annotations). The subquery will find project-specific annotation
7254	07 Dec 16	nicklas	3825	on the parent annotation set that is overriding the inherited annotation.
7254	07 Dec 16	nicklas	3826	</description>
7254	07 Dec 16	nicklas	3827	</query>
7254	07 Dec 16	nicklas	3828
7256	08 Dec 16	nicklas	3829	<query id="PS_FIND_OVERRIDE_ID_FOR_PROJECT_ANNOTATION_INHERITED" type="SQL">
7249	02 Dec 16	nicklas	3830	<sql>
7255	08 Dec 16	nicklas	3831	UPDATE [Annotations]
7255	08 Dec 16	nicklas	3832	SET [override_id] = COALESCE(
7255	08 Dec 16	nicklas	3833	(SELECT [id] FROM [Annotations]
7255	08 Dec 16	nicklas	3834	WHERE [annotationset_id] = :annotationSetId
7255	08 Dec 16	nicklas	3835	AND [inherited_id] = :parentOverrideId
7255	08 Dec 16	nicklas	3836	AND [source] <> 0
7255	08 Dec 16	nicklas	3837	AND [project_id] = 0)
7255	08 Dec 16	nicklas	3838	, 0)
7255	08 Dec 16	nicklas	3839	WHERE id = :annotationId
7249	02 Dec 16	nicklas	3840	</sql>
7249	02 Dec 16	nicklas	3841	<description>
7255	08 Dec 16	nicklas	3842	Updates the "override_id" column on a newly created project-specific
7290	31 Jan 17	nicklas	3843	(CLONED or INHERITED) annotation to point to the existing default
7290	31 Jan 17	nicklas	3844	annotation id or 0 if no default annotation exists.
7255	08 Dec 16	nicklas	3845	</description>
7255	08 Dec 16	nicklas	3846	</query>
7255	08 Dec 16	nicklas	3847
7256	08 Dec 16	nicklas	3848	<query id="PS_RESET_OVERRIDE_ON_PROJECT_ANNOTATIONS" type="HQL">
7255	08 Dec 16	nicklas	3849	<sql>
7255	08 Dec 16	nicklas	3850	UPDATE [Annotations]
7255	08 Dec 16	nicklas	3851	SET [override_id] = 0
7255	08 Dec 16	nicklas	3852	WHERE [override_id] IN (:deletedAnnotations)
7255	08 Dec 16	nicklas	3853	OR [inherited_id] IN (
7255	08 Dec 16	nicklas	3854	SELECT [id] FROM [Annotations]
7255	08 Dec 16	nicklas	3855	WHERE [override_id] IN (:deletedPrimaryAnnotations)
7255	08 Dec 16	nicklas	3856	)
7255	08 Dec 16	nicklas	3857	</sql>
7255	08 Dec 16	nicklas	3858	<description>
7249	02 Dec 16	nicklas	3859	Reset the "override_id" column on project-specific annotations
7249	02 Dec 16	nicklas	3860	that points to a default annotation that has been removed.
7249	02 Dec 16	nicklas	3861	</description>
7249	02 Dec 16	nicklas	3862	</query>
7256	08 Dec 16	nicklas	3863
7262	12 Dec 16	nicklas	3864	<query id="PS_LOAD_ANNOTATIONS_IN_NON_EXISTING_PROJECTS" type="SQL">
7256	08 Dec 16	nicklas	3865	<sql>
7262	12 Dec 16	nicklas	3866	SELECT a.[id], a.[annotationset_id], a.[value_id], a.[project_id], at.[value_type]
7256	08 Dec 16	nicklas	3867	FROM [Annotations] a
7256	08 Dec 16	nicklas	3868	INNER JOIN [AnnotationTypes] at ON at.[id] = a.[annotationtype_id]
7262	12 Dec 16	nicklas	3869	WHERE a.[project_id] <> 0 AND a.[project_id] NOT IN (SELECT [id] FROM [Projects])
7256	08 Dec 16	nicklas	3870	</sql>
7256	08 Dec 16	nicklas	3871	<description>
7256	08 Dec 16	nicklas	3872	SQL query for loading information about annotations
7256	08 Dec 16	nicklas	3873	that are project-specific annotations for a given
7256	08 Dec 16	nicklas	3874	list of projects.
7256	08 Dec 16	nicklas	3875	Used by the ProjectSpecificAnnotationsManager when
7256	08 Dec 16	nicklas	3876	a project has been deleted.
7256	08 Dec 16	nicklas	3877	</description>
7256	08 Dec 16	nicklas	3878	</query>
7249	02 Dec 16	nicklas	3879
7256	08 Dec 16	nicklas	3880	<query id="PS_DELETE_FROM_PARAMETERVALUES" type="SQL">
7256	08 Dec 16	nicklas	3881	<sql>
7256	08 Dec 16	nicklas	3882	DELETE FROM [ParameterValues] WHERE [id] IN (:deletedValues)
7256	08 Dec 16	nicklas	3883	</sql>
7256	08 Dec 16	nicklas	3884	<description>
7256	08 Dec 16	nicklas	3885	SQL query for deleting mutliple parameter values with a given id's.
7256	08 Dec 16	nicklas	3886	Used by the ProjectSpecificAnnotationsManager.
7256	08 Dec 16	nicklas	3887	</description>
7256	08 Dec 16	nicklas	3888	</query>
7249	02 Dec 16	nicklas	3889
7256	08 Dec 16	nicklas	3890	<query id="PS_DELETE_FROM_VALUES" type="SQL">
7256	08 Dec 16	nicklas	3891	<sql>
7256	08 Dec 16	nicklas	3892	DELETE FROM [{1}] WHERE [id] IN (:deletedValues)
7256	08 Dec 16	nicklas	3893	</sql>
7256	08 Dec 16	nicklas	3894	<description>
7256	08 Dec 16	nicklas	3895	SQL query for deleting all actual annotation values with given id's.
7256	08 Dec 16	nicklas	3896	The {1} parameter is the table the value are stored in, eg. StringValues,
7256	08 Dec 16	nicklas	3897	IntegerValues, FloatValues, etc.
7256	08 Dec 16	nicklas	3898	Used by the ProjectSpecificAnnotationsManager.
7256	08 Dec 16	nicklas	3899	</description>
7256	08 Dec 16	nicklas	3900	</query>
7256	08 Dec 16	nicklas	3901
7256	08 Dec 16	nicklas	3902	<query id="PS_DELETE_FROM_ANNOTATIONS_IN_PROJECTS" type="SQL">
7256	08 Dec 16	nicklas	3903	<sql>
7256	08 Dec 16	nicklas	3904	DELETE FROM [Annotations] WHERE [project_id] IN (:deletedProjects)
7256	08 Dec 16	nicklas	3905	</sql>
7256	08 Dec 16	nicklas	3906	<description>
7256	08 Dec 16	nicklas	3907	SQL query for deleting all annotation entries referenceing
7256	08 Dec 16	nicklas	3908	given list of projects.
7256	08 Dec 16	nicklas	3909	Used by the ProjectSpecificAnnotationsManager.
7256	08 Dec 16	nicklas	3910	</description>
7256	08 Dec 16	nicklas	3911	</query>
7257	08 Dec 16	nicklas	3912
7260	12 Dec 16	nicklas	3913	<query id="PS_FIND_PROJECT_SPECIFIC_ANNOTATION" type="HQL">
7260	12 Dec 16	nicklas	3914	<sql>
7260	12 Dec 16	nicklas	3915	SELECT ad FROM AnnotationData ad
7260	12 Dec 16	nicklas	3916	WHERE ad.projectId = :activeProject
7260	12 Dec 16	nicklas	3917	AND ad.overrideId = :defaultAnnotation
7263	13 Dec 16	nicklas	3918	AND ad.annotationSet = :annotationSet
7260	12 Dec 16	nicklas	3919	</sql>
7260	12 Dec 16	nicklas	3920	<description>
7260	12 Dec 16	nicklas	3921	HQL query for locating a project-specific annotation
7260	12 Dec 16	nicklas	3922	overriding a specified default annotation.
7260	12 Dec 16	nicklas	3923	Used by the ProjectSpecificAnnotationsManager.
7260	12 Dec 16	nicklas	3924	</description>
7260	12 Dec 16	nicklas	3925	</query>
7260	12 Dec 16	nicklas	3926
7257	08 Dec 16	nicklas	3927	<query id="COUNT_PROJECT_ANNOTATIONS_FOR_ANNOTATIONTYPE" type="HQL">
7257	08 Dec 16	nicklas	3928	<sql>
7257	08 Dec 16	nicklas	3929	SELECT count(*)
7257	08 Dec 16	nicklas	3930	FROM AnnotationData ad
7257	08 Dec 16	nicklas	3931	WHERE ad.annotationType = :annotationType
7257	08 Dec 16	nicklas	3932	AND ad.projectId <> 0
7257	08 Dec 16	nicklas	3933	</sql>
7257	08 Dec 16	nicklas	3934	<description>
7257	08 Dec 16	nicklas	3935	HQL query that counts the number of project-specific annotations
7257	08 Dec 16	nicklas	3936	for an annotation type.
7257	08 Dec 16	nicklas	3937	</description>
7257	08 Dec 16	nicklas	3938	</query>
7408	06 Oct 17	nicklas	3939
7408	06 Oct 17	nicklas	3940	<query id="GET_USER_DEVICE" type="HQL">
7408	06 Oct 17	nicklas	3941	<sql>
7408	06 Oct 17	nicklas	3942	SELECT dev
7408	06 Oct 17	nicklas	3943	FROM UserDeviceData dev
7408	06 Oct 17	nicklas	3944	WHERE dev.user = :userId
7408	06 Oct 17	nicklas	3945	AND dev.client = :clientId
7408	06 Oct 17	nicklas	3946	AND dev.token = :token
7408	06 Oct 17	nicklas	3947	</sql>
7408	06 Oct 17	nicklas	3948	<description>
7408	06 Oct 17	nicklas	3949	HQL query that selects a device for a given user and client
7408	06 Oct 17	nicklas	3950	with a given device token.
7408	06 Oct 17	nicklas	3951	</description>
7408	06 Oct 17	nicklas	3952	</query>
7256	08 Dec 16	nicklas	3953
29	22 Feb 05	nicklas	3954	</predefined-queries>