Forum


List Manager Support

List Manager support
Forums
Public write access is disabled. Please login

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

Hello,

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?

Cheers

Edited by liam.baker - 08.03.2018 13:57

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

Hello,
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:

https://dev.mysql.com/doc/refman/5.7/en/distinct-optimization.html

Regards
Moonsoft Team
www.moonsoft.es
Are you satisfied with our products/services/support?
Please help us to keep improving, add a review at  joomla extensions site and  magento connect
FaLang translation system by Faboba

Our clients' feedback