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)

Sort by

Martin Dráb 240,163 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
badiyev 52 on at

Like (0)

Report
Copy link

Link copied!

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

Thanks.

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

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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,286 on at

Like (0)

Report
Copy link

Link copied!

What are you looking for ?

Was this reply helpful? Yes No
badiyev 52 on at

Like (0)

Report
Copy link

Link copied!

The question is what i am looking for.

Was this reply helpful? Yes No
badiyev 52 on at

Like (0)

Report
Copy link

Link copied!

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 240,163 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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