Setting Filters & Sorting for Multiple Items Snippets
Learn how to control which records appear in a Multiple Items Snippet list using static filters and sorting options.
Controlling Which Records Appear
A Multiple Items Snippet is designed to display a list of records from a specific data table. Unlike a Single Item Snippet, which shows one particular record, the Multiple Items snippet shows a set of records dynamically pulled from your table.
By default, when you create a Multiple Items snippet and select a table in Step 2, the snippet is configured to display all records from that table.However, you often won’t want to expose every single record in your table to every viewer. This is where Filters and Sorting come in.
Filters allow you to define specific conditions that records must meet to be included and displayed in the snippet’s List View. This lets you curate the data presented to the end-user.
Example Filter
For example, using our marketing campaign example, if you’re creating a snippet for an active client, you might only want them to see campaigns whose Status is “Active” or “Paused”, but not “Planning” or “Completed”. You would add filters here to exclude records based on those unwanted statuses.
Filters are configured using simple dropdowns and inputs that reflect the fields in your table. You can combine multiple filter conditions (AND/OR) to build complex data subsets.
Sorting allows you to control the order in which records are presented in the List View of your Multiple Items snippet.You can choose a field to sort by (e.g., Start Date, Campaign Name) and the order (Ascending or Descending). For example, sorting by Start Date (Descending) would show the newest campaigns first.
The filters you set in Step 2 are static. This means they are permanently applied to this specific snippet. Any viewer who accesses this snippet’s Shareable URL, regardless of who they are, will only see the records that pass these static filters.If you need to filter the data dynamically based on the person viewing the snippet (e.g., each client only sees their own campaigns, while keeping the snippet URL the same), static filters are usually not the right choice. This dynamic record-level filtering is handled by the Permission feature.Learn more about implementing dynamic, user-based data access: Understanding the Permission Mechanism and User-Based Permission Explained
Any changes you make to the Filter or Sort settings will immediately affect ALL existing and future Shareable URLs for that specific snippet.If you update a filter to exclude certain records, those records will instantly disappear from any live view of that snippet’s URL.
Pro Tip
If you need two different lists of data from the same table (e.g., one showing only “Active” campaigns and another showing only “Completed” campaigns), you should create two separate Multiple Items snippets, each with its own filter configuration.
Was this page helpful?
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Crust AI Documentation","colors":{"primary":"#752AC5","light":"#752AC5","dark":"#752AC5"},"logo":{"light":"https://mintcdn.com/crustai/rUCtKZsN7yplxJjE/logo/logo.png?fit=max\u0026auto=format\u0026n=rUCtKZsN7yplxJjE\u0026q=85\u0026s=960845f4820db91504c1881723f17de2","dark":"https://mintcdn.com/crustai/rUCtKZsN7yplxJjE/logo/logo.png?fit=max\u0026auto=format\u0026n=rUCtKZsN7yplxJjE\u0026q=85\u0026s=960845f4820db91504c1881723f17de2"},"favicon":"/favicon.svg","navbar":{"links":[{"label":"Support","href":"mailto:contact@trycrust.ai"}],"primary":{"type":"button","label":"Back to Snippet Builder","href":"https://app.trycrust.ai"}},"icons":{"library":"lucide"},"integrations":{"intercom":{"appId":"xodlrcmj"},"mixpanel":{"projectToken":"22bf19cf751e1e0b1219462f7dd2d6b1"}},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"crustai","hasAudioNarration":false,"actualSubdomain":"crustai","customDomains":["docs.trycrust.ai"],"gitSource":{"type":"github","owner":"yahllil","repo":"docs","deployBranch":"main","contentDirectory":"","isPrivate":true,"mountPath":"","label":""},"chroma":{"liveDeploymentHistoryId":"6a21e6db03d4026a3ef775fe","collectionId":"14d29270-528d-4508-83b8-861205220fb9","schemaVersion":"v2"},"feedback":{"thumbs":true},"entitlements":{},"buildId":"6a21e6db03d4026a3ef775fe:success","clientVersion":"0.0.4044","searchFilterCounts":[{"language":"default","tag":"Getting Started","count":3},{"language":"default","tag":"Sharing Your Snippets","count":3},{"language":"default","tag":"Understanding Snippets","count":2},{"language":"default","tag":"Controlling Data Access","count":2},{"language":"default","tag":"Customizing Design \u0026 Appearance","count":2},{"language":"default","tag":"Navigating Between Snippets","count":2},{"language":"default","tag":"Selecting Which Data to Display","count":2},{"language":"default","tag":"Update Data and Trigger Actions","count":2}]},"assistantConfig":{},"basePath":"","hasChatPermissions":false,"hasWebMcpPermissions":false,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"byok-sep-25","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"vite-origin","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-updated-9-15","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[],"page":{"pagePath":"chapters/selecting-which-data-to-display/setting-filters-and-sorting-for-multiple-items-snippets","slug":"/chapters/selecting-which-data-to-display/setting-filters-and-sorting-for-multiple-items-snippets","pageMetadata":{"title":"Setting Filters \u0026 Sorting for Multiple Items Snippets","sidebarTitle":"Multiple Items Snippet","description":"Learn how to control which records appear in a Multiple Items Snippet list using static filters and sorting options.","icon":"filter","href":"/chapters/selecting-which-data-to-display/setting-filters-and-sorting-for-multiple-items-snippets"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Learn how to control which records appear in a Multiple Items Snippet list using static filters and sorting options.\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={a:`a`,br:`br`,code:`code`,em:`em`,hr:`hr`,p:`p`,strong:`strong`,..._provideComponents(),...props.components},{Accordion,Heading,OptimizedFrame,OptimizedImage,Tip}=_components;if(!Accordion)_missingMdxReference(`Accordion`,true);if(!Heading)_missingMdxReference(`Heading`,true);if(!OptimizedFrame)_missingMdxReference(`OptimizedFrame`,true);if(!OptimizedImage)_missingMdxReference(`OptimizedImage`,true);if(!Tip)_missingMdxReference(`Tip`,true);return _jsxs(_Fragment,{children:[_jsx(Tip,{children:_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Controlling Which Records Appear`}),_jsx(_components.br,{}),`\n`,`A `,_jsx(_components.strong,{children:`Multiple Items Snippet`}),` is designed to display a list of records from a specific data table. Unlike a Single Item Snippet, which shows one particular record, the Multiple Items snippet shows a set of records dynamically pulled from your table.`]})}),`\n`,_jsx(OptimizedFrame,{width:`560`,height:`315`,src:`https://www.youtube.com/embed/bnbOaKydvis?si=SCyk6F9BS0B3Z_ls`,title:`YouTube video player`,frameborder:`0`,allow:`accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share`,referrerpolicy:`strict-origin-when-cross-origin`,allowfullscreen:true}),`\n`,_jsxs(_components.p,{children:[`By default, when you create a Multiple Items snippet and select a table in Step 2, the snippet is configured to display `,_jsx(_components.em,{children:`all`}),` records from that table.`]}),`\n`,_jsx(OptimizedImage,{src:`https://mintcdn.com/crustai/hzHjilLfWRl0Vr04/images/multi-step-2.png?fit=max\u0026auto=format\u0026n=hzHjilLfWRl0Vr04\u0026q=85\u0026s=836181982580aa124f758fb8e3191b54`,alt:`Multi Step 2 Pn`,\"data-og-width\":`3502`,width:`3502`,\"data-og-height\":`2030`,height:`2030`,\"data-path\":`images/multi-step-2.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/crustai/hzHjilLfWRl0Vr04/images/multi-step-2.png?w=280\u0026fit=max\u0026auto=format\u0026n=hzHjilLfWRl0Vr04\u0026q=85\u0026s=0ab57fa86622ec2bd096d8ec4b3ab6eb 280w, https://mintcdn.com/crustai/hzHjilLfWRl0Vr04/images/multi-step-2.png?w=560\u0026fit=max\u0026auto=format\u0026n=hzHjilLfWRl0Vr04\u0026q=85\u0026s=0e3ca7d810889450bb3964f2d2a6145f 560w, https://mintcdn.com/crustai/hzHjilLfWRl0Vr04/images/multi-step-2.png?w=840\u0026fit=max\u0026auto=format\u0026n=hzHjilLfWRl0Vr04\u0026q=85\u0026s=e0d2e4ab75cff9d2a3d426a7c10fddb9 840w, https://mintcdn.com/crustai/hzHjilLfWRl0Vr04/images/multi-step-2.png?w=1100\u0026fit=max\u0026auto=format\u0026n=hzHjilLfWRl0Vr04\u0026q=85\u0026s=080b38a1d4781d2b88a2e1a59a62f3d9 1100w, https://mintcdn.com/crustai/hzHjilLfWRl0Vr04/images/multi-step-2.png?w=1650\u0026fit=max\u0026auto=format\u0026n=hzHjilLfWRl0Vr04\u0026q=85\u0026s=25aa2543aca574e32e3ec4a83adc3aaa 1650w, https://mintcdn.com/crustai/hzHjilLfWRl0Vr04/images/multi-step-2.png?w=2500\u0026fit=max\u0026auto=format\u0026n=hzHjilLfWRl0Vr04\u0026q=85\u0026s=4e8a621aaed502dea881b5dab0cbf638 2500w`}),`\n`,_jsxs(_components.p,{children:[`However, you often won’t want to expose every single record in your table to every viewer. This is where `,_jsx(_components.strong,{children:`Filters`}),` and `,_jsx(_components.strong,{children:`Sorting`}),` come in.`]}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`filtering-records`,children:`Filtering Records`}),`\n`,_jsx(_components.p,{children:`Filters allow you to define specific conditions that records must meet to be included and displayed in the snippet’s List View. This lets you curate the data presented to the end-user.`}),`\n`,_jsx(OptimizedImage,{src:`https://mintcdn.com/crustai/hzHjilLfWRl0Vr04/images/multi-step-2-filter.png?fit=max\u0026auto=format\u0026n=hzHjilLfWRl0Vr04\u0026q=85\u0026s=59ebc34b837efa69bf4c4d5a512c828c`,alt:`Multi Step 2 Filter Pn`,\"data-og-width\":`2266`,width:`2266`,\"data-og-height\":`840`,height:`840`,\"data-path\":`images/multi-step-2-filter.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/crustai/hzHjilLfWRl0Vr04/images/multi-step-2-filter.png?w=280\u0026fit=max\u0026auto=format\u0026n=hzHjilLfWRl0Vr04\u0026q=85\u0026s=2149a290fb48aa382bc2592ce1a76c10 280w, https://mintcdn.com/crustai/hzHjilLfWRl0Vr04/images/multi-step-2-filter.png?w=560\u0026fit=max\u0026auto=format\u0026n=hzHjilLfWRl0Vr04\u0026q=85\u0026s=ee3e4eb94f3a67cbfec8841723bf2274 560w, https://mintcdn.com/crustai/hzHjilLfWRl0Vr04/images/multi-step-2-filter.png?w=840\u0026fit=max\u0026auto=format\u0026n=hzHjilLfWRl0Vr04\u0026q=85\u0026s=16a3095bc0a5c607e79a23b5b5adb168 840w, https://mintcdn.com/crustai/hzHjilLfWRl0Vr04/images/multi-step-2-filter.png?w=1100\u0026fit=max\u0026auto=format\u0026n=hzHjilLfWRl0Vr04\u0026q=85\u0026s=3608fb60680887ccd727f3fc3dfca27d 1100w, https://mintcdn.com/crustai/hzHjilLfWRl0Vr04/images/multi-step-2-filter.png?w=1650\u0026fit=max\u0026auto=format\u0026n=hzHjilLfWRl0Vr04\u0026q=85\u0026s=d5e9e5703bba30db37c23806aa3226fa 1650w, https://mintcdn.com/crustai/hzHjilLfWRl0Vr04/images/multi-step-2-filter.png?w=2500\u0026fit=max\u0026auto=format\u0026n=hzHjilLfWRl0Vr04\u0026q=85\u0026s=2c66eed16d1d6a6e7caf80492e5e93ac 2500w`}),`\n`,_jsx(Accordion,{title:`Example Filter`,id:`example-filter`,children:_jsxs(_components.p,{children:[`For example, using our marketing campaign example, if you’re creating a snippet for an active client, you might only want them to see campaigns whose `,_jsx(_components.code,{children:`Status`}),` is “Active” or “Paused”, but not “Planning” or “Completed”. You would add filters here to exclude records based on those unwanted statuses.`]})}),`\n`,_jsxs(_components.p,{children:[`Filters are configured using simple dropdowns and inputs that reflect the fields in your table. You can combine multiple filter conditions (`,_jsx(_components.code,{children:`AND`}),`/`,_jsx(_components.code,{children:`OR`}),`) to build complex data subsets.`]}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`sorting-records`,children:`Sorting Records`}),`\n`,_jsx(_components.p,{children:`Sorting allows you to control the order in which records are presented in the List View of your Multiple Items snippet.`}),`\n`,_jsx(OptimizedImage,{src:`https://mintcdn.com/crustai/hzHjilLfWRl0Vr04/images/multi-step-2-sort.png?fit=max\u0026auto=format\u0026n=hzHjilLfWRl0Vr04\u0026q=85\u0026s=df996f296462c29ee50383cf6fcbdd4d`,alt:`Multi Step 2 Sort Pn`,\"data-og-width\":`2254`,width:`2254`,\"data-og-height\":`602`,height:`602`,\"data-path\":`images/multi-step-2-sort.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/crustai/hzHjilLfWRl0Vr04/images/multi-step-2-sort.png?w=280\u0026fit=max\u0026auto=format\u0026n=hzHjilLfWRl0Vr04\u0026q=85\u0026s=3a973720e61a8b5e4d87cd92bbe2e055 280w, https://mintcdn.com/crustai/hzHjilLfWRl0Vr04/images/multi-step-2-sort.png?w=560\u0026fit=max\u0026auto=format\u0026n=hzHjilLfWRl0Vr04\u0026q=85\u0026s=d1371638063644d82a0c8b8e47ac3dba 560w, https://mintcdn.com/crustai/hzHjilLfWRl0Vr04/images/multi-step-2-sort.png?w=840\u0026fit=max\u0026auto=format\u0026n=hzHjilLfWRl0Vr04\u0026q=85\u0026s=308ce96ce0099bb68780077c39f64e5f 840w, https://mintcdn.com/crustai/hzHjilLfWRl0Vr04/images/multi-step-2-sort.png?w=1100\u0026fit=max\u0026auto=format\u0026n=hzHjilLfWRl0Vr04\u0026q=85\u0026s=7157cbc35badddd999e98c3e3710e6ea 1100w, https://mintcdn.com/crustai/hzHjilLfWRl0Vr04/images/multi-step-2-sort.png?w=1650\u0026fit=max\u0026auto=format\u0026n=hzHjilLfWRl0Vr04\u0026q=85\u0026s=cf8c066b88ac576760a8466e4712fa88 1650w, https://mintcdn.com/crustai/hzHjilLfWRl0Vr04/images/multi-step-2-sort.png?w=2500\u0026fit=max\u0026auto=format\u0026n=hzHjilLfWRl0Vr04\u0026q=85\u0026s=d8482d52f811311706da9d3b009a571d 2500w`}),`\n`,_jsxs(_components.p,{children:[`You can choose a field to sort by (e.g., `,_jsx(_components.code,{children:`Start Date`}),`, `,_jsx(_components.code,{children:`Campaign Name`}),`) and the order (Ascending or Descending). For example, sorting by `,_jsx(_components.code,{children:`Start Date (Descending)`}),` would show the newest campaigns first.`]}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`important-note-static-vs-dynamic-filtering`,children:`Important Note: Static vs. Dynamic Filtering`}),`\n`,_jsxs(_components.p,{children:[`The filters you set in Step 2 are `,_jsx(_components.strong,{children:`static`}),`. This means they are permanently applied to `,_jsx(_components.em,{children:`this specific snippet`}),`. Any viewer who accesses this snippet’s Shareable URL, regardless of who they are, will `,_jsx(_components.em,{children:`only`}),` see the records that pass these static filters.`]}),`\n`,_jsxs(_components.p,{children:[`If you need to filter the data `,_jsx(_components.em,{children:`dynamically`}),` based on the person viewing the snippet (e.g., each client only sees `,_jsx(_components.em,{children:`their own`}),` campaigns, while keeping the snippet URL the same), static filters are usually not the right choice. This dynamic record-level filtering is handled by the `,_jsx(_components.a,{href:`/chapters/controlling-data-access/understanding-the-permission-mechanism`,children:_jsx(_components.strong,{children:`Permission`})}),` feature.`]}),`\n`,_jsxs(_components.p,{children:[`Learn more about implementing dynamic, user-based data access: `,_jsx(_components.a,{href:`/chapters/controlling-data-access/understanding-the-permission-mechanism`,children:`Understanding the Permission Mechanism`}),` and `,_jsx(_components.a,{href:`/chapters/controlling-data-access/user-based-permission-explained`,children:`User-Based Permission Explained`})]}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`impact-of-changes-on-shared-urls`,children:`Impact of Changes on Shared URLs`}),`\n`,_jsx(_components.p,{children:`Any changes you make to the Filter or Sort settings will immediately affect ALL existing and future Shareable URLs for that specific snippet.`}),`\n`,_jsx(_components.p,{children:`If you update a filter to exclude certain records, those records will instantly disappear from any live view of that snippet’s URL.`}),`\n`,_jsx(Tip,{children:_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Pro Tip`}),_jsx(_components.br,{}),`\n`,`If you need two different lists of data from the same table (e.g., one showing only “Active” campaigns and another showing only “Completed” campaigns), you should create two separate Multiple Items snippets, each with its own filter configuration.`]})})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Setting Filters \u0026 Sorting for Multiple Items Snippets","sidebarTitle":"Multiple Items Snippet","description":"Learn how to control which records appear in a Multiple Items Snippet list using static filters and sorting options.","icon":"filter","href":"/chapters/selecting-which-data-to-display/setting-filters-and-sorting-for-multiple-items-snippets"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"Filtering Records","slug":"filtering-records","depth":2,"children":[]},{"title":"Sorting Records","slug":"sorting-records","depth":2,"children":[]},{"title":"Important Note: Static vs. Dynamic Filtering","slug":"important-note-static-vs-dynamic-filtering","depth":2,"children":[]},{"title":"Impact of Changes on Shared URLs","slug":"impact-of-changes-on-shared-urls","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":[],"subdomain":"crustai","siteName":"Crust AI Documentation","title":"Setting Filters \u0026 Sorting for Multiple Items Snippets - Crust AI Documentation","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-01-07T08:03:42.819Z","originalFileLocation":"chapters/selecting-which-data-to-display/setting-filters-and-sorting-for-multiple-items-snippets.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Learn how to control which records appear in a Multiple Items Snippet list using static filters and sorting options.\">\u003cmeta data-mint-head name=\"application-name\" content=\"Crust AI Documentation\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/crustai/HZrWpaHBXEmgaNgY/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/crustai/HZrWpaHBXEmgaNgY/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/crustai/HZrWpaHBXEmgaNgY/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/crustai/HZrWpaHBXEmgaNgY/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/crustai/HZrWpaHBXEmgaNgY/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/crustai/HZrWpaHBXEmgaNgY/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/crustai/HZrWpaHBXEmgaNgY/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/crustai/HZrWpaHBXEmgaNgY/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/crustai/HZrWpaHBXEmgaNgY/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Setting Filters \u0026amp; Sorting for Multiple Items Snippets - Crust AI Documentation\">\u003cmeta data-mint-head property=\"og:description\" content=\"Learn how to control which records appear in a Multiple Items Snippet list using static filters and sorting options.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Crust AI Documentation\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.trycrust.ai/chapters/selecting-which-data-to-display/setting-filters-and-sorting-for-multiple-items-snippets\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://crustai.mintlify.app/_mintlify/api/og/v2?division=Selecting+Which+Data+to+Display\u0026amp;title=Setting+Filters+%26+Sorting+for+Multiple+Items+Snippets\u0026amp;description=Learn+how+to+control+which+records+appear+in+a+Multiple+Items+Snippet+list+using+static+filters+and+sorting+options.\u0026amp;theme=3f26cf4361499096c6a64aac\u0026amp;signature=24326c2edae119b2f30171a9aff26803dcb247705a41e955dd8cc2700b083e5f\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Setting Filters \u0026amp; Sorting for Multiple Items Snippets - Crust AI Documentation\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Learn how to control which records appear in a Multiple Items Snippet list using static filters and sorting options.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://crustai.mintlify.app/_mintlify/api/og/v2?division=Selecting+Which+Data+to+Display\u0026amp;title=Setting+Filters+%26+Sorting+for+Multiple+Items+Snippets\u0026amp;description=Learn+how+to+control+which+records+appear+in+a+Multiple+Items+Snippet+list+using+static+filters+and+sorting+options.\u0026amp;theme=3f26cf4361499096c6a64aac\u0026amp;signature=24326c2edae119b2f30171a9aff26803dcb247705a41e955dd8cc2700b083e5f\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/crustai/HZrWpaHBXEmgaNgY/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Crust AI Documentation\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#752AC5\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.trycrust.ai/chapters/selecting-which-data-to-display/setting-filters-and-sorting-for-multiple-items-snippets\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/chapters/selecting-which-data-to-display/setting-filters-and-sorting-for-multiple-items-snippets.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.trycrust.ai/#organization\",\"name\":\"Crust AI Documentation\",\"url\":\"https://docs.trycrust.ai\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/crustai/rUCtKZsN7yplxJjE/logo/logo.png?fit=max\u0026auto=format\u0026n=rUCtKZsN7yplxJjE\u0026q=85\u0026s=960845f4820db91504c1881723f17de2\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.trycrust.ai#website\",\"name\":\"Crust AI Documentation\",\"url\":\"https://docs.trycrust.ai\",\"publisher\":{\"@id\":\"https://docs.trycrust.ai/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.trycrust.ai/chapters/selecting-which-data-to-display/setting-filters-and-sorting-for-multiple-items-snippets#webpage\",\"url\":\"https://docs.trycrust.ai/chapters/selecting-which-data-to-display/setting-filters-and-sorting-for-multiple-items-snippets\",\"name\":\"Setting Filters \u0026 Sorting for Multiple Items Snippets\",\"description\":\"Learn how to control which records appear in a Multiple Items Snippet list using static filters and sorting options.\",\"dateModified\":\"2026-01-07T08:03:42.819Z\",\"isPartOf\":{\"@id\":\"https://docs.trycrust.ai#website\"},\"breadcrumb\":{\"@id\":\"https://docs.trycrust.ai/chapters/selecting-which-data-to-display/setting-filters-and-sorting-for-multiple-items-snippets#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.trycrust.ai/chapters/selecting-which-data-to-display/setting-filters-and-sorting-for-multiple-items-snippets#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Selecting Which Data to Display\",\"item\":\"https://docs.trycrust.ai/chapters/selecting-which-data-to-display/selecting-a-record-for-single-item-snippets\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Setting Filters \u0026 Sorting for Multiple Items Snippets\",\"item\":\"https://docs.trycrust.ai/chapters/selecting-which-data-to-display/setting-filters-and-sorting-for-multiple-items-snippets\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.trycrust.ai/chapters/selecting-which-data-to-display/setting-filters-and-sorting-for-multiple-items-snippets#article\",\"headline\":\"Setting Filters \u0026 Sorting for Multiple Items Snippets\",\"name\":\"Setting Filters \u0026 Sorting for Multiple Items Snippets\",\"description\":\"Learn how to control which records appear in a Multiple Items Snippet list using static filters and sorting options.\",\"url\":\"https://docs.trycrust.ai/chapters/selecting-which-data-to-display/setting-filters-and-sorting-for-multiple-items-snippets\",\"mainEntityOfPage\":{\"@id\":\"https://docs.trycrust.ai/chapters/selecting-which-data-to-display/setting-filters-and-sorting-for-multiple-items-snippets#webpage\"},\"dateModified\":\"2026-01-07T08:03:42.819Z\",\"publisher\":{\"@id\":\"https://docs.trycrust.ai/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.trycrust.ai#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Crust AI Documentation\",\"creator\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","siteName":"Crust AI Documentation","nav":{"global":null,"groups":[{"group":"Getting Started","pages":[{"title":"Crust AI Overview","sidebarTitle":"Overview","icon":"target","href":"/chapters/getting-started/crust-ai-overview"},{"title":"Key Concepts","icon":"lightbulb","href":"/chapters/getting-started/key-concepts"},{"title":"Quickstart - Build Your First Snippet","sidebarTitle":"Build Your First Snippet","icon":"rocket","href":"/chapters/getting-started/quickstart-build-your-first-snippet"}]},{"group":"Understanding Snippets","pages":[{"title":"The Snippet Builder Interface","sidebarTitle":"The Builder Interface","icon":"app-window","href":"/chapters/building-and-understanding-snippets/the-snippet-builder-interface"},{"title":"Understanding Snippet Types","icon":"list-minus","href":"/chapters/building-and-understanding-snippets/understanding-snippet-types"}]},{"group":"Selecting Which Data to Display","pages":[{"title":"Selecting a Record for Single Item Snippets","sidebarTitle":"Single Item Snippet","description":"Learn how to choose the specific data record that a Single Item Snippet will display.","icon":"scan","href":"/chapters/selecting-which-data-to-display/selecting-a-record-for-single-item-snippets"},{"title":"Setting Filters \u0026 Sorting for Multiple Items Snippets","sidebarTitle":"Multiple Items Snippet","icon":"filter","href":"/chapters/selecting-which-data-to-display/setting-filters-and-sorting-for-multiple-items-snippets"}]},{"group":"Controlling Data Access","pages":[{"title":"Understanding the Permission Mechanism","sidebarTitle":"The Permission Mechanism","description":"Learn how Crust AI controls data access in Multiple Items Snippets using different permission types.","icon":"shield","href":"/chapters/controlling-data-access/understanding-the-permission-mechanism"},{"title":"User-Based Permission Explained","sidebarTitle":"User-Based Permission","icon":"circle-user","href":"/chapters/controlling-data-access/user-based-permission-explained"}]},{"group":"Customizing Design \u0026 Appearance","pages":[{"title":"Customizing the Snippet UI/UX","sidebarTitle":"Design \u0026 UI/UX","icon":"palette","href":"/chapters/customizing-design-and-appearance/customizing-the-snippet-ui-ux"},{"title":"Mobile \u0026 Desktop Responsiveness","sidebarTitle":"Desktop Responsiveness","icon":"monitor-smartphone","href":"/chapters/customizing-design-and-appearance/mobile-and-desktop-responsiveness"}]},{"group":"Update Data and Trigger Actions","pages":[{"title":"Adding Interactive Elements to Update Data","sidebarTitle":"Interactive Elements","icon":"square-dashed-mouse-pointer","href":"/chapters/update-data-and-trigger-actions/adding-interactive-elements-to-update-data"},{"title":"Fire an Automation Directly from a Snippet","sidebarTitle":"Fire Automations","icon":"workflow","href":"/chapters/update-data-and-trigger-actions/fire-an-automation-directly-from-a-snippet"}]},{"group":"Sharing Your Snippets","pages":[{"title":"Understanding the Shareable URL Structure","sidebarTitle":"Shareable URL Structure","icon":"link-2","href":"/chapters/sharing-your-snippets/understanding-the-shareable-url-structure"},{"title":"Share a Snippet Directly from Airtable","sidebarTitle":"Share Directly from Airtable","icon":"screen-share","href":"/chapters/sharing-your-snippets/share-a-snippet-directly-from-airtable"},{"title":"Integrate a Snippet in a Make/Zapier Flow","sidebarTitle":"Integrate with Make/Zapier","icon":"zap","href":"/chapters/sharing-your-snippets/integrate-a-snippet-in-a-make-or-zapier-flow"}]},{"group":"Navigating Between Snippets","pages":[{"title":"Why Link Snippets?","icon":"link","href":"/chapters/navigating-between-snippets-for-building-robust-apps/why-link-snippets"},{"title":"How to Add Navigation to Snippets","sidebarTitle":"Add Snippet Navigation","icon":"layers-2","href":"/chapters/navigating-between-snippets-for-building-robust-apps/how-to-add-navigation-to-snippets"}]}]},"basePath":"","title":"Setting Filters \u0026 Sorting for Multiple Items Snippets - Crust AI Documentation","buildId":"dpl_DeHjVRGfFnhYQwHnfC2pjeXXv8h9","deploymentId":"dpl_DeHjVRGfFnhYQwHnfC2pjeXXv8h9","dynamics":["a74be98ba7"],"chunks":["zoom-image-lightbox-BG6oD64b.js","lightbox-handle-r17bVUz3.js"]}