If you create a typed list in the tool which generates a custom TypedList class...

how can you then put sort expressons on that?

I tried the usual SortExpression and adding that to the FetchTypedList function, but the exception was thrown that my table names did not match aliases in the database?

however after just changing my code to use defined resultset fields, it works fine...

i'd rather use the typedlist in advance to keep other developers consistent.

It should work, you must be doing something wrong. Here's an example using a filter and a sort.

            FilteredPODetailTypedList list = new FilteredPODetailTypedList();
            DataAccessAdapter adapter = new DataAccessAdapter();
            IRelationPredicateBucket bucket = (IRelationPredicateBucket)list.GetRelationInfo();
            bucket.PredicateExpression.Add(PredicateFactory.CompareValue(PODetailFieldIndex.PONumber, ComparisonOperator.Equal, PONumber));
            ISortExpression sort = new SortExpression(SortClauseFactory.Create(PODetailFieldIndex.POLineNumber, SortOperator.Ascending));
            adapter.FetchTypedList(list.GetFieldsInfo(), list, bucket, 0, sort, false);

Thanks for the answer, Jim!

Most common error is that developers forget to use the normal entity field indexes for the fields which are in the typed list. After all, a typed list is just build with entity fields.

i'm doing exactly that...using the entity fields for the sorter as well...but somehow whatever it is sending to the database is getting screwed up.

i'll reproduce and post my code and the resulting exception