Display unique records

  • bajan4evr2

    (@bajan4evr2)


    7 years, 9 months ago

    I have a database where I enter the names of riders on a daily basis. So everyday it is possible that the same name is entered again. If that same person rides 5 days, the list will display that record 5 times. How can I display a list of unique records so that the person’s name only appears once? Thank you for this plugin.

Viewing 1 replies (of 1 total)
  • Plugin Author Roland Barker

    (@xnau)

    7 years, 9 months ago

    You will need to use some custom code for this because there is no built-in method for showing only the unique records from a list.

    There are two basic ways to do this: first, you can alter the query that is used to get the list using a filter. This would be if you only want to show the unique records and don’t care about any of the info in the duplicates. The ‘pdb-list_query‘ filter would be good for that.

    The other way to do this is to use a custom template where you use the looping to build up an array of data. You would do this in such a way as to catch any duplicates and deal with those differently, depending on what you what to do with the information in those records. Once your array is filled, use it to display the records.

Viewing 1 replies (of 1 total)

The topic ‘Display unique records’ is closed to new replies.