在线共享点上具有多父级列的级联下拉字段 [英] Cascade Dropdown Fields with multi parent column on Sharepoint online

问题描述

我是新来的分享开发.在Cascade下拉列表中，我还需要再做一次filter(relationshipListParentColumn) 公司专栏.在员工列表中，公司和名称，EmpName列在那里.我需要同时使用这两种( ) 列以过滤EmpName.我尝试过但无法过滤.您能帮助实现这一目标吗?谢谢

I am new to sharepoint development. In Cascade dropdown list, I need to do one more filter(relationshipListParentColumn)along with Company column. In employee list, Company and Designation, EmpName columns are there. I need to use both these (Company and Designation) columns to filter EmpName. I tried but unable to filter. Can you help to achieve this. Thanks

代码:

<script src="https://site name/jquery.min.js"></script>  
<script src="https://sitename/jquery.SPServices.min.js"></script>  
<script type="text/javascript">  
$(document).ready(function ()  
{  
    $().SPServices.SPCascadeDropdowns(  
    {  
        relationshipList: "Employee",  
        relationshipListParentColumn: "Company",  
        relationshipListChildColumn: "EmpName",  
        parentColumn: "Company",  
        childColumn: "Employee",  
        debug: true  
    });  
});  
</script>

推荐答案

您好，Akil，

Hi Akil,

在这里，您将获得详细的说明，以在SharePoint中实现级联查找列:

Here you go with detailed instructions to achieve the cascading lookup columns in SharePoint:

使用SP Services的SP 2010 - 在SharePoint中级联或筛选查找列

SP 2010 using SP Services - Cascading or Filtering Lookup Columns in SharePoint

SP 2013/在线- 使用REST API在SharePoint中进行级联下拉菜单

SP 2013/ Online - Cascading dropdown in SharePoint using REST API

包含CAML和REST API的代码的多值查找- SharePoint中的多值查找列

Multi-value lookup with code for CAML as well as REST API - Multi-value lookup column in SharePoint

要针对您的方案实施的常规代码:

(文档).ready(function(){

(document).ready(function(){

().SPServices.SPCascadeDropdowns({ lationshipList:主列表的显示名称"， relationshipListParentColumn:来自主列表的父列内部名称"， lationshipListChildColumn:主列表中的子列内部名称"， parentColumn:来自列表/库的父列显示名称"， childColumn:来自列表/库的子列显示名称"； }); });

().SPServices.SPCascadeDropdowns({ relationshipList: "Display Name of Master List", relationshipListParentColumn: "Parent Column Internal Name from Master List", relationshipListChildColumn: "Child Column Internal Name from Master List", parentColumn: "Parent Column Display Name from List/Library", childColumn: "Child Column Display Name from List/Library" }); });

这篇关于在线共享点上具有多父级列的级联下拉字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！