We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
MODX Community Forums Archive

Select Distinct values

    • 36924 ☆ A M B ☆
    • 298 Posts
    ojchris Reply #1, 12 years, 4 months ago
    In SQL if I have a table named Activity with a 'Category' column and other coloumns like Location, Client, etc. Though you could have a category repeated across the rows I could use the statement SELECT DISTINCT Category FROM Activity; to have a results of only unique Category values.

    How can this be achieved on MODx. I was thinking getResources.