Need some advice on unioning entitylists : According to the documentation...

Tue, 08 Jul 2008 13:32:35 -700

Author: TimClamp
Subject: 787
Posted: 08-Jul-2008 at 1:32pm

According to the documentation for generic entitylist, it supports CopyTo.

CopyTo

(Inherited from System.Collections.ObjectModel.Collection)

List1.CopyTo(List2)

Need some advice on unioning entitylists : Try something like this: EntityList<Entity>...

Mon, 28 Apr 2008 13:55:33 -700

Author: davidklitzke
Subject: 787
Posted: 28-Apr-2008 at 1:55pm

Try something like this:

EntityList elist = new EntityList(Entity);

foreach (AvailableGenericStep stepAG in gSteps) {

elist.add(stepAG)

}

foreach (AvailableNonGenericStep stepANG in ngSteps) {

elist.add(stepANG)

}

Need some advice on unioning entitylists : One of my modules in my app that...

Sat, 26 Apr 2008 12:37:34 -700

Author: BillG
Subject: 787
Posted: 26-Apr-2008 at 12:37pm

One of my modules in my app that I am developing is a workflow type piece where a member calls up with a problem and a step by step process is done to complete the solution. Throughout the process the user selects steps from a drop down list that signify what was done to complete it. There are two types of steps that can be done, generics steps that can occur in any order throughout the process and specfic steps that have to occur in order and certain steps can only follow other steps.

I have two tables in the database, one called AvailableGenericSteps which has a TypeCd and a ResponseCd. The other table is called AvailableNonGenericSteps which has a TypeCd, an origincd and a responsecd. Basically the typecd indicates the type of case it is.

So now I need to figure out to fill the drop down list. At the point that I am ready to fill it, I know two things, The type of problem it is and the previous step.

So in VB I did a query on the first table, AvailableGenericSteps where typecd was equal to the typecd of the case and retrieved back all the rows that qualified. I then queried the second table, AvailableNonGenericSteps with the typecd and the previous step code. I then retrieved back all the rows that qualified and unioned them with the query from the first table. Using this union, I then populated my drop down box.

In IdeaBlade I don't have a union, so any suggestions on how to do this using 2 entity lists. One entityList will have the steps retrieved back the from the AvailableGenericSteps and the other entityList will have the steps retrieved back from the AvailableNonGenericSteps. Now do I combine the two entitylists and populate the datasource of the ComboBox?

Here is what I have so far.

public void BuildStepsList()

{

RdbQuery query1 = new Query(typeof(AvailableGenericStep));

query1.AddClause(AvailableGenericStep.EventTypeCdEntityColumn, EntityTypeQueryOp.EQ, currentEvent.EventTypeCd);

EntityList gSteps = myPM.GetEntities(query1);

RdbQuery query2 = new Query(typeof(AvailableNonGenericStep));

query2.AddClause(AvailableNonGenericStep.EventTypeCdEntityColumn, EntityTypeQueryOp.EQ, currentEvent.EventTypeCd);

EntityList ngSteps = myPM.GetEntities(query2);

}

A thought just occured to me, can I do the following?

EntityList list = new EntityList();

list.Add(nSteps);

list.Add(ngSteps);

but then how do I bind the binding source object to that????

Is this a place for a Dynamic Entity?

DevForce Community Forum : Need some advice on unioning entitylists

Need some advice on unioning entitylists : According to the documentation...

Need some advice on unioning entitylists : Try something like this: EntityList<Entity>...

Need some advice on unioning entitylists : One of my modules in my app that...