Search Specification Containing IIf() Causes SBL-DAT-00479: CSSString doesn't support operator "OR" (Doc ID 1265610.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Siebel CRM - Version 8.0.0.7 [20426] and later
Information in this document applies to any platform.
*** Checked for currency on 25 June, 2015 ***

Symptoms

A custom applet search specification causes an error in Fix Pack 8.0.0.7 although it worked without problems in Fix Pack 8.0.0.5.

Error Messages:
--------------------
SBL-DAT-00479: CSSString doesn't support operator 'OR'


Steps:
--------------------
By following these steps the issue can be reproduced:

  1. Include the search specification

    IIf([Type] <> "Chain", IIf(GetProfileAttr ("Org.Country") IS NOT NULL, [Country] = GetProfileAttr ("Org.Country"),[Type] <> "Chain"), "") OR [Type] = "Chain"

    in the Affiliated Account Form List Applet or any other applet.
  2. Make sure there is a record under the applet with the Type value as "Chain".
  3. Try to do an empty query on the applet.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms