C1 Community
ComponentOne Community is a free source for developers and help authors to collaborate and communicate.

How to add fixed advanced elementary condition

rated by 0 users
This post has 2 Replies | 2 Followers

Not Ranked
Posts 1
joeyzhang Posted: Tue, Jan 13 2009 9:59 PM
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
Top 25 Contributor
Posts 456
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

Not Ranked
Posts 1
critenlee replied on Fri, Aug 21 2009 10:15 PM


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) | RSS
Contact ComponentOne: 1.800.858.2739 ©1987-2010 ComponentOne LLC All Rights Reserved.