Sorting by group field not by lookup settings of the field [RESOLVED]

Scriptcase 9 General
#1

Hi,
I have a grid with a group by id field with a lookup settings
When the group runs, the table shows a right view group by id field
but when I get into summary button the order changes to lookup settings(description) instead id field

any ideas to setup the order by id field instead the lookup settings?

thanks

RESOLVED:
Change at Summary settings / Layout settings / Set “Database value” instead “Display value”

1 Like
#2

lookup is basically very inefficient way to query. you are better off by adding the field label as a new field next to its ID. For instance if i have group_id, i ll be adding group_text in the query by joining on group_id . for the database it is far more efficient way , instead of running hundreds of lookup queries , one for every record.

#3

Yes, I totally agree.
thanks.

1 Like