Hi all,
I'm currently developing a dashboard that will likely be used by multiple users at the same time.
Users will be able to set some initial parameters within the dashboard, and click on a button that will trigger a BR that will return some output rows within a table in the database.
After the process is complete, the user will be able to see the output rows through the following SQL Table Editor:
the parameters that you can see in the \"Where Clause\" are literal parameters that are set from within the BR when it is triggered by the user (using BRApi.Dashboards.Parameters.SetLiteralParameterValue()), and their value depend on the initial parameters that the user selected in the dashboard.
The problem is, I saw in some posts within the forum that literal parameters are \"common\" to all users, so every time one user will click the button and launch the process, the literal parameters will be changed. This is a problem, because we expect users to use the dashboard simultaneously.
Is there a workaround that does not use literal parameters? Or is there a way to make literal parameters \"unique\" to every user?
Thanks in advance!
","kudosSumWeight":0,"postTime":"2023-06-23T05:59:31.159-04:00","images":{"__typename":"AssociatedImageConnection","edges":[{"__typename":"AssociatedImageEdge","cursor":"MjUuMnwyLjF8b3wyNXxfTlZffDE","node":{"__ref":"AssociatedImage:{\"url\":\"https://community.onestreamsoftware.com/t5/s/otqon28567/images/bS0yMTIzOS01MzE2aUMyRjU3MjhGNjJCMjlENzY?revision=2\"}"}}],"totalCount":1,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"attachments":{"__typename":"AttachmentConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"tags":{"__typename":"TagConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[{"__typename":"TagEdge","cursor":"MjUuMnwyLjF8b3wxMHxfTlZffDE","node":{"__typename":"Tag","id":"tag:Dashboards","text":"Dashboards","time":"2020-01-09T10:56:57.000-05:00","lastActivityTime":null,"messagesCount":null,"followersCount":null}}]},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:21239_2"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":8035},"visibilityScope":"PUBLIC","canonicalUrl":null,"seoTitle":null,"seoDescription":null,"isEscalated":null,"placeholder":false,"originalMessageForPlaceholder":null,"messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}},"archivalData":null,"customFields":[],"body":"Hi all,
I'm currently developing a dashboard that will likely be used by multiple users at the same time.
Users will be able to set some initial parameters within the dashboard, and click on a button that will trigger a BR that will return some output rows within a table in the database.
After the process is complete, the user will be able to see the output rows through the following SQL Table Editor:
the parameters that you can see in the \"Where Clause\" are literal parameters that are set from within the BR when it is triggered by the user (using BRApi.Dashboards.Parameters.SetLiteralParameterValue()), and their value depend on the initial parameters that the user selected in the dashboard.
The problem is, I saw in some posts within the forum that literal parameters are \"common\" to all users, so every time one user will click the button and launch the process, the literal parameters will be changed. This is a problem, because we expect users to use the dashboard simultaneously.
Is there a workaround that does not use literal parameters? Or is there a way to make literal parameters \"unique\" to every user?
Thanks in advance!
"},"Conversation:conversation:21239":{"__typename":"Conversation","id":"conversation:21239","solved":true,"topic":{"__ref":"ForumTopicMessage:message:21239"},"lastPostingActivityTime":"2024-10-29T15:01:03.902-04:00","lastPostTime":"2024-10-29T15:01:03.902-04:00","unreadReplyCount":21,"isSubscribed":false},"ModerationData:moderation_data:21239":{"__typename":"ModerationData","id":"moderation_data:21239","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"AssociatedImage:{\"url\":\"https://community.onestreamsoftware.com/t5/s/otqon28567/images/bS0yMTIzOS01MzE2aUMyRjU3MjhGNjJCMjlENzY?revision=2\"}":{"__typename":"AssociatedImage","url":"https://community.onestreamsoftware.com/t5/s/otqon28567/images/bS0yMTIzOS01MzE2aUMyRjU3MjhGNjJCMjlENzY?revision=2","title":"fc_0-1687513687144.png","associationType":"BODY","width":1495,"height":209,"altText":null},"Revision:revision:21239_2":{"__typename":"Revision","id":"revision:21239_2","lastEditTime":"2023-06-23T06:01:00.066-04:00"},"ForumReplyMessage:message:21249":{"__typename":"ForumReplyMessage","id":"message:21249","conversation":{"__ref":"Conversation:conversation:21239"},"author":{"__ref":"User:user:1118"},"revisionNum":1,"uid":21249,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:Rules"},"subject":"Re: Literal parameters and multiple users","readOnly":false,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:21249"},"parent":{"__ref":"ForumTopicMessage:message:21239"},"body":"You can also create an Ancillary table to store the parameter selection for each user. And fetch those values in your dashboard with this approach you can also save pervious selections made by the user.
You can opt for any of the approach mentioned the Ancillary table is the preferred one, but it is complex where as |UserText4| is simpler and quickest to implement.
","body@stringLength":"431","rawBody":"You can also create an Ancillary table to store the parameter selection for each user. And fetch those values in your dashboard with this approach you can also save pervious selections made by the user.
You can opt for any of the approach mentioned the Ancillary table is the preferred one, but it is complex where as |UserText4| is simpler and quickest to implement.
","kudosSumWeight":1,"repliesCount":1,"postTime":"2023-06-23T09:33:44.967-04:00","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"attachments":{"__typename":"AttachmentConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:21249_1"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":7774},"visibilityScope":"PUBLIC","isEscalated":null,"placeholder":false,"originalMessageForPlaceholder":null,"messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}},"customFields":[],"replies":{"__typename":"MessageConnection","edges":[{"__typename":"MessageEdge","cursor":"MjUuMnwyLjF8b3wxMHwxNDowLDM5OjF8MQ","node":{"__ref":"ForumReplyMessage:message:21293"}}],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"CachedAsset:theme:customTheme1-1743582051355":{"__typename":"CachedAsset","id":"theme:customTheme1-1743582051355","value":{"id":"customTheme1","animation":{"fast":"150ms","normal":"250ms","slow":"500ms","slowest":"750ms","function":"cubic-bezier(0.07, 0.91, 0.51, 1)","__typename":"AnimationThemeSettings"},"avatar":{"borderRadius":"50%","collections":["default"],"__typename":"AvatarThemeSettings"},"basics":{"browserIcon":{"imageAssetName":"OneStream_Symbol_Black-1728623750904.png","imageLastModified":"1728623754994","__typename":"ThemeAsset"},"customerLogo":{"imageAssetName":"Community_Logo_V2-1728623741343.png","imageLastModified":"1728623745056","__typename":"ThemeAsset"},"maximumWidthOfPageContent":"1500px","oneColumnNarrowWidth":"800px","gridGutterWidthMd":"30px","gridGutterWidthXs":"10px","pageWidthStyle":"WIDTH_OF_BROWSER","__typename":"BasicsThemeSettings"},"buttons":{"borderRadiusSm":"0","borderRadius":"0","borderRadiusLg":"0","paddingY":"5px","paddingYLg":"7px","paddingYHero":"var(--lia-bs-btn-padding-y-lg)","paddingX":"12px","paddingXLg":"16px","paddingXHero":"60px","fontStyle":"NORMAL","fontWeight":"400","textTransform":"NONE","disabledOpacity":0.5,"primaryTextColor":"var(--lia-bs-white)","primaryTextHoverColor":"var(--lia-bs-white)","primaryTextActiveColor":"var(--lia-bs-white)","primaryBgColor":"var(--lia-bs-body-color)","primaryBgHoverColor":"hsl(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), calc(var(--lia-bs-body-color-l) * 0.85))","primaryBgActiveColor":"hsl(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), calc(var(--lia-bs-body-color-l) * 0.7))","primaryBorder":"1px solid transparent","primaryBorderHover":"1px solid transparent","primaryBorderActive":"1px solid transparent","primaryBorderFocus":"1px solid var(--lia-bs-white)","primaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-body-color), 0 0 0 4px hsla(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), var(--lia-bs-body-color-l), 0.2)","secondaryTextColor":"var(--lia-bs-white)","secondaryTextHoverColor":"var(--lia-bs-white)","secondaryTextActiveColor":"var(--lia-bs-white)","secondaryBgColor":"var(--lia-bs-body-color)","secondaryBgHoverColor":"hsl(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), calc(var(--lia-bs-body-color-l) * 0.85))","secondaryBgActiveColor":"hsl(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), calc(var(--lia-bs-body-color-l) * 0.7))","secondaryBorder":"1px solid transparent","secondaryBorderHover":"1px solid transparent","secondaryBorderActive":"1px solid transparent","secondaryBorderFocus":"1px solid transparent","secondaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-body-color), 0 0 0 4px hsla(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), var(--lia-bs-body-color-l), 0.2)","tertiaryTextColor":"var(--lia-bs-body-color)","tertiaryTextHoverColor":"hsl(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), calc(var(--lia-bs-body-color-l) * 0.95))","tertiaryTextActiveColor":"hsl(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), calc(var(--lia-bs-body-color-l) * 0.9))","tertiaryBgColor":"transparent","tertiaryBgHoverColor":"transparent","tertiaryBgActiveColor":"hsla(var(--lia-bs-gray-400-h), var(--lia-bs-gray-400-s), var(--lia-bs-gray-400-l), 0.04)","tertiaryBorder":"1px solid transparent","tertiaryBorderHover":"1px solid hsla(var(--lia-bs-gray-400-h), var(--lia-bs-gray-400-s), var(--lia-bs-gray-400-l), 0.08)","tertiaryBorderActive":"1px solid transparent","tertiaryBorderFocus":"1px solid transparent","tertiaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-body-color), 0 0 0 4px hsla(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), var(--lia-bs-body-color-l), 0.2)","destructiveTextColor":"var(--lia-bs-danger)","destructiveTextHoverColor":"hsl(var(--lia-bs-danger-h), var(--lia-bs-danger-s), calc(var(--lia-bs-danger-l) * 0.95))","destructiveTextActiveColor":"hsl(var(--lia-bs-danger-h), var(--lia-bs-danger-s), calc(var(--lia-bs-danger-l) * 0.9))","destructiveBgColor":"var(--lia-bs-gray-200)","destructiveBgHoverColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.96))","destructiveBgActiveColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.92))","destructiveBorder":"1px solid transparent","destructiveBorderHover":"1px solid transparent","destructiveBorderActive":"1px solid transparent","destructiveBorderFocus":"1px solid transparent","destructiveBoxShadowFocus":"0 0 0 1px var(--lia-bs-body-color), 0 0 0 4px hsla(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), var(--lia-bs-body-color-l), 0.2)","__typename":"ButtonsThemeSettings"},"border":{"color":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","mainContent":"LIGHT","sideContent":"LIGHT","radiusSm":"3px","radius":"5px","radiusLg":"9px","radius50":"100vw","__typename":"BorderThemeSettings"},"boxShadow":{"xs":"0 0 0 1px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.08), 0 3px 0 -1px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.08)","sm":"0 2px 4px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.06)","md":"0 5px 15px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.15)","lg":"0 10px 30px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.15)","__typename":"BoxShadowThemeSettings"},"cards":{"bgColor":"var(--lia-panel-bg-color)","borderRadius":"var(--lia-panel-border-radius)","boxShadow":"var(--lia-box-shadow-xs)","__typename":"CardsThemeSettings"},"chip":{"maxWidth":"300px","height":"30px","__typename":"ChipThemeSettings"},"coreTypes":{"defaultMessageLinkColor":"#5564FF","defaultMessageLinkDecoration":"none","defaultMessageLinkFontStyle":"NORMAL","defaultMessageLinkFontWeight":"400","defaultMessageFontStyle":"NORMAL","defaultMessageFontWeight":"400","forumColor":"#5564FF","forumFontFamily":"var(--lia-bs-font-family-base)","forumFontWeight":"var(--lia-default-message-font-weight)","forumLineHeight":"var(--lia-bs-line-height-base)","forumFontStyle":"var(--lia-default-message-font-style)","forumMessageLinkColor":"var(--lia-default-message-link-color)","forumMessageLinkDecoration":"var(--lia-default-message-link-decoration)","forumMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","forumMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","forumSolvedColor":"#00985B","blogColor":"#6E26C1","blogFontFamily":"var(--lia-bs-font-family-base)","blogFontWeight":"var(--lia-default-message-font-weight)","blogLineHeight":"1.75","blogFontStyle":"var(--lia-default-message-font-style)","blogMessageLinkColor":"var(--lia-default-message-link-color)","blogMessageLinkDecoration":"var(--lia-default-message-link-decoration)","blogMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","blogMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","tkbColor":"#FF8FB4","tkbFontFamily":"var(--lia-bs-font-family-base)","tkbFontWeight":"var(--lia-default-message-font-weight)","tkbLineHeight":"1.75","tkbFontStyle":"var(--lia-default-message-font-style)","tkbMessageLinkColor":"var(--lia-default-message-link-color)","tkbMessageLinkDecoration":"var(--lia-default-message-link-decoration)","tkbMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","tkbMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","qandaColor":"#4099E2","qandaFontFamily":"var(--lia-bs-font-family-base)","qandaFontWeight":"var(--lia-default-message-font-weight)","qandaLineHeight":"var(--lia-bs-line-height-base)","qandaFontStyle":"var(--lia-default-message-link-font-style)","qandaMessageLinkColor":"var(--lia-default-message-link-color)","qandaMessageLinkDecoration":"var(--lia-default-message-link-decoration)","qandaMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","qandaMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","qandaSolvedColor":"#3FA023","ideaColor":"#FFCB11","ideaFontFamily":"var(--lia-bs-font-family-base)","ideaFontWeight":"var(--lia-default-message-font-weight)","ideaLineHeight":"var(--lia-bs-line-height-base)","ideaFontStyle":"var(--lia-default-message-font-style)","ideaMessageLinkColor":"var(--lia-default-message-link-color)","ideaMessageLinkDecoration":"var(--lia-default-message-link-decoration)","ideaMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","ideaMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","contestColor":"#FCC845","contestFontFamily":"var(--lia-bs-font-family-base)","contestFontWeight":"var(--lia-default-message-font-weight)","contestLineHeight":"var(--lia-bs-line-height-base)","contestFontStyle":"var(--lia-default-message-link-font-style)","contestMessageLinkColor":"var(--lia-default-message-link-color)","contestMessageLinkDecoration":"var(--lia-default-message-link-decoration)","contestMessageLinkFontStyle":"ITALIC","contestMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","occasionColor":"#B6BDFF","occasionFontFamily":"var(--lia-bs-font-family-base)","occasionFontWeight":"var(--lia-default-message-font-weight)","occasionLineHeight":"var(--lia-bs-line-height-base)","occasionFontStyle":"var(--lia-default-message-font-style)","occasionMessageLinkColor":"var(--lia-default-message-link-color)","occasionMessageLinkDecoration":"var(--lia-default-message-link-decoration)","occasionMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","occasionMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","grouphubColor":"#333333","categoryColor":"#949494","communityColor":"#FFFFFF","productColor":"#949494","__typename":"CoreTypesThemeSettings"},"colors":{"black":"#000000","white":"#FFFFFF","gray100":"#F7F7F7","gray200":"#F7F7F7","gray300":"#E8E8E8","gray400":"#D9D9D9","gray500":"#CCCCCC","gray600":"#949494","gray700":"#707070","gray800":"#545454","gray900":"#333333","dark":"#545454","light":"#F7F7F7","primary":"#373737","secondary":"#333333","bodyText":"#000000","bodyBg":"#F7F7F7","info":"#409AE2","success":"#41C5AE","warning":"#FCC844","danger":"#D13A1F","alertSystem":"#FF6600","textMuted":"#707070","highlight":"#FFFCAD","outline":"var(--lia-bs-primary)","custom":["#5564FF","#FF0000","#0099AA","#3D65C9","#0033FF","#660099"],"__typename":"ColorsThemeSettings"},"divider":{"size":"3px","marginLeft":"4px","marginRight":"4px","borderRadius":"50%","bgColor":"var(--lia-bs-gray-600)","bgColorActive":"var(--lia-bs-gray-600)","__typename":"DividerThemeSettings"},"dropdown":{"fontSize":"var(--lia-bs-font-size-sm)","borderColor":"var(--lia-bs-border-color)","borderRadius":"var(--lia-bs-border-radius-sm)","dividerBg":"var(--lia-bs-gray-300)","itemPaddingY":"5px","itemPaddingX":"20px","headerColor":"var(--lia-bs-gray-700)","__typename":"DropdownThemeSettings"},"email":null,"emoji":{"skinToneDefault":"#ffcd43","skinToneLight":"#fae3c5","skinToneMediumLight":"#e2cfa5","skinToneMedium":"#daa478","skinToneMediumDark":"#a78058","skinToneDark":"#5e4d43","__typename":"EmojiThemeSettings"},"heading":{"color":"var(--lia-bs-body-color)","fontFamily":"OneStream Sans","fontStyle":"NORMAL","fontWeight":"400","h1FontSize":"34px","h2FontSize":"32px","h3FontSize":"28px","h4FontSize":"24px","h5FontSize":"20px","h6FontSize":"16px","lineHeight":"1.3","subHeaderFontSize":"11px","subHeaderFontWeight":"500","h1LetterSpacing":"normal","h2LetterSpacing":"normal","h3LetterSpacing":"normal","h4LetterSpacing":"normal","h5LetterSpacing":"normal","h6LetterSpacing":"normal","subHeaderLetterSpacing":"2px","h1FontWeight":"var(--lia-bs-headings-font-weight)","h2FontWeight":"var(--lia-bs-headings-font-weight)","h3FontWeight":"var(--lia-bs-headings-font-weight)","h4FontWeight":"var(--lia-bs-headings-font-weight)","h5FontWeight":"var(--lia-bs-headings-font-weight)","h6FontWeight":"var(--lia-bs-headings-font-weight)","__typename":"HeadingThemeSettings"},"icons":{"size10":"10px","size12":"12px","size14":"14px","size16":"16px","size20":"20px","size24":"24px","size30":"30px","size40":"40px","size50":"50px","size60":"60px","size80":"80px","size120":"120px","size160":"160px","__typename":"IconsThemeSettings"},"imagePreview":{"bgColor":"var(--lia-bs-gray-900)","titleColor":"var(--lia-bs-white)","controlColor":"var(--lia-bs-white)","controlBgColor":"var(--lia-bs-gray-800)","__typename":"ImagePreviewThemeSettings"},"input":{"borderColor":"var(--lia-bs-gray-600)","disabledColor":"var(--lia-bs-gray-600)","focusBorderColor":"var(--lia-bs-primary)","labelMarginBottom":"10px","btnFontSize":"var(--lia-bs-font-size-sm)","focusBoxShadow":"0 0 0 3px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","checkLabelMarginBottom":"2px","checkboxBorderRadius":"3px","borderRadiusSm":"var(--lia-bs-border-radius-sm)","borderRadius":"var(--lia-bs-border-radius)","borderRadiusLg":"var(--lia-bs-border-radius-lg)","formTextMarginTop":"4px","textAreaBorderRadius":"var(--lia-bs-border-radius)","activeFillColor":"var(--lia-bs-primary)","__typename":"InputThemeSettings"},"loading":{"dotDarkColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.2)","dotLightColor":"hsla(var(--lia-bs-white-h), var(--lia-bs-white-s), var(--lia-bs-white-l), 0.5)","barDarkColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.06)","barLightColor":"hsla(var(--lia-bs-white-h), var(--lia-bs-white-s), var(--lia-bs-white-l), 0.4)","__typename":"LoadingThemeSettings"},"link":{"color":"#5564FF","hoverColor":"#5564FF","decoration":"none","hoverDecoration":"underline","__typename":"LinkThemeSettings"},"listGroup":{"itemPaddingY":"15px","itemPaddingX":"15px","borderColor":"var(--lia-bs-gray-300)","__typename":"ListGroupThemeSettings"},"modal":{"contentTextColor":"var(--lia-bs-body-color)","contentBg":"var(--lia-bs-white)","backgroundBg":"var(--lia-bs-black)","smSize":"440px","mdSize":"760px","lgSize":"1080px","backdropOpacity":0.3,"contentBoxShadowXs":"var(--lia-bs-box-shadow-sm)","contentBoxShadow":"var(--lia-bs-box-shadow)","headerFontWeight":"700","__typename":"ModalThemeSettings"},"navbar":{"position":"FIXED","background":{"attachment":null,"clip":null,"color":"var(--lia-bs-white)","imageAssetName":"","imageLastModified":"0","origin":null,"position":"CENTER_CENTER","repeat":"NO_REPEAT","size":"COVER","__typename":"BackgroundProps"},"backgroundOpacity":0.8,"paddingTop":"15px","paddingBottom":"15px","borderBottom":"1px solid var(--lia-bs-border-color)","boxShadow":"var(--lia-bs-box-shadow-sm)","brandMarginRight":"30px","brandMarginRightSm":"10px","brandLogoHeight":"30px","linkGap":"10px","linkJustifyContent":"flex-start","linkPaddingY":"5px","linkPaddingX":"10px","linkDropdownPaddingY":"9px","linkDropdownPaddingX":"var(--lia-nav-link-px)","linkColor":"var(--lia-bs-body-color)","linkHoverColor":"var(--lia-bs-primary)","linkFontSize":"var(--lia-bs-font-size-sm)","linkFontStyle":"NORMAL","linkFontWeight":"400","linkTextTransform":"NONE","linkLetterSpacing":"normal","linkBorderRadius":"var(--lia-bs-border-radius-sm)","linkBgColor":"transparent","linkBgHoverColor":"transparent","linkBorder":"none","linkBorderHover":"none","linkBoxShadow":"none","linkBoxShadowHover":"none","linkTextBorderBottom":"none","linkTextBorderBottomHover":"none","dropdownPaddingTop":"10px","dropdownPaddingBottom":"15px","dropdownPaddingX":"10px","dropdownMenuOffset":"2px","dropdownDividerMarginTop":"10px","dropdownDividerMarginBottom":"10px","dropdownBorderColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","controllerBgHoverColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.1)","controllerIconColor":"var(--lia-bs-body-color)","controllerIconHoverColor":"var(--lia-bs-body-color)","controllerTextColor":"var(--lia-nav-controller-icon-color)","controllerTextHoverColor":"var(--lia-nav-controller-icon-hover-color)","controllerHighlightColor":"hsla(30, 100%, 50%)","controllerHighlightTextColor":"var(--lia-yiq-light)","controllerBorderRadius":"var(--lia-border-radius-50)","hamburgerColor":"var(--lia-nav-controller-icon-color)","hamburgerHoverColor":"var(--lia-nav-controller-icon-color)","hamburgerBgColor":"transparent","hamburgerBgHoverColor":"transparent","hamburgerBorder":"none","hamburgerBorderHover":"none","collapseMenuMarginLeft":"20px","collapseMenuDividerBg":"var(--lia-nav-link-color)","collapseMenuDividerOpacity":0.16,"__typename":"NavbarThemeSettings"},"pager":{"textColor":"var(--lia-bs-link-color)","textFontWeight":"var(--lia-font-weight-md)","textFontSize":"var(--lia-bs-font-size-sm)","__typename":"PagerThemeSettings"},"panel":{"bgColor":"var(--lia-bs-white)","borderRadius":"var(--lia-bs-border-radius)","borderColor":"var(--lia-bs-border-color)","boxShadow":"none","__typename":"PanelThemeSettings"},"popover":{"arrowHeight":"8px","arrowWidth":"16px","maxWidth":"300px","minWidth":"100px","headerBg":"var(--lia-bs-white)","borderColor":"var(--lia-bs-border-color)","borderRadius":"var(--lia-bs-border-radius)","boxShadow":"0 0.5rem 1rem hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.15)","__typename":"PopoverThemeSettings"},"prism":{"color":"#000000","bgColor":"#f5f2f0","fontFamily":"var(--font-family-monospace)","fontSize":"var(--lia-bs-font-size-base)","fontWeightBold":"var(--lia-bs-font-weight-bold)","fontStyleItalic":"italic","tabSize":2,"highlightColor":"#b3d4fc","commentColor":"#62707e","punctuationColor":"#6f6f6f","namespaceOpacity":"0.7","propColor":"#990055","selectorColor":"#517a00","operatorColor":"#906736","operatorBgColor":"hsla(0, 0%, 100%, 0.5)","keywordColor":"#0076a9","functionColor":"#d3284b","variableColor":"#c14700","__typename":"PrismThemeSettings"},"rte":{"bgColor":"var(--lia-bs-white)","borderRadius":"var(--lia-panel-border-radius)","boxShadow":" var(--lia-panel-box-shadow)","customColor1":"#bfedd2","customColor2":"#fbeeb8","customColor3":"#f8cac6","customColor4":"#eccafa","customColor5":"#c2e0f4","customColor6":"#2dc26b","customColor7":"#f1c40f","customColor8":"#e03e2d","customColor9":"#b96ad9","customColor10":"#3598db","customColor11":"#169179","customColor12":"#e67e23","customColor13":"#ba372a","customColor14":"#843fa1","customColor15":"#236fa1","customColor16":"#ecf0f1","customColor17":"#ced4d9","customColor18":"#95a5a6","customColor19":"#7e8c8d","customColor20":"#34495e","customColor21":"#000000","customColor22":"#ffffff","defaultMessageHeaderMarginTop":"40px","defaultMessageHeaderMarginBottom":"20px","defaultMessageItemMarginTop":"0","defaultMessageItemMarginBottom":"30px","diffAddedColor":"hsla(170, 53%, 51%, 0.4)","diffChangedColor":"hsla(43, 97%, 63%, 0.4)","diffNoneColor":"hsla(0, 0%, 80%, 0.4)","diffRemovedColor":"hsla(9, 74%, 47%, 0.4)","specialMessageHeaderMarginTop":"40px","specialMessageHeaderMarginBottom":"20px","specialMessageItemMarginTop":"0","specialMessageItemMarginBottom":"30px","__typename":"RteThemeSettings"},"tags":{"bgColor":"var(--lia-bs-gray-200)","bgHoverColor":"var(--lia-bs-gray-400)","borderRadius":"var(--lia-bs-border-radius-sm)","color":"var(--lia-bs-body-color)","hoverColor":"var(--lia-bs-body-color)","fontWeight":"var(--lia-font-weight-md)","fontSize":"var(--lia-font-size-xxs)","textTransform":"UPPERCASE","letterSpacing":"0.5px","__typename":"TagsThemeSettings"},"toasts":{"borderRadius":"var(--lia-bs-border-radius)","paddingX":"12px","__typename":"ToastsThemeSettings"},"typography":{"fontFamilyBase":"OneStream Sans","fontStyleBase":"NORMAL","fontWeightBase":"400","fontWeightLight":"300","fontWeightNormal":"400","fontWeightMd":"500","fontWeightBold":"700","letterSpacingSm":"normal","letterSpacingXs":"normal","lineHeightBase":"1.5","fontSizeBase":"16px","fontSizeXxs":"11px","fontSizeXs":"12px","fontSizeSm":"14px","fontSizeLg":"20px","fontSizeXl":"24px","smallFontSize":"14px","customFonts":[{"source":"SERVER","name":"OneStream Sans","styles":[{"style":"NORMAL","weight":"400","__typename":"FontStyleData"},{"style":"NORMAL","weight":"500","__typename":"FontStyleData"}],"assetNames":["OneStreamSans-normal-400.woff2","OneStreamSans-normal-500.woff2"],"__typename":"CustomFont"}],"__typename":"TypographyThemeSettings"},"unstyledListItem":{"marginBottomSm":"5px","marginBottomMd":"10px","marginBottomLg":"15px","marginBottomXl":"20px","marginBottomXxl":"25px","__typename":"UnstyledListItemThemeSettings"},"yiq":{"light":"#ffffff","dark":"#000000","__typename":"YiqThemeSettings"},"colorLightness":{"primaryDark":0.36,"primaryLight":0.74,"primaryLighter":0.89,"primaryLightest":0.95,"infoDark":0.39,"infoLight":0.72,"infoLighter":0.85,"infoLightest":0.93,"successDark":0.24,"successLight":0.62,"successLighter":0.8,"successLightest":0.91,"warningDark":0.39,"warningLight":0.68,"warningLighter":0.84,"warningLightest":0.93,"dangerDark":0.41,"dangerLight":0.72,"dangerLighter":0.89,"dangerLightest":0.95,"__typename":"ColorLightnessThemeSettings"},"localOverride":false,"__typename":"Theme"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/Loading/LoadingDot-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Loading/LoadingDot-1737726265000","value":{"title":"Loading..."},"localOverride":false},"CachedAsset:quilt:onestream.prod:pages/forums/ForumMessagePage:board:Rules-1743582049557":{"__typename":"CachedAsset","id":"quilt:onestream.prod:pages/forums/ForumMessagePage:board:Rules-1743582049557","value":{"id":"ForumMessagePage","container":{"id":"Common","headerProps":{"backgroundImageProps":null,"backgroundColor":null,"addComponents":null,"removeComponents":["community.widget.bannerWidget"],"componentOrder":null,"__typename":"QuiltContainerSectionProps"},"headerComponentProps":{"community.widget.breadcrumbWidget":{"disableLastCrumbForDesktop":false}},"footerProps":null,"footerComponentProps":null,"items":[{"id":"message-list","layout":"MAIN_SIDE","bgColor":null,"showTitle":null,"showDescription":null,"textPosition":null,"textColor":null,"sectionEditLevel":null,"bgImage":null,"disableSpacing":null,"edgeToEdgeDisplay":null,"fullHeight":null,"showBorder":null,"__typename":"MainSideQuiltSection","columnMap":{"main":[{"id":"messages.widget.topicWithThreadedReplyListWidget","className":"lia-topic-with-replies","props":{"editLevel":"CONFIGURE"},"__typename":"QuiltComponent"}],"side":[{"id":"messages.widget.relatedContentWidget","className":null,"props":null,"__typename":"QuiltComponent"}],"__typename":"MainSideSectionColumns"}}],"__typename":"QuiltContainer"},"__typename":"Quilt","localOverride":false},"localOverride":false},"CachedAsset:text:en_US-components/common/EmailVerification-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-components/common/EmailVerification-1737726265000","value":{"email.verification.title":"Email Verification Required","email.verification.message.update.email":"To participate in the community, you must first verify your email address. The verification email was sent to {email}. To change your email, visit My Settings.","email.verification.message.resend.email":"To participate in the community, you must first verify your email address. The verification email was sent to {email}. Resend email."},"localOverride":false},"CachedAsset:text:en_US-pages/forums/ForumMessagePage-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-pages/forums/ForumMessagePage-1737726265000","value":{"title":"{contextMessageSubject} | {communityTitle}","errorMissing":"This message cannot be found","name":"Forum Message Page","section.message-list.title":"Forum Discussion","archivedMessageTitle":"This Content Has Been Archived"},"localOverride":false},"CachedAsset:quiltWrapper:onestream.prod:Common:1743581942336":{"__typename":"CachedAsset","id":"quiltWrapper:onestream.prod:Common:1743581942336","value":{"id":"Common","header":{"backgroundImageProps":{"assetName":null,"backgroundSize":"COVER","backgroundRepeat":"NO_REPEAT","backgroundPosition":"CENTER_CENTER","lastModified":null,"__typename":"BackgroundImageProps"},"backgroundColor":"transparent","items":[{"id":"community.widget.navbarWidget","props":{"showUserName":true,"showRegisterLink":true,"useIconLanguagePicker":true,"useLabelLanguagePicker":true,"links":{"sideLinks":[],"mainLinks":[{"children":[{"linkType":"INTERNAL","id":"app-build","params":{"boardId":"AppBuild","categoryId":"your-community"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"workflow-d-i","params":{"boardId":"WorkflowDI","categoryId":"your-community"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"rules","params":{"boardId":"Rules","categoryId":"your-community"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"reporting","params":{"boardId":"Reporting","categoryId":"your-community"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"solution-exchange","params":{"categoryId":"SolutionExchange"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"french-language-forum","params":{"boardId":"FrenchLanguageForum","categoryId":"your-community"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"academicalliances","params":{"boardId":"academicalliances","categoryId":"your-community"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"your-community","params":{"categoryId":"your-community"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"welcome","params":{"boardId":"welcome","categoryId":"resources"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"blog","params":{"boardId":"blog","categoryId":"resources"},"routeName":"BlogBoardPage"},{"linkType":"INTERNAL","id":"bulletins-1","params":{"categoryId":"technicaldocuments"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"tech-talks","params":{"boardId":"TechTalks","categoryId":"NewsAndViews"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"podcast","params":{"boardId":"Podcast","categoryId":"NewsAndViews"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"bulletins","params":{"categoryId":"Bulletins"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"financial-close-compliance-ideas","params":{"boardId":"FinancialCloseComplianceIdeas","categoryId":"Ideas"},"routeName":"IdeaBoardPage"},{"linkType":"INTERNAL","id":"planning-analysis-ideas","params":{"boardId":"PlanningAnalysisIdeas","categoryId":"Ideas"},"routeName":"IdeaBoardPage"},{"linkType":"INTERNAL","id":"advanced-analytics-ideas","params":{"boardId":"AdvancedAnalyticsIdeas","categoryId":"Ideas"},"routeName":"IdeaBoardPage"},{"linkType":"INTERNAL","id":"productivity-ideas","params":{"boardId":"ProductivityIdeas","categoryId":"Ideas"},"routeName":"IdeaBoardPage"},{"linkType":"INTERNAL","id":"market-place-core-ideas","params":{"boardId":"MarketPlaceCoreIdeas","categoryId":"Ideas"},"routeName":"IdeaBoardPage"},{"linkType":"INTERNAL","id":"platform-core","params":{"boardId":"PlatformCore","categoryId":"Ideas"},"routeName":"IdeaBoardPage"}],"linkType":"INTERNAL","id":"ideas","params":{"categoryId":"Ideas"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"platformupgrades","params":{"groupHubId":"platformupgrades"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"taxprovision","params":{"groupHubId":"taxprovision"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"p-a-b","params":{"groupHubId":"PAB"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"customer-advisory-board","params":{"groupHubId":"CustomerAdvisoryBoard"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"sensibleml","params":{"groupHubId":"sensibleml"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"e-s-g-focus-group","params":{"groupHubId":"ESGFocusGroup"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"partner-a-i-services","params":{"groupHubId":"PartnerAIServices"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"projectlongship","params":{"groupHubId":"projectlongship"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"boatlaunchdevelopers","params":{"groupHubId":"boatlaunchdevelopers"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"cpmexpress","params":{"groupHubId":"cpmexpress"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"privatepreview-journalentrymanager-link","params":{"groupHubId":"privatepreview-journalentrymanager"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"n-a-c-a-b-link","params":{"groupHubId":"NACAB"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"e-m-e-a-c-a-b-link","params":{"groupHubId":"EMEACAB"},"routeName":"GroupHubPage"}],"linkType":"INTERNAL","id":"advanced","params":{"categoryId":"Advanced"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"partner-1","params":{"boardId":"Partner","categoryId":"Partner"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"summit-webinar-materials","params":{"boardId":"SummitWebinarMaterials","categoryId":"Partner"},"routeName":"TkbBoardPage"},{"linkType":"INTERNAL","id":"onestreamtaxprovisionpartners","params":{"boardId":"onestreamtaxprovisionpartners","categoryId":"Partner"},"routeName":"TkbBoardPage"}],"linkType":"INTERNAL","id":"partner","params":{"categoryId":"Partner"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"wave","params":{"boardId":"Wave","categoryId":"internal"},"routeName":"TkbBoardPage"},{"linkType":"INTERNAL","id":"internalforum","params":{"boardId":"internalforum","categoryId":"internal"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"internal","params":{"categoryId":"Internal"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"abuse-reports","params":{"boardId":"abuse-reports","categoryId":"community-management"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"filter-notifications","params":{"boardId":"filter-notifications","categoryId":"community-management"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"moderation-archive","params":{"boardId":"moderation-archive","categoryId":"community-management"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"moderation-k-b","params":{"boardId":"ModerationKB","categoryId":"community-management"},"routeName":"TkbBoardPage"},{"linkType":"INTERNAL","id":"introduce","params":{"boardId":"Introduce","categoryId":"community-management"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"community-management","params":{"categoryId":"community-management"},"routeName":"CategoryPage"},{"children":[],"linkType":"INTERNAL","id":"internal-link","params":{"categoryId":"internal"},"routeName":"CategoryPage"}]},"className":"QuiltComponent_lia-component-edit-mode__0nCcm","style":{"boxShadow":"var(--lia-bs-box-shadow-sm)","linkFontWeight":"400","controllerHighlightColor":"hsla(30, 100%, 50%)","dropdownDividerMarginBottom":"10px","hamburgerBorderHover":"none","linkFontSize":"15px","linkBoxShadowHover":"none","backgroundOpacity":0.8,"controllerBorderRadius":"var(--lia-border-radius-50)","hamburgerBgColor":"transparent","linkTextBorderBottom":"none","hamburgerColor":"var(--lia-nav-controller-icon-color)","brandLogoHeight":"80px","linkLetterSpacing":"normal","linkBgHoverColor":"transparent","collapseMenuDividerOpacity":0.16,"paddingBottom":"10px","dropdownPaddingBottom":"15px","dropdownMenuOffset":"2px","hamburgerBgHoverColor":"transparent","borderBottom":"1px solid var(--lia-bs-border-color)","hamburgerBorder":"none","dropdownPaddingX":"10px","brandMarginRightSm":"10px","linkBoxShadow":"none","linkJustifyContent":"center","linkColor":"var(--lia-bs-body-color)","collapseMenuDividerBg":"var(--lia-nav-link-color)","dropdownPaddingTop":"10px","controllerHighlightTextColor":"var(--lia-yiq-dark)","controllerTextColor":"var(--lia-nav-controller-icon-color)","background":{"imageAssetName":"","color":"var(--lia-bs-white)","size":"COVER","repeat":"NO_REPEAT","position":"CENTER_CENTER","imageLastModified":""},"linkBorderRadius":"var(--lia-bs-border-radius-sm)","linkHoverColor":"var(--lia-bs-body-color)","position":"FIXED","linkBorder":"none","linkTextBorderBottomHover":"2px solid var(--lia-bs-gray-800)","brandMarginRight":"30px","hamburgerHoverColor":"var(--lia-nav-controller-icon-color)","linkBorderHover":"none","collapseMenuMarginLeft":"20px","linkFontStyle":"NORMAL","linkPaddingX":"10px","controllerTextHoverColor":"var(--lia-nav-controller-icon-hover-color)","paddingTop":"0px","linkPaddingY":"5px","linkTextTransform":"NONE","dropdownBorderColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","controllerBgHoverColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.1)","linkDropdownPaddingX":"var(--lia-nav-link-px)","linkBgColor":"transparent","linkDropdownPaddingY":"9px","controllerIconColor":"var(--lia-bs-body-color)","dropdownDividerMarginTop":"10px","linkGap":"10px","controllerIconHoverColor":"var(--lia-bs-body-color)"},"showSearchIcon":true,"languagePickerStyle":"iconAndLabel"},"__typename":"QuiltComponent"},{"id":"community.widget.breadcrumbWidget","props":null,"__typename":"QuiltComponent"},{"id":"community.widget.bannerWidget","props":{"backgroundColor":"transparent","visualEffects":{"showBottomBorder":true},"backgroundOpacity":100,"backgroundImageProps":{"assetName":"community-widget-bannerWidget-1730266943818.jpg","backgroundSize":"COVER","lastModified":"1730266947000","backgroundPosition":"CENTER_CENTER","backgroundRepeat":"NO_REPEAT"},"fontColor":"var(--lia-bs-body-color)"},"__typename":"QuiltComponent"}],"__typename":"QuiltWrapperSection"},"footer":{"backgroundImageProps":{"assetName":null,"backgroundSize":"COVER","backgroundRepeat":"NO_REPEAT","backgroundPosition":"CENTER_CENTER","lastModified":null,"__typename":"BackgroundImageProps"},"backgroundColor":"var(--lia-bs-body-color)","items":[{"id":"custom.widget.Footer","props":{"widgetVisibility":"signedInOrAnonymous","useTitle":true,"useBackground":false,"title":"","lazyLoad":false},"__typename":"QuiltComponent"}],"__typename":"QuiltWrapperSection"},"__typename":"QuiltWrapper","localOverride":false},"localOverride":false},"CachedAsset:text:en_US-components/common/ActionFeedback-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-components/common/ActionFeedback-1737726265000","value":{"joinedGroupHub.title":"Welcome","joinedGroupHub.message":"You are now a member of this group and are subscribed to updates.","groupHubInviteNotFound.title":"Invitation Not Found","groupHubInviteNotFound.message":"Sorry, we could not find your invitation to the group. The owner may have canceled the invite.","groupHubNotFound.title":"Group Not Found","groupHubNotFound.message":"The grouphub you tried to join does not exist. It may have been deleted.","existingGroupHubMember.title":"Already Joined","existingGroupHubMember.message":"You are already a member of this group.","accountLocked.title":"Account Locked","accountLocked.message":"Your account has been locked due to multiple failed attempts. Try again in {lockoutTime} minutes.","editedGroupHub.title":"Changes Saved","editedGroupHub.message":"Your group has been updated.","leftGroupHub.title":"Goodbye","leftGroupHub.message":"You are no longer a member of this group and will not receive future updates.","deletedGroupHub.title":"Deleted","deletedGroupHub.message":"The group has been deleted.","groupHubCreated.title":"Group Created","groupHubCreated.message":"{groupHubName} is ready to use","accountClosed.title":"Account Closed","accountClosed.message":"The account has been closed and you will now be redirected to the homepage","resetTokenExpired.title":"Reset Password Link has Expired","resetTokenExpired.message":"Try resetting your password again","invalidUrl.title":"Invalid URL","invalidUrl.message":"The URL you're using is not recognized. Verify your URL and try again.","accountClosedForUser.title":"Account Closed","accountClosedForUser.message":"{userName}'s account is closed","inviteTokenInvalid.title":"Invitation Invalid","inviteTokenInvalid.message":"Your invitation to the community has been canceled or expired.","inviteTokenError.title":"Invitation Verification Failed","inviteTokenError.message":"The url you are utilizing is not recognized. Verify your URL and try again","pageNotFound.title":"Access Denied","pageNotFound.message":"You do not have access to this area of the community or it doesn't exist","eventAttending.title":"Responded as Attending","eventAttending.message":"You'll be notified when there's new activity and reminded as the event approaches","eventInterested.title":"Responded as Interested","eventInterested.message":"You'll be notified when there's new activity and reminded as the event approaches","eventNotFound.title":"Event Not Found","eventNotFound.message":"The event you tried to respond to does not exist.","redirectToRelatedPage.title":"Showing Related Content","redirectToRelatedPageForBaseUsers.title":"Showing Related Content","redirectToRelatedPageForBaseUsers.message":"The content you are trying to access is archived","redirectToRelatedPage.message":"The content you are trying to access is archived","relatedUrl.archivalLink.flyoutMessage":"The content you are trying to access is archived View Archived Content"},"localOverride":false},"CachedAsset:component:custom.widget.Footer-en-1743582058662":{"__typename":"CachedAsset","id":"component:custom.widget.Footer-en-1743582058662","value":{"component":{"id":"custom.widget.Footer","template":{"id":"Footer","markupLanguage":"HTML","style":null,"texts":null,"defaults":{"config":{"applicablePages":[],"description":"","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.Footer","form":null,"config":null,"props":[],"__typename":"Component"}],"grouping":"TEXTHTML","__typename":"ComponentTemplate"},"properties":{"config":{"applicablePages":[],"description":"","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"form":null,"__typename":"Component","localOverride":false},"globalCss":null,"form":null},"localOverride":false},"CachedAsset:text:en_US-components/community/Breadcrumb-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-components/community/Breadcrumb-1737726265000","value":{"navLabel":"Breadcrumbs","dropdown":"Additional parent page navigation"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBanner-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBanner-1737726265000","value":{"messageMarkedAsSpam":"This post has been marked as spam","messageMarkedAsSpam@board:TKB":"This article has been marked as spam","messageMarkedAsSpam@board:BLOG":"This post has been marked as spam","messageMarkedAsSpam@board:FORUM":"This discussion has been marked as spam","messageMarkedAsSpam@board:OCCASION":"This event has been marked as spam","messageMarkedAsSpam@board:IDEA":"This idea has been marked as spam","manageSpam":"Manage Spam","messageMarkedAsAbuse":"This post has been marked as abuse","messageMarkedAsAbuse@board:TKB":"This article has been marked as abuse","messageMarkedAsAbuse@board:BLOG":"This post has been marked as abuse","messageMarkedAsAbuse@board:FORUM":"This discussion has been marked as abuse","messageMarkedAsAbuse@board:OCCASION":"This event has been marked as abuse","messageMarkedAsAbuse@board:IDEA":"This idea has been marked as abuse","preModCommentAuthorText":"This comment will be published as soon as it is approved","preModCommentModeratorText":"This comment is awaiting moderation","messageMarkedAsOther":"This post has been rejected due to other reasons","messageMarkedAsOther@board:TKB":"This article has been rejected due to other reasons","messageMarkedAsOther@board:BLOG":"This post has been rejected due to other reasons","messageMarkedAsOther@board:FORUM":"This discussion has been rejected due to other reasons","messageMarkedAsOther@board:OCCASION":"This event has been rejected due to other reasons","messageMarkedAsOther@board:IDEA":"This idea has been rejected due to other reasons","messageArchived":"This post was archived on {date}","relatedUrl":"View Related Content","relatedContentText":"Showing related content","archivedContentLink":"View Archived Content"},"localOverride":false},"CachedAsset:text:en_US-components/messages/RelatedContentWidget-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/RelatedContentWidget-1737726265000","value":{"title":"Related Content","emptyDescription":"No content to show"},"localOverride":false},"Forum:board:welcome":{"__typename":"Forum","id":"board:welcome","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Blog:board:blog":{"__typename":"Blog","id":"board:blog","blogPolicies":{"__typename":"BlogPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:AppBuild":{"__typename":"Forum","id":"board:AppBuild","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:WorkflowDI":{"__typename":"Forum","id":"board:WorkflowDI","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"entityType":"FORUM","displayId":"WorkflowDI","nodeType":"board","depth":2,"conversationStyle":"FORUM","title":"Workflow and Data Integration","shortTitle":"Workflow and Data Integration","parent":{"__ref":"Category:category:your-community"},"userContext":{"__typename":"NodeUserContext","canAddAttachments":false,"canUpdateNode":false,"canPostMessages":false,"isSubscribed":false},"avatar":null,"description":"Discuss data loading and processing into the application","eventPath":"category:your-community/community:otqon28567board:WorkflowDI/"},"Forum:board:Reporting":{"__typename":"Forum","id":"board:Reporting","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"entityType":"FORUM","displayId":"Reporting","nodeType":"board","depth":2,"conversationStyle":"FORUM","title":"Reporting","shortTitle":"Reporting","parent":{"__ref":"Category:category:your-community"},"userContext":{"__typename":"NodeUserContext","canAddAttachments":false,"canUpdateNode":false,"canPostMessages":false,"isSubscribed":false},"avatar":null,"description":"Questions about Cube Views and Reports","eventPath":"category:your-community/community:otqon28567board:Reporting/"},"Category:category:Advanced":{"__typename":"Category","id":"category:Advanced","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:Bulletins":{"__typename":"Category","id":"category:Bulletins","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"GroupHub:grouphub:taxprovision":{"__typename":"GroupHub","id":"grouphub:taxprovision","grouphubPolicies":{"__typename":"GroupHubPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"entityType":"GROUP_HUB","displayId":"taxprovision","nodeType":"grouphub","depth":2,"title":"OneStream Tax Provision","shortTitle":"OneStream Tax Provision"},"Forum:board:FrenchLanguageForum":{"__typename":"Forum","id":"board:FrenchLanguageForum","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:TechTalks":{"__typename":"Forum","id":"board:TechTalks","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:Podcast":{"__typename":"Forum","id":"board:Podcast","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"GroupHub:grouphub:platformupgrades":{"__typename":"GroupHub","id":"grouphub:platformupgrades","grouphubPolicies":{"__typename":"GroupHubPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:technicaldocuments":{"__typename":"Category","id":"category:technicaldocuments","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"entityType":"CATEGORY","displayId":"technicaldocuments","nodeType":"category","depth":2,"title":"Technical Documents","shortTitle":"Technical Documents"},"Rank:rank:14":{"__typename":"Rank","id":"rank:14","position":13,"name":"Valued Contributor","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:5":{"__typename":"User","id":"user:5","uid":5,"login":"OSAdmin","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2021-07-16T10:44:17.712-04:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.onestreamsoftware.com/t5/s/otqon28567/images/dS01LTExMmk1NkQwQkNDQTk1RTAyNDBF"},"rank":{"__ref":"Rank:rank:14"},"messagesCount":1059,"kudosGivenCount":0,"kudosReceivedCount":118,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":15,"entityType":"USER","eventPath":"community:otqon28567/user:5"},"Tkb:board:AcceptedCodeSample":{"__typename":"Tkb","id":"board:AcceptedCodeSample","entityType":"TKB","displayId":"AcceptedCodeSample","nodeType":"board","depth":3,"conversationStyle":"TKB","title":"Accepted Code Samples","shortTitle":"Accepted Code Samples","parent":{"__ref":"Category:category:technicaldocuments"},"userContext":{"__typename":"NodeUserContext","canAddAttachments":false,"canUpdateNode":false,"canPostMessages":false,"isSubscribed":false},"avatar":null,"description":"OneStream approved sample code snippets and examples to help everyone write rules.","eventPath":"category:technicaldocuments/category:Bulletins/community:otqon28567board:AcceptedCodeSample/"},"TkbTopicMessage:message:6614":{"__typename":"TkbTopicMessage","uid":6614,"subject":"Dashboard: Get or Set Literal Parameter","id":"message:6614","revisionNum":2,"repliesCount":0,"author":{"__ref":"User:user:5"},"depth":0,"hasGivenKudo":false,"helpful":null,"board":{"__ref":"Tkb:board:AcceptedCodeSample"},"conversation":{"__ref":"Conversation:conversation:6614"},"contentWorkflow":{"__typename":"ContentWorkflow","state":"PUBLISH","scheduledPublishTime":null,"scheduledTimezone":null,"shortScheduledTimezone":null,"userContext":{"__typename":"MessageWorkflowContext","canSubmitForReview":null,"canEdit":false,"canRecall":null,"canSubmitForPublication":null,"canReturnToAuthor":null,"canPublish":null,"canReturnToReview":null,"canSchedule":null}},"moderationData":{"__ref":"ModerationData:moderation_data:6614"},"teaser":"","postTime":"2022-04-07T14:08:47.487-04:00","lastPublishTime":"2023-09-28T06:17:42.371-04:00","readOnly":true,"introduction":"","metrics":{"__typename":"MessageMetrics","views":2531},"placeholder":false,"originalMessageForPlaceholder":null,"entityType":"TKB_ARTICLE","eventPath":"category:technicaldocuments/category:Bulletins/community:otqon28567board:AcceptedCodeSample/message:6614"},"Conversation:conversation:6614":{"__typename":"Conversation","id":"conversation:6614","solved":false,"topic":{"__ref":"TkbTopicMessage:message:6614"},"lastPostingActivityTime":"2023-09-28T06:17:42.371-04:00","lastPostTime":"2022-04-07T14:08:47.487-04:00"},"ModerationData:moderation_data:6614":{"__typename":"ModerationData","id":"moderation_data:6614","status":"APPROVED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:6614":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:6614","relatedMessage":{"__ref":"TkbTopicMessage:message:6614"}},"Rank:rank:16":{"__typename":"Rank","id":"rank:16","position":15,"name":"Contributor II","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:268":{"__typename":"User","id":"user:268","uid":268,"login":"RobDessureault","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2021-11-04T08:51:41.974-04:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.onestreamsoftware.com/t5/s/otqon28567/m_assets/avatars/default/avatar-3.svg?time=0"},"rank":{"__ref":"Rank:rank:16"},"messagesCount":218,"kudosGivenCount":19,"kudosReceivedCount":13,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":3,"entityType":"USER","eventPath":"community:otqon28567/user:268"},"Tkb:board:taxprovisiontkb-board":{"__typename":"Tkb","id":"board:taxprovisiontkb-board","entityType":"TKB","displayId":"taxprovisiontkb-board","nodeType":"board","depth":3,"conversationStyle":"TKB","title":"OneStream Tax Provision Articles","shortTitle":"Knowledge Base","parent":{"__ref":"GroupHub:grouphub:taxprovision"},"userContext":{"__typename":"NodeUserContext","canAddAttachments":false,"canUpdateNode":false,"canPostMessages":false,"isSubscribed":false},"avatar":null,"description":"","eventPath":"grouphub:taxprovision/category:Advanced/community:otqon28567board:taxprovisiontkb-board/"},"TkbTopicMessage:message:29377":{"__typename":"TkbTopicMessage","uid":29377,"subject":"Parameters","id":"message:29377","revisionNum":7,"repliesCount":0,"author":{"__ref":"User:user:268"},"depth":0,"hasGivenKudo":false,"helpful":null,"board":{"__ref":"Tkb:board:taxprovisiontkb-board"},"conversation":{"__ref":"Conversation:conversation:29377"},"contentWorkflow":{"__typename":"ContentWorkflow","state":"PUBLISH","scheduledPublishTime":null,"scheduledTimezone":null,"shortScheduledTimezone":null,"userContext":{"__typename":"MessageWorkflowContext","canSubmitForReview":null,"canEdit":false,"canRecall":null,"canSubmitForPublication":null,"canReturnToAuthor":null,"canPublish":null,"canReturnToReview":null,"canSchedule":false}},"moderationData":{"__ref":"ModerationData:moderation_data:29377"},"teaser":"","postTime":"2024-02-05T16:34:17.469-05:00","lastPublishTime":"2024-02-14T15:08:41.887-05:00","readOnly":false,"introduction":"","metrics":{"__typename":"MessageMetrics","views":487},"placeholder":false,"originalMessageForPlaceholder":null,"entityType":"TKB_ARTICLE","eventPath":"grouphub:taxprovision/category:Advanced/community:otqon28567board:taxprovisiontkb-board/message:29377"},"Conversation:conversation:29377":{"__typename":"Conversation","id":"conversation:29377","solved":false,"topic":{"__ref":"TkbTopicMessage:message:29377"},"lastPostingActivityTime":"2024-02-14T15:08:41.887-05:00","lastPostTime":"2024-02-05T16:34:17.469-05:00"},"ModerationData:moderation_data:29377":{"__typename":"ModerationData","id":"moderation_data:29377","status":"APPROVED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:29377":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:29377","relatedMessage":{"__ref":"TkbTopicMessage:message:29377"}},"User:user:532":{"__typename":"User","id":"user:532","uid":532,"login":"Ashok","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2021-11-22T17:35:36.403-05:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.onestreamsoftware.com/t5/s/otqon28567/m_assets/avatars/default/avatar-7.svg?time=0"},"rank":{"__ref":"Rank:rank:18"},"messagesCount":40,"kudosGivenCount":33,"kudosReceivedCount":26,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":2,"entityType":"USER","eventPath":"community:otqon28567/user:532"},"ForumTopicMessage:message:15761":{"__typename":"ForumTopicMessage","uid":15761,"subject":"Literal parameter : issue with unbalanced [ or ] in the text being input","id":"message:15761","revisionNum":2,"repliesCount":5,"author":{"__ref":"User:user:532"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:Reporting"},"conversation":{"__ref":"Conversation:conversation:15761"},"moderationData":{"__ref":"ModerationData:moderation_data:15761"},"postTime":"2023-01-31T19:40:12.910-05:00","lastPublishTime":"2023-05-23T04:41:03.429-04:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":2865},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:your-community/community:otqon28567board:Reporting/message:15761"},"Conversation:conversation:15761":{"__typename":"Conversation","id":"conversation:15761","solved":true,"topic":{"__ref":"ForumTopicMessage:message:15761"},"lastPostingActivityTime":"2023-05-23T04:41:03.429-04:00","lastPostTime":"2023-02-01T11:24:33.793-05:00"},"ModerationData:moderation_data:15761":{"__typename":"ModerationData","id":"moderation_data:15761","status":"UNMODERATED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:15761":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:15761","relatedMessage":{"__ref":"ForumTopicMessage:message:15761"}},"User:user:5123":{"__typename":"User","id":"user:5123","uid":5123,"login":"Tom","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2023-02-02T11:22:11.287-05:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.onestreamsoftware.com/t5/s/otqon28567/m_assets/avatars/default/avatar-3.svg?time=0"},"rank":{"__ref":"Rank:rank:18"},"messagesCount":15,"kudosGivenCount":1,"kudosReceivedCount":3,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:otqon28567/user:5123"},"ForumTopicMessage:message:33138":{"__typename":"ForumTopicMessage","uid":33138,"subject":"Parameter for SQL","id":"message:33138","revisionNum":1,"repliesCount":8,"author":{"__ref":"User:user:5123"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:Rules"},"conversation":{"__ref":"Conversation:conversation:33138"},"moderationData":{"__ref":"ModerationData:moderation_data:33138"},"postTime":"2024-04-19T13:46:18.245-04:00","lastPublishTime":"2024-04-19T13:46:18.245-04:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":2031},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:your-community/community:otqon28567board:Rules/message:33138"},"Conversation:conversation:33138":{"__typename":"Conversation","id":"conversation:33138","solved":true,"topic":{"__ref":"ForumTopicMessage:message:33138"},"lastPostingActivityTime":"2024-04-22T07:53:35.049-04:00","lastPostTime":"2024-04-22T07:53:35.049-04:00"},"ModerationData:moderation_data:33138":{"__typename":"ModerationData","id":"moderation_data:33138","status":"UNMODERATED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:33138":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:33138","relatedMessage":{"__ref":"ForumTopicMessage:message:33138"}},"Rank:rank:19":{"__typename":"Rank","id":"rank:19","position":18,"name":"New Contributor II","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:3953":{"__typename":"User","id":"user:3953","uid":3953,"login":"particle","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2022-10-20T00:38:13.861-04:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.onestreamsoftware.com/t5/s/otqon28567/m_assets/avatars/default/avatar-12.svg?time=0"},"rank":{"__ref":"Rank:rank:19"},"messagesCount":6,"kudosGivenCount":1,"kudosReceivedCount":1,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:otqon28567/user:3953"},"ForumTopicMessage:message:13514":{"__typename":"ForumTopicMessage","uid":13514,"subject":"FdxExecuteCubeView parameters","id":"message:13514","revisionNum":1,"repliesCount":10,"author":{"__ref":"User:user:3953"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:WorkflowDI"},"conversation":{"__ref":"Conversation:conversation:13514"},"moderationData":{"__ref":"ModerationData:moderation_data:13514"},"postTime":"2022-11-16T20:32:16.165-05:00","lastPublishTime":"2022-11-16T20:32:16.165-05:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":6151},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:your-community/community:otqon28567board:WorkflowDI/message:13514"},"Conversation:conversation:13514":{"__typename":"Conversation","id":"conversation:13514","solved":true,"topic":{"__ref":"ForumTopicMessage:message:13514"},"lastPostingActivityTime":"2023-09-01T22:24:56.139-04:00","lastPostTime":"2023-09-01T22:24:56.139-04:00"},"ModerationData:moderation_data:13514":{"__typename":"ModerationData","id":"moderation_data:13514","status":"UNMODERATED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:13514":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:13514","relatedMessage":{"__ref":"ForumTopicMessage:message:13514"}},"CachedAsset:text:en_US-components/community/Navbar-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-components/community/Navbar-1737726265000","value":{"community":"Community Home","inbox":"Inbox","manageContent":"Manage Content","tos":"Terms of Service","forgotPassword":"Forgot Password","themeEditor":"Theme Editor","edit":"Edit Navigation Bar","skipContent":"Skip to content","migrated-link-9":"Support ","reports":"Application Build","migrated-link-7":"News","accepted-code-sample":"Accepted Code Samples","migrated-link-8":"Groups","advanced":"Groups","migrated-link-1":"Internal","migrated-link-2":"Partners","rules":"Rules","migrated-link-0":"Hubs","o-h":"Implementation Q&A Archive","migrated-link-5":"Resources","blog":"Community Blog","migrated-link-6":"IdeaStream","pie":"PIE","migrated-link-3":"Developer Network","wave-presentations":"WAVE Presentations","migrated-link-4":"Forums","partner-1":"Partner Forum","your-community":"Forums","internal-link":"Internal","privatepreview-journalentrymanager-link":"Private Preview: Journey Entry Manager","planning-analysis-ideas":"Planning & Analysis","welcome":"Community Announcements","filter-notifications":"Filter Notifications","partner-a-i-services":"Partner AI Services","foundational-design-guides":"Foundational Design Guides","platformupgrades":"Platform v8+ Upgrades","sensibleml":"Sensible ML","ideas":"IdeaStream","academicalliances":"Academic Alliances","market-place-core-ideas":"OneStream Solutions","news-and-views":"Internal","e-s-g-focus-group":"ESG Focus Group","foundationaldesign":"Foundational Design Guides","community-management":"Moderate","community-announcements":"Community Announcements","internal":"Internal","workflow-d-i":"Workflow and Data Integration","abuse-reports":"Abuse Reports","internalforum":"Internal Consultants (PIE)","productivity-":"Productivity","customer-advisory-board":"Customer Advisory Board- CAB","platform":"Platform","wave":"WAVE Content","planning-":"Planning & Analysis","reports-1":"Application Build","app-build":"Application Build","financial-close-compliance-ideas":"Financial Close & Consolidations","podcast":"The OneStream Podcast: Continue the Conversation","moderation-archive":"Moderation Forum Archive","technical-documents":"Technical Documents","p-a-b":"Partner Advisory Board","data-workflow--integration-":"Data Workflow & Integration","moderation-k-b":"Moderation KB Archive","reporting":"Reporting","bulletins":"Resources","cpmexpress":"CPM Express","summit-":"Summit + Webinar Materials","introduce":"Introduce Yourself","community-blog":"Community Blog","solution-exchange":"Solution Exchange","productivity-ideas":"Productivity","partner-discussions":"Partner Forum","tech-talks":"OneStream Tech Talks: Continue the Conversation","bulletins-1":"Technical Documents","advanced-analytics-ideas":"Advanced Analytics & AI","boatlaunchdevelopers":"Boat Launch","platform-core":"Platform","summit-webinar-materials":"Summit and Webinar Materials","onestream-community-resources":"OneStream Community Resources","partner":"Partners","e-m-e-a-c-a-b-link":"EMEA Customer Advisory Board","french-language-forum":"French Language Forum","projectlongship":"Project Longship","taxprovision":"Tax Provision","n-a-c-a-b-link":"NA Customer Advisory Board","onestreamtaxprovisionpartners":"OneStream Tax Provision"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarHamburgerDropdown-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarHamburgerDropdown-1737726265000","value":{"hamburgerLabel":"Side Menu"},"localOverride":false},"CachedAsset:text:en_US-components/community/BrandLogo-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-components/community/BrandLogo-1737726265000","value":{"logoAlt":"Khoros","themeLogoAlt":"Brand Logo"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarTextLinks-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarTextLinks-1737726265000","value":{"more":"More"},"localOverride":false},"CachedAsset:text:en_US-components/search/SpotlightSearchIcon-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-components/search/SpotlightSearchIcon-1737726265000","value":{"search":"Search"},"localOverride":false},"CachedAsset:text:en_US-components/authentication/AuthenticationLink-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-components/authentication/AuthenticationLink-1737726265000","value":{"title.login":"Sign In","title.registration":"Register","title.forgotPassword":"Forgot Password","title.multiAuthLogin":"Sign In"},"localOverride":false},"CachedAsset:text:en_US-components/nodes/NodeLink-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-components/nodes/NodeLink-1737726265000","value":{"place":"Place {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageView/MessageViewStandard-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewStandard-1737726265000","value":{"anonymous":"Anonymous","author":"{messageAuthorLogin}","authorBy":"{messageAuthorLogin}","board":"{messageBoardTitle}","replyToUser":" to {parentAuthor}","showMoreReplies":"Show More","replyText":"Reply","repliesText":"Replies","markedAsSolved":"Marked as Solved","movedMessagePlaceholder.BLOG":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholder.TKB":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholder.FORUM":"{count, plural, =0 {This reply has been} other {These replies have been} }","movedMessagePlaceholder.IDEA":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholder.OCCASION":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholderUrlText":"moved.","messageStatus":"Status: ","statusChanged":"Status changed: {previousStatus} to {currentStatus}","statusAdded":"Status added: {status}","statusRemoved":"Status removed: {status}","labelExpand":"expand replies","labelCollapse":"collapse replies","unhelpfulReason.reason1":"Content is outdated","unhelpfulReason.reason2":"Article is missing information","unhelpfulReason.reason3":"Content is for a different Product","unhelpfulReason.reason4":"Doesn't match what I was searching for"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageDeepLink-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageDeepLink-1737726265000","value":{"viewFullDiscussion@board:FORUM":"View Full Discussion ({repliesCount} Replies)","viewFullDiscussion@board:BLOG":"View Full Discussion ({repliesCount} Comments)","viewFullDiscussion@board:TKB":"View Full Discussion ({repliesCount} Comments)","viewFullDiscussion@board:IDEA":"View Full Discussion ({repliesCount} Comments)","viewFullDiscussion@board:OCCASION":"View Full Discussion ({repliesCount} Comments)","showParents@board:FORUM":"Show Parent Replies","showParents@board:BLOG":"Show Parent Comments","showParents@board:TKB":"Show Parent Comments","showParents@board:IDEA":"Show Parent Comments","showParents@board:OCCASION":"Show Parent Comments"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageReplyCallToAction-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyCallToAction-1737726265000","value":{"leaveReply":"Leave a reply...","leaveReply@board:BLOG@message:root":"Leave a comment...","leaveReply@board:TKB@message:root":"Leave a comment...","leaveReply@board:IDEA@message:root":"Leave a comment...","leaveReply@board:OCCASION@message:root":"Leave a comment...","repliesTurnedOff.FORUM":"Replies are turned off for this topic","repliesTurnedOff.BLOG":"Comments are turned off for this topic","repliesTurnedOff.TKB":"Comments are turned off for this topic","repliesTurnedOff.IDEA":"Comments are turned off for this topic","repliesTurnedOff.OCCASION":"Comments are turned off for this topic","infoText":"Stop poking me!"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/QueryHandler-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/QueryHandler-1737726265000","value":{"title":"Query Handler"},"localOverride":false},"QueryVariables:MessageSolutions":{"__typename":"QueryVariables","id":"MessageSolutions","value":{"first":10,"constraints":{"topicId":{"eq":"message:21239"},"solution":{"eq":true}},"sorts":{"postTime":{"direction":"ASC"}},"useAvatar":true,"useAuthorLogin":true,"useAuthorRank":false,"useBody":true,"useKudosCount":false,"useTimeToRead":false,"useMedia":true,"useRepliesCount":false,"useSearchSnippet":false,"useAcceptedSolutionButton":true,"useSolvedBadge":false,"useAttachments":true,"useTags":false,"useUserHoverCard":false,"useNodeHoverCard":false,"usePreviewSubjectModal":false,"useMessageStatus":false}},"ROOT_MUTATION":{"__typename":"Mutation"},"CachedAsset:text:en_US-components/community/NavbarDropdownToggle-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarDropdownToggle-1737726265000","value":{"ariaLabelClosed":"Press the down arrow to open the menu"},"localOverride":false},"CachedAsset:text:en_US-components/messages/EscalatedMessageBanner-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/EscalatedMessageBanner-1737726265000","value":{"escalationMessage":"Escalated to Salesforce by {username} on {date}","viewDetails":"View Details","modalTitle":"Case Details","escalatedBy":"Escalated by: ","escalatedOn":"Escalated on: ","caseNumber":"Case Number: ","status":"Status: ","lastUpdateDate":"Last Update: ","automaticEscalation":"automatic escalation","anonymous":"Anonymous"},"localOverride":false},"CachedAsset:text:en_US-components/users/UserLink-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-components/users/UserLink-1737726265000","value":{"authorName":"View Profile: {author}","anonymous":"Anonymous"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/users/UserRank-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserRank-1737726265000","value":{"rankName":"{rankName}","userRank":"Author rank {rankName}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageTime-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageTime-1737726265000","value":{"postTime":"Published: {time}","lastPublishTime":"Last Update: {time}","conversation.lastPostingActivityTime":"Last posting activity time: {time}","conversation.lastPostTime":"Last post time: {time}","moderationData.rejectTime":"Rejected time: {time}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSolvedBadge-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSolvedBadge-1737726265000","value":{"solved":"Solved"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSubject-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSubject-1737726265000","value":{"noSubject":"(no subject)"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBody-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBody-1737726265000","value":{"showMessageBody":"Show More","mentionsErrorTitle":"{mentionsType, select, board {Board} user {User} message {Message} other {}} No Longer Available","mentionsErrorMessage":"The {mentionsType} you are trying to view has been removed from the community.","videoProcessing":"Video is being processed. Please try again in a few minutes.","bannerTitle":"Video provider requires cookies to play the video. Accept to continue or {url} it directly on the provider's site.","buttonTitle":"Accept","urlText":"watch"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageCustomFields-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageCustomFields-1737726265000","value":{"CustomField.default.label":"Value of {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageReplyButton-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyButton-1737726265000","value":{"repliesCount":"{count}","title":"Reply","title@board:BLOG@message:root":"Comment","title@board:TKB@message:root":"Comment","title@board:IDEA@message:root":"Comment","title@board:OCCASION@message:root":"Comment"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSolutionList-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSolutionList-1737726265000","value":{"emptyDescription":"No has been message solutions yet"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageView/MessageViewInline-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewInline-1737726265000","value":{"bylineAuthor":"{bylineAuthor}","bylineBoard":"{bylineBoard}","anonymous":"Anonymous","place":"Place {bylineBoard}","gotoParent":"Go to parent {name}"},"localOverride":false},"CachedAsset:text:en_US-components/customComponent/CustomComponent-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-components/customComponent/CustomComponent-1737726265000","value":{"errorMessage":"Error rendering component id: {customComponentId}","bannerTitle":"Video provider requires cookies to play the video. Accept to continue or {url} it directly on the provider's site.","buttonTitle":"Accept","urlText":"watch"},"localOverride":false},"User:user:1118":{"__typename":"User","id":"user:1118","uid":1118,"login":"Omkareshwar","deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://community.onestreamsoftware.com/t5/s/otqon28567/m_assets/avatars/default/avatar-2.svg?time=0"},"rank":{"__ref":"Rank:rank:16"},"email":"","messagesCount":77,"biography":null,"topicsCount":8,"kudosReceivedCount":173,"kudosGivenCount":116,"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2022-01-07T07:58:12.782-05:00","confirmEmailStatus":null},"followersCount":null,"solutionsCount":7},"ModerationData:moderation_data:21249":{"__typename":"ModerationData","id":"moderation_data:21249","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"Revision:revision:21249_1":{"__typename":"Revision","id":"revision:21249_1","lastEditTime":"2023-06-23T09:33:44.967-04:00"},"User:user:5217":{"__typename":"User","id":"user:5217","uid":5217,"login":"RobbSalzmann","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2023-02-14T12:24:35.378-05:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.onestreamsoftware.com/t5/s/otqon28567/images/dS01MjE3LU1udm1PUw?image-coordinates=0%2C0%2C110%2C110"},"entityType":"USER","eventPath":"community:otqon28567/user:5217","rank":{"__ref":"Rank:rank:13"}},"ModerationData:moderation_data:21267":{"__typename":"ModerationData","id":"moderation_data:21267","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"AssociatedImage:{\"url\":\"https://community.onestreamsoftware.com/t5/s/otqon28567/images/bS0yMTI2Ny01MzI1aTNBQkU4RDk3MEQ0NzU2OTc?revision=2\"}":{"__typename":"AssociatedImage","url":"https://community.onestreamsoftware.com/t5/s/otqon28567/images/bS0yMTI2Ny01MzI1aTNBQkU4RDk3MEQ0NzU2OTc?revision=2","title":"RobbSalzmann_1-1687546284465.png","associationType":"BODY","width":841,"height":310,"altText":null},"AssociatedImage:{\"url\":\"https://community.onestreamsoftware.com/t5/s/otqon28567/images/bS0yMTI2Ny01MzI2aTU3RTQ3QUMzMjExNkNGNjk?revision=2\"}":{"__typename":"AssociatedImage","url":"https://community.onestreamsoftware.com/t5/s/otqon28567/images/bS0yMTI2Ny01MzI2aTU3RTQ3QUMzMjExNkNGNjk?revision=2","title":"RobbSalzmann_2-1687546376131.png","associationType":"BODY","width":871,"height":308,"altText":null},"AcceptedSolutionMessage:message:21267":{"__typename":"AcceptedSolutionMessage","author":{"__ref":"User:user:5217"},"id":"message:21267","revisionNum":2,"uid":21267,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:Rules"},"parent":{"__ref":"ForumTopicMessage:message:21239"},"conversation":{"__ref":"Conversation:conversation:21239"},"subject":"Re: Literal parameters and multiple users","moderationData":{"__ref":"ModerationData:moderation_data:21267"},"body":"Literal Parameters values are application-wide, session inspecfic. Things like formats and colors work well in Literal parameters
For user/session specific parameters, use Input Parameters:
In your code, these Input Parameters are oddly named \"ModifiedSubVars\". You change the value of the ModifiedSubVars on the returned Task Result object, e.g. XFLoadDashboardTaskResult, XFSelectionChangedTaskResult depending on what event you're handling. Be sure to also set one or all of the ChangeCustomSubstVarsIn properties to True.
E.g.
selectionChangedTaskResult.ChangeCustomSubstVarsInDashboard = True
selectionChangedTaskResult.ModifiedCustomSubstVars.Add(\"pm_myParameter_Name\", \"User Specific Value\")
Literal Parameters values are application-wide, session inspecfic. Things like formats and colors work well in Literal parameters
For user/session specific parameters, use Input Parameters:
In your code, these Input Parameters are oddly named \"ModifiedSubVars\". You change the value of the ModifiedSubVars on the returned Task Result object, e.g. XFLoadDashboardTaskResult, XFSelectionChangedTaskResult depending on what event you're handling. Be sure to also set one or all of the ChangeCustomSubstVarsIn properties to True.
E.g.
selectionChangedTaskResult.ChangeCustomSubstVarsInDashboard = True
selectionChangedTaskResult.ModifiedCustomSubstVars.Add(\"pm_myParameter_Name\", \"User Specific Value\")
It finally works! The problem was that the popup came out every time the dashboard refreshed, thus every time this section of the script was triggered:
Case Is = DashboardExtenderFunctionType.LoadDashboard
If args.FunctionName.XFEqualsIgnoreCase(\"LoadFunction\") Then
.....
End If
I managed to avoid the pop up to come out by adding a couple of lines of code:
Case Is = DashboardExtenderFunctionType.LoadDashboard
If args.FunctionName.XFEqualsIgnoreCase(\"LoadFunction\") Then
loadDashboardTaskResult.ChangeCustomSubstVarsInDashboard = True
If Not(args.LoadDashboardTaskInfo.CustomSubstVarsFromPriorRun.XFGetValue(\"p_RowEntityList\").Equals(\"None\")) Then
loadDashboardTaskResult.ModifiedCustomSubstVars.Add(\"p_RowEntityList\", args.LoadDashboardTaskInfo.CustomSubstVarsFromPriorRun.XFGetValue(\"p_RowEntityList\"))
loadDashboardTaskResult.ModifiedCustomSubstVars.Add(\"p_RowAccList\", args.LoadDashboardTaskInfo.CustomSubstVarsFromPriorRun.XFGetValue(\"p_RowAccList\"))
loadDashboardTaskResult.ModifiedCustomSubstVars.Add(\"p_RowDocList\", args.LoadDashboardTaskInfo.CustomSubstVarsFromPriorRun.XFGetValue(\"p_RowDocList\"))
Return loadDashboardTaskResult
Else
loadDashboardTaskResult.ModifiedCustomSubstVars.Add(\"p_RowEntityList\", \"None\")
loadDashboardTaskResult.ModifiedCustomSubstVars.Add(\"p_RowAccList\", \"None\")
loadDashboardTaskResult.ModifiedCustomSubstVars.Add(\"p_RowDocList\", \"None\")
Return loadDashboardTaskResult
End If
End If
The rest of the script is structured as Rob suggested.
Thank you all for the help!
","body@stripHtml({\"removeProcessingText\":true,\"removeSpoilerMarkup\":true,\"removeTocMarkup\":true,\"truncateLength\":200})@stringLength":"203","postTime":"2023-06-30T03:49:51.534-04:00","lastPublishTime":"2023-06-30T03:49:51.534-04:00","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"attachments":{"__typename":"AttachmentConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"solution":true,"metrics":{"__typename":"MessageMetrics","views":7575},"placeholder":false,"originalMessageForPlaceholder":null,"videos":{"__typename":"VideoConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"isEscalated":null,"entityType":"FORUM_REPLY","eventPath":"category:your-community/community:otqon28567board:Rules/message:21239/message:21453","customFields":[],"readOnly":false,"editFrozen":false,"body@stringLength":"2183","rawBody":"It finally works! The problem was that the popup came out every time the dashboard refreshed, thus every time this section of the script was triggered:
Case Is = DashboardExtenderFunctionType.LoadDashboard
If args.FunctionName.XFEqualsIgnoreCase(\"LoadFunction\") Then
.....
End If
I managed to avoid the pop up to come out by adding a couple of lines of code:
Case Is = DashboardExtenderFunctionType.LoadDashboard
If args.FunctionName.XFEqualsIgnoreCase(\"LoadFunction\") Then
loadDashboardTaskResult.ChangeCustomSubstVarsInDashboard = True
If Not(args.LoadDashboardTaskInfo.CustomSubstVarsFromPriorRun.XFGetValue(\"p_RowEntityList\").Equals(\"None\")) Then
loadDashboardTaskResult.ModifiedCustomSubstVars.Add(\"p_RowEntityList\", args.LoadDashboardTaskInfo.CustomSubstVarsFromPriorRun.XFGetValue(\"p_RowEntityList\"))
loadDashboardTaskResult.ModifiedCustomSubstVars.Add(\"p_RowAccList\", args.LoadDashboardTaskInfo.CustomSubstVarsFromPriorRun.XFGetValue(\"p_RowAccList\"))
loadDashboardTaskResult.ModifiedCustomSubstVars.Add(\"p_RowDocList\", args.LoadDashboardTaskInfo.CustomSubstVarsFromPriorRun.XFGetValue(\"p_RowDocList\"))
Return loadDashboardTaskResult
Else
loadDashboardTaskResult.ModifiedCustomSubstVars.Add(\"p_RowEntityList\", \"None\")
loadDashboardTaskResult.ModifiedCustomSubstVars.Add(\"p_RowAccList\", \"None\")
loadDashboardTaskResult.ModifiedCustomSubstVars.Add(\"p_RowDocList\", \"None\")
Return loadDashboardTaskResult
End If
End If
The rest of the script is structured as Rob suggested.
Thank you all for the help!
","kudosSumWeight":1,"repliesCount":2,"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:21453_1"},"latestVersion":null,"visibilityScope":"PUBLIC","messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}}},"QueryVariables:ReplyList:message:21249:1":{"__typename":"QueryVariables","id":"ReplyList:message:21249:1","value":{"id":"message:21249","first":10,"sorts":{"kudosSumWeight":{"direction":"DESC","order":0},"postTime":{"direction":"ASC","order":1}},"repliesFirst":3,"repliesFirstDepthThree":1,"repliesSorts":{"kudosSumWeight":{"direction":"DESC","order":0},"postTime":{"direction":"ASC","order":1}},"useAvatar":true,"useAuthorLogin":true,"useAuthorRank":true,"useBody":true,"useKudosCount":true,"useTimeToRead":false,"useMedia":false,"useReadOnlyIcon":false,"useRepliesCount":true,"useSearchSnippet":false,"useAcceptedSolutionButton":true,"useSolvedBadge":false,"useAttachments":false,"attachmentsFirst":5,"useTags":false,"useNodeAncestors":false,"useUserHoverCard":false,"useNodeHoverCard":false,"useModerationStatus":true,"usePreviewSubjectModal":false,"useMessageStatus":true}},"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserAvatar-1737726265000","value":{"altText":"{login}'s avatar","altTextGeneric":"User's avatar"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/ranks/UserRankLabel-1737726265000","value":{"altTitle":"Icon for {rankName} rank"},"localOverride":false},"CachedAsset:text:en_US-components/messages/AcceptedSolutionButton-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/AcceptedSolutionButton-1737726265000","value":{"accept":"Mark as Solution","accepted":"Marked as Solution","errorHeader":"Error!","errorAdd":"There was an error marking as solution.","errorRemove":"There was an error unmarking as solution.","solved":"Solved","topicAlreadySolvedErrorTitle":"Solution Already Exists","topicAlreadySolvedErrorDesc":"Refresh the browser to view the existing solution"},"localOverride":false},"CachedAsset:text:en_US-components/messages/ThreadedReplyList-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/ThreadedReplyList-1737726265000","value":{"title":"{count, plural, one{# Reply} other{# Replies}}","title@board:BLOG":"{count, plural, one{# Comment} other{# Comments}}","title@board:TKB":"{count, plural, one{# Comment} other{# Comments}}","title@board:IDEA":"{count, plural, one{# Comment} other{# Comments}}","title@board:OCCASION":"{count, plural, one{# Comment} other{# Comments}}","noRepliesTitle":"No Replies","noRepliesTitle@board:BLOG":"No Comments","noRepliesTitle@board:TKB":"No Comments","noRepliesTitle@board:IDEA":"No Comments","noRepliesTitle@board:OCCASION":"No Comments","noRepliesDescription":"Be the first to reply","noRepliesDescription@board:BLOG":"Be the first to comment","noRepliesDescription@board:TKB":"Be the first to comment","noRepliesDescription@board:IDEA":"Be the first to comment","noRepliesDescription@board:OCCASION":"Be the first to comment","messageReadOnlyAlert:BLOG":"Comments have been turned off for this post","messageReadOnlyAlert:TKB":"Comments have been turned off for this article","messageReadOnlyAlert:IDEA":"Comments have been turned off for this idea","messageReadOnlyAlert:FORUM":"Replies have been turned off for this discussion","messageReadOnlyAlert:OCCASION":"Comments have been turned off for this event"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/nodes/NodeIcon-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/nodes/NodeIcon-1737726265000","value":{"contentType":"Content Type {style, select, FORUM {Forum} BLOG {Blog} TKB {Knowledge Base} IDEA {Ideas} OCCASION {Events} other {}} icon"},"localOverride":false},"Revision:revision:21453_1":{"__typename":"Revision","id":"revision:21453_1","lastEditTime":"2023-06-30T03:49:51.534-04:00"},"Rank:rank:13":{"__typename":"Rank","id":"rank:13","position":12,"name":"Valued Contributor II","color":"333333","icon":null,"rankStyle":"TEXT"},"Revision:revision:21267_2":{"__typename":"Revision","id":"revision:21267_2","lastEditTime":"2023-06-23T16:11:42.084-04:00"},"Rank:rank:5":{"__typename":"Rank","id":"rank:5","position":2,"name":"VIP","color":"660099","icon":null,"rankStyle":"TEXT"},"User:user:171":{"__typename":"User","id":"user:171","uid":171,"login":"ckattookaran","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2021-10-29T18:34:08.485-04:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.onestreamsoftware.com/t5/s/otqon28567/m_assets/avatars/default/avatar-11.svg?time=0"},"rank":{"__ref":"Rank:rank:5"},"entityType":"USER","eventPath":"community:otqon28567/user:171"},"ModerationData:moderation_data:21293":{"__typename":"ModerationData","id":"moderation_data:21293","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:21293":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:171"},"id":"message:21293","revisionNum":1,"uid":21293,"depth":2,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:Rules"},"parent":{"__ref":"ForumReplyMessage:message:21249"},"conversation":{"__ref":"Conversation:conversation:21239"},"subject":"Re: Literal parameters and multiple users","moderationData":{"__ref":"ModerationData:moderation_data:21293"},"body":"I wouldn't recommend storing parameters in tables. That is what session variables are for. Please do not create tables when you can use existing functionality.
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"161","kudosSumWeight":2,"repliesCount":0,"postTime":"2023-06-26T09:05:03.887-04:00","lastPublishTime":"2023-06-26T09:05:03.887-04:00","metrics":{"__typename":"MessageMetrics","views":7730},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:your-community/community:otqon28567board:Rules/message:21239/message:21293","replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"readOnly":false,"editFrozen":false,"body@stringLength":"166","rawBody":"I wouldn't recommend storing parameters in tables. That is what session variables are for. Please do not create tables when you can use existing functionality.
","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:21293_1"},"latestVersion":null,"messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}}},"CachedAsset:text:en_US-components/tags/TagView/TagViewChip-1737726265000":{"__typename":"CachedAsset","id":"text:en_US-components/tags/TagView/TagViewChip-1737726265000","value":{"tagLabelName":"Tag name {tagName}"},"localOverride":false},"Revision:revision:21293_1":{"__typename":"Revision","id":"revision:21293_1","lastEditTime":"2023-06-26T09:05:03.887-04:00"}}}},"page":"/forums/ForumMessagePage/ForumMessagePage","query":{"boardId":"Rules","messageSubject":"literal-parameters-and-multiple-users","messageId":"21239","replyId":"21249"},"buildId":"1X_rVGuKI_JRqNV8zH-FY","runtimeConfig":{"buildInformationVisible":false,"logLevelApp":"info","logLevelMetrics":"info","openTelemetryClientEnabled":false,"openTelemetryConfigName":"onestream","openTelemetryServiceVersion":"25.2.0","openTelemetryUniverse":"prod","openTelemetryCollector":"http://localhost:4318","openTelemetryRouteChangeAllowedTime":"5000","apolloDevToolsEnabled":false,"inboxMuteWipFeatureEnabled":false},"isFallback":false,"isExperimentalCompile":false,"dynamicIds":["./components/seo/QAPageSchema/QAPageSchema.tsx","./components/community/Navbar/NavbarWidget.tsx","./components/community/Breadcrumb/BreadcrumbWidget.tsx","./components/messages/TopicWithThreadedReplyListWidget/TopicWithThreadedReplyListWidget.tsx","./components/messages/RelatedContentWidget/RelatedContentWidget.tsx","./components/customComponent/CustomComponent/CustomComponent.tsx","./components/messages/MessageView/MessageViewStandard/MessageViewStandard.tsx","../shared/client/components/common/List/UnstyledList/UnstyledList.tsx","./components/messages/MessageView/MessageView.tsx","./components/messages/MessageView/MessageViewInline/MessageViewInline.tsx","./components/customComponent/CustomComponentContent/HtmlContent.tsx","./components/customComponent/CustomComponentContent/CustomComponentScripts.tsx","../shared/client/components/common/List/UnwrappedList/UnwrappedList.tsx","./components/tags/TagView/TagView.tsx","./components/tags/TagView/TagViewChip/TagViewChip.tsx"],"appGip":true,"scriptLoader":[]}