Update MemberVariable Programmatically

By - Mar 19, 2018

MemberVariable can be used as default value of filter.  To modify the selected value of MemberVariable programmatically, we need to update both UniqueName and Properties column in [dbo].[ApplicationMemberVariableMembers] table.

Assume we have a member variable called Current Month.  Here is a sample query that we can use to update its selection.