{"id":10525,"date":"2023-09-08T23:03:46","date_gmt":"2023-09-08T21:03:46","guid":{"rendered":"https:\/\/help.metashare.com\/?page_id=10525"},"modified":"2026-05-08T23:25:05","modified_gmt":"2026-05-08T21:25:05","slug":"warning-lookup-threshold","status":"publish","type":"page","link":"https:\/\/help.metashare.com\/en\/warning-lookup-threshold\/","title":{"rendered":"MetaShare alert: List view lookup threshold"},"content":{"rendered":"\n<p>In SharePoint there is a limit on number of lookup columns that can be used in a single view. This means that MetaShare workspaces cannot have more than 12 lookup columns (<a href=\"https:\/\/help.metashare.com\/en\/get-started\/metashares-supported-site-columns\/#managed-metadata-column\">managed metadata<\/a>\u00a0and\u00a0<a href=\"https:\/\/help.metashare.com\/en\/get-started\/metashares-supported-site-columns\/#person-or-group-column\">person or groups<\/a>\u00a0columns) selected as view fields. Additionally, the sum of lookup columns used as view fields and selected as filters must also not exceed 12. <\/p>\n\n\n\n<p>Once exceeded, so when a 13th lookup column filter is applied, there will be a warning shown and MetaShare will display search based results instead of query based results.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MetaShare documentation: Warning Lookup Threshold. Learn more about this feature in the MetaShare help center.<\/p>\n","protected":false},"author":9,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":{"0":"post-10525","1":"page","2":"type-page","3":"status-publish","5":"no-featured-image-padding"},"_links":{"self":[{"href":"https:\/\/help.metashare.com\/en\/wp-json\/wp\/v2\/pages\/10525","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.metashare.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/help.metashare.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/help.metashare.com\/en\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/help.metashare.com\/en\/wp-json\/wp\/v2\/comments?post=10525"}],"version-history":[{"count":4,"href":"https:\/\/help.metashare.com\/en\/wp-json\/wp\/v2\/pages\/10525\/revisions"}],"predecessor-version":[{"id":12577,"href":"https:\/\/help.metashare.com\/en\/wp-json\/wp\/v2\/pages\/10525\/revisions\/12577"}],"wp:attachment":[{"href":"https:\/\/help.metashare.com\/en\/wp-json\/wp\/v2\/media?parent=10525"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}