This post is more than 5 years old
132 Posts
0
1180
Sorting with multiple fields in DPA?
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.
connolly
132 Posts
0
October 23rd, 2017 15:00
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.