We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Sort within Group

Comments

1 comment

  • Avatar
    Infogix Support
    Originally posted by: gmullin

    Give this a go.

    node:Static_Data
    bretype:core::Static Data
    editor:sortkey=5cc7659774e23486
    output:@40fe6c55598828e5/=
    prop:StaticData=<<EOX
    DeptID,Name,EmpID
    1000,AAA,100
    3000,BBB,200
    500,CCC,300
    1000,DDD,50
    EOX
    editor:XY=210,160
    end:Static_Data
    
    node:Sort
    bretype:core::Sort
    editor:sortkey=5cc765aa505a356b
    input:@40fd2c743ebf4304/=Static_Data.40fe6c55598828e5
    output:@40fd2c746a2a3b47/=
    prop:CompareOrderExpr=<<EOX
    'DeptID'.long(),'EmpID'.long()
    EOX
    editor:XY=310,160
    end:Sort
    
    node:Agg_Ex
    bretype:core::Agg Ex
    editor:sortkey=5cc766184b08216e
    input:@4b4668c040aa5a85/=Sort.40fd2c746a2a3b47
    output:@4b4668e708143fb4/=
    prop:GroupBy=<<EOX
    'DeptID'.long()
    EOX
    prop:Script=<<EOX
    
    emit *
    where lastInGroup
    
    EOX
    prop:SortInput=false
    editor:XY=400,160
    node:Bypass
    bretype:::Bypass
    editor:shadow=4b467f7e02db3a85
    input:@4b467f7e129d45c1/=
    input:@4b467f830ffe047b/=
    output:@40fd2c7436717256/=
    end:Bypass
    
    node:Sort
    bretype:::Sort
    editor:shadow=4b467f8972dc33df
    input:@40fd2c743ebf4304/=
    output:@40fd2c746a2a3b47/=
    end:Sort
    
    node:Agg
    bretype:::Agg
    editor:shadow=4b467f9b3d5028c0
    input:@40fd2c7427456e5b/=
    output:@40fd2c744c862db0/=
    end:Agg
    
    end:Agg_Ex
    0
    Comment actions Permalink

Please sign in to leave a comment.