If using IN or NOT IN then you must place the value within parentheses An AND

If using in or not in then you must place the value

This preview shows page 371 - 373 out of 512 pages.

If using IN or NOT IN, then you must place the value within parentheses. An AND is implied between multiple conditions that are defined that use these comparison values. AND means that all the conditions must be met before the action occurs. LIKE and NOT LIKE allow you to use wildcards. For example, LIKE Smith%, or NOT LIKE Sm%th%. The following requirements of the underlying database apply: If you define values for the comparison operands LIKE, IN, NOT IN, and BETWEEN in the Value field of the Conditions list of the Workflow Policies view, then it must be in a form that the underlying database expects. IN, NOT IN, and BETWEEN require you to enter the database specific format for the field examined. For example, IN ('a', 'b', 'c') or IN (1, 2, 3, 4) and BETWEEN 'A' and 'B' or BETWEEN 1 and 10. On an MS SQL Server database, if you define a workflow policy condition on a LONG column, then the available comparisons are IS NULL, IS NOT NULL, LIKE, and NOT LIKE. NOTE: It is up to the creator of the policy to make sure the syntax is correct. The Process Designer only passes the BETWEEN clause to the database. It does not confirm syntax, except for date and time. For date and time fields, the Process Designer converts the date and time columns to the format of month/day/year, hour:minute:second. A Field That Is Not Known Is Interpreted as Null If a field value is not known rather than having no value, then the field is interpreted as null. For example, assume a condition includes the following logic: FIeldA IS UPDATED FieldB <> "MyValue" In this case, if FieldB is null, then the condition <> "MyValue" is false. Null is interpreted as the field value is not known. When evaluating whether null is not equal to Y, Siebel assumes the field could be set to anything, including Y. Therefore, because it cannot be concluded that the field is definitely not set to Y, false is returned and the Workflow Monitor Agent does not execute the action. Specialized Comparisons in the Conditions List The Comparison field supports the specialized operators IS ADDED, IS UPDATED, and IS DELETED. The IS operators serve as a starting point for the examination of the workflow policy.
Image of page 371
Siebel Business Process Framework: Workflow Guide Version 8.1, Rev A Defining a Custom Workflow Policy Conditions for a Workflow Policy 372 If defining a batch type of workflow policy, then the comparison operators IS ADDED, IS UPDATED, or IS DELETED must be used in conjunction with a regular workflow policy condition. These comparison operators are considered special conditions that are intended for Dynamic mode when calling rows to look up a regular condition. The following comparisons work at the workflow policy component level but do not operate at the field level: IS ADDED. If a new row is added for this workflow policy component, then call this workflow policy to be examined. If used in conjunction with a standard comparison, IS ADDED can be used when a record is updated.
Image of page 372
Image of page 373

You've reached the end of your free preview.

Want to read all 512 pages?

  • Summer '16
  • Oracle
  • Siebel Workflow, Workflow Guide

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes