Re: How to add fixed advanced elementary condition

ActiveX

ActiveX controls

How to add fixed advanced elementary condition

  • rated by 0 users
  • This post has 2 Replies |
  • 2 Followers
  • Hi all,
    I have a new requirement that need to add a fixed elementary condition.
    e.g. The below is the fixed elementary condition (I name it include condition):
    (
    (
    (CASE.CASE_TYPE_ID = 1) AND
    (CASE.DUPLICATE = 0) AND
    (CASE.DISPOSITION_ID <> 1)) OR
    (
    (CASE.CASE_TYPE_ID = 3) AND
    (
    (CASE.CASE_STATUS_ID = 6) OR
    (CASE.CASE_STATUS_ID = 7) OR
    (CASE.CASE_STATUS_ID = 5)) AND
    (
    (CASE.DISPOSITION_ID <> 1) AND
    (CASE.DISPOSITION_ID <> 6) AND
    (CASE.DISPOSITION_ID <> 10)) AND
    (CASE.DUPLICATE = 0)) OR
    (
    (CASE.CASE_TYPE_ID = 4) AND
    (CASE.DUPLICATE = 0) AND
    (CASE.DISPOSITION_ID <> 1))
    )

    I need to use it with other editable conditions . The editable conditions have been carried out .
    The below is required result :

    Select cases where all of the following apply
    Case Disposition is equal to Settled
    Includable condition
    Case Type is equla to Claim

    At the same time, i know the AdvElemTemplate of item template attributes,but i do not know how to use it.
    who can help me to solve the issue?

    thanks
    Gary.Zhang
  • Subqueries.zip
    Hello Gary,
     
    I am attaching a sample project which adds the advanced and complex elementary condition by using the C1Query control. Please let me know if this sample project helps.
     
    Have a nice day.
     
    Regards,
    James Smith
    ComponentOne LLC
     
    <joeyzhang> wrote in message news:213330@10.0.1.98...
    Hi all,
    I have a new requirement that need to add a fixed elementary condition.
    e.g. The below is the fixed elementary condition (I name it include condition):
    (
    (
    (CASE.CASE_TYPE_ID = 1) AND
    (CASE.DUPLICATE = 0) AND
    (CASE.DISPOSITION_ID <> 1)) OR
    (
    (CASE.CASE_TYPE_ID = 3) AND
    (
    (CASE.CASE_STATUS_ID = 6) OR
    (CASE.CASE_STATUS_ID = 7) OR
    (CASE.CASE_STATUS_ID = 5)) AND
    (
    (CASE.DISPOSITION_ID <> 1) AND
    (CASE.DISPOSITION_ID <> 6) AND
    (CASE.DISPOSITION_ID <> 10)) AND
    (CASE.DUPLICATE = 0)) OR
    (
    (CASE.CASE_TYPE_ID = 4) AND
    (CASE.DUPLICATE = 0) AND
    (CASE.DISPOSITION_ID <> 1))
    )

    I need to use it with other editable conditions . The editable conditions have been carried out .
    The below is required result :

    Select cases where all of the following apply
    Case Disposition is equal to Settled
    Includable condition
    Case Type is equla to Claim

    At the same time, i know the AdvElemTemplate of item template attributes,but i do not know how to use it.
    who can help me to solve the issue?

    thanks
    Gary.Zhang


    http://helpcentral.componentone.com/cs/forums/p/77894/213330.aspx#213330


  • Thanks for your sharing. Thanks for sharing this useful information. It's great.




    gratuit pour mobile sonnerie portable mp3 - Sonnerie portable MP3 est en effet un pouvoir de l'innovation technologique. Êtes-vous familier avec cette sonnerie portable?gratuit pour mobile sonnerie portable mp3

Page 1 of 1 (3 items)