1. Configuring Siebel Business Applications
  2. Effect of CIAI Columns on Sorts

Effect of CIAI Columns on Sorts

If querying on a column that is configured for CIAI, then the ORDER_BY clause might or might not include the CIAI column depending on the following situations:

  • A view with the Visibility Applet Type property set to All uses the CIAI column in the ORDER_BY clause.

  • A view with the Visibility Applet Type property set to Org does not use the CIAI column for sorts.

If querying on another column in the same view that is not configured for CIAI, then Siebel CRM does not use the CIAI column in the ORDER_BY clause.