Sorting form with 2 data sources

(0) Share

Report

Posted on by badiyev

Hello,

I have been searching this question for days and i could not find any answer. My question is:
I have 2 data sources in my form. And i have a grid. This data sources are joined to each other with inner join. I have fields of both Data Source on my grid. Now i want to sort this grid with following order:

ds1.Name
ds1.Surname
ds2.ExamDate

The grid Data Souce is ds1.
How can i sort with this way?

Thanks a lot;

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (1)

Martin Dráb 237,976 Most Valuable Professional on at

Like (0)

Report

Do you want to do it from GUI, or in code?

Was this reply helpful? Yes No
badiyev 52 on at

Like (0)

Report

I want to do it with code, i mean, when the form loads.

Thanks.

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

Hi badiyev,

Take a look at this community thread community.dynamics.com/.../127335

Was this reply helpful? Yes No
badiyev 52 on at

Like (0)

Report

hello ievgen,

Thanks for your suggestion and reply, but unfortunately this is not what i am looking for.

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

What are you looking for ?

Was this reply helpful? Yes No
badiyev 52 on at

Like (0)

Report

The question is what i am looking for.

Was this reply helpful? Yes No
badiyev 52 on at

Like (0)

Report

Martin, i am still facing with this problem, can you please suggest a solution?

Best of Regards.

Was this reply helpful? Yes No
Martin Dráb 237,976 Most Valuable Professional on at

Like (1)

Report

addSortField() does seem to be the answer. If you say it's not what you want, tell us why.

Nobody replied because just saying "The question is what i am looking for" doesn't explain anything.

Was this reply helpful? Yes No
badiyev 52 on at

Like (1)

Report

Martin,

When i use addSortField(), it only sorts for the field i provided latest.

For example: I use:

On init() of first ds:

this.queryBuildDataSource().sortClear();

ds2_ds.query().dataSourceTable(tableNum(tb2)).addSortField(fieldNum(tb2, SomeDate));

ds2_ds.query().dataSourceTable(tableNum(tb2)).addSortField(fieldNum(tb2, SomeFIeld));

this.query().dataSourceTable(tableNum(tb1)).addSortField(fieldNum(tb1, RecId));

Here, only sort one is by table 1.recid . I want it to be sorted, first by SomeDate, then by SomeField, then by recid.

Best regards.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (1)

Report

You could create a temporary table with an index that matches your field order, populate the records from the joined datasources, and use addSortIndex:

msdn.microsoft.com/.../querybuilddatasource.addsortindex.aspx;MSPPError=-2147217396

This is the only way probably that you could use to get it working.

Was this reply helpful? Yes No