CODEWITHSUNDEEP
erpacumatica
xDJR1875
xDJR1875

Reputation: 280

What is the best way using BQL to select non-duplicate items from BQL?

What is the best way using BQL to select non-duplicate items from BQL?

Search<PRTaxCode.prGovtRefNbr, 
 Where<PRTaxCode.prGovtRefNbr, IsNotNull>,
    And<PRTaxCode.prGovtRefNbr, ***not already in results***>>?

Current Results: 52-55555555555 52-55555555555 <-- remove this duplicate 52-12345678 52-144550099

Results should be : 52-55555555555 52-12345678 52-144550099

Upvotes: 0

Views: 228

Answers (1)

xDJR1875
xDJR1875

Reputation: 280

Using the Aggregate and GroupBy constructs gave the desired results.

found my own answer: 

  Search4<PRTaxCode.prGovtRefNbr, 
    Where<PRTaxCode.prGovtRefNbr, IsNotNull>, 
Aggregate<GroupBy<PRTaxCode.prGovtRefNbr>>>

Upvotes: 1

Related Questions