"}},"componentScriptGroups({\"componentId\":\"custom.widget.Custom_Footer_Snaplogic_Subfooter\"})":{"__typename":"ComponentScriptGroups","scriptGroups":{"__typename":"ComponentScriptGroupsDefinition","afterInteractive":{"__typename":"PageScriptGroupDefinition","group":"AFTER_INTERACTIVE","scriptIds":[]},"lazyOnLoad":{"__typename":"PageScriptGroupDefinition","group":"LAZY_ON_LOAD","scriptIds":[]}},"componentScripts":[]},"message({\"id\":\"message:24776\"})":{"__ref":"ForumReplyMessage:message:24776"},"message({\"id\":\"message:18760\"})":{"__ref":"ForumReplyMessage:message:18760"},"message({\"id\":\"message:18761\"})":{"__ref":"ForumReplyMessage:message:18761"},"message({\"id\":\"message:24755\"})":{"__ref":"AcceptedSolutionMessage:message:24755"},"message({\"id\":\"message:24760\"})":{"__ref":"ForumReplyMessage:message:24760"},"message({\"id\":\"message:18762\"})":{"__ref":"AcceptedSolutionMessage:message:18762"},"message({\"id\":\"message:24751\"})":{"__ref":"AcceptedSolutionMessage:message:24751"},"message({\"id\":\"message:24680\"})":{"__ref":"ForumReplyMessage:message:24680"},"message({\"id\":\"message:24681\"})":{"__ref":"ForumReplyMessage:message:24681"},"messages:{\"constraints\":{\"solution\":{\"eq\":true},\"topicId\":{\"eq\":\"message:18759\"}},\"sorts\":{\"postTime\":{\"direction\":\"ASC\"}}}":{"__typename":"MessageConnection","edges":[{"__typename":"MessageEdge","cursor":"MjUuOXwyLjF8aXwxMHwzOToxfGludCwxODc2MiwxODc2Mg","node":{"__ref":"AcceptedSolutionMessage:message:18762"}},{"__typename":"MessageEdge","cursor":"MjUuOXwyLjF8aXwxMHwzOToxfGludCwxODc2MiwyNDc1MQ","node":{"__ref":"AcceptedSolutionMessage:message:24751"}},{"__typename":"MessageEdge","cursor":"MjUuOXwyLjF8aXwxMHwzOToxfGludCwxODc2MiwyNDc1NQ","node":{"__ref":"AcceptedSolutionMessage:message:24755"}}],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null},"totalCount":3},"message({\"id\":\"message:24738\"})":{"__ref":"ForumReplyMessage:message:24738"},"message({\"id\":\"message:24759\"})":{"__ref":"ForumReplyMessage:message:24759"}},"Theme:customTheme1":{"__typename":"Theme","id":"customTheme1"},"User:user:-1":{"__typename":"User","id":"user:-1","entityType":"USER","eventPath":"community:iaudz84835/user:-1","uid":-1,"login":"Retired","email":"","avatar":null,"rank":null,"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":"ANONYMOUS","registrationTime":null,"confirmEmailStatus":false,"registrationAccessLevel":"VIEW","ssoRegistrationFields":[]},"ssoId":null,"profileSettings":{"__typename":"ProfileSettings","dateDisplayStyle":{"__typename":"InheritableStringSettingWithPossibleValues","key":"layout.friendly_dates_enabled","value":"true","localValue":"true","possibleValues":["true","false"]},"dateDisplayFormat":{"__typename":"InheritableStringSetting","key":"layout.format_pattern_date","value":"MM-dd-yyyy","localValue":"MM-dd-yyyy"},"language":{"__typename":"InheritableStringSettingWithPossibleValues","key":"profile.language","value":"en-US","localValue":null,"possibleValues":["en-US","es-ES"]},"repliesSortOrder":{"__typename":"InheritableStringSettingWithPossibleValues","key":"config.user_replies_sort_order","value":"DEFAULT","localValue":"DEFAULT","possibleValues":["DEFAULT","LIKES","PUBLISH_TIME","REVERSE_PUBLISH_TIME"]}},"deleted":false},"CachedAsset:pages-1759529115984":{"__typename":"CachedAsset","id":"pages-1759529115984","value":[{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"BlogViewAllPostsPage","type":"BLOG","urlPath":"/category/:categoryId/blog/:boardId/all-posts/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"CasePortalPage","type":"CASE_PORTAL","urlPath":"/caseportal","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"CreateGroupHubPage","type":"GROUP_HUB","urlPath":"/groups/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"CaseViewPage","type":"CASE_DETAILS","urlPath":"/case/:caseId/:caseNumber","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"InboxPage","type":"COMMUNITY","urlPath":"/inbox","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"HelpFAQPage","type":"COMMUNITY","urlPath":"/help","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"IdeaMessagePage","type":"IDEA_POST","urlPath":"/idea/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"IdeaViewAllIdeasPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId/all-ideas/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"LoginPage","type":"USER","urlPath":"/signin","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"WorkstreamsPage","type":"COMMUNITY","urlPath":"/workstreams","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"BlogPostPage","type":"BLOG","urlPath":"/category/:categoryId/blogs/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"ThemeEditorPage","type":"COMMUNITY","urlPath":"/designer/themes","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"TkbViewAllArticlesPage","type":"TKB","urlPath":"/category/:categoryId/kb/:boardId/all-articles/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"OccasionEditPage","type":"EVENT","urlPath":"/event/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"OAuthAuthorizationAllowPage","type":"USER","urlPath":"/auth/authorize/allow","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"PageEditorPage","type":"COMMUNITY","urlPath":"/designer/pages","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"PostPage","type":"COMMUNITY","urlPath":"/category/:categoryId/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"ForumBoardPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"TkbBoardPage","type":"TKB","urlPath":"/category/:categoryId/kb/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"EventPostPage","type":"EVENT","urlPath":"/category/:categoryId/events/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"UserBadgesPage","type":"COMMUNITY","urlPath":"/users/:login/:userId/badges","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"GroupHubMembershipAction","type":"GROUP_HUB","urlPath":"/membership/join/:nodeId/:membershipType","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"MaintenancePage","type":"COMMUNITY","urlPath":"/maintenance","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"IdeaReplyPage","type":"IDEA_REPLY","urlPath":"/idea/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"UserSettingsPage","type":"USER","urlPath":"/mysettings/:userSettingsTab","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"GroupHubsPage","type":"GROUP_HUB","urlPath":"/groups","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"ForumPostPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"OccasionRsvpActionPage","type":"OCCASION","urlPath":"/event/:boardId/:messageSubject/:messageId/rsvp/:responseType","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"VerifyUserEmailPage","type":"USER","urlPath":"/verifyemail/:userId/:verifyEmailToken","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"AllOccasionsPage","type":"OCCASION","urlPath":"/category/:categoryId/events/:boardId/all-events/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"EventBoardPage","type":"EVENT","urlPath":"/category/:categoryId/events/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"TkbReplyPage","type":"TKB_REPLY","urlPath":"/kb/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"IdeaBoardPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"CommunityGuideLinesPage","type":"COMMUNITY","urlPath":"/communityguidelines","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"CaseCreatePage","type":"SALESFORCE_CASE_CREATION","urlPath":"/caseportal/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"TkbEditPage","type":"TKB","urlPath":"/kb/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"ForgotPasswordPage","type":"USER","urlPath":"/forgotpassword","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"IdeaEditPage","type":"IDEA","urlPath":"/idea/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"TagPage","type":"COMMUNITY","urlPath":"/tag/:tagName","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"BlogBoardPage","type":"BLOG","urlPath":"/category/:categoryId/blog/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"OccasionMessagePage","type":"OCCASION_TOPIC","urlPath":"/event/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"ManageContentPage","type":"COMMUNITY","urlPath":"/managecontent","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"ClosedMembershipNodeNonMembersPage","type":"GROUP_HUB","urlPath":"/closedgroup/:groupHubId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"CommunityPage","type":"COMMUNITY","urlPath":"/","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"ForumMessagePage","type":"FORUM_TOPIC","urlPath":"/discussions/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"IdeaPostPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"BlogMessagePage","type":"BLOG_ARTICLE","urlPath":"/blog/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"RegistrationPage","type":"USER","urlPath":"/register","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"EditGroupHubPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"ForumEditPage","type":"FORUM","urlPath":"/discussions/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"ResetPasswordPage","type":"USER","urlPath":"/resetpassword/:userId/:resetPasswordToken","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"TkbMessagePage","type":"TKB_ARTICLE","urlPath":"/kb/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"BlogEditPage","type":"BLOG","urlPath":"/blog/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"ManageUsersPage","type":"USER","urlPath":"/users/manage/:tab?/:manageUsersTab?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"ForumReplyPage","type":"FORUM_REPLY","urlPath":"/discussions/:boardId/:messageSubject/:messageId/replies/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"PrivacyPolicyPage","type":"COMMUNITY","urlPath":"/privacypolicy","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"NotificationPage","type":"COMMUNITY","urlPath":"/notifications","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"UserPage","type":"USER","urlPath":"/users/:login/:userId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"HealthCheckPage","type":"COMMUNITY","urlPath":"/health","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"OccasionReplyPage","type":"OCCASION_REPLY","urlPath":"/event/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"ManageMembersPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/manage/:tab?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"SearchResultsPage","type":"COMMUNITY","urlPath":"/search","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"BlogReplyPage","type":"BLOG_REPLY","urlPath":"/blog/:boardId/:messageSubject/:messageId/replies/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"GroupHubPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"TermsOfServicePage","type":"COMMUNITY","urlPath":"/termsofservice","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"CategoryPage","type":"CATEGORY","urlPath":"/category/:categoryId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"ForumViewAllTopicsPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId/all-topics/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"TkbPostPage","type":"TKB","urlPath":"/category/:categoryId/kbs/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1759529115984,"localOverride":null,"page":{"id":"GroupHubPostPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"}],"localOverride":false},"Rank:rank:14":{"__typename":"Rank","id":"rank:14","position":13,"name":"Valued Contributor","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:2269":{"__typename":"User","id":"user:2269","uid":2269,"login":"darshthakkar","deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://community.snaplogic.com/t5/s/iaudz84835/images/dS0yMjY5LTY0MDBpQTdBMUQ0MURDRUUzNUZDNw"},"rank":{"__ref":"Rank:rank:14"},"email":"","messagesCount":407,"biography":null,"topicsCount":45,"kudosReceivedCount":103,"kudosGivenCount":564,"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2022-03-10T06:20:21.693-08:00","confirmEmailStatus":null},"followersCount":null,"solutionsCount":29,"entityType":"USER","eventPath":"community:iaudz84835/user:2269"},"Category:category:platform":{"__typename":"Category","id":"category:platform","entityType":"CATEGORY","displayId":"platform","nodeType":"category","depth":2,"title":"Getting the Most Out of the SnapLogic Platform","shortTitle":"Getting the Most Out of the SnapLogic Platform","parent":{"__ref":"Category:category:products"}},"Category:category:top":{"__typename":"Category","id":"category:top","entityType":"CATEGORY","displayId":"top","nodeType":"category","depth":0,"title":"Top","shortTitle":"Top"},"Category:category:products":{"__typename":"Category","id":"category:products","entityType":"CATEGORY","displayId":"products","nodeType":"category","depth":1,"parent":{"__ref":"Category:category:top"},"title":"Discussions","shortTitle":"Discussions","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:pipelines":{"__typename":"Forum","id":"board:pipelines","entityType":"FORUM","displayId":"pipelines","nodeType":"board","depth":3,"conversationStyle":"FORUM","repliesProperties":{"__typename":"RepliesProperties","sortOrder":"LIKES","repliesFormat":"threaded"},"tagProperties":{"__typename":"TagNodeProperties","tagsEnabled":{"__typename":"PolicyResult","failureReason":null}},"requireTags":false,"tagType":"FREEFORM_AND_PRESET","description":"Discuss how to use the SnapLogic platform.","title":"Designing and Running Pipelines","shortTitle":"Designing and Running Pipelines","parent":{"__ref":"Category:category:platform"},"ancestors":{"__typename":"CoreNodeConnection","edges":[{"__typename":"CoreNodeEdge","node":{"__ref":"Community:community:iaudz84835"}},{"__typename":"CoreNodeEdge","node":{"__ref":"Category:category:products"}},{"__typename":"CoreNodeEdge","node":{"__ref":"Category:category:platform"}}]},"userContext":{"__typename":"NodeUserContext","canAddAttachments":false,"canUpdateNode":false,"canPostMessages":false,"isSubscribed":false},"theme":{"__ref":"Theme:customTheme1"},"boardPolicies":{"__typename":"BoardPolicies","canViewSpamDashBoard":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.access_spam_quarantine.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.access_spam_quarantine.allowed.accessDenied","args":[]}},"canArchiveMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.content_archivals.enable_content_archival_settings.accessDenied","key":"error.lithium.policies.content_archivals.enable_content_archival_settings.accessDenied","args":[]}},"canPublishArticleOnCreate":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.forums.policy_can_publish_on_create_workflow_action.accessDenied","key":"error.lithium.policies.forums.policy_can_publish_on_create_workflow_action.accessDenied","args":[]}},"canReadNode":{"__typename":"PolicyResult","failureReason":null}},"linkProperties":{"__typename":"LinkProperties","isExternalLinkWarningEnabled":true},"forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/"},"ForumTopicMessage:message:18759":{"__typename":"ForumTopicMessage","uid":18759,"subject":"Using list of values in Filter snap","id":"message:18759","entityType":"FORUM_TOPIC","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:18759","revisionNum":1,"repliesCount":12,"author":{"__ref":"User:user:2269"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:pipelines"},"conversation":{"__ref":"Conversation:conversation:18759"},"readOnly":false,"editFrozen":false,"showMoveIndicator":false,"moderationData":{"__ref":"ModerationData:moderation_data:18759"},"body":"
Hi Team,
\n
Is it possible to function a list of values in the filter snap? \nLet’s assume, I want to filter IDs whose values are 100, 110, 300, etc., how can I put this in Filter snap without using || function?
\n
I was planning to use $ID IN (100, 110, 300, etc.) but this one doesn’t seem to work so I have been using a conventional way as below: \n$ID == \"100\" || $ID ==\"110\" || $ID ==\"300\"
\n
Thanking in advance for your suggestions.
\n
Regards, \nDarsh
","body@stringLength":"554","rawBody":"
Hi Team,
\n
Is it possible to function a list of values in the filter snap? \nLet’s assume, I want to filter IDs whose values are 100, 110, 300, etc., how can I put this in Filter snap without using || function?
\n
I was planning to use $ID IN (100, 110, 300, etc.) but this one doesn’t seem to work so I have been using a conventional way as below: \n$ID == \"100\" || $ID ==\"110\" || $ID ==\"300\"
I would recommend that you not use JSON.parse() for every record. It can be fairly taxing on your CPU depending on data volume. If you want to remove the hardcoded reference to the array of values to search for, I recommend you look at Expression Libraries.
\n
Hope this helps!
\n
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"233","kudosSumWeight":2,"postTime":"2024-01-03T04:57:09.391-08:00","lastPublishTime":"2024-01-03T04:57:09.391-08:00","solution":true,"metrics":{"__typename":"MessageMetrics","views":8039},"visibilityScope":"PUBLIC","placeholder":false,"showMoveIndicator":false,"originalMessageForPlaceholder":null,"isEscalated":null,"replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[{"__typename":"MessageEdge","cursor":"MjUuOXwyLjF8b3wzfDE0OjAsMzk6MXwx","node":{"__ref":"ForumReplyMessage:message:24760"}}]},"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"messagePolicies":{"__typename":"MessagePolicies","canReply":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.forums.action.message.reply_to_entity.allow.accessDenied","key":"error.lithium.policies.forums.action.message.reply_to_entity.allow.accessDenied","args":[]}},"canAcceptSolution":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.accepted_solutions.action_allow.message.mark_as_accepted_solution.accessDenied","key":"error.lithium.policies.accepted_solutions.action_allow.message.mark_as_accepted_solution.accessDenied","args":[]}},"canRejectSolution":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.accepted_solutions.action_allow.message.unmark_as_accepted_solution.accessDenied","key":"error.lithium.policies.accepted_solutions.action_allow.message.unmark_as_accepted_solution.accessDenied","args":[]}},"canTag":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.labels.action.labelableentity.set_labels.allow.accessDenied","key":"error.lithium.policies.labels.action.labelableentity.set_labels.allow.accessDenied","args":[]}},"canEdit":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.forums.action_allow.edit_message.accessDenied","key":"error.lithium.policies.forums.action_allow.edit_message.accessDenied","args":[]}},"canKudo":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.kudos.action.entity.give_kudos.allow.accessDenied","key":"error.lithium.policies.kudos.action.entity.give_kudos.allow.accessDenied","args":[]}}},"body@stripHtml({\"removeProcessingText\":true,\"removeSpoilerMarkup\":true,\"removeTocMarkup\":true,\"truncateLength\":200})@stringLength":"233","images":{"__typename":"AssociatedImageConnection","edges":[{"__typename":"AssociatedImageEdge","cursor":"MjUuOXwyLjF8b3wyNXxfTlZffDE","node":{"__ref":"AssociatedImage:{\"url\":\"https://community.snaplogic.com/t5/s/iaudz84835/images/bS0yNDc1NS02MTE4aTFBMjc0NDhFRjIzQkQ3MkU?revision=1\"}"}}],"totalCount":1,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"videos":{"__typename":"VideoConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"ModerationData:moderation_data:24760":{"__typename":"ModerationData","id":"moderation_data:24760","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:24760":{"__typename":"ForumReplyMessage","uid":24760,"id":"message:24760","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:18759/message:24760","revisionNum":1,"author":{"__ref":"User:user:2269"},"readOnly":false,"repliesCount":1,"depth":2,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"AcceptedSolutionMessage:message:24755"},"conversation":{"__ref":"Conversation:conversation:18759"},"subject":"Re: Using list of values in Filter snap","moderationData":{"__ref":"ModerationData:moderation_data:24760"},"body":"
koryknick - If I use 2 filter snaps would that be more effective than using [\"abc\", \"xyz\"].filter(x=> $txt.contains(x)).length >=1?
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"144","kudosSumWeight":0,"postTime":"2024-01-03T06:20:21.950-08:00","lastPublishTime":"2024-01-03T06:20:21.950-08:00","metrics":{"__typename":"MessageMetrics","views":1285},"visibilityScope":"PUBLIC","placeholder":false,"showMoveIndicator":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[{"__typename":"MessageEdge","cursor":"MjUuOXwyLjF8b3wxfDE0OjAsMzk6MXwx","node":{"__ref":"ForumReplyMessage:message:24776"}}]},"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"messagePolicies":{"__typename":"MessagePolicies","canReply":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.forums.action.message.reply_to_entity.allow.accessDenied","key":"error.lithium.policies.forums.action.message.reply_to_entity.allow.accessDenied","args":[]}},"canAcceptSolution":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.accepted_solutions.action_allow.message.mark_as_accepted_solution.accessDenied","key":"error.lithium.policies.accepted_solutions.action_allow.message.mark_as_accepted_solution.accessDenied","args":[]}},"canRejectSolution":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.accepted_solutions.action_allow.message.unmark_as_accepted_solution.accessDenied","key":"error.lithium.policies.accepted_solutions.action_allow.message.unmark_as_accepted_solution.accessDenied","args":[]}},"canTag":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.labels.action.labelableentity.set_labels.allow.accessDenied","key":"error.lithium.policies.labels.action.labelableentity.set_labels.allow.accessDenied","args":[]}},"canEdit":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.forums.action_allow.edit_message.accessDenied","key":"error.lithium.policies.forums.action_allow.edit_message.accessDenied","args":[]}},"canKudo":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.kudos.action.entity.give_kudos.allow.accessDenied","key":"error.lithium.policies.kudos.action.entity.give_kudos.allow.accessDenied","args":[]}}}},"ModerationData:moderation_data:24776":{"__typename":"ModerationData","id":"moderation_data:24776","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:24776":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:2269"},"id":"message:24776","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:18759/message:24776","revisionNum":1,"uid":24776,"depth":3,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumReplyMessage:message:24760"},"conversation":{"__ref":"Conversation:conversation:18759"},"subject":"Re: Using list of values in Filter snap","moderationData":{"__ref":"ModerationData:moderation_data:24776"},"body":"
koryknick - CPU memory consumption as well as time taken to validate/execute the pipeline is pretty much the same with \"abc\", \"xyz\"].filter(x=> $txt.contains(x)).length >=1 as well as using 2 filter snaps.
There have been instances where using 2 filter snaps is faster than using the expression detailed above however if we have to scale the solution and there is a need to use 10 filter snaps that needs to filters out strings then the solution provided by koryknick would be helpful.
Tried using expression library too however everytime the string needs to be updated, expression library needs to be updated and putting them into a filter snap instead is easier and convenient approach.
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"224","kudosSumWeight":0,"repliesCount":0,"postTime":"2024-01-04T09:06:27.320-08:00","lastPublishTime":"2024-01-04T09:06:27.320-08:00","metrics":{"__typename":"MessageMetrics","views":1267},"visibilityScope":"PUBLIC","placeholder":false,"showMoveIndicator":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"messagePolicies":{"__typename":"MessagePolicies","canReply":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.forums.action.message.reply_to_entity.allow.accessDenied","key":"error.lithium.policies.forums.action.message.reply_to_entity.allow.accessDenied","args":[]}},"canAcceptSolution":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.accepted_solutions.action_allow.message.mark_as_accepted_solution.accessDenied","key":"error.lithium.policies.accepted_solutions.action_allow.message.mark_as_accepted_solution.accessDenied","args":[]}},"canRejectSolution":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.accepted_solutions.action_allow.message.unmark_as_accepted_solution.accessDenied","key":"error.lithium.policies.accepted_solutions.action_allow.message.unmark_as_accepted_solution.accessDenied","args":[]}},"canTag":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.labels.action.labelableentity.set_labels.allow.accessDenied","key":"error.lithium.policies.labels.action.labelableentity.set_labels.allow.accessDenied","args":[]}},"canEdit":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.forums.action_allow.edit_message.accessDenied","key":"error.lithium.policies.forums.action_allow.edit_message.accessDenied","args":[]}},"canKudo":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.kudos.action.entity.give_kudos.allow.accessDenied","key":"error.lithium.policies.kudos.action.entity.give_kudos.allow.accessDenied","args":[]}}}},"User:user:724":{"__typename":"User","id":"user:724","uid":724,"login":"siwadon","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2018-08-22T15:57:55.940-07:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.snaplogic.com/t5/s/iaudz84835/m_assets/avatars/default/avatar-8.svg?time=0"},"rank":{"__ref":"Rank:rank:4"},"entityType":"USER","eventPath":"community:iaudz84835/user:724"},"ModerationData:moderation_data:18760":{"__typename":"ModerationData","id":"moderation_data:18760","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:18760":{"__typename":"ForumReplyMessage","uid":18760,"id":"message:18760","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:18759/message:18760","revisionNum":1,"author":{"__ref":"User:user:724"},"readOnly":false,"repliesCount":3,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumTopicMessage:message:18759"},"conversation":{"__ref":"Conversation:conversation:18759"},"subject":"Re: Using list of values in Filter snap","moderationData":{"__ref":"ModerationData:moderation_data:18760"},"body":"
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"84","kudosSumWeight":1,"postTime":"2022-09-23T13:43:11.521-07:00","lastPublishTime":"2022-09-23T13:43:11.521-07:00","metrics":{"__typename":"MessageMetrics","views":4448},"visibilityScope":"PUBLIC","placeholder":false,"showMoveIndicator":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[{"__typename":"MessageEdge","cursor":"MjUuOXwyLjF8b3wzfDE0OjAsMzk6MXwx","node":{"__ref":"ForumReplyMessage:message:18761"}}]},"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"messagePolicies":{"__typename":"MessagePolicies","canReply":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.forums.action.message.reply_to_entity.allow.accessDenied","key":"error.lithium.policies.forums.action.message.reply_to_entity.allow.accessDenied","args":[]}},"canAcceptSolution":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.accepted_solutions.action_allow.message.mark_as_accepted_solution.accessDenied","key":"error.lithium.policies.accepted_solutions.action_allow.message.mark_as_accepted_solution.accessDenied","args":[]}},"canRejectSolution":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.accepted_solutions.action_allow.message.unmark_as_accepted_solution.accessDenied","key":"error.lithium.policies.accepted_solutions.action_allow.message.unmark_as_accepted_solution.accessDenied","args":[]}},"canTag":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.labels.action.labelableentity.set_labels.allow.accessDenied","key":"error.lithium.policies.labels.action.labelableentity.set_labels.allow.accessDenied","args":[]}},"canEdit":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.forums.action_allow.edit_message.accessDenied","key":"error.lithium.policies.forums.action_allow.edit_message.accessDenied","args":[]}},"canKudo":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.kudos.action.entity.give_kudos.allow.accessDenied","key":"error.lithium.policies.kudos.action.entity.give_kudos.allow.accessDenied","args":[]}}}},"ModerationData:moderation_data:18761":{"__typename":"ModerationData","id":"moderation_data:18761","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:18761":{"__typename":"ForumReplyMessage","uid":18761,"id":"message:18761","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:18759/message:18761","revisionNum":1,"author":{"__ref":"User:user:2269"},"readOnly":false,"repliesCount":2,"depth":2,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumReplyMessage:message:18760"},"conversation":{"__ref":"Conversation:conversation:18759"},"subject":"Re: Using list of values in Filter snap","moderationData":{"__ref":"ModerationData:moderation_data:18761"},"body":"
Thank you @siwadon. \nI believe for the above suggestion, I’ll have to ensure that my numbers are strings and then use that function in a mapper, right?
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"154","kudosSumWeight":0,"postTime":"2022-09-23T13:45:27.583-07:00","lastPublishTime":"2022-09-23T13:45:27.583-07:00","metrics":{"__typename":"MessageMetrics","views":4460},"visibilityScope":"PUBLIC","placeholder":false,"showMoveIndicator":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[{"__typename":"MessageEdge","cursor":"MjUuOXwyLjF8b3wxfDE0OjAsMzk6MXwx","node":{"__ref":"AcceptedSolutionMessage:message:18762"}}]},"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"messagePolicies":{"__typename":"MessagePolicies","canReply":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.forums.action.message.reply_to_entity.allow.accessDenied","key":"error.lithium.policies.forums.action.message.reply_to_entity.allow.accessDenied","args":[]}},"canAcceptSolution":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.accepted_solutions.action_allow.message.mark_as_accepted_solution.accessDenied","key":"error.lithium.policies.accepted_solutions.action_allow.message.mark_as_accepted_solution.accessDenied","args":[]}},"canRejectSolution":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.accepted_solutions.action_allow.message.unmark_as_accepted_solution.accessDenied","key":"error.lithium.policies.accepted_solutions.action_allow.message.unmark_as_accepted_solution.accessDenied","args":[]}},"canTag":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.labels.action.labelableentity.set_labels.allow.accessDenied","key":"error.lithium.policies.labels.action.labelableentity.set_labels.allow.accessDenied","args":[]}},"canEdit":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.forums.action_allow.edit_message.accessDenied","key":"error.lithium.policies.forums.action_allow.edit_message.accessDenied","args":[]}},"canKudo":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.kudos.action.entity.give_kudos.allow.accessDenied","key":"error.lithium.policies.kudos.action.entity.give_kudos.allow.accessDenied","args":[]}}}},"ModerationData:moderation_data:18762":{"__typename":"ModerationData","id":"moderation_data:18762","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"AcceptedSolutionMessage:message:18762":{"__typename":"AcceptedSolutionMessage","author":{"__ref":"User:user:724"},"id":"message:18762","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:18759/message:18762","revisionNum":1,"uid":18762,"depth":3,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumReplyMessage:message:18761"},"conversation":{"__ref":"Conversation:conversation:18759"},"subject":"Re: Using list of values in Filter snap","moderationData":{"__ref":"ModerationData:moderation_data:18762"},"body":"
It depends. If your $ID are numbers, you can change the expression to
\n
[100, 110, 300].indexOf($ID) != -1\n
\n
I don’t understand your last question about Mapper. Since you mentioned using the Filter snap, this is for the Filter expression setting.
\n
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"203","kudosSumWeight":2,"repliesCount":1,"postTime":"2022-09-23T13:57:47.623-07:00","lastPublishTime":"2022-09-23T13:57:47.623-07:00","solution":true,"metrics":{"__typename":"MessageMetrics","views":8759},"visibilityScope":"PUBLIC","placeholder":false,"showMoveIndicator":false,"originalMessageForPlaceholder":null,"isEscalated":null,"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[],"messagePolicies":{"__typename":"MessagePolicies","canReply":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.forums.action.message.reply_to_entity.allow.accessDenied","key":"error.lithium.policies.forums.action.message.reply_to_entity.allow.accessDenied","args":[]}},"canAcceptSolution":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.accepted_solutions.action_allow.message.mark_as_accepted_solution.accessDenied","key":"error.lithium.policies.accepted_solutions.action_allow.message.mark_as_accepted_solution.accessDenied","args":[]}},"canRejectSolution":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.accepted_solutions.action_allow.message.unmark_as_accepted_solution.accessDenied","key":"error.lithium.policies.accepted_solutions.action_allow.message.unmark_as_accepted_solution.accessDenied","args":[]}},"canTag":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.labels.action.labelableentity.set_labels.allow.accessDenied","key":"error.lithium.policies.labels.action.labelableentity.set_labels.allow.accessDenied","args":[]}},"canEdit":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.forums.action_allow.edit_message.accessDenied","key":"error.lithium.policies.forums.action_allow.edit_message.accessDenied","args":[]}},"canKudo":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.kudos.action.entity.give_kudos.allow.accessDenied","key":"error.lithium.policies.kudos.action.entity.give_kudos.allow.accessDenied","args":[]}}},"body@stripHtml({\"removeProcessingText\":true,\"removeSpoilerMarkup\":true,\"removeTocMarkup\":true,\"truncateLength\":200})@stringLength":"203","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"videos":{"__typename":"VideoConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"Rank:rank:17":{"__typename":"Rank","id":"rank:17","position":16,"name":"Contributor","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:1524":{"__typename":"User","id":"user:1524","uid":1524,"login":"Abhishek_Soni37","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2020-10-15T06:44:38.452-07:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.snaplogic.com/t5/s/iaudz84835/m_assets/avatars/default/avatar-6.svg?time=0"},"rank":{"__ref":"Rank:rank:17"},"entityType":"USER","eventPath":"community:iaudz84835/user:1524"},"ModerationData:moderation_data:24751":{"__typename":"ModerationData","id":"moderation_data:24751","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"AcceptedSolutionMessage:message:24751":{"__typename":"AcceptedSolutionMessage","author":{"__ref":"User:user:1524"},"id":"message:24751","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:18759/message:24751","revisionNum":2,"uid":24751,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumTopicMessage:message:18759"},"conversation":{"__ref":"Conversation:conversation:18759"},"subject":"Re: Using list of values in Filter snap","moderationData":{"__ref":"ModerationData:moderation_data:24751"},"body":"
In the pipeline properties, I've defined a parameter filterValues that will contain the strings based on which you want to filter the records.
Use the below expression in the filter snap:
JSON.parse(_filterValues).map(x => $txt.contains(x)).filter(y => y == true).length == 1
The result based on the input above looks like this:
The record that doesn't have the matching string defined in the filterValues parameter will be omitted.
Hope this helps!
Cheers😉, Abhishek
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"243","kudosSumWeight":1,"repliesCount":0,"postTime":"2024-01-03T02:27:34.911-08:00","lastPublishTime":"2024-01-03T04:29:48.708-08:00","solution":true,"metrics":{"__typename":"MessageMetrics","views":7969},"visibilityScope":"PUBLIC","placeholder":false,"showMoveIndicator":false,"originalMessageForPlaceholder":null,"isEscalated":null,"replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"customFields":[],"messagePolicies":{"__typename":"MessagePolicies","canReply":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.forums.action.message.reply_to_entity.allow.accessDenied","key":"error.lithium.policies.forums.action.message.reply_to_entity.allow.accessDenied","args":[]}},"canAcceptSolution":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.accepted_solutions.action_allow.message.mark_as_accepted_solution.accessDenied","key":"error.lithium.policies.accepted_solutions.action_allow.message.mark_as_accepted_solution.accessDenied","args":[]}},"canRejectSolution":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.accepted_solutions.action_allow.message.unmark_as_accepted_solution.accessDenied","key":"error.lithium.policies.accepted_solutions.action_allow.message.unmark_as_accepted_solution.accessDenied","args":[]}},"canTag":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.labels.action.labelableentity.set_labels.allow.accessDenied","key":"error.lithium.policies.labels.action.labelableentity.set_labels.allow.accessDenied","args":[]}},"canEdit":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.forums.action_allow.edit_message.accessDenied","key":"error.lithium.policies.forums.action_allow.edit_message.accessDenied","args":[]}},"canKudo":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.kudos.action.entity.give_kudos.allow.accessDenied","key":"error.lithium.policies.kudos.action.entity.give_kudos.allow.accessDenied","args":[]}}},"body@stripHtml({\"removeProcessingText\":true,\"removeSpoilerMarkup\":true,\"removeTocMarkup\":true,\"truncateLength\":200})@stringLength":"243","images":{"__typename":"AssociatedImageConnection","edges":[{"__typename":"AssociatedImageEdge","cursor":"MjUuOXwyLjF8b3wyNXxfTlZffDE","node":{"__ref":"AssociatedImage:{\"url\":\"https://community.snaplogic.com/t5/s/iaudz84835/images/bS0yNDc1MS02MTE3aTZBQUQyNEJEREM0REIxNkQ?revision=2\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjUuOXwyLjF8b3wyNXxfTlZffDI","node":{"__ref":"AssociatedImage:{\"url\":\"https://community.snaplogic.com/t5/s/iaudz84835/images/bS0yNDc1MS02MTE2aURGMTRENTk3NEE3NDRFRTY?revision=2\"}"}}],"totalCount":2,"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":[]},"videos":{"__typename":"VideoConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"ModerationData:moderation_data:24680":{"__typename":"ModerationData","id":"moderation_data:24680","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:24680":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:2269"},"id":"message:24680","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:18759/message:24680","revisionNum":2,"uid":24680,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumTopicMessage:message:18759"},"conversation":{"__ref":"Conversation:conversation:18759"},"subject":"Re: Using list of values in Filter snap","moderationData":{"__ref":"ModerationData:moderation_data:24680"},"body":"
siwadon - Hope you're doing well. Can we use multiple values in the string function \".contains()\"?
I have a column which has multiple values and I want to filter it out using a filter snap, let's say for instance the unique values in that column are - xyz, abc, pnr, stu, win, scp, c - xyz, c - abc, etc.
I want to filter out all records where there is an existence of xyz and abc; how can I achieve this using a filter snap as .contains can't be used in conjunction with the function \".indexOf($ID)\" . Can you please throw some light?
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"208","kudosSumWeight":0,"repliesCount":0,"postTime":"2023-12-27T12:35:01.556-08:00","lastPublishTime":"2023-12-27T12:38:41.533-08:00","metrics":{"__typename":"MessageMetrics","views":2981},"visibilityScope":"PUBLIC","placeholder":false,"showMoveIndicator":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"customFields":[],"messagePolicies":{"__typename":"MessagePolicies","canReply":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.forums.action.message.reply_to_entity.allow.accessDenied","key":"error.lithium.policies.forums.action.message.reply_to_entity.allow.accessDenied","args":[]}},"canAcceptSolution":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.accepted_solutions.action_allow.message.mark_as_accepted_solution.accessDenied","key":"error.lithium.policies.accepted_solutions.action_allow.message.mark_as_accepted_solution.accessDenied","args":[]}},"canRejectSolution":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.accepted_solutions.action_allow.message.unmark_as_accepted_solution.accessDenied","key":"error.lithium.policies.accepted_solutions.action_allow.message.unmark_as_accepted_solution.accessDenied","args":[]}},"canTag":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.labels.action.labelableentity.set_labels.allow.accessDenied","key":"error.lithium.policies.labels.action.labelableentity.set_labels.allow.accessDenied","args":[]}},"canEdit":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.forums.action_allow.edit_message.accessDenied","key":"error.lithium.policies.forums.action_allow.edit_message.accessDenied","args":[]}},"canKudo":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.kudos.action.entity.give_kudos.allow.accessDenied","key":"error.lithium.policies.kudos.action.entity.give_kudos.allow.accessDenied","args":[]}}},"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"ModerationData:moderation_data:24681":{"__typename":"ModerationData","id":"moderation_data:24681","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:24681":{"__typename":"ForumReplyMessage","uid":24681,"id":"message:24681","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:18759/message:24681","revisionNum":1,"author":{"__ref":"User:user:2269"},"readOnly":false,"repliesCount":1,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumTopicMessage:message:18759"},"conversation":{"__ref":"Conversation:conversation:18759"},"subject":"Re: Using list of values in Filter snap","moderationData":{"__ref":"ModerationData:moderation_data:24681"},"body":"
siwadon - We can easily use 2 filter snaps; one will have the string as $ID.contains (xyz) and the other filter snap as $ID.contains (abc) however if I have to filter multiple values where .contains() can be helpful, how can we do that effectively?
Thank you.
Regards,
Darsh
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"208","kudosSumWeight":0,"postTime":"2023-12-27T12:40:16.013-08:00","lastPublishTime":"2023-12-27T12:40:16.013-08:00","metrics":{"__typename":"MessageMetrics","views":2971},"visibilityScope":"PUBLIC","placeholder":false,"showMoveIndicator":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[{"__typename":"MessageEdge","cursor":"MjUuOXwyLjF8b3wzfDE0OjAsMzk6MXwx","node":{"__ref":"ForumReplyMessage:message:24738"}}]},"messagePolicies":{"__typename":"MessagePolicies","canReply":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.forums.action.message.reply_to_entity.allow.accessDenied","key":"error.lithium.policies.forums.action.message.reply_to_entity.allow.accessDenied","args":[]}},"canAcceptSolution":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.accepted_solutions.action_allow.message.mark_as_accepted_solution.accessDenied","key":"error.lithium.policies.accepted_solutions.action_allow.message.mark_as_accepted_solution.accessDenied","args":[]}},"canRejectSolution":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.accepted_solutions.action_allow.message.unmark_as_accepted_solution.accessDenied","key":"error.lithium.policies.accepted_solutions.action_allow.message.unmark_as_accepted_solution.accessDenied","args":[]}},"canTag":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.labels.action.labelableentity.set_labels.allow.accessDenied","key":"error.lithium.policies.labels.action.labelableentity.set_labels.allow.accessDenied","args":[]}},"canEdit":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.forums.action_allow.edit_message.accessDenied","key":"error.lithium.policies.forums.action_allow.edit_message.accessDenied","args":[]}},"canKudo":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.kudos.action.entity.give_kudos.allow.accessDenied","key":"error.lithium.policies.kudos.action.entity.give_kudos.allow.accessDenied","args":[]}}},"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"ModerationData:moderation_data:24738":{"__typename":"ModerationData","id":"moderation_data:24738","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:24738":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:2269"},"id":"message:24738","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:18759/message:24738","revisionNum":1,"uid":24738,"depth":2,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumReplyMessage:message:24681"},"conversation":{"__ref":"Conversation:conversation:18759"},"subject":"Re: Using list of values in Filter snap","moderationData":{"__ref":"ModerationData:moderation_data:24738"},"body":"
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"95","kudosSumWeight":0,"repliesCount":0,"postTime":"2024-01-02T12:03:45.597-08:00","lastPublishTime":"2024-01-02T12:03:45.597-08:00","metrics":{"__typename":"MessageMetrics","views":2963},"visibilityScope":"PUBLIC","placeholder":false,"showMoveIndicator":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"customFields":[]},"ModerationData:moderation_data:24759":{"__typename":"ModerationData","id":"moderation_data:24759","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:24759":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:2269"},"id":"message:24759","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:18759/message:24759","revisionNum":1,"uid":24759,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumTopicMessage:message:18759"},"conversation":{"__ref":"Conversation:conversation:18759"},"subject":"Re: Using list of values in Filter snap","moderationData":{"__ref":"ModerationData:moderation_data:24759"},"body":"
Thank you koryknick and Abhishek_Soni37 for your insights, I will try both of them and thank you koryknick for the additional insights. I will definitely test this out using expression library.