more info:
on starting tomcat, i see a lot of these in the intellij console:
INFO SqlDialect 2010-10-13 04:23:50,400 http-8080-Processor20 : Unknown SQL Type Name "null"; using String instead.
INFO SqlDialect 2010-10-13 04:23:50,400 http-8080-Processor20 : Unknown SQL Type Name "null"; using String instead.
INFO SqlDialect 2010-10-13 04:23:50,400 http-8080-Processor20 : Unknown SQL Type Name "null"; using String instead.
INFO SqlDialect 2010-10-13 04:23:50,400 http-8080-Processor20 : Unknown SQL Type Name "null"; using String instead.
INFO SqlDialect 2010-10-13 04:23:50,401 http-8080-Processor20 : Unknown SQL Type Name "null"; using String instead.
INFO SqlDialect 2010-10-13 04:23:50,401 http-8080-Processor20 : Unknown SQL Type Name "null"; using String instead.
INFO SqlDialect 2010-10-13 04:23:50,401 http-8080-Processor20 : Unknown SQL Type Name "null"; using String instead.
INFO SqlDialect 2010-10-13 04:23:50,401 http-8080-Processor20 : Unknown SQL Type Name "null"; using String instead.
INFO SqlDialect 2010-10-13 04:23:50,402 http-8080-Processor20 : Unknown SQL Type Name "null"; using String instead.
INFO SqlDialect 2010-10-13 04:23:50,501 http-8080-Processor20 : Unknown SQL Type Name "null"; using String instead.
INFO SqlDialect 2010-10-13 04:23:50,501 http-8080-Processor20 : Unknown SQL Type Name "null"; using String instead.
INFO SqlDialect 2010-10-13 04:23:50,519 http-8080-Processor24 : Unknown SQL Type Name "null"; using String instead.
INFO SqlDialect 2010-10-13 04:23:50,519 http-8080-Processor24 : Unknown SQL Type Name "null"; using String instead.
INFO SqlDialect 2010-10-13 04:23:50,525 http-8080-Processor24 : Unknown SQL Type Name "null"; using String instead.
here's the full error and sql:
ERROR Table 2010-10-13 04:24:10,535 t: http-8080-Processor21 : internalExecuteQuery
org.postgresql.util.PSQLException: ERROR: UNION types text and integer cannot be matched
Position: 1280
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at org.labkey.api.data.StatementWrapper.executeQuery(StatementWrapper.java:542)
at org.labkey.api.data.Table._executeQuery(Table.java:146)
at org.labkey.api.data.Table.executeQuery(Table.java:306)
at org.labkey.api.data.Table.selectForDisplay(Table.java:1415)
at org.labkey.api.data.Table.access$300(Table.java:79)
at org.labkey.api.data.Table$2.call(Table.java:1427)
at org.labkey.api.data.Table$2.call(Table.java:1424)
at org.labkey.api.data.AsyncQueryRequest$1.run(AsyncQueryRequest.java:69)
at java.lang.Thread.run(Thread.java:619)
ERROR Table 2010-10-13 04:24:10,536 t: http-8080-Processor21 : SQL [3244]
-- <QueryServiceImpl.getSelectSQL(FilteredTable over StudyData UNION table)>
SELECT *
FROM (
SELECT
StudyData.participantid AS Id,
StudyData.Project AS Project,
StudyData.Account AS Account,
StudyData.dataset AS DataSet,
StudyData$DataSet$.name AS "DataSet$Name",
StudyData.Remark AS Remark,
StudyData.Description AS Description,
StudyData.lsid AS LSID
FROM (
-- <StudyUnionTableInfo>
(SELECT '03f66167-8965-102d-bff3-493dbd27f43e' AS dataset, 1061 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1496_alopecia" D) UNION ALL
(SELECT '03f66153-8965-102d-bff3-493dbd27f43e' AS dataset, 1007 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1462_birth" D) UNION ALL
(SELECT '03f66142-8965-102d-bff3-493dbd27f43e' AS dataset, 1008 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, D.project, NULL AS Account FROM studydataset."c108d1463_blood" D) UNION ALL
(SELECT '03f6615b-8965-102d-bff3-493dbd27f43e' AS dataset, 1065 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1500_bcs" D) UNION ALL
(SELECT '03f66158-8965-102d-bff3-493dbd27f43e' AS dataset, 1047 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, D.project, NULL AS Account FROM studydataset."c108d1466_clinremarks" D) UNION ALL
(SELECT '03f6615a-8965-102d-bff3-493dbd27f43e' AS dataset, 1064 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1499_dentalstatus" D) UNION ALL
(SELECT '03f66146-8965-102d-bff3-493dbd27f43e' AS dataset, 1014 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, D.project, NULL AS Account FROM studydataset."c108d1470_drug" D) UNION ALL
(SELECT '03f66159-8965-102d-bff3-493dbd27f43e' AS dataset, 1067 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, NULL AS ParentId, D.remark, D.project, D.account FROM studydataset."c108d1502_encounters" D) UNION ALL
(SELECT '03f66141-8965-102d-bff3-493dbd27f43e' AS dataset, 1023 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1479_obs" D) UNION ALL
(SELECT '03f66145-8965-102d-bff3-493dbd27f43e' AS dataset, 1029 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1482_prenatal" D) UNION ALL
(SELECT '03f66139-8965-102d-bff3-493dbd27f43e' AS dataset, 1033 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1485_procedures" D) UNION ALL
(SELECT '03f66147-8965-102d-bff3-493dbd27f43e' AS dataset, 1030 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1483_problem" D) UNION ALL
(SELECT '03f6615f-8965-102d-bff3-493dbd27f43e' AS dataset, 1069 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, D.project, NULL AS Account FROM studydataset."c108d1507_restraints" D) UNION ALL
(SELECT '03f66148-8965-102d-bff3-493dbd27f43e' AS dataset, 1031 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, NULL AS Remark, D.project, NULL AS Account FROM studydataset."c108d1484_surgery" D) UNION ALL
(SELECT '03f6613b-8965-102d-bff3-493dbd27f43e' AS dataset, 1034 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, NULL AS Remark, D.project, NULL AS Account FROM studydataset."c108d1486_surgsum" D) UNION ALL
(SELECT '03f6616c-8965-102d-bff3-493dbd27f43e' AS dataset, 1075 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1509_treatments" D) UNION ALL
(SELECT '03f6613c-8965-102d-bff3-493dbd27f43e' AS dataset, 1035 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1487_tb" D) UNION ALL
(SELECT '03f66164-8965-102d-bff3-493dbd27f43e' AS dataset, 1062 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1497_teeth" D) UNION ALL
(SELECT '03f6613f-8965-102d-bff3-493dbd27f43e' AS dataset, 1037 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, D.project, NULL AS Account FROM studydataset."c108d1489_treatment_order" D) UNION ALL
(SELECT '03f66157-8965-102d-bff3-493dbd27f43e' AS dataset, 1045 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1494_weight" D) UNION ALL
(SELECT '03f66165-8965-102d-bff3-493dbd27f43e' AS dataset, 1063 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1498_vitals" D) UNION ALL
(SELECT '03f6614e-8965-102d-bff3-493dbd27f43e' AS dataset, 1050 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, D.project, D.account FROM studydataset."c108d1457_bacteriologyruns" D) UNION ALL
(SELECT '03f6614a-8965-102d-bff3-493dbd27f43e' AS dataset, 1049 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1458_bacteriologyresults" D) UNION ALL
(SELECT '03f66154-8965-102d-bff3-493dbd27f43e' AS dataset, 1055 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, D.project, D.account FROM studydataset."c108d1464_chemistryruns" D) UNION ALL
(SELECT '03f66162-8965-102d-bff3-493dbd27f43e' AS dataset, 1056 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1465_chemistryresults" D) UNION ALL
(SELECT '03f66163-8965-102d-bff3-493dbd27f43e' AS dataset, 1057 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, D.project, D.account FROM studydataset."c108d1473_hematologyruns" D) UNION ALL
(SELECT '03f66160-8965-102d-bff3-493dbd27f43e' AS dataset, 1058 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, D.account FROM studydataset."c108d1471_hematologymorphology" D) UNION ALL
(SELECT '03f66161-8965-102d-bff3-493dbd27f43e' AS dataset, 1059 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1472_hematologyresults" D) UNION ALL
(SELECT '03f66169-8965-102d-bff3-493dbd27f43e' AS dataset, 1082 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, D.project, D.account FROM studydataset."c108d1475_immunologyruns" D) UNION ALL
(SELECT '03f66168-8965-102d-bff3-493dbd27f43e' AS dataset, 1083 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1476_immunologyresults" D) UNION ALL
(SELECT '03f6614c-8965-102d-bff3-493dbd27f43e' AS dataset, 1051 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, D.project, D.account FROM studydataset."c108d1480_parasitologyruns" D) UNION ALL
(SELECT '03f66152-8965-102d-bff3-493dbd27f43e' AS dataset, 1052 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1481_parasitologyresults" D) UNION ALL
(SELECT '03f6616b-8965-102d-bff3-493dbd27f43e' AS dataset, 1080 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, D.project, D.account FROM studydataset."c108d1491_urinalysisruns" D) UNION ALL
(SELECT '03f6616a-8965-102d-bff3-493dbd27f43e' AS dataset, 1081 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1490_urinalysisresults" D) UNION ALL
(SELECT '03f66150-8965-102d-bff3-493dbd27f43e' AS dataset, 1053 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, D.project, D.account FROM studydataset."c108d1492_virologyruns" D) UNION ALL
(SELECT '03f66156-8965-102d-bff3-493dbd27f43e' AS dataset, 1054 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1493_virologyresults" D) UNION ALL
(SELECT '03f6615e-8965-102d-bff3-493dbd27f43e' AS dataset, 1068 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, NULL AS Remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1501_alerts" D) UNION ALL
(SELECT '03f66149-8965-102d-bff3-493dbd27f43e' AS dataset, 1001 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1455_arrival" D) UNION ALL
(SELECT '03f6614d-8965-102d-bff3-493dbd27f43e' AS dataset, 1002 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, D.project, NULL AS Account FROM studydataset."c108d1456_assignment" D) UNION ALL
(SELECT '03f66151-8965-102d-bff3-493dbd27f43e' AS dataset, 1004 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, D.project, NULL AS Account FROM studydataset."c108d1459_behavetrem" D) UNION ALL
(SELECT '03f6614b-8965-102d-bff3-493dbd27f43e' AS dataset, 1048 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1467_deaths" D) UNION ALL
(SELECT '03f66143-8965-102d-bff3-493dbd27f43e' AS dataset, 1012 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, NULL AS Remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1468_demographics" D) UNION ALL
(SELECT '03f66144-8965-102d-bff3-493dbd27f43e' AS dataset, 1013 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1469_departure" D) UNION ALL
(SELECT '03f6613a-8965-102d-bff3-493dbd27f43e' AS dataset, 1018 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1474_housing" D) UNION ALL
(SELECT '03f66138-8965-102d-bff3-493dbd27f43e' AS dataset, 5001 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, NULL AS Description, NULL AS ParentId, NULL AS Remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1510_inbreeding" D) UNION ALL
(SELECT '03f66166-8965-102d-bff3-493dbd27f43e' AS dataset, 1060 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1495_menses" D) UNION ALL
(SELECT '03f6616f-8965-102d-bff3-493dbd27f43e' AS dataset, 1079 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1512_pairtest" D) UNION ALL
(SELECT '03f66155-8965-102d-bff3-493dbd27f43e' AS dataset, 1006 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, NULL AS Remark, NULL AS Project, D.account FROM studydataset."c108d1460_biopsy" D) UNION ALL
(SELECT '03f6614f-8965-102d-bff3-493dbd27f43e' AS dataset, 1005 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, NULL AS Remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1461_biopsydiag" D) UNION ALL
(SELECT '03f6616d-8965-102d-bff3-493dbd27f43e' AS dataset, 1073 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, D.project, D.account FROM studydataset."c108d1506_clinpathrequests" D) UNION ALL
(SELECT '03f66171-8965-102d-bff3-493dbd27f43e' AS dataset, 1077 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1508_errors" D) UNION ALL
(SELECT '03f66170-8965-102d-bff3-493dbd27f43e' AS dataset, 1078 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1511_feeding" D) UNION ALL
(SELECT '03f6615c-8965-102d-bff3-493dbd27f43e' AS dataset, 1070 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1503_histology" D) UNION ALL
(SELECT '03f66140-8965-102d-bff3-493dbd27f43e' AS dataset, 1022 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, NULL AS Remark, D.project, D.account FROM studydataset."c108d1477_necropsy" D) UNION ALL
(SELECT '03f6613e-8965-102d-bff3-493dbd27f43e' AS dataset, 1021 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1478_necropsydiag" D) UNION ALL
(SELECT '03f6616e-8965-102d-bff3-493dbd27f43e' AS dataset, 1072 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1505_organ_weights" D) UNION ALL
(SELECT '03f6613d-8965-102d-bff3-493dbd27f43e' AS dataset, 1036 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1488_tissue_requests" D) UNION ALL
(SELECT '03f6615d-8965-102d-bff3-493dbd27f43e' AS dataset, 1071 AS datasetid, D.date AS _visitdate, D.participantid, D.sequencenum, D._key, D.participantsequencekey, D.sourcelsid, D.qcstate, D.lsid, D.description, D.parentid, D.remark, NULL AS Project, NULL AS Account FROM studydataset."c108d1504_tissue_samples" D)
-- </StudyUnionTableInfo>
) StudyData
LEFT OUTER JOIN (SELECT * FROM study.dataset
WHERE (container IN (?))) StudyData$DataSet$ ON (CAST((StudyData.dataset) AS VARCHAR) = CAST((StudyData$DataSet$.entityid) AS VARCHAR))) x
ORDER BY Id ASC
LIMIT 101
-- </QueryServiceImpl.getSelectSQL()>
?[1] 29e3860b-02b5-102d-b524-493dbd27b599
org.labkey.api.data.Table$2.call(Table.java:1427)
org.labkey.api.data.Table$2.call(Table.java:1424)
org.labkey.api.data.AsyncQueryRequest$1.run(AsyncQueryRequest.java:69)
java.lang.Thread.run(Thread.java:619) |