Query selects distinct records by default | Community
Skip to main content
N
narulasaurabh
Level 2
February 15, 2019
Solved

Query selects distinct records by default

  • February 15, 2019
  • 1 reply
  • 1596 views

When I select data using Query from Workflow Targeting activities, then the query by default selects distinct records. What is the best way to select all records and not just distinct.

Thanks

Saurabh

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Jonathon_wodnicki

    Hi,

    Click 'Advanced parameters...' in the 'Additional columns' dialog, there's a checkbox to turn off DISTINCT in the select.

    Thanks,

    -Jon

    1 reply

    Jonathon_wodnicki
    Community Advisor
    Jonathon_wodnickiCommunity AdvisorAccepted solution
    Community Advisor
    February 15, 2019

    Hi,

    Click 'Advanced parameters...' in the 'Additional columns' dialog, there's a checkbox to turn off DISTINCT in the select.

    Thanks,

    -Jon

      Terms & ConditionsAccessibility statement

      Loading footer...