On Sat, Jul 22, 2023 at 10:13:42AM +0200, Benny Pedersen wrote:
> Henrik K via users skrev den 2023-07-22 06:50:
>
> > > | gvk | unwhitelist_from|
> > > grant.kel...@sonic.com | 7421538 |
> > > | gvk | whitelist_from | *@sonic.com | 7526210 |
>
> user_prefs in sql/ldap can not do unwhitelist, it
> missing priority field in sql/ldap for this to work,
> only thing that is possible as now is to remove the
> whitelist not add unwhitelist, would need feature
> request for priority field
No need for feature request, already exists:
user_scores_sql_custom_query
Create own SQL that sorts as you want, for example MySQL ORDER BY
FIELD(...).
Then again why even write unneeded stuff in DB. Fix it in the backend or
create triggers etc to cleanup redundant stuff.
