Elements order at list where more than one group

[oreolana]

My form and list has more than one group and I would like to randomize elements order.
Is it possible?

 

[troester]

You can "Randomize elements" inside a group and "Randomize groups" in your form but I think it doesn't affect the list view.

 

[oreolana]

You can "Randomize elements" inside a group and "Randomize groups" in your form but I think it doesn't affect the list view.

Yes, it doesn't affect the list view.

Now I think to do a new databasejoin dropdown (or better auto-complete) with filter in option "Joins where and/or order by statement (sql)".

But I have errors.

WHERE `dbme_entity_performance`.`entity_full_name` 
IN 
(SELECT dbme_entity_repeat_user_access.parent_id FROM dbme_entity_performance, dbme_entity_repeat_user_access WHERE dbme_entity_repeat_user_access.user_access = {$my->id}
)

Error message :

Unknown column 'dbme_entity_performance.entity_full_name' in 'IN/ALL/ANY subquery' SQL=SELECT DISTINCT(`dbme_entity_1`.`id`) AS value, edrpou_code AS text FROM `dbme_entity` AS `dbme_entity_1` WHERE `dbme_entity_performance`.`entity_full_name` IN (SELECT dbme_entity_repeat_user_access.parent_id FROM dbme_entity_performance, dbme_entity_repeat_user_access WHERE dbme_entity_repeat_user_access.user_access = 944 ) ORDER BY text ASC

 

[troester]

Use {thistable} (literally)
WHERE {thistable}.`entity_full_name` IN (SELECT dbme_entity_repeat_user_access.parent_id FROM dbme_entity_performance, dbme_entity_repeat_user_access WHERE dbme_entity_repeat_user_access.user_access = {$my->id} )

 

[oreolana]

Use {thistable} (literally)
WHERE {thistable}.`entity_full_name` IN (SELECT dbme_entity_repeat_user_access.parent_id FROM dbme_entity_performance, dbme_entity_repeat_user_access WHERE dbme_entity_repeat_user_access.user_access = {$my->id} )

THANKS!

It's work, but some another
WHERE {thistable}.`entity_full_name` IN (SELECT dbme_entity.entity_full_name FROM dbme_entity, dbme_entity_performance WHERE dbme_entity.id IN (SELECT dbme_entity_repeat_user_access.parent_id FROM dbme_entity, dbme_entity_repeat_user_access WHERE dbme_entity_repeat_user_access.user_access = {$my->id} ))

because
{thistable}.`entity_full_name` is varchar(255),
dbme_entity.entity_full_name is varchar(255),
dbme_entity.id is int(11),
dbme_entity_repeat_user_access.parent_id is int(11).

Thank you very much!

 

[oreolana]

I'm using databasejoin dropdown.

But I want auto-complete.

How can I autofill ?