<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<TAF Version="0x02000002">
  <Comments/>
  <Program>
    <ActionRef Ref="If">
      <ActionRef Ref="Search"/>
    </ActionRef>
    <ActionRef Ref="Return"/>
  </Program>
  <Actions>
    <IfAction Expanded="True" ID="If" Sig="if  ">
      <Expression><![CDATA[('<@ARG _function>'='search')]]></Expression>
      <ExpressionInfo>
        <ExpLeft><![CDATA[<@ARG _function>]]></ExpLeft>
        <ExpRight>search</ExpRight>
        <Operator>iseq</Operator>
      </ExpressionInfo>
    </IfAction>
    <SearchAction DSID="rcr_data" DeploymentDSID="rcr_data" ID="Search" Sig="srch">
      <Tables>
        <TableName>Catalog</TableName>
        <TableName>Artist</TableName>
        <TableName>ProvenanceKeywordsCatalogue</TableName>
      </Tables>
      <DataDictionary>
        <Column ColumnType="0" DataType="vcha">
          <TableName>Catalog</TableName>
          <ColumnName>Title</ColumnName>
        </Column>
        <Column ColumnType="0" DataType="vcha">
          <TableName>Catalog</TableName>
          <ColumnName>PageTitle</ColumnName>
        </Column>
        <Column ColumnType="0" DataType="vcha">
          <TableName>Catalog</TableName>
          <ColumnName>z_ThumbnailTitle</ColumnName>
        </Column>
        <Column ColumnType="0" DataType="vcha">
          <TableName>Catalog</TableName>
          <ColumnName>DateOfWork</ColumnName>
        </Column>
        <Column ColumnType="0" DataType="vcha">
          <TableName>Catalog</TableName>
          <ColumnName>Provenance</ColumnName>
        </Column>
        <Column ColumnType="0" DataType="vcha">
          <TableName>Artist</TableName>
          <ColumnName>z_FullName</ColumnName>
        </Column>
        <Column ColumnType="0" DataType="vcha">
          <TableName>Artist</TableName>
          <ColumnName>birth_death</ColumnName>
        </Column>
        <Column ColumnType="0" DataType="vcha">
          <TableName>Catalog</TableName>
          <ColumnName>Caption</ColumnName>
        </Column>
        <Column ColumnType="0" DataType="vcha">
          <TableName>Catalog</TableName>
          <ColumnName>Medium</ColumnName>
        </Column>
        <Column ColumnType="0" DataType="vcha">
          <TableName>Catalog</TableName>
          <ColumnName>Subject</ColumnName>
        </Column>
        <Column ColumnType="0" DataType="vcha">
          <TableName>Catalog</TableName>
          <ColumnName>CanvasSize</ColumnName>
        </Column>
        <Column ColumnType="0" DataType="vcha">
          <TableName>Catalog</TableName>
          <ColumnName>IventoryNumber</ColumnName>
        </Column>
        <Column ColumnType="0" DataType="dobl">
          <TableName>Catalog</TableName>
          <ColumnName>ID_Artist</ColumnName>
        </Column>
        <Column ColumnType="0" DataType="vcha">
          <TableName>ProvenanceKeywordsCatalogue</TableName>
          <ColumnName>KeyWord</ColumnName>
        </Column>
        <Column ColumnType="0" DataType="dobl">
          <TableName>Artist</TableName>
          <ColumnName>ID</ColumnName>
        </Column>
        <Column ColumnType="0" DataType="dobl">
          <TableName>ProvenanceKeywordsCatalogue</TableName>
          <ColumnName>ID_Catalogue</ColumnName>
        </Column>
        <Column ColumnType="0" DataType="dobl">
          <TableName>Catalog</TableName>
          <ColumnName>ID</ColumnName>
        </Column>
      </DataDictionary>
      <SearchColumns>
        <ColumnReference>
          <TableName>Catalog</TableName>
          <ColumnName>Title</ColumnName>
        </ColumnReference>
        <ColumnReference>
          <TableName>Catalog</TableName>
          <ColumnName>PageTitle</ColumnName>
        </ColumnReference>
        <ColumnReference>
          <TableName>Catalog</TableName>
          <ColumnName>z_ThumbnailTitle</ColumnName>
        </ColumnReference>
        <ColumnReference>
          <TableName>Catalog</TableName>
          <ColumnName>DateOfWork</ColumnName>
        </ColumnReference>
        <ColumnReference>
          <TableName>Catalog</TableName>
          <ColumnName>Provenance</ColumnName>
        </ColumnReference>
        <ColumnReference>
          <TableName>Artist</TableName>
          <ColumnName>z_FullName</ColumnName>
        </ColumnReference>
        <ColumnReference>
          <TableName>Artist</TableName>
          <ColumnName>birth_death</ColumnName>
        </ColumnReference>
        <ColumnReference>
          <TableName>Catalog</TableName>
          <ColumnName>Caption</ColumnName>
        </ColumnReference>
      </SearchColumns>
      <OrderColumns>
        <OrderColumn>
          <Ascending><![CDATA[true]]></Ascending>
          <TableOwner/>
          <TableName/>
          <ColumnName>1</ColumnName>
        </OrderColumn>
      </OrderColumns>
      <GroupColumns/>
      <Criteria>
        <CriteriaItem>
          <TableName>Catalog</TableName>
          <ColumnName>Title</ColumnName>
          <Operator>iseq</Operator>
          <Value><![CDATA[<@ARG Title>]]></Value>
          <QuoteValue>true</QuoteValue>
          <IncludeIfEmpty>false</IncludeIfEmpty>
        </CriteriaItem>
        <CriteriaItem>
          <Conjunction>and</Conjunction>
          <TableName>Catalog</TableName>
          <ColumnName>Medium</ColumnName>
          <Operator>iseq</Operator>
          <Value><![CDATA[<@ARG Medium>]]></Value>
          <QuoteValue>true</QuoteValue>
          <IncludeIfEmpty>false</IncludeIfEmpty>
        </CriteriaItem>
        <CriteriaItem>
          <Conjunction>and</Conjunction>
          <TableName>Catalog</TableName>
          <ColumnName>Subject</ColumnName>
          <Operator>iseq</Operator>
          <Value><![CDATA[<@ARG Subject>]]></Value>
          <QuoteValue>true</QuoteValue>
          <IncludeIfEmpty>false</IncludeIfEmpty>
        </CriteriaItem>
        <CriteriaItem>
          <Conjunction>and</Conjunction>
          <TableName>Catalog</TableName>
          <ColumnName>DateOfWork</ColumnName>
          <Operator>iseq</Operator>
          <Value><![CDATA[<@ARG DateOfWork>]]></Value>
          <QuoteValue>true</QuoteValue>
          <IncludeIfEmpty>false</IncludeIfEmpty>
        </CriteriaItem>
        <CriteriaItem>
          <Conjunction>and</Conjunction>
          <TableName>Catalog</TableName>
          <ColumnName>CanvasSize</ColumnName>
          <Operator>iseq</Operator>
          <Value><![CDATA[<@ARG size>]]></Value>
          <QuoteValue>true</QuoteValue>
          <IncludeIfEmpty>false</IncludeIfEmpty>
        </CriteriaItem>
        <CriteriaItem>
          <Conjunction>and</Conjunction>
          <TableName>Catalog</TableName>
          <ColumnName>IventoryNumber</ColumnName>
          <Operator>iseq</Operator>
          <Value><![CDATA[<@ARG InvNum>]]></Value>
          <QuoteValue>true</QuoteValue>
          <IncludeIfEmpty>false</IncludeIfEmpty>
        </CriteriaItem>
        <CriteriaItem>
          <Conjunction>and</Conjunction>
          <TableName>Catalog</TableName>
          <ColumnName>ID_Artist</ColumnName>
          <Operator>iseq</Operator>
          <Value><![CDATA[<@ARG ID_artist>]]></Value>
          <QuoteValue>false</QuoteValue>
          <IncludeIfEmpty>true</IncludeIfEmpty>
        </CriteriaItem>
        <CriteriaItem>
          <Conjunction>and</Conjunction>
          <TableName>ProvenanceKeywordsCatalogue</TableName>
          <ColumnName>KeyWord</ColumnName>
          <Operator>iseq</Operator>
          <Value><![CDATA[<@arg keyword>]]></Value>
          <QuoteValue>true</QuoteValue>
          <IncludeIfEmpty>false</IncludeIfEmpty>
        </CriteriaItem>
      </Criteria>
      <JoinCriteria>
        <JoinItem JoinType="Equal">
          <FirstTable>Artist</FirstTable>
          <FirstColumn>ID</FirstColumn>
          <SecondTable>Catalog</SecondTable>
          <SecondColumn>ID_Artist</SecondColumn>
        </JoinItem>
        <JoinItem JoinType="Equal">
          <FirstTable>ProvenanceKeywordsCatalogue</FirstTable>
          <FirstColumn>ID_Catalogue</FirstColumn>
          <SecondTable>Catalog</SecondTable>
          <SecondColumn>ID</SecondColumn>
        </JoinItem>
      </JoinCriteria>
      <StartRow>1</StartRow>
      <ResultSet Name="ResultSet" Type="Array"/>
      <ResultsOutput Ref="Search.Results"/>
      <NoResultsOutput Ref="Search.NoResults"/>
      <ErrorOutput Ref="Search.Error"/>
    </SearchAction>
    <ReturnAction ID="Return" Sig="stop"/>
  </Actions>
  <DataSources>
    <DataSource ID="rcr_data">
      <DSType>ODBC</DSType>
      <DSN>rcr_data</DSN>
      <DBMS/>
      <Host>rcr_data</Host>
      <Database/>
      <UserInfo Encrypted="True" Encryption="50">
        <UserName>%83%F5%CA%24%1E%06%12%F8%D1QB%DCn%E9h%F5</UserName>
        <Password>%0Bo%A3t%CC%05%C5U%C9%CC%BA%BAR%FA%B8%C5%88K%A1%0E%D2%CA%F7%8B</Password>
      </UserInfo>
    </DataSource>
  </DataSources>
  <Outputs>
    <Output ID="Search.Results" Type="HTML"><![CDATA[<b></b><@assign resultset <@distinct array=resultset cols=1>>
<@if expr=<@numrows array=resultset>=1>
<@INCLUDE FILE="<@appfilepath><@COLUMN 'Catalog.PageTitle'>">
<@else>
<@INCLUDE FILE="<@appfilepath>searchlist.htm">
</@if>
<@COLUMN 'Catalog.Caption'>]]></Output>
    <Output ID="Search.NoResults" Type="HTML"><![CDATA[<@INCLUDE FILE="<@appfilepath>index.html">]]></Output>
    <Output ID="Search.Error" Type="HTML"><![CDATA[<@clearerrors>]]></Output>
  </Outputs>
</TAF>
