Impossible to set a defined value at the top of the drop-down table of an attribute in the identity

[CeLopezini]

Hi, 

We have a requirement from the client in which he requests that a specific value within a drop down table is up to the top and that the rest of the values are in alphabetical order, however we have tried different queries and when configuring the query directly in the attribute it does not work as it does in the DATA Analyzer.

Attached are some images for you to have more details about them.

I have tried some of these querys:

SELECT 'Autre Titre' as ID
UNION ALL
SELECT DISTINCT title as ID
FROM Users u
WHERE STATUSKEY = 1 AND title != 'Autre Titre';

SELECT DISTINCT CASE WHEN title = 'Autre Titre' THEN 0 ELSE 1 END as SortOrder,
                title as ID
FROM Users u
WHERE STATUSKEY = 1
ORDER BY SortOrder, ID;

 Do you have any idea how to solve it? 

Thanks,

[Darshanjain]

Hi @CeLopezini 

No, this will not work as per the data analyzer, it queries the result in form of hql and give you the result in user forms so you wont be able achieve the above scenairo .

It automatically sorts based on the column

Thanks

Darshan