stupid newbie question

Scriptcase 8 Discussion
#1

How do I set the default sort order of a grid
Looked everywhere
Thanks in anticipation
I have done all the stuff in sorting rules but grid stays the same
Sorting Rules in Scriptcase Grids
In Grid applications you can work with sorted data creating sorting rules, all this with a very practical way, editing settings of the applications you can implement this functionality in seconds.

SC says “To create a sorting rule, go to grid settings and select “Sorting Rules”. but this does not alter the initial view of the grid”

SC also says Scriptcase Application Sorting

It is also possible to configure a grid to star by the search and configure the search fields tha same way that we can configure the form fields, we can change the field to select, auto-compete or even create a caputure link in the field.

How exactly

#2

how about using a select … order by …

#3

Well, I’m a newbie too that wants this. The use of “select order by…” would work but, where is the SQL that populates the grid initially? I started to mess with the Form Settings->SQL but, whilst I thought that was the place to add the “order by…” it isn’t. If it is then I haven’t worked out how it works as I caused some crashes as a result of my tinkering.

#4

If you select SQL from the left side tree menu, there should be an option for Sort By…you can enter which fields and either ascending or descending…hope that helps.

There might also be a tree menu item for Sort…depending on the type of application you are creating.

#5

I have a similar question to Johneb above.
Sorting works manually for the user of the grid, but I am unable to influence the default sort field or sort order.
I have attempted to use “ORDER BY” in the SQL SELECT statement, but have not been able to change the way my grids are sorted.

#6

You mean that the grid is ignoring your order-by? That looks odd to me…