Create a new field 'sql'
add query
(SELECT id as value, title as text FROM
#__categories where extension = 'com_content' and published = 1) union (SELECT 0 as value,'Empty' as text)
add valid default value, in this case existing category or 0
save
Successful save
Save failed with the following error: The default value is invalid.
Labels |
Added:
?
|
Status | New | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2022-12-04 07:15:07 |
Closed_By | ⇒ | joomdonation | |
Labels |
Added:
No Code Attached Yet
Removed: ? |
PR #39355 should address this issue. Unfortunately, Joomla 3 does not receive regular bugs fixes on anymore, so we can only have this issue fixed for Joomla 4. Please help testing . Thanks !