Search for existing answers to your product and support questions.
Familiarize yourself with our support site and learn best practices in working with our team.
Manage Service Requests, View and update service requests submitted by you and others in your organization.
Submit a new issue to our technical support team.
Oracle B2C Service insights from our Technical Support team subject matter experts
Browse resources to assist you in launching your implementation and ensure a successful go-live.
Access your OCI account.
Find product documentation for supported versions of B2C and documentation libraries for related service solutions.
You will have the tools to improve your customers' experience when you learn about all the things our products can do.
Find links for API documentation, Custom Processes, Customer Portal, and Agent Browser UI Extensibility Framework.
Explore how accelerators are designed to demonstrate how an integration scenario could be built using the public integration and extension capabilities of the Oracle B2C Service.
Prepare for a successful transition by reviewing upcoming release changes and enhancements.
Explore webinars, events, and feature kits to learn about B2C Service features, functionality, and best practices from the technical experts.
Oracle MyLearn offers a portfolio of free and paid subscription-based learning resources to help you gain valuable skills, accelerate cloud adoption, increase productivity, and transform your business.
Empower your team with the skills to implement, configure, manage, and use your applications with Customer Experience Cloud Training.
Our goal is to facilitate a friendly, supportive environment where members can easily collaborate with each other on solutions and best practices.
Ask and answer questions specific to B2C.
This is an exciting resource intended to help with your Oracle Service Cloud Analytics.
Share product improvement ideas and enhancement requests with Oracle Development, while collaborating with other Oracle customers and partners.
Update your phone number, email notification preferences, and severity 1 and severity 2 contact preferences.
View the contact managers within your organization.
Find contact information of the Technical Account Manager (TAM) and Client Success Manager (CSM) for your organization.
Environment:
Analytics
Resolution:
When configuring filters in a report, the options listed in the Operator field depend on the type of field selected.
Note that wildcards are not allowed with any of the first eight operators listed below: =, !=, <, <=, >, >=, not equals or null, and between. If you are using wildcards, you must use the like or not like operators. For this reason, when using text fields, it is most common to use the like or not like operators.
When using the like operators -- like, not like, and not like or null: you should generally use a wildcard (%) to surround your value. For example, if you want to include all fields that contain the word 'all,' you should type '%all%' (including the single quotation marks) in the value field.
Operators and Descriptions Operator Description equals (=) The field matches the value exactly, including case. not equals (!=) The field does not match the value listed. not equals or The field does not match the value listed or the field is a null value. less than (<) The field is numerically less than the value listed. less than or equals (<=) The field is numerically less than or equal to the value listed. greater than (>) The field is numerically greater than the value listed. greater than or equals (>=) The field is numerically greater than or equal to the value listed. between The field falls between two specified values, including the endpoints. That is, if the between range is from 1 to 100, values that equal 1 or 100 match. When using this option, click in the Value or Expression 2 cell to enter the range of values. like The field matches the value that is listed. When using the like expression, you should generally use the % sign (wildcards) to surround your value. For example, if you were looking for all fields that contain the word "all", you should type %all% in the value field. not like The field does not match the value that is listed. When using the like expression, you generally should use the % sign (wildcards) to surround your value. For example, if you were looking for all fields that do not contain the word "all", you should type %all% in the value field. not like or null The field is either a null value or does not match the expression listed. You can use wildcards with this option. in list The field matches one of the drop-down menu items selected. (Used only with menu-type fields.) not in list The field does not match any of the menu items selected. When using this operator with integer fields, the numbers in the Value field must be comma-separated. When using this operator with text fields, the text strings in the Value field must be comma-separated and each text string must be offset by single quotes (for example, ‘red’,’green’,’orange’). Spaces between entries are ignored. is null The field contains no data in the database and is a null value. Note: This operator is not available in run-time selectable filters. is not null The field contains some type of data in the database. Note: This operator is not available in run-time selectable filters. != or null The field is either a null value or does not match the value exactly, including case. Wildcards are not allowed with this field. complex expression The field matches the expression listed in the value. This operator is only allowed with text fields and automatically includes a trailing wildcard however, it does not include a preceding wildcard for the search. != or null The field does not match the expression listed in the value. This operator is only allowed with text fields and automatically includes a trailing wildcard. To use the NULL filters in reports you need to uncheck the check box that says, "Make this filter selectable at run time.", in the filters.
Note: In order to see null value operators you will need to:
For additional information, refer to the Filter Operators section in the Online Help User Guide documentation. To access Oracle B2C Service manuals and documentation online, refer to the Documentation for Oracle B2C Service Products.