List Manager Support

List Manager support
Public write access is disabled. Please login

How to remove duplicate entries from Option List 08.03.2018 13:56


First of all, thank you for your support so far.

I have a query regarding the optionlist list. I currently have a field which populates its data from another list using the following SQL code:

select value,value from #__listmanager_values where idfield=1

My problem is, as the original list builds up I have multiple duplicate entries in idfield=1. This is causing the optionlist to auto populate with all of the items (including the duplicate ones). Is there a way to strip out the duplicates so only unique fields are loaded in the optionlist?


Edited by liam.baker - 08.03.2018 13:57

Re: How to remove duplicate entries from Option List 08.03.2018 17:14

you can try to configure using a 'select distinct' or 'group by' at your sql in order to discard duplicates. Here we share the official docs so you can check the syntax:

Moonsoft Team
Are you satisfied with our products/services/support?
Please help us to keep improving, add a review at  joomla extensions site and  magento connect

Our clients' feedback