The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

jvonallmen's avatar
jvonallmen
Icon for OneStream Employee rankOneStream Employee
4 years ago
Solved

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
  • NaeemPathan's avatar
    NaeemPathan
    4 years ago

    Hi Jerry,

    Not sure if you had a response on this, but what you could do is by creating the parameter as a 'Member list' and in your Member filter reference a business rule which sorts your entities. I have attached a screenshot of an example which you could use, you can change the entity filter variable to suit your requirements. 

     

     

     

    Regards,

    Naeem

marisolbritton's avatar
marisolbritton
New Contributor III
3 years ago

Hi!  If I want to sort on the default description do I just change it from Memberlistname to Memberdefaultdescription?

  • Mike_Sabourin's avatar
    Mike_Sabourin
    Contributor II
    3 years ago

    Yes. that should work.

    • marisolbritton's avatar
      marisolbritton
      New Contributor III
      3 years ago

      Hi Michel!  

       

      I changed this to Memberdefaultdescription but it's giving me an error about it not being included in MemberListArgs.  Any ideas on what I can try?  Thanks

      • Mike_Sabourin's avatar
        Mike_Sabourin
        Contributor II
        3 years ago

        Sorry. Memberlistname is just the name of the list you're creating. What you'd want to do is change the .Name in the below part of the code to .Description...

         

         If Not objMemberInfos Is Nothing Then
		                    	objMembers = (From memberInfo In objMemberInfos Order By memberInfo.Member.Name Ascending Select memberInfo.Member).ToList()
		                    End If