{"id":6891,"date":"2015-07-15T13:10:01","date_gmt":"2015-07-15T05:10:01","guid":{"rendered":"http:\/\/www.boostsolutions.com\/blog\/?p=6891"},"modified":"2023-07-31T11:38:14","modified_gmt":"2023-07-31T03:38:14","slug":"cascading-cross-site-one-go","status":"publish","type":"post","link":"https:\/\/www.boostsolutions.com\/blog\/cascading-cross-site-one-go\/","title":{"rendered":"Cascading and Cross site in one go"},"content":{"rendered":"

Cascading function has been required by many customers so far, and it’s a common requirement in the SharePoint market as SharePoint itself doesn’t support this.<\/p>\n

Why we need cascading and cross site function:<\/p>\n

1. Avoid selecting redundant data<\/p>\n

2. Improve efficiency<\/p>\n

3. Look up records from different sites under one site collection<\/p>\n

4. Locate desired data quickly<\/p>\n

With a very common example, country, state and city, which represents the key function of Cascaded lookup column.<\/p>\n

First Part: Cascading function<\/strong><\/p>\n

Suppose we have a list that stores countries, states and cities like below:<\/p>\n

\"2015-07-15_12-49-16\"<\/a><\/p>\n

The state name will be repeated more than once, such as ‘California<\/strong>‘, it looks like this when you use the SharePoint lookup column:<\/p>\n

\"2015-07-15_12-39-11\"<\/a><\/p>\n

While with Cascaded lookup column, it removes duplicate data and shows only the states for US <\/strong>by filtering the data:<\/p>\n

1. It filtered out the related states and cities based on the Country selected automatically:<\/p>\n

\"2015-07-15_12-51-16\"<\/a><\/p>\n

2. It shows single records and states that belong to US<\/strong> only:<\/p>\n

\"2015-07-15_12-53-31\"<\/a><\/p>\n

 <\/p>\n

Second Part: Cross Site function<\/strong><\/p>\n

The original SharePoint lookup column settings page:<\/p>\n

\"2015-07-15_12-57-23\"<\/a><\/p>\n

While with Cascaded lookup column, the settings page is:<\/p>\n

\"2015-07-15_13-00-42\"<\/a><\/p>\n

It supports to lookup from other sites of the current site collection, which an improvement of OOTB lookup column.<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Cascading function has been required by many customers so far, and it’s a common requirement in the SharePoint market as SharePoint itself doesn’t support this. Why we need cascading and cross site function: 1. Avoid selecting redundant data 2. Improve efficiency 3. Look up records from different sites under one site collection 4. Locate desired […]<\/p>\n","protected":false},"author":70,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1,347],"tags":[],"_links":{"self":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/6891"}],"collection":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/users\/70"}],"replies":[{"embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=6891"}],"version-history":[{"count":7,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/6891\/revisions"}],"predecessor-version":[{"id":6915,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/6891\/revisions\/6915"}],"wp:attachment":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=6891"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=6891"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=6891"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}