<?xml version="1.0" encoding="utf-8"?>
<configs xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xmlns="OmniSearch"
         xsi:schemaLocation="OmniSearch d:\oadev\omnidex\config\OmniSearch.xsd">
  <config>
    <configID>config1</configID>

    <global>
      <tracing>false</tracing>
    </global>

    <connections>
      <connection>
        <connectionID>connection1</connectionID>
        <datasourceType>FILE</datasourceType>
        <datasourceName>#Datasource_Filename#</datasourceName>
      </connection>
      <defaultConnection>connection1</defaultConnection>
      <defaultConnectionType>CONNECTONLOAD</defaultConnectionType>
    </connections>

    <displays>
      <display>
        <displayID>display1</displayID>
        <row>
          <column>
            <panelID>CriteriaTree</panelID>
          </column>
          <column>
            <panelID>Target</panelID>
          </column>
        </row>
        <row>
          <column span="2">
            <panelID>Grid</panelID>
          </column>
        </row>
      </display>
    </displays>

    <panels>
      <!-- ********************************************************** -->
      <!-- *** CRITERIATREE PANEL                                 *** -->
      <!-- ********************************************************** -->
      <panel>
        <panelID>CriteriaTree</panelID>
        <panelType>CRITERIATREE</panelType>
        <panelBehavior>
          <initialView>EXPANDALL</initialView>
          <collapse>MANUAL</collapse>
        </panelBehavior>
        <content>
          <title>
            <text>SEARCH CATEGORIES</text>
          </title>
        </content>
        <controls>
          <controlID>CriteriaTree</controlID>
        </controls>
      </panel>

      <!-- ********************************************************** -->
      <!-- *** TARGET PANEL                                       *** -->
      <!-- ********************************************************** -->
      <panel>
        <panelID>Target</panelID>
        <panelType>TARGET</panelType>
        <panelBehavior>
          <initialView>NONE</initialView>
          <collapse>AUTO</collapse>
        </panelBehavior>
        <content>
          <title>
            <text>CURRENT SEARCH</text>
          </title>
          <topText>
            <displayState>WITHCONTROLS</displayState>
            <text>
              <![CDATA[<div class="center bold">%COUNT_STRING("No rows","%COUNT% row","%COUNT% rows") selected<br/><span class="small">(%TOTAL_TIME%)</span></div>]]>
            </text>
          </topText>
          <centerText>
            <text>
              <![CDATA[Choose categories from the left and <br />then enter criteria in this workspace.]]>
            </text>
            <displayState>BEFORECONTROLS</displayState>
          </centerText>
        </content>
        <displayOrder>TOP</displayOrder>
      </panel>

      <!-- ********************************************************** -->
      <!-- *** GRID PANEL                                         *** -->
      <!-- ********************************************************** -->
      <panel>
        <panelID>Grid</panelID>
        <panelType>GRID</panelType>
        <content>
          <title>
            <text>Selected Rows</text>
          </title>
        </content>
        <controls>
          <controlID>Grid</controlID>
        </controls>
        <displayOrder>TOP</displayOrder>
      </panel>

      <!-- ********************************************************** -->
      <!-- *** DYNAMIC PANELS                                     *** -->
      <!-- ********************************************************** -->
      <panel>
        <panelID>#Column_Name#</panelID>
        <panelType>DYNAMIC</panelType>
        <content>
          <helpText>
            <text>#Column_Description#</text>
          </helpText>
        </content>
        <controls>
          <controlID>#Column_Name#</controlID>
        </controls>
      </panel>

    </panels>

    <controls>
      <control>
        <controlID>CriteriaTree</controlID>
        <targetPanelID>Target</targetPanelID>
        <criteriaTree>
          <trees>
            <tree>
              <nodes>
                <node>
                  <level>1</level>
                  <label>#Column_Label#</label>
                  <hoverHelp>Choose criteria for the #Column_Name# column</hoverHelp>
                  <dynamicPanelID>#Column_Name#</dynamicPanelID>
                </node>
              </nodes>
            </tree>
          </trees>
        </criteriaTree>
      </control>

      <control>
        <controlID>Grid</controlID>
        <gridResultSet>
          <paging>
            <numPerPage>20</numPerPage>
          </paging>
          <sql>
            select * from #Table_Name# where %CRITERIA%
          </sql>
        </gridResultSet>
      </control>

      <control>
        <controlID>#Column_Name#</controlID>
        <checkboxList>
          <displaySQL>
            <sql>
              select #Column_Name#, COUNT(*) from #Table_Name# where %CRITERIA% group by #Column_Name#
            </sql>
            <displayColumns>0</displayColumns>
            <criteriaColumns>0</criteriaColumns>
            <countColumn>1</countColumn>
          </displaySQL>
          <controlView>
            <initialValues>CHECKNONE</initialValues>
            <selectAllButton>true</selectAllButton>
            <clearAllButton>true</clearAllButton>
            <invertButton>true</invertButton>
          </controlView>
        </checkboxList>
      </control>

      <control>
        <controlID>#Column_Name#</controlID>
        <textbox>
          <tblName>#Table_Name#</tblName>
          <colName>#Column_Name#</colName>
          <prompt>
            <label>
            <alignment>LEFT</alignment>
            <location>LEFT</location>
            <text>#Column_Label#</text>
            <width>1000</width>
            </label>
          </prompt>
        </textbox>
      </control>

    </controls>
  </config>
</configs>


