[#5999] Dropdown field types with OPTGROUP

Hi Kyle !

I go back to a past question, sorry for my English. I will try to explain that I need to do.
I guide the fields out of database by means of CB Query Field .

Here screenshot databases .


That to show out data, I use such call




When to hatch OPTGROUP, subsequent data get in this OPTGROUP . they do not have OPTGROUP and must be in ordinary list .





Please help to decide a problem

The optgroups are not closed in code, but in the DOM. You need to ensure the groups come after the non-grouped entries by using ORDER BY. It does not disturb the ordering of the rows, but will consider implementing that for a later release if you're wanting to have non-grouped, then grouped, then non-grouped again.

forge.joomlapolis.com/issues/6066

I have now come across a situation where I need to have two levels of indentation in my dropdown, i.e.
Is it possible to create a hierarchy ?

Optgroup inside of optgroup doesn't exist in HTML (it's not in the specification so it may or may not work; up to the browser). Best way to support that is to just increment the subsequent optgroup with a dash or some other character. Additionally as stated above you can not have an option outside of an optgroup after the optgroup; that won't work currently and for now options outside of an optgroup must come before the optgroup.