Skip to main content
narulasaurabh
Level 2
Feb 15, 2019 2:34 AM UTC
Solved

Query selects distinct records by default

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.
    Jonathon_wodnicki
    Jonathon_wodnickiAccepted solution
    Community Advisor
    Feb 15, 2019 5:58 PM UTC

    Hi,

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

    Thanks,

    -Jon

    View in thread

    1 reply

    Jonathon_wodnicki
    Community Advisor
    Jonathon_wodnickiCommunity AdvisorAccepted solution
    Community Advisor
    Feb 15, 2019 5:58 PM UTC

    Hi,

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

    Thanks,

    -Jon

    Translate
      Terms & ConditionsAccessibility statement

      Loading footer...