Forum Discussion

jvonallmen's avatar
jvonallmen
Icon for OneStream Employee rankOneStream Employee
5 years ago

How can I use a Business Rule to sort a Member List in alphabetical order?

    Namespace OneStream.BusinessRule.Finance.XFR_MemberListAlphabetical Public Class MainClass '-----------------------------------------------------------------------------------------------...
Finance
Koemets's avatar
Koemets
Contributor
4 years ago

Any particular reason we might think of, that prevents the display in alphabetical order from XFBR (not Finance) business rule? Members' name format is XXX1111. Essentially I use logic similar to the OP, but the alphanumeric values returned are not listed in alphabetical order as prescribed by linq select, but in rather random order.

  • Mike_Sabourin's avatar
    Mike_Sabourin
    Contributor II
    4 years ago

    Hi Koemets,

     

    I can't think of a particular reason off-hand why it wouldn't return the correct order, but if you want to post your code, I'd be happy to look and see if anything jumps out

    • Koemets's avatar
      Koemets
      Contributor
      4 years ago

       

       

       

      Dim objMembers As List(Of Member) = Nothing
      If Not masterCL Is Nothing Then
             objMembers = (From memberInfo In masterCL Order By memberInfo.Member.Name Ascending Select memberInfo.Member).ToList()
      End If

      • Mike_Sabourin's avatar
        Mike_Sabourin
        Contributor II
        4 years ago

        I've never tried it in an XFBR before, but it should be doable. However, the methodology might have to be changed. I think you might have to cycle through the alphabetical list you created in this and add it to a text string to return the order back to the cube view (result being like A#XXX111, A#XXX112, etc). If I get a chance, I'll play around with it and see if I can get it to work.