Hello

Could someone point me in the right direction to be able to translate this query to LLBLGen code.

I have a table called Processed, it contains ChannelID, TransactionID and TransactionIndex. The table is keyed by a conjuction of TransactionID and TransactionIndex.

I need to pull a certain ChannelID number and I would like all the repeating transaction IDs for the transactionID that I pull. I know I could do this with two fetches, where the first would pull the first entry and the next fetch would filter on TransactionID and pull my other records, but is there a way to do this with one fetch?

Please let me know.

Thank you, Bruno Valle

Please use a FieldCompareSetPredicate as mentioned in the docs "Using the generated code -> Adapter/ SelfServicing -> filtering and sorting -> the predicate system"

Thank you.

I got to say this is the nicest forum I have ever encountered. I could see the response already been RTFM, but you were really nice, you actually pointed out the chapter and everything.

Thank you again. BV