Highlighted
8 Krypton

Sorting with multiple fields in DPA?

Jump to solution

Trying to find some info about sorting with multiple fields in DPA?

Basic scenario is that I'm trying to use the DPA reporting to sort Avamar clients by both Domain Name and Client Name, so that I get a listing with both values relative to the following:

Domains named A, B, C

Domain A clients named sys31, sys32, sys33

Domain B clients named sys24, sys25, sys26

Domain C clients named sys17, sys18, sys19

The output needs to be sorted and reported so it shows up as:

A   sys31

A   sys32

A   sys33

B   sys24

B   sys25

B   sys26

C   sys17

C   sys18

C   sys19

Do I have to "feed" the same data source into two separate Order operators and then Merge them into the Report? And if I wanted to "operate" on other data fields that aren't being sorted, should I be doing that before or after the merge?

(and for those interested, the end goal is to be able to have a Backup Client Schedule timeline report where the Avamar clients on the Y axis are listed in the above format of Domain followed by Client; also having trouble figuring out how to change the Y-axis labels in that chart - that's likely another discussion in itself)

All comments/feedback appreciated - thanks.

0 Kudos
1 Solution

Accepted Solutions
8 Krypton

Re: Sorting with multiple fields in DPA?

Jump to solution

FYI, figured this out. It was pretty simple (which is maybe why no one replied?).

Basically, you need to set up Order operators in the "reverse sequence" of how you want the data to be sorted (that is, the "higher" sort orders come later and the "lower" sort orders come earlier).

So for the above example, the first Order operator after your data source would sort on the sys* values.

Then, your second Order operator would sort on the letter values, but would be "fed" the already sorted sys* values associated with each letter value in the sequence sorted by the previous operator.


Pretty cool.

0 Kudos
1 Reply
8 Krypton

Re: Sorting with multiple fields in DPA?

Jump to solution

FYI, figured this out. It was pretty simple (which is maybe why no one replied?).

Basically, you need to set up Order operators in the "reverse sequence" of how you want the data to be sorted (that is, the "higher" sort orders come later and the "lower" sort orders come earlier).

So for the above example, the first Order operator after your data source would sort on the sys* values.

Then, your second Order operator would sort on the letter values, but would be "fed" the already sorted sys* values associated with each letter value in the sequence sorted by the previous operator.


Pretty cool.

0 Kudos