✓
✓
✓
✓
✓
✓
✓
/*
Can you give me an adhoc query that lists all trial counts with a source of '%Liaison%'
*/
SELECT s.value AS SOURCE, a.value AS STATUS,
COUNT(*) AS "NUMBER OF TRIALS"
FROM query_term s
JOIN query_term a
ON a.doc_id = s.doc_id
JOIN pub_proc_cg c
ON c.id = s.doc_id
WHERE s.path = '/InScopeProtocol/ProtocolSources'
+ '/ProtocolSource/SourceName'
AND s.value = 'NCI Liaison Office-Brussels'
AND a.path = '/InScopeProtocol/ProtocolAdminInfo'
+ '/CurrentProtocolStatus'
-- AND a.value IN ('Active', 'Approved-not yet active',
-- 'Closed', 'Completed')
GROUP BY s.value, a.value
SELECT n.doc_id, n.value AS "Name",
b.value AS "Contact", e.value AS "Email"
FROM query_term n
JOIN query_term t
ON t.doc_id = n.doc_id
AND t.path = '/Licensee/LicenseeInformation' +
'/LicenseeStatus'
JOIN query_term b
ON b.doc_id = n.doc_id
AND b.path = '/Licensee/ContactPersons' +
'/ContactPerson/ContactName'
JOIN query_term ct
ON ct.doc_id = n.doc_id
AND ct.path = '/Licensee/ContactPersons' +
'/ContactPerson/ContactType'
AND left(ct.node_loc, 8) = left(b.node_loc, 8)
LEFT OUTER JOIN query_term p
ON p.doc_id = b.doc_id
AND p.path = '/Licensee/ContactPersons' +
'/ContactPerson/ContactDetail' +
'/Phone'
AND left(p.node_loc, 8) = left(b.node_loc, 8)
LEFT OUTER JOIN query_term e
ON e.doc_id = b.doc_id
AND e.path = '/Licensee/ContactPersons' +
'/ContactPerson/ContactDetail' +
'/Email'
AND left(e.node_loc, 8) = left(b.node_loc, 8)
WHERE n.path = '/Licensee/LicenseeInformation' +
'/LicenseeNameInformation' +
'/OfficialName/Name'
and t.value in ('Production', 'Test')
ORDER BY n.value, ct.value
✓
✓
- <!-- $Id: CDR0000559215.xml 9553 2010-03-25 23:44:34Z volker $ --> ? ^^^^ ^ ^ ^^ ^^^^^ + <!-- $Id: CDR0000559215.xml 12011 2013-09-09 19:23:02Z volker $ --> ? ^^^^^ ^ ^ ^^ +++ ^^
- <!-- $Id: $ --> + <!-- $Id: CDR0000315570.xml 12049 2013-09-27 17:22:06Z volker $ --> - ================================================================ + ========================================================================= ? +++++++++ - $Id: $ + $Id: CDR0000315570.xml 12049 2013-09-27 17:22:06Z volker $ + BZIssue::OCECDR-3648 - Changes to Summaries Reports - Comments displaying - ================================================================ --> + ========================================================================= --> ? +++++++++ + - <!-- encoding = "UTF-8"/> --> - - <xsl:template match = "/"> ? - + <xsl:template match = "/"> - <xsl:apply-templates select = "Summary/SummarySection ? - + <xsl:apply-templates select = "Summary/SummarySection - [SectMetaData/SectionType = ? - + [SectMetaData/SectionType = - 'Changes to summary']"/> ? - + 'Changes to summary']"/> - <xsl:template match = "SummarySection"> ? - + <xsl:template match = "SummarySection"> - <xsl:value-of select = "Title"/> ? - + <xsl:value-of select = "Title"/> - <xsl:template match = "SummarySection/Title | ? - + <xsl:template match = "SummarySection/Title | - SummarySection/SectMetaData | ? - + SummarySection/SectMetaData | - Comment"/> ? - + Comment"/>
- <!-- $Id: CDR0000756673.xml 12282 2014-01-14 19:39:46Z bkline $ --> ? ^ ^^ ^^ ^^ ^ --- + <!-- $Id: CDR0000756673.xml 12287 2014-01-14 22:02:07Z volker $ --> ? ^ ^^ ^^ ^^ ^^^ + - <!-- Filter title: Ganz Schoen Feist --> ? ^^^^^^^^^ ^ + <!-- Filter title: Viel Feister --> ? ^^ ^ ++ + <xsl:text>... tadaaa</xsl:text> -
- <?xml version="1.0" encoding="utf-8"?> - <!-- $Id: CDR0000000092.xml 12275 2014-01-13 15:47:53Z bkline $ --> - <!-- Filter title: DocTitle for Term --> - <!-- - ================================================================ - $Id: $ + <?xml version="1.0"?> + <xsl:transform xmlns:xsl="http://www.w3.org/1999/XSL/Transform" + version="1.0" + xmlns:cdr="cips.nci.nih.gov/cdr"> + <xsl:output method="text"/> + <!--Filter written by C.Burg - 10/30/2001 --> - DocTitle Filter: Terminology + <!-- ========================================================== + This program is a filter to display the Terminology + titles + ==========================================================--> + <xsl:template match="Term"> - OCECDR-3717: Term with ampersand character in it produces errors - in protocols + <!-- ====================================== + Display Preferred Term name + ======================================--> + <xsl:if test="PreferredName"> + <xsl:for-each select="PreferredName"> + <xsl:value-of select="."/>;<xsl:text/> + </xsl:for-each> + </xsl:if> - Filter written by C.Burg - 10/30/2001 - ================================================================ --> - <xsl:transform xmlns:xsl = "http://www.w3.org/1999/XSL/Transform" - xmlns:cdr = "cips.nci.nih.gov/cdr" - version = "1.0"> - <xsl:output method = "html"/> + <!-- ==================================== + Display Term Type + ====================================--> + <xsl:if test="TermType/TermTypeName"> + <xsl:for-each select="TermType/TermTypeName"> + <xsl:value-of select="."/>;<xsl:text/> + </xsl:for-each> + </xsl:if> + <!-- ========================================= + Display Semantic Type + Modified 10/09/2002 (CB) to replace SemanticTypeText + with SematicType - <!-- - =============================================================== - This program is a filter to display the Terminology titles - =============================================================== --> - <xsl:template match = "Term"> - <!-- - ============================================================== - Display Preferred Term name - ============================================================== --> ? ^^^^^^^^^^^^^^^^^^^^^ + ========================================= --> ? ^^^^^^^^^ - <xsl:if test = "PreferredName"> - <xsl:value-of select = "PreferredName"/> - <xsl:text>;</xsl:text> - </xsl:if> + <xsl:if test="SemanticType"> + <xsl:for-each select="SemanticType"> + <xsl:variable name="Ref" select="@cdr:ref"/> + <xsl:variable name="SemTypeID" select="@cdr:ref"/> + <xsl:variable name="SemTypeInfo" select="document(concat ('cdr:',$SemTypeID,'/lastp'))"/> + <xsl:value-of select="$SemTypeInfo/Term/PreferredName"/> + <xsl:if test="position() !=last()">;<xsl:text/></xsl:if> - <!-- - ============================================================== - Display Term Type - ============================================================== --> - <xsl:if test = "TermType/TermTypeName"> - <xsl:for-each select = "TermType/TermTypeName"> - <xsl:value-of select = "."/> - <xsl:text>;</xsl:text> - </xsl:for-each> + </xsl:for-each> ? +++++ - </xsl:if> + </xsl:if> ? ++++++ + </xsl:template> - <!-- - ============================================================== - Display Semantic Type - Modified 10/09/2002 (CB) to replace SemanticTypeText with - SematicType - ============================================================== --> - <xsl:if test = "SemanticType"> - <xsl:for-each select = "SemanticType"> - <xsl:variable name = "Ref" - select = "@cdr:ref"/> - <xsl:variable name = "SemTypeID" - select = "@cdr:ref"/> - <xsl:variable name = "SemTypeInfo" - select = "document(concat ('cdr:',$SemTypeID, - '/lastp'))"/> - <xsl:value-of select = "$SemTypeInfo/Term/PreferredName"/> - <xsl:if test = "position() != last()"> - <xsl:text>;</xsl:text> - </xsl:if> - </xsl:for-each> - </xsl:if> - </xsl:template> - </xsl:transform> ? - + </xsl:transform>? ++
- <!-- $Id: CDR0000000134.xml 9523 2010-03-12 19:44:52Z volker $ --> ? ^ ^^ ^ ^ - ^ ^ ^ + <!-- $Id: CDR0000000134.xml 12050 2013-09-27 17:48:58Z volker $ --> ? ^^^ ^ ^ ^ + ^ ^ ^ + OCECDR-3588 - Links from Drug Dictionary to NCI Thesaurus - <xsl:variable name = "conceptId"> + <xsl:variable name = "conceptId"> ? + - <xsl:value-of select = "normalize-space( + <xsl:value-of select = "normalize-space( ? + - ../../OtherName/ - SourceInformation/ - VocabularySource/ - SourceTermId)"/> - </xsl:variable> - - <xsl:if test = "/Term/ - NCIThesaurusConcept[@Public = 'Yes'] - = $conceptId"> - <xsl:text> (</xsl:text> - <xsl:element name = "ExternalRef"> - <xsl:attribute name = "xref"> - <xsl:text>http://ncit.nci.nih.gov/</xsl:text> - <xsl:text>ncitbrowser/ConceptReport.jsp?</xsl:text> - <xsl:text>dictionary=NCI%20Thesaurus&code=</xsl:text> - <xsl:value-of select = "$conceptId"/> - <!-- - normalize-space( - --> + </xsl:variable> + + <xsl:if test = "/Term/ + NCIThesaurusConcept[@Public = 'Yes'] + = $conceptId"> + <xsl:text> (</xsl:text> + <xsl:element name = "ExternalRef"> + <xsl:attribute name = "xref"> + <xsl:text>http://ncit.nci.nih.gov/</xsl:text> + <xsl:text>ncitbrowser/ConceptReport.jsp?</xsl:text> + <xsl:text>dictionary=NCI%20Thesaurus&code=</xsl:text> + <xsl:value-of select = "$conceptId"/> - </xsl:attribute> + </xsl:attribute> ? + - <xsl:value-of select = "../DefinitionSource/ + <xsl:value-of select = "../DefinitionSource/ ? + - </xsl:element> + </xsl:element> ? + - <xsl:text>)</xsl:text> + <xsl:text>)</xsl:text> ? +
- <?xml version="1.0"?> + <?xml version = "1.0" encoding="utf-8"?> + <!-- $Id: CDR0000350018.xml 11877 2013-06-25 21:18:57Z volker $ --> + <!-- Filter title: Module: Denormalize and Upcode Protocol Terminology --> + <!-- + ==================================================================== - <!-- - $Id: CDR0000350018.xml 9319 2009-10-28 15:39:13Z bkline $ + $Id: CDR0000350018.xml 11877 2013-06-25 21:18:57Z volker $
- $Id: CDR0000343579.xml,v 1.22 2008/08/13 19:23:15 venglisc Exp $ + $Id: CDR0000343579.xml 9319 2009-10-28 15:39:13Z bkline $ + $Log: not supported by cvs2svn $ - $Log: CDR0000343579.xml,v $ - Revision 1.22 2008/08/13 19:23:15 venglisc - Added ResponsibleParty block. (Bug 4223) -
- <!-- $Id: CDR0000616048.xml 10121 2011-07-15 22:59:34Z volker $ --> ? ^^ ^^^^ ^ ------ + <!-- $Id: CDR0000616048.xml 12091 2013-10-30 17:25:24Z volker $ --> ? + ^ ^ +++++++++ ^ - $Id: CDR0000616048.xml 10121 2011-07-15 22:59:34Z volker $ ? ^^ ^^^^ ^ ------ + $Id: CDR0000616048.xml 12091 2013-10-30 17:25:24Z volker $ ? + ^ ^ +++++++++ ^ + OCECDR-3528: Ability to put links to other Dictionary terms in More + Information block on Cancer.gov
- <!-- $Id: CDR0000315588.xml 12275 2014-01-13 15:47:53Z bkline $ --> ? ^^^ ^ ^^ ^ ^^ ^ --- + <!-- $Id: CDR0000315588.xml 12311 2014-02-05 19:28:53Z volker $ --> ? ^^^ ^ ^^ ^ ^^ ^^^ + - $Id: CDR0000315588.xml 12275 2014-01-13 15:47:53Z bkline $ ? ^^^ ^ ^^ ^ ^^ ^ --- + $Id: CDR0000315588.xml 12311 2014-02-05 19:28:53Z volker $ ? ^^^ ^ ^^ ^ ^^ ^^^ +
- <!-- $Id: CDR0000000157.xml 12275 2014-01-13 15:47:53Z bkline $ --> ? -- ^^^^ ^ ^^ ^ --- + <!-- $Id: CDR0000000157.xml 12092 2013-10-30 19:22:53Z volker $ --> ? ++ ^ ++ + ^ ^^ ^^^ + - $Id: CDR0000000157.xml 12275 2014-01-13 15:47:53Z bkline $ ? -- ^^^^ ^ ^^ ^ --- + $Id: CDR0000000157.xml 12092 2013-10-30 19:22:53Z volker $ ? ++ ^ ++ + ^ ^^ ^^^ + - <!-- - --> ? - + <!-- ? ++ + --> - <!-- - --> ? - + <!-- ? ++ + -->
- <!-- $Id: CDR0000660145.xml 12275 2014-01-13 15:47:53Z bkline $ --> + <!-- $Id$ --> - Template to sort the TermMenus - Template to remove the TermMenu and SqlResult elements from the output - Template to sort the FamilialCancerSyndrome - <xsl:template match = "GeneticsProfessionalDetails" ? ^^^^^^^^^^^^^^^^^^^^^^^^^^^ + <xsl:template match = "*"> ? ^ + - mode = "copy"> + <xsl:apply-templates mode = "copy"/> - <xsl:apply-templates select = "*[not(self::FamilialCancerSyndrome)] - [not(self::MemberOfGeneticsSociety)]" - mode = "copy"/> - <xsl:apply-templates select = "FamilialCancerSyndrome" - mode = "sorting"> - <xsl:sort select = "Term/DisplayName"/> - </xsl:apply-templates> - <xsl:apply-templates select = "MemberOfGeneticsSociety" - mode = "copy"/> - <!-- - =========================================================================== - Template to sort the FamilialCancerSyndrome - =========================================================================== --> - <xsl:template match = "FamilialCancerSyndrome" - mode = "sorting"> - <xsl:apply-templates select = "."/> - </xsl:template> - - - <!-- - =========================================================================== - =========================================================================== --> - <xsl:template match = "@* | node()"> - <xsl:copy> - <xsl:apply-templates select = "@* | node()" - mode = "copy"/> - </xsl:copy> - </xsl:template> -
- <!-- Filter title: Media QC Report Filter --> - $Id: CDR0000433163.xml 12275 2014-01-13 15:47:53Z bkline $ + $Id: CDR0000433163.xml,v 1.7 2008/12/10 22:10:17 venglisc Exp $ - $Log: not supported by cvs2svn $ + $Log: CDR0000433163.xml,v $ + Revision 1.7 2008/12/10 22:10:17 venglisc + Modified to handle new Glossary structure (Bug 4366) + - <xsl:apply-templates select = "PermissionInformation"/> - </xsl:template> - - - <!-- - ======================================================================= - Template to display Physical Media Information - ======================================================================= --> - <xsl:template match = "PermissionInformation"> - <p/> - <span class="lbold">Permission Information</span> - - <table xsl:use-attribute-sets = "table"> - <tr> - <td xsl:use-attribute-sets = "cell1of2"> - <b>Permission Requested</b> - </td> - <td xsl:use-attribute-sets = "cell2of2"> - <xsl:value-of select = "PermissionRequested"/> - </td> - </tr> - <xsl:if test = "PermissionRequestDate"> - <tr> - <td xsl:use-attribute-sets = "cell1of2"> - <b>Request Date</b> - </td> - <td xsl:use-attribute-sets = "cell2of2"> - <xsl:value-of select = "PermissionRequestDate"/> - </td> - </tr> - </xsl:if> - <xsl:if test = "PermissionResponse"> - <tr> - <td xsl:use-attribute-sets = "cell1of2"> - <b>Response</b> - </td> - <td xsl:use-attribute-sets = "cell2of2"> - <xsl:value-of select = "PermissionResponse"/> - </td> - </tr> - </xsl:if> - <xsl:if test = "PermissionResponseDate"> - <tr> - <td xsl:use-attribute-sets = "cell1of2"> - <b>Response Date</b> - </td> - <td xsl:use-attribute-sets = "cell2of2"> - <xsl:value-of select = "PermissionResponseDate"/> - </td> - </tr> - </xsl:if> - <xsl:if test = "PermissionExpirationDate"> - <tr> - <td xsl:use-attribute-sets = "cell1of2"> - <b>Expiration</b> - </td> - <td> - <xsl:value-of select = "PermissionExpirationDate"/> - </td> - </tr> - </xsl:if> - <xsl:if test = "PublisherPermissionText"> - <tr> - <td xsl:use-attribute-sets = "cell1of2"> - <b>Publisher Text</b> - </td> - <td> - <xsl:value-of select = "PublisherPermissionText"/> - </td> - </tr> - </xsl:if> - - <xsl:apply-templates select = "ApprovedUse"/> - - <xsl:if test = "SpanishTranslationPermissionRequested"> - <tr> - <td xsl:use-attribute-sets = "cell1of2"> - <b>Spanish Permission Requested</b> - </td> - <td> - <xsl:value-of select = "SpanishTranslationPermissionRequested"/> - </td> - </tr> - </xsl:if> - <xsl:if test = "SpanishTranslationPermissionResponse"> - <tr> - <td xsl:use-attribute-sets = "cell1of2"> - <b>Spanish Permission Response</b> - </td> - <td> - <xsl:value-of select = "SpanishTranslationPermissionResponse"/> - </td> - </tr> - </xsl:if> - <xsl:if test = "Comment"> - <tr> - <td xsl:use-attribute-sets = "cell1of2"> - <b>Comment</b> - </td> - <td> - <ul> - <xsl:for-each select = "Comment"> - <li> - <xsl:value-of select = "."/> - </li> - </xsl:for-each> - </ul> - </td> - </tr> - </xsl:if> - </table> - <p/> - </xsl:template> - - - <!-- - ======================================================================= - Template to display the Proposed Use Information - ======================================================================= --> - <xsl:template match = "ApprovedUse"> - <tr> - <td xsl:use-attribute-sets = "cell1of2"> - <b>Approved Use</b> - </td> - <td xsl:use-attribute-sets = "cell2of2"> - <xsl:apply-templates select = "Summary | Glossary"/> - </td> - </tr> - <tr> - <td><br/></td> - </tr>
- Template to collect all RelatedInformation elements + Denormalize the GlossaryTermConcept information - Template to create the RelatedSummaryRef element + Denormalize the GlossaryTermConcept information - Template to create the RelatedDrugSummaryLink element + Denormalize the GlossaryTermConcept information
- <!-- $Id: CDR0000613261.xml 10297 2012-01-19 16:27:44Z volker $ --> ? - ^ ^^^^ ^ ^ ^ ^ + <!-- $Id: CDR0000613261.xml 12091 2013-10-30 17:25:24Z volker $ --> ? + ^ ^ ^^^^ ^ ^ ^ - $Id: CDR0000613261.xml 10297 2012-01-19 16:27:44Z volker $ ? - ^ ^^^^ ^ ^ ^ ^ + $Id: CDR0000613261.xml 12091 2013-10-30 17:25:24Z volker $ ? + ^ ^ ^^^^ ^ ^ ^ + OCECDR-3528: Ability to put links to other Dictionary terms in More + Information block on Cancer.gov
- $Id: CDR0000349690.xml 11692 2013-05-09 18:58:36Z bkline $ ? ^^ --- ^ ^ ^^ + $Id: CDR0000349690.xml 11635 2013-04-15 17:59:59Z bkline $ ? ^^ +++ ^ ^ ^^
✓
- </rule> - </pattern> - - <!--=================================================================--> - If there's more than one RelatedExternalRef, each one must have a - UseWith attribute, otherwise Publish Preview objects. - <!--=================================================================--> - <pattern> - <rule context = '/GlossaryTermConcept/RelatedInformation'> - <assert test = - "(count(/GlossaryTermConcept/RelatedInformation - /RelatedExternalRef) < 2) or ( - count(/GlossaryTermConcept/RelatedInformation - /RelatedExternalRef) = - count(/GlossaryTermConcept/RelatedInformation - /RelatedExternalRef/@UseWith))" - >If more than one RelatedExternalRef, each must have UseWith attr</assert> - <!-- Language(s) of linking document; e.g.: UseWith='en' or 'es' --> ? - ----- + <!-- Language(s) of linking document; e.g.: UseWith='en sp' --> ? + - type = 'UseWithLanguage' ? ^^^^^^^^^^^^^^^ + type = 'NMTOKENS' ? ^^^^^^^^ - <!-- Language(s) of linking document; e.g.: UseWith='en' or 'es' --> ? - ----- + <!-- Language(s) of linking document; e.g.: UseWith='en sp' --> ? + - type = 'UseWithLanguage' ? ^^^^^^^^^^^^^^^ + type = 'NMTOKENS' ? ^^^^^^^^ - <simpleType name = 'UseWithLanguage'> - <restriction base = 'string'> - <enumeration value = 'en'/> - <enumeration value = 'es'/> - </restriction> - </simpleType> -
- $Id: InScopeProtocol.xml 12015 2013-09-10 13:11:00Z bkline $ ? ^^ ^ --- + $Id: InScopeProtocol.xml 12027 2013-09-19 13:15:21Z bkline $ ? ^^ ^ +++ + JIRA::OCECDR-3665