List Manager Forum

How to remove duplicate entries from Option List

User liam.baker 2018-03-08 13:56:42


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

Moonsoft support 2018-03-08 17:14:46

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:



Create dynamic calculators

Buy now!
Support/development 10 hours

Get a bigger amount of hours for more complex tasks and get a 10% discount

Buy now!