How to Sort The Options List of A Searchable?

[nofue]

Having a field defined as

select	'f_result'	as name
	,	'Ergebnis'	as label
	,	true		as searchable
	,	4			as width
	,	'select'	as type
	,	0			as value
	,	true		as autocomplete
	, 	'Wählen…'	as empty_option
	, (	select json_agg(
                   json_build_object(
                       'label', term,
                       'value', result_id
                   )
                )
          from results_of_efforts
      ) as options
	;		

I'd like to have the items of this field sorted.
using "order by term" gives

[2025-10-06T15:23:23.391Z ERROR sqlpage::render] SQL error: In "prospects.sql": The following error occurred while executing an SQL statement:
    error returned from database: column "results_of_efforts.term" must appear in the GROUP BY clause or be used in an aggregate function

Would using a sorted view instead of a table help?

[nofue]

Hey, it's straight forward -- just put the line not after the FROM, but "elsewhere":

         SELECT json_agg(
                  json_build_object(
                      'label', term,
                      'value', kind_id
                  )
                  ORDER BY term          -- put it inside json_agg()
                )
         FROM kinds_of_efforts
       ) AS options;