[progress Communities] [progress Openedge Abl] Forum Post: Filter Over Multiple...

  • Thread starter Thread starter mjoosen
  • Start date Start date
Status
Not open for further replies.
M

mjoosen

Guest
Dear Community We find problems when not all steps in een relationship path are bound. This seems counter intuitive. Example We have the entity Contract (5 instances) with a relation (cardinality 1->1) to an entity supplier (for each Contract 1). Contract has an id: ContractId, Supplier has an id: SupplierId We have the entity Article (120.000 instances). Article has an in: SupplierId We use a loop construct to loop over contracts (not directly relevant for the issue at hand). Therefore we have an entity Filter (1 instance) with a relation to Contract (cardinalitity 1->1) Filter has an id: ContractId Situation 1 (run is killed after 1 hour because it is stuck) Scope : Article (ALIAS:ART) Filter (ALIAS:FLTR) -> Contract (ALIAS: FLTR_CONTRACT) ---->Supplier (ALIAS: FLTR_SUPPLIER) Filter : ART.SupplierId = FLTR_SUPPLIER.SupplierId Situation 2 (run is finished in less than 10 seconds) Scope Article (ALIAS:ART) Filter (ALIAS:FLTR) -> Contract (ALIAS: FLTR_CONTRACT) ---->Supplier (ALIAS: FLTR_SUPPLIER) Filter : FLTR.ContractId= FLTR_CONTRACT.ContractId ART.SupplierId = FLTR_SUPPLIER.SupplierId

Continue reading...
 
Status
Not open for further replies.
Back
Top