Note for Oracle Database Users

If a SQL view column is defined as searchable (using the isSearchable attribute), then the SQL statement should include the S_ column immediately after the non S_ column. The list of SQL view columns should include the normal column as well as the S_ column.

Example:

<addSqlView name="bugs_and_cases" id="4040">
    <description>my SQL view description</description>
    <sql>select title, s_title, id_number from table_case UNION select title, s_title, id_number from table_bug</sql>
 </addSqlView>


 <addSqlViewColumn name="title" sqlView="bugs_and_cases" datatype="String" >


     <length>255</length>


     <isSearchable>true</isSearchable>


  </addSqlViewColumn>




 <addSqlViewColumn name="s_title" sqlView="bugs_and_cases" datatype="String" >


     <length>255</length>


  </addSqlViewColumn>




 <addSqlViewColumn name="id" sqlView="bugs_and_cases" datatype="String" >


     <length>80</length>


  </addSqlViewColumn>







See Also
SQL Views
Note on Column Ordering



Next
Notes on Indexes











 Note for Oracle Database Users