A
Anverion
Guest
Hello-- I have been trying for several hours to figure this out, however, I thought I run this by the group to see if they have some suggestions. I have two collections: 1. Earnings Details 2. Reference What I need to do is to compare 4 key fields in the Earnings Details collection with the reference table to ensure that I have a valid combination. In the Earnings Details, I have the following four fields: 1. Fund Type 2. Payment Type 3. Performer Type 4. Contract Type The values of these fields must match a single element in the collection or it's an invalid combination. I have tried using the exists operator, but I see a ton of duplicate results. Since I have 9 elements int the Details, I would expect the same number, pass or fail. What I have tried: cmsefd->exists(cmsefd.fundType=ref.fundtype,cmsefd.paymentType=ref.paymentType,cmsefd.performerType=ref.performerType,cmsefd.contractType=ref.contractType.) I will try and post images when I get a chance. VPN from home isn't allowing me to copy at the moment. Thanks for help! - Branden
Continue reading...
Continue reading...