Example grid report template—CCSAMP search Chunk text with DSC search parameter usage

Create the following text template file and name it CCSAMP-Srch-Grid.tpl.

CCSAMP-Srch-Grid-using-Search-criteria.tpl

{!-- Ventyx-Datasource-Aliases: DSC_PARAMETERS --}
From the DSC:
{.loop in $DSC_PARAMETERS as $DSC}
agreedDateDelta #: {$DSC.AGREEDDATEDELTA:}
agreedDateSearchOption #: {$DSC.AGREEDDATESEARCHOPTION:}
agreedFrom #: {$DSC.AGREEDFROM:}
agreedTo #: {$DSC.AGREEDTO:}
analysedDateDelta #: {$DSC.ANALYSEDDATEDELTA:}
analysedDateSearchOption #: {$DSC.ANALYSEDDATESEARCHOPTION:}
analysedFrom #: {$DSC.ANALYSEDFROM:}
analysedTo #: {$DSC.ANALYSEDTO:}
analyteCode #: {$DSC.ANALYTECODE:}
analyteDescription #: {$DSC.ANALYTEDESCRIPTION:}
analyteName #: {$DSC.ANALYTENAME:}
authorisedDateDelta #: {$DSC.AUTHORISEDDATEDELTA:}
authorisedDateSearchOption #: {$DSC.AUTHORISEDDATESEARCHOPTION:}
authorisedFrom #: {$DSC.AUTHORISEDFROM:}
authorisedTo #: {$DSC.AUTHORISEDTO:}
biofieldCategory1 #: {$DSC.BIOFIELDCATEGORY1:}
biofieldCategory2 #: {$DSC.BIOFIELDCATEGORY2:}
biofieldCategory3 #: {$DSC.BIOFIELDCATEGORY3:}
biofieldCodes #: {$DSC.BIOFIELDCODES:}
biofieldConstraint1 #: {$DSC.BIOFIELDCONSTRAINT1:}
biofieldConstraint2 #: {$DSC.BIOFIELDCONSTRAINT2:}
biofieldDateFrom1 #: {$DSC.BIOFIELDDATEFROM1:}
biofieldDateFrom2 #: {$DSC.BIOFIELDDATEFROM2:}
biofieldDateTo1 #: {$DSC.BIOFIELDDATETO1:}
biofieldDateTo2 #: {$DSC.BIOFIELDDATETO2:}
biofieldName1 #: {$DSC.BIOFIELDNAME1:}
biofieldName2 #: {$DSC.BIOFIELDNAME2:}
biofieldName3 #: {$DSC.BIOFIELDNAME3:}
biofieldNumeric1 #: {$DSC.BIOFIELDNUMERIC1:}
biofieldNumeric2 #: {$DSC.BIOFIELDNUMERIC2:}
biofieldOperand1 #: {$DSC.BIOFIELDOPERAND1:}
biofieldOperand2 #: {$DSC.BIOFIELDOPERAND2:}
biofieldString1 #: {$DSC.BIOFIELDSTRING1:}
biofieldString2 #: {$DSC.BIOFIELDSTRING2:}
clientCode #: {$DSC.CLIENTCODE:}
clientName #: {$DSC.CLIENTNAME:}
clientSampleName #: {$DSC.CLIENTSAMPLENAME:}
clientSubmissionNumber #: {$DSC.CLIENTSUBMISSIONNUMBER:}
code #: {$DSC.CODE:}
codeOrNameFilter #: {$DSC.CODEORNAMEFILTER:}
completedDateDelta #: {$DSC.COMPLETEDDATEDELTA:}
completedDateSearchOption #: {$DSC.COMPLETEDDATESEARCHOPTION:}
completedFrom #: {$DSC.COMPLETEDFROM:}
completedTo #: {$DSC.COMPLETEDTO:}
compositeQcStatus #: {$DSC.COMPOSITEQCSTATUS:}
compositeSpecStatus #: {$DSC.COMPOSITESPECSTATUS:}
contactCode #: {$DSC.CONTACTCODE:}
contactId #: {$DSC.CONTACTID:}
contactName #: {$DSC.CONTACTNAME:}
contract #: {$DSC.CONTRACT:}
contractSubmissionNumber #: {$DSC.CONTRACTSUBMISSIONNUMBER:}
costCentreCode #: {$DSC.COSTCENTRECODE:}
costCentreDescription #: {$DSC.COSTCENTREDESCRIPTION:}
costCentreName #: {$DSC.COSTCENTRENAME:}
description #: {$DSC.DESCRIPTION:}
ersCode #: {$DSC.ERSCODE:}
ersDescription #: {$DSC.ERSDESCRIPTION:}
ersName #: {$DSC.ERSNAME:}
excludedRepReqId #: {$DSC.EXCLUDEDREPREQID:}
finalisedDateDelta #: {$DSC.FINALISEDDATEDELTA:}
finalisedDateSearchOption #: {$DSC.FINALISEDDATESEARCHOPTION:}
finalisedFrom #: {$DSC.FINALISEDFROM:}
finalisedTo #: {$DSC.FINALISEDTO:}
firstReportedDateDelta #: {$DSC.FIRSTREPORTEDDATEDELTA:}
firstReportedDateSearchOption #: {$DSC.FIRSTREPORTEDDATESEARCHOPTION:}
firstReportedFrom #: {$DSC.FIRSTREPORTEDFROM:}
firstReportedTo #: {$DSC.FIRSTREPORTEDTO:}
id #: {$DSC.ID:}
ids #: {$DSC.IDS:}
invoiceToClientCode #: {$DSC.INVOICETOCLIENTCODE:}
invoiceToClientName #: {$DSC.INVOICETOCLIENTNAME:}
isActive #: {$DSC.ISACTIVE:}
isArchivedSearchOption #: {$DSC.ISARCHIVEDSEARCHOPTION:}
isDistinctSearch #: {$DSC.ISDISTINCTSEARCH:}
isExcludeReportRequestJob #: {$DSC.ISEXCLUDEREPORTREQUESTJOB:}
isExclusiveScope #: {$DSC.ISEXCLUSIVESCOPE:}
isOrganisationScope #: {$DSC.ISORGANISATIONSCOPE:}
isPromotable #: {$DSC.ISPROMOTABLE:}
isTextOmitted #: {$DSC.ISTEXTOMITTED:}
jobCategoryCode #: {$DSC.JOBCATEGORYCODE:}
jobType #: {$DSC.JOBTYPE:}
laboratoryCode #: {$DSC.LABORATORYCODE:}
laboratoryId #: {$DSC.LABORATORYID:}
lastActivatedDateDelta #: {$DSC.LASTACTIVATEDDATEDELTA:}
lastActivatedDateSearchOption #: {$DSC.LASTACTIVATEDDATESEARCHOPTION:}
lastActivatedFrom #: {$DSC.LASTACTIVATEDFROM:}
lastActivatedTo #: {$DSC.LASTACTIVATEDTO:}
lastArchivedDateDelta #: {$DSC.LASTARCHIVEDDATEDELTA:}
lastArchivedDateSearchOption #: {$DSC.LASTARCHIVEDDATESEARCHOPTION:}
lastArchivedFrom #: {$DSC.LASTARCHIVEDFROM:}
lastArchivedTo #: {$DSC.LASTARCHIVEDTO:}
lastInvoicedDateDelta #: {$DSC.LASTINVOICEDDATEDELTA:}
lastInvoicedDateSearchOption #: {$DSC.LASTINVOICEDDATESEARCHOPTION:}
lastInvoicedFrom #: {$DSC.LASTINVOICEDFROM:}
lastInvoicedTo #: {$DSC.LASTINVOICEDTO:}
lastReportedDateDelta #: {$DSC.LASTREPORTEDDATEDELTA:}
lastReportedDateSearchOption #: {$DSC.LASTREPORTEDDATESEARCHOPTION:}
lastReportedFrom #: {$DSC.LASTREPORTEDFROM:}
lastReportedTo #: {$DSC.LASTREPORTEDTO:}
name #: {$DSC.NAME:}
nameOrDescriptionFilter #: {$DSC.NAMEORDESCRIPTIONFILTER:}
organisationCodes #: {$DSC.ORGANISATIONCODES:}
organisationCode #: {$DSC.ORGANISATIONCODE:}
organisationId #: {$DSC.ORGANISATIONID:}
ownerChangedDateDelta #: {$DSC.OWNERCHANGEDDATEDELTA:}
ownerChangedDateSearchOption #: {$DSC.OWNERCHANGEDDATESEARCHOPTION:}
ownerChangedFrom #: {$DSC.OWNERCHANGEDFROM:}
ownerChangedTo #: {$DSC.OWNERCHANGEDTO:}
ownerUserCode #: {$DSC.OWNERUSERCODE:}
possibleDateDelta #: {$DSC.POSSIBLEDATEDELTA:}
possibleDateSearchOption #: {$DSC.POSSIBLEDATESEARCHOPTION:}
possibleFrom #: {$DSC.POSSIBLEFROM:}
possibleTo #: {$DSC.POSSIBLETO:}
priority #: {$DSC.PRIORITY:}
projectCode #: {$DSC.PROJECTCODE:}
projectName #: {$DSC.PROJECTNAME:}
receivedDateDelta #: {$DSC.RECEIVEDDATEDELTA:}
receivedDateSearchOption #: {$DSC.RECEIVEDDATESEARCHOPTION:}
receivedFrom #: {$DSC.RECEIVEDFROM:}
receivedTo #: {$DSC.RECEIVEDTO:}
receptionUserCode #: {$DSC.RECEPTIONUSERCODE:}
registeredDateDelta #: {$DSC.REGISTEREDDATEDELTA:}
registeredDateSearchOption #: {$DSC.REGISTEREDDATESEARCHOPTION:}
registeredFrom #: {$DSC.REGISTEREDFROM:}
registeredTo #: {$DSC.REGISTEREDTO:}
registrationUserCode #: {$DSC.REGISTRATIONUSERCODE:}
releasedDateDelta #: {$DSC.RELEASEDDATEDELTA:}
releasedDateSearchOption #: {$DSC.RELEASEDDATESEARCHOPTION:}
releasedFrom #: {$DSC.RELEASEDFROM:}
releasedTo #: {$DSC.RELEASEDTO:}
requiredDateDelta #: {$DSC.REQUIREDDATEDELTA:}
requiredDateSearchOption #: {$DSC.REQUIREDDATESEARCHOPTION:}
requiredFrom #: {$DSC.REQUIREDFROM:}
requiredTo #: {$DSC.REQUIREDTO:}
sampleAnalysedDateDelta #: {$DSC.SAMPLEANALYSEDDATEDELTA:}
sampleAnalysedDateSearchOption #: {$DSC.SAMPLEANALYSEDDATESEARCHOPTION:}
sampleAnalysedFrom #: {$DSC.SAMPLEANALYSEDFROM:}
sampleAnalysedTo #: {$DSC.SAMPLEANALYSEDTO:}
sampleCode #: {$DSC.SAMPLECODE:}
sampleCompletedDateDelta #: {$DSC.SAMPLECOMPLETEDDATEDELTA:}
sampleCompletedDateSearchOption #: {$DSC.SAMPLECOMPLETEDDATESEARCHOPTIO:}
sampleCompletedFrom #: {$DSC.SAMPLECOMPLETEDFROM:}
sampleCompletedTo #: {$DSC.SAMPLECOMPLETEDTO:}
sampleDescription #: {$DSC.SAMPLEDESCRIPTION:}
sampleFirstReportedDateDelta #: {$DSC.SAMPLEFIRSTREPORTEDDATEDELTA:}
sampleFirstReportedDateSearchOption #: {$DSC.SAMPLEFIRSTREPORTEDDATESEARCHO:}
sampleFirstReportedFrom #: {$DSC.SAMPLEFIRSTREPORTEDFROM:}
sampleFirstReportedTo #: {$DSC.SAMPLEFIRSTREPORTEDTO:}
sampleLastActivatedDateDelta #: {$DSC.SAMPLELASTACTIVATEDDATEDELTA:}
sampleLastActivatedDateSearchOption #: {$DSC.SAMPLELASTACTIVATEDDATESEARCHO:}
sampleLastActivatedFrom #: {$DSC.SAMPLELASTACTIVATEDFROM:}
sampleLastActivatedTo #: {$DSC.SAMPLELASTACTIVATEDTO:}
sampleLastReportedDateDelta #: {$DSC.SAMPLELASTREPORTEDDATEDELTA:}
sampleLastReportedDateSearchOption #: {$DSC.SAMPLELASTREPORTEDDATESEARCHOP:}
sampleLastReportedFrom #: {$DSC.SAMPLELASTREPORTEDFROM:}
sampleLastReportedTo #: {$DSC.SAMPLELASTREPORTEDTO:}
sampleName #: {$DSC.SAMPLENAME:}
sampleProductCode #: {$DSC.SAMPLEPRODUCTCODE:}
sampleReceivedDateDelta #: {$DSC.SAMPLERECEIVEDDATEDELTA:}
sampleReceivedDateSearchOption #: {$DSC.SAMPLERECEIVEDDATESEARCHOPTION:}
sampleReceivedFrom #: {$DSC.SAMPLERECEIVEDFROM:}
sampleReceivedTo #: {$DSC.SAMPLERECEIVEDTO:}
sampleRegisteredDateDelta #: {$DSC.SAMPLEREGISTEREDDATEDELTA:}
sampleRegisteredDateSearchOption #: {$DSC.SAMPLEREGISTEREDDATESEARCHOPTI:}
sampleRegisteredFrom #: {$DSC.SAMPLEREGISTEREDFROM:}
sampleRegisteredTo #: {$DSC.SAMPLEREGISTEREDTO:}
sampleRequiredDateDelta #: {$DSC.SAMPLEREQUIREDDATEDELTA:}
sampleRequiredDateSearchOption #: {$DSC.SAMPLEREQUIREDDATESEARCHOPTION:}
sampleRequiredFrom #: {$DSC.SAMPLEREQUIREDFROM:}
sampleRequiredTo #: {$DSC.SAMPLEREQUIREDTO:}
sampleStartedDateDelta #: {$DSC.SAMPLESTARTEDDATEDELTA:}
sampleStartedDateSearchOption #: {$DSC.SAMPLESTARTEDDATESEARCHOPTION:}
sampleStartedFrom #: {$DSC.SAMPLESTARTEDFROM:}
sampleStartedTo #: {$DSC.SAMPLESTARTEDTO:}
sampleValidatedDateDelta #: {$DSC.SAMPLEVALIDATEDDATEDELTA:}
sampleValidatedDateSearchOption #: {$DSC.SAMPLEVALIDATEDDATESEARCHOPTIO:}
sampleValidatedFrom #: {$DSC.SAMPLEVALIDATEDFROM:}
sampleValidatedTo #: {$DSC.SAMPLEVALIDATEDTO:}
sampleWorkflowStatus #: {$DSC.SAMPLEWORKFLOWSTATUS:}
schemeAnalysedDateDelta #: {$DSC.SCHEMEANALYSEDDATEDELTA:}
schemeAnalysedDateSearchOption #: {$DSC.SCHEMEANALYSEDDATESEARCHOPTION:}
schemeAnalysedFrom #: {$DSC.SCHEMEANALYSEDFROM:}
schemeAnalysedTo #: {$DSC.SCHEMEANALYSEDTO:}
schemeCode #: {$DSC.SCHEMECODE:}
schemeCompletedDateDelta #: {$DSC.SCHEMECOMPLETEDDATEDELTA:}
schemeCompletedDateSearchOption #: {$DSC.SCHEMECOMPLETEDDATESEARCHOPTIO:}
schemeCompletedFrom #: {$DSC.SCHEMECOMPLETEDFROM:}
schemeCompletedTo #: {$DSC.SCHEMECOMPLETEDTO:}
schemeDescription #: {$DSC.SCHEMEDESCRIPTION:}
schemeName #: {$DSC.SCHEMENAME:}
schemeReleasedDateDelta #: {$DSC.SCHEMERELEASEDDATEDELTA:}
schemeReleasedDateSearchOption #: {$DSC.SCHEMERELEASEDDATESEARCHOPTION:}
schemeReleasedFrom #: {$DSC.SCHEMERELEASEDFROM:}
schemeReleasedTo #: {$DSC.SCHEMERELEASEDTO:}
schemeStartedDateDelta #: {$DSC.SCHEMESTARTEDDATEDELTA:}
schemeStartedDateSearchOption #: {$DSC.SCHEMESTARTEDDATESEARCHOPTION:}
schemeStartedFrom #: {$DSC.SCHEMESTARTEDFROM:}
schemeStartedTo #: {$DSC.SCHEMESTARTEDTO:}
schemeValidatedDateDelta #: {$DSC.SCHEMEVALIDATEDDATEDELTA:}
schemeValidatedDateSearchOption #: {$DSC.SCHEMEVALIDATEDDATESEARCHOPTIO:}
schemeValidatedFrom #: {$DSC.SCHEMEVALIDATEDFROM:}
schemeValidatedTo #: {$DSC.SCHEMEVALIDATEDTO:}
schemeVersion #: {$DSC.SCHEMEVERSION:}
schemeVersionOrName #: {$DSC.SCHEMEVERSIONORNAME:}
schemeWorkflowStatus #: {$DSC.SCHEMEWORKFLOWSTATUS:}
searchScope #: {$DSC.SEARCHSCOPE:}
sectionCode #: {$DSC.SECTIONCODE:}
sectionDescription #: {$DSC.SECTIONDESCRIPTION:}
sectionName #: {$DSC.SECTIONNAME:}
stakeholderClientCode #: {$DSC.STAKEHOLDERCLIENTCODE:}
stakeholderClientDescription #: {$DSC.STAKEHOLDERCLIENTDESCRIPTION:}
stakeholderClientName #: {$DSC.STAKEHOLDERCLIENTNAME:}
stakeholderContactCode #: {$DSC.STAKEHOLDERCONTACTCODE:}
stakeholderContactName #: {$DSC.STAKEHOLDERCONTACTNAME:}
stakeholderUserCode #: {$DSC.STAKEHOLDERUSERCODE:}
startedDateDelta #: {$DSC.STARTEDDATEDELTA:}
startedDateSearchOption #: {$DSC.STARTEDDATESEARCHOPTION:}
startedFrom #: {$DSC.STARTEDFROM:}
startedTo #: {$DSC.STARTEDTO:}
syntaxCode #: {$DSC.SYNTAXCODE:}
validatedDateDelta #: {$DSC.VALIDATEDDATEDELTA:}
validatedDateSearchOption #: {$DSC.VALIDATEDDATESEARCHOPTION:}
validatedFrom #: {$DSC.VALIDATEDFROM:}
validatedTo #: {$DSC.VALIDATEDTO:}
workflowStatus #: {$DSC.WORKFLOWSTATUS:}

{.onEmpty}
No sample data found.
{/loop}

Since this report template is to create a report of the search results in the CCSAMP—Search Sample application, then the RSSampleSearch data source is, by default, available to the report template, however, it does not reference it. The report template, however, uses the DSC_PARAMETERS data source, so a DSC file is required to build it. Therefore the template comprises the TPL file and the DSC file, that is, a ZIP file containing both these files.

Create the following file and name it CCSAMP-Srch-Grid-using-Search-criteria.dsc.

CCSAMP-Srch-Grid-using-Search-criteria.dsc

<?xml version="1.0" ?> 
<SQL>
    <SQLQUERY>
        <SQLTABLE>DSC_PARAMETERS</SQLTABLE>
        <SQLCOMMAND>
        select 'Parameters' as Parameters
            {{, ('^agreedDateDelta') as agreedDateDelta}}
            {{, ('^agreedDateSearchOption') as agreedDateSearchOption}}
            {{, ('^agreedFrom') as agreedFrom}}
            {{, ('^agreedTo') as agreedTo}}
            {{, ('^analysedDateDelta') as analysedDateDelta}}
            {{, ('^analysedDateSearchOption') as analysedDateSearchOption}}
            {{, ('^analysedFrom') as analysedFrom}}
            {{, ('^analysedTo') as analysedTo}}
            {{, ('^analyteCode') as analyteCode}}
            {{, ('^analyteDescription') as analyteDescription}}
            {{, ('^analyteName') as analyteName}}
            {{, ('^authorisedDateDelta') as authorisedDateDelta}}
            {{, ('^authorisedDateSearchOption') as authorisedDateSearchOption}}
            {{, ('^authorisedFrom') as authorisedFrom}}
            {{, ('^authorisedTo') as authorisedTo}}
            {{, ('^iofieldCategory1') as biofieldCategory1}}
            {{, ('^iofieldCategory2') as biofieldCategory2}}
            {{, ('^iofieldCategory3') as biofieldCategory3}}
            {{, ('^iofieldCodes') as biofieldCodes}}
            {{, ('^iofieldConstraint1') as biofieldConstraint1}}
            {{, ('^iofieldConstraint2') as biofieldConstraint2}}
            {{, ('^iofieldDateFrom1') as biofieldDateFrom1}}
            {{, ('^iofieldDateFrom2') as biofieldDateFrom2}}
            {{, ('^iofieldDateTo1') as biofieldDateTo1}}
            {{, ('^iofieldDateTo2') as biofieldDateTo2}}
            {{, ('^iofieldName1') as biofieldName1}}
            {{, ('^iofieldName2') as biofieldName2}}
            {{, ('^iofieldName3') as biofieldName3}}
            {{, ('^iofieldNumeric1') as biofieldNumeric1}}
            {{, ('^iofieldNumeric2') as biofieldNumeric2}}
            {{, ('^iofieldOperand1') as biofieldOperand1}}
            {{, ('^iofieldOperand2') as biofieldOperand2}}
            {{, ('^iofieldString1') as biofieldString1}}
            {{, ('^iofieldString2') as biofieldString2}}
            {{, ('^clientCode') as clientCode}}
            {{, ('^clientName') as clientName}}
            {{, ('^clientSampleName') as clientSampleName}}
            {{, ('^clientSubmissionNumber') as clientSubmissionNumber}}
            {{, ('^code') as code}}
            {{, ('^codeOrNameFilter') as codeOrNameFilter}}
            {{, ('^completedDateDelta') as completedDateDelta}}
            {{, ('^completedDateSearchOption') as completedDateSearchOption}}
            {{, ('^completedFrom') as completedFrom}}
            {{, ('^completedTo') as completedTo}}
            {{, ('^compositeQcStatus') as compositeQcStatus}}
            {{, ('^compositeSpecStatus') as compositeSpecStatus}}
            {{, ('^contactCode') as contactCode}}
            {{, ('^contactId') as contactId}}
            {{, ('^contactName') as contactName}}
            {{, ('^contract') as contract}}
            {{, ('^contractSubmissionNumber') as contractSubmissionNumber}}
            {{, ('^costCentreCode') as costCentreCode}}
            {{, ('^costCentreDescription') as costCentreDescription}}
            {{, ('^costCentreName') as costCentreName}}
            {{, ('^description') as description}}
            {{, ('^ersCode') as ersCode}}
            {{, ('^ersDescription') as ersDescription}}
            {{, ('^ersName') as ersName}}
            {{, ('^excludedRepReqId') as excludedRepReqId}}
            {{, ('^finalisedDateDelta') as finalisedDateDelta}}
            {{, ('^finalisedDateSearchOption') as finalisedDateSearchOption}}
            {{, ('^finalisedFrom') as finalisedFrom}}
            {{, ('^finalisedTo') as finalisedTo}}
            {{, ('^firstReportedDateDelta') as firstReportedDateDelta}}
            {{, ('^firstReportedDateSearchOption') as firstReportedDateSearchOption}}
            {{, ('^firstReportedFrom') as firstReportedFrom}}
            {{, ('^firstReportedTo') as firstReportedTo}}
            {{, ('^id') as id}}
            {{, ('^ids') as ids}}
            {{, ('^invoiceToClientCode') as invoiceToClientCode}}
            {{, ('^invoiceToClientName') as invoiceToClientName}}
            {{, ('^isActive') as isActive}}
            {{, ('^isArchivedSearchOption') as isArchivedSearchOption}}
            {{, ('^isDistinctSearch') as isDistinctSearch}}
            {{, ('^isExcludeReportRequestJob') as isExcludeReportRequestJob}}
            {{, ('^isExclusiveScope') as isExclusiveScope}}
            {{, ('^isOrganisationScope') as isOrganisationScope}}
            {{, ('^isPromotable') as isPromotable}}
            {{, ('^isTextOmitted') as isTextOmitted}}
            {{, ('^jobCategoryCode') as jobCategoryCode}}
            {{, ('^jobType') as jobType}}
            {{, ('^laboratoryCode') as laboratoryCode}}
            {{, ('^laboratoryId') as laboratoryId}}
            {{, ('^lastActivatedDateDelta') as lastActivatedDateDelta}}
            {{, ('^lastActivatedDateSearchOption') as lastActivatedDateSearchOption}}
            {{, ('^lastActivatedFrom') as lastActivatedFrom}}
            {{, ('^lastActivatedTo') as lastActivatedTo}}
            {{, ('^lastArchivedDateDelta') as lastArchivedDateDelta}}
            {{, ('^lastArchivedDateSearchOption') as lastArchivedDateSearchOption}}
            {{, ('^lastArchivedFrom') as lastArchivedFrom}}
            {{, ('^lastArchivedTo') as lastArchivedTo}}
            {{, ('^lastInvoicedDateDelta') as lastInvoicedDateDelta}}
            {{, ('^lastInvoicedDateSearchOption') as lastInvoicedDateSearchOption}}
            {{, ('^lastInvoicedFrom') as lastInvoicedFrom}}
            {{, ('^lastInvoicedTo') as lastInvoicedTo}}
            {{, ('^lastReportedDateDelta') as lastReportedDateDelta}}
            {{, ('^lastReportedDateSearchOption') as lastReportedDateSearchOption}}
            {{, ('^lastReportedFrom') as lastReportedFrom}}
            {{, ('^lastReportedTo') as lastReportedTo}}
            {{, ('^name') as name}}
            {{, ('^nameOrDescriptionFilter') as nameOrDescriptionFilter}}
            {{, ('^organisationCodes') as organisationCodes}}
            {{, ('^organisationCode') as organisationCode}}
            {{, ('^organisationId') as organisationId}}
            {{, ('^ownerChangedDateDelta') as ownerChangedDateDelta}}
            {{, ('^ownerChangedDateSearchOption') as ownerChangedDateSearchOption}}
            {{, ('^ownerChangedFrom') as ownerChangedFrom}}
            {{, ('^ownerChangedTo') as ownerChangedTo}}
            {{, ('^ownerUserCode') as ownerUserCode}}
            {{, ('^possibleDateDelta') as possibleDateDelta}}
            {{, ('^possibleDateSearchOption') as possibleDateSearchOption}}
            {{, ('^possibleFrom') as possibleFrom}}
            {{, ('^possibleTo') as possibleTo}}
            {{, ('^priority') as priority}}
            {{, ('^projectCode') as projectCode}}
            {{, ('^projectName') as projectName}}
            {{, ('^receivedDateDelta') as receivedDateDelta}}
            {{, ('^receivedDateSearchOption') as receivedDateSearchOption}}
            {{, ('^receivedFrom') as receivedFrom}}
            {{, ('^receivedTo') as receivedTo}}
            {{, ('^receptionUserCode') as receptionUserCode}}
            {{, ('^registeredDateDelta') as registeredDateDelta}}
            {{, ('^registeredDateSearchOption') as registeredDateSearchOption}}
            {{, ('^registeredFrom') as registeredFrom}}
            {{, ('^registeredTo') as registeredTo}}
            {{, ('^registrationUserCode') as registrationUserCode}}
            {{, ('^releasedDateDelta') as releasedDateDelta}}
            {{, ('^releasedDateSearchOption') as releasedDateSearchOption}}
            {{, ('^releasedFrom') as releasedFrom}}
            {{, ('^releasedTo') as releasedTo}}
            {{, ('^requiredDateDelta') as requiredDateDelta}}
            {{, ('^requiredDateSearchOption') as requiredDateSearchOption}}
            {{, ('^requiredFrom') as requiredFrom}}
            {{, ('^requiredTo') as requiredTo}}
            {{, ('^sampleAnalysedDateDelta') as sampleAnalysedDateDelta}}
            {{, ('^sampleAnalysedDateSearchOption') as sampleAnalysedDateSearchOption}}
            {{, ('^sampleAnalysedFrom') as sampleAnalysedFrom}}
            {{, ('^sampleAnalysedTo') as sampleAnalysedTo}}
            {{, ('^sampleCode') as sampleCode}}
            {{, ('^sampleCompletedDateDelta') as sampleCompletedDateDelta}}
            {{, ('^sampleCompletedDateSearchOption') as sampleCompletedDateSearchOptio}}
            {{, ('^sampleCompletedFrom') as sampleCompletedFrom}}
            {{, ('^sampleCompletedTo') as sampleCompletedTo}}
            {{, ('^sampleDescription') as sampleDescription}}
            {{, ('^sampleFirstReportedDateDelta') as sampleFirstReportedDateDelta}}
            {{, ('^sampleFirstReportedDateSearchOption') as sampleFirstReportedDateSearchOption}}
            {{, ('^sampleFirstReportedFrom') as sampleFirstReportedFrom}}
            {{, ('^sampleFirstReportedTo') as sampleFirstReportedTo}}
            {{, ('^sampleLastActivatedDateDelta') as sampleLastActivatedDateDelta}}
            {{, ('^sampleLastActivatedDateSearchOption') as sampleLastActivatedDateSearchO}}
            {{, ('^sampleLastActivatedFrom') as sampleLastActivatedFrom}}
            {{, ('^sampleLastActivatedTo') as sampleLastActivatedTo}}
            {{, ('^sampleLastReportedDateDelta') as sampleLastReportedDateDelta}}
            {{, ('^sampleLastReportedDateSearchOption') as sampleLastReportedDateSearchOp}}
            {{, ('^sampleLastReportedFrom') as sampleLastReportedFrom}}
            {{, ('^sampleLastReportedTo') as sampleLastReportedTo}}
            {{, ('^sampleName') as sampleName}}
            {{, ('^sampleProductCode') as sampleProductCode}}
            {{, ('^sampleReceivedDateDelta') as sampleReceivedDateDelta}}
            {{, ('^sampleReceivedDateSearchOption') as sampleReceivedDateSearchOption}}
            {{, ('^sampleReceivedFrom') as sampleReceivedFrom}}
            {{, ('^sampleReceivedTo') as sampleReceivedTo}}
            {{, ('^sampleRegisteredDateDelta') as sampleRegisteredDateDelta}}
            {{, ('^sampleRegisteredDateSearchOption') as sampleRegisteredDateSearchOpti}}
            {{, ('^sampleRegisteredFrom') as sampleRegisteredFrom}}
            {{, ('^sampleRegisteredTo') as sampleRegisteredTo}}
            {{, ('^sampleRequiredDateDelta') as sampleRequiredDateDelta}}
            {{, ('^sampleRequiredDateSearchOption') as sampleRequiredDateSearchOption}}
            {{, ('^sampleRequiredFrom') as sampleRequiredFrom}}
            {{, ('^sampleRequiredTo') as sampleRequiredTo}}
            {{, ('^sampleStartedDateDelta') as sampleStartedDateDelta}}
            {{, ('^sampleStartedDateSearchOption') as sampleStartedDateSearchOption}}
            {{, ('^sampleStartedFrom') as sampleStartedFrom}}
            {{, ('^sampleStartedTo') as sampleStartedTo}}
            {{, ('^sampleValidatedDateDelta') as sampleValidatedDateDelta}}
            {{, ('^sampleValidatedDateSearchOption') as sampleValidatedDateSearchOption}}
            {{, ('^sampleValidatedFrom') as sampleValidatedFrom}}
            {{, ('^sampleValidatedTo') as sampleValidatedTo}}
            {{, ('^sampleWorkflowStatus') as sampleWorkflowStatus}}
            {{, ('^schemeAnalysedDateDelta') as schemeAnalysedDateDelta}}
            {{, ('^schemeAnalysedDateSearchOption') as schemeAnalysedDateSearchOption}}
            {{, ('^schemeAnalysedFrom') as schemeAnalysedFrom}}
            {{, ('^schemeAnalysedTo') as schemeAnalysedTo}}
            {{, ('^schemeCode') as schemeCode}}
            {{, ('^schemeCompletedDateDelta') as schemeCompletedDateDelta}}
            {{, ('^schemeCompletedDateSearchOption') as schemeCompletedDateSearchOption}}
            {{, ('^schemeCompletedFrom') as schemeCompletedFrom}}
            {{, ('^schemeCompletedTo') as schemeCompletedTo}}
            {{, ('^schemeDescription') as schemeDescription}}
            {{, ('^schemeName') as schemeName}}
            {{, ('^schemeReleasedDateDelta') as schemeReleasedDateDelta}}
            {{, ('^schemeReleasedDateSearchOption') as schemeReleasedDateSearchOption}}
            {{, ('^schemeReleasedFrom') as schemeReleasedFrom}}
            {{, ('^schemeReleasedTo') as schemeReleasedTo}}
            {{, ('^schemeStartedDateDelta') as schemeStartedDateDelta}}
            {{, ('^schemeStartedDateSearchOption') as schemeStartedDateSearchOption}}
            {{, ('^schemeStartedFrom') as schemeStartedFrom}}
            {{, ('^schemeStartedTo') as schemeStartedTo}}
            {{, ('^schemeValidatedDateDelta') as schemeValidatedDateDelta}}
            {{, ('^schemeValidatedDateSearchOption') as schemeValidatedDateSearchOption}}
            {{, ('^schemeValidatedFrom') as schemeValidatedFrom}}
            {{, ('^schemeValidatedTo') as schemeValidatedTo}}
            {{, ('^schemeVersion') as schemeVersion}}
            {{, ('^schemeVersionOrName') as schemeVersionOrName}}
            {{, ('^schemeWorkflowStatus') as schemeWorkflowStatus}}
            {{, ('^searchScope') as searchScope}}
            {{, ('^sectionCode') as sectionCode}}
            {{, ('^sectionDescription') as sectionDescription}}
            {{, ('^sectionName') as sectionName}}
            {{, ('^stakeholderClientCode') as stakeholderClientCode}}
            {{, ('^stakeholderClientDescription') as stakeholderClientDescription}}
            {{, ('^stakeholderClientName') as stakeholderClientName}}
            {{, ('^stakeholderContactCode') as stakeholderContactCode}}
            {{, ('^stakeholderContactName') as stakeholderContactName}}
            {{, ('^stakeholderUserCode') as stakeholderUserCode}}
            {{, ('^startedDateDelta') as startedDateDelta}}
            {{, ('^startedDateSearchOption') as startedDateSearchOption}}
            {{, ('^startedFrom') as startedFrom}}
            {{, ('^startedTo') as startedTo}}
            {{, ('^syntaxCode') as syntaxCode}}
            {{, ('^validatedDateDelta') as validatedDateDelta}}
            {{, ('^validatedDateSearchOption') as validatedDateSearchOption}}
            {{, ('^validatedFrom') as validatedFrom}}
            {{, ('^validatedTo') as validatedTo}}
            {{, ('^workflowStatus') as workflowStatus}}

    from
        Dual

        </SQLCOMMAND>
    </SQLQUERY>
</SQL>

Zip the CCSAMP-Srch-Grid-using-Search-criteria.tpl and CCSAMP-Srch-Grid-using-Search-criteria.dsc file to create CCSAMP-Srch-Grid-using-Search-criteria.zip file.
Create the following report template using the CCTPLR—Report Template application:

Organisation Scope: Selected

Report Template Code: CCSAMP-SRCH-2

Name: CCSAMP Search Grid

Is Active: Selected

Type: 00—Grid

File: Upload the CCSAMP-Srch-Grid.tpl file

Report Engine: 03—Text

Default Output Format: TXT—Text

Output File Name: CCSAMP_Search_Results.txt
Create the following application preference using the CCPREF—Preference application:

Scope: Instance, or other scope to restrict the report template availability when performing the export to report.

Preference Name: SEARCH_REPORT_CCSAMP

Description: Sample search reports available

Setting Type: STRING

Setting Value: Add CCSAMP-SRCH-2:Samples search criteria to the comma-separated list of available templates.

Preference Type: PREFERENCE

Is Active: Checked
Enter search criteria in the CCSAMP—Search Sample application and click Search.

Note: Until a search is performed, the Export to report button is unavailable. Entering new search criteria also makes this button unavailable.
Click Export to report to open the Export to Report dialog and enter the following report details:

Report Template Code: CCSAMP-SRCH-2

Download: Selected
Click OK to generate the grid report.

The DSC_PARAMETERS result set is built by the DSC.
Click the Click to download button, then click the button showing the name of the downloaded file to open and view the report.