If you have questions or if you want to share your opinion about Aware IM post your message on this forum
#53997 by numberz
Sun May 31, 2020 11:28 pm
Hi and thanks in advance.
I have created items for a database. These items have numerous fields, with "Item No'" being the first on left.
How can I make this field be the field that is used for sorting, and in smallest to largest meaning, I want to see item 101, then 102, then 103, etc.
What I'm getting is the numbers as they were created
Regards and thanks,
#53998 by aware_support
Mon Jun 01, 2020 1:12 am
You need to create a query that sorts by this number, for example:

FIND ALL MyObject ORDER BY MyObject.ItemNo ASC
#54000 by numberz
Mon Jun 01, 2020 1:11 pm
Thank you.
Can anyone add to this please?
A query where? How
#54007 by BLOMASKY
Mon Jun 01, 2020 3:25 pm
In AwareIM, when you display multiple records in a list (in a row), you use a Query which both selects which records to display (I.E. only customers in Florida, All Items, Backordered items, etc.) and Which columns (fields) to display.

When you right click on Queries and select "New Query" you are presented with a window where you can select which items to display. There are 2 ways to do this, (with 2 tabs displayed) Standard View and Textual View. In both you can control the sort order. In standard view, on the right, is a list of attributes (field) that you can check to sort by. In Textual view, at the end of your "FIND" statement, you enter ORDER BY Table.attribute. i.e. Order By Orders.itemID

#54014 by numberz
Tue Jun 02, 2020 11:39 am
Bruce, thanks!
So simple and I knew exactly where to go...but I somehow had most of the attributes checked, thinking it was somehow a filter for choosing which columns to allow user to sort.
Again, thank you.

Who is online

Users browsing this forum: No registered users and 31 guests