我需要筛选SharePoint列表中的下拉列表并更改颜色以更改数据 [英] i need filter for dropdown in the list SharePoint and change color for change data

查看:47
本文介绍了我需要筛选SharePoint列表中的下拉列表并更改颜色以更改数据的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

 我有自定义列表并通过api rest SharePoint 2013获取数据,我需要对数据进行过滤并为下拉菜单中的选择项更改颜色数据下拉名称 类别

这是我的名字

  var Title = result.Title;

              nbsp; bsp         

       var itemlink =" + result.ID;

     

 //创建列表项:

       var item = document.createElement('div');

           item .setAttribute('class','col-lg- 3'+'col-xs-6'+'small-box  clearfix');

 

       //设置其内容:

   //item .setAttribute('onclick',itemli nk);

 

  var element1 = document.createElement("a");;

     element1.setAttribute('class','link');

  

     

      var HtmlText ='< div>'+'< div bg-aqua block-2" +' ;'+ result.Title +'/p>'+'

'+ GetNothingFor(result.percentag e)+'%'+ '</h3> < div>'+ GetNothingForNull (结果周期)+'</div>'  +'< div> '+'< li>'+ GetNothingFor Null(结果.金额)+''+ GetNothingForNull(result.Uni t)+'| | | | | | | | | | | | | | | YTD'+ GetNothingForNull(result.YTD )+'</li> </p> </div> </div> '

               

     

<bsp;   //sult.Title +"br/""+ res " +& nbsp;" +' ' +' ' +结果.句点+"br/>" + '& nbsp;' + result.Amount  +'& nbsp;' + result.Unit +'& nbsp;' + result.YTD;

     

   var div = document.createElement("div"));

     element1.setAttribute('class','col-lg-3'+'col-xs-6'+'');

     element1.innerHTML = HtmlText;

     

      element1.setAttribute('t arget','_ blank');      item.appendChild(element1);

    //item.appendChild(document.crea teTextNode(result.Title)); 跨度>

       //将其添加到列表中:

       list.appendChild(item);

       });

 

     },

   错误:function(){

    //alert(无法获取商品");

    }

  });

//最后,返回构造的列表:

   返回列表;

 

}

函数SPConvertDate(t){

   if(t!= null)

   {

    var d = new Date(t.substr(0,4),parseInt(t.substr(5,2))-1,t.substr(8,2),t.substr(11,2),t.substr (14,2),t.substr(17,2));

    d.setHours(d.getHours()+ 3);

    var month =((d.getMonth()+ 1)< 10)吗? "0" +(d.getMonth()+ 1):(d.getMonth()+ 1);

    var date =(d.getDate()< 10)吗? "0" + d.getDate():d.getDate();

    var minutes =(d.getMinutes()< 10)吗? "0" + d.getMinutes():d.getMinutes();

    var amPm =(d.getHours()< 12)吗? 上午" :" pm" ;;

 

    //返回月份+-" +日期+-" + d.getFullYear();

   返回日期+-" +月+-" + d.getFullYear();

 

   

   }

   else

   {

  返回t;

   }

}

 

    

 

 

函数GetNothingForNull(value)

{

//alert(value);

if(value == null)

{

return(");

}

else

{

返回值;

}

}

 

函数GetNothingFor(value)

{

//alert(value);

if(value == null)

{

返回0;

}

else

{

返回值;

}

}

 

 

函数changeColor()

    {

 

  

    }

 

 

 

</script>

 

< style>

.small-box> .inner {

                             padding:0px;

}

.inner .footer2 {

    font-size:18px;

   填充:10px;

    font-weight:粗体;

}

.small-box.bg-aqua.bg-aqua.blo ck-2 {

   最小高度:164像素;

}

 

.small-box.bg-aqua.bg-aqua.blo ck-2 {

 

    box-shadow:-1px 3px 2px rgba(128,128,128,0.4)!Important; }

.small-box h3 {

   

   填充:10px;

    margin:0px;

}

.icon2 li {

  字体样式:正常;

   

   右:0px;

    

   底部:0像素;

}

.pe {

      margin-bottom:10px;

          padding-bottom:40px;

}

.p {

                             text-align:center;

                             font-size:medium;

}

.small-box.bg-aqua.block-2 {

                            过渡:所有0.6秒的缓解;

}

.footer2{

                                transition:all 0.6s ease ;

 

}

 

.small-box.bg-aqua.block-2{

                             opacity:1;

                             transition:all 0.5s ease;

                             }

 

.small-box.bg-aqua.block-2:hover {

transform:scale(1.1);

background-color:#0aa4ca !Important;

 

}

 

.small-box.bg-aqua.block-2:hover .footer2{

               

                             transform:scale(1.1);

               

    text-shadow: 1px 1px 1px #969696;

}

#tit{

               

                             margin:10px;

}

 

 

</style>

 

</head>

 

<body>

<!-- Small boxes (Stat box) -->

<div>

<select id="drpcountries" onchange="changeColor()" style="width:300px ;float:right">

<option   value="All">ALL</option>

 

</select >

</div>

 

<div id="foo" style="width:100%;height:50% ">

<script type="text/javascript">

document.getElementById('foo').appendChild(GridViewList());

 

//add different colors to div

 

 

var colors =['#599aef','#45c1eb','#3bd3ad','#9ad861','#ffcc4b','#ff6b49','#ec5062','#ad8fea','#e688c3','#636676'];

$(".bg-aqua").each(function(i){

$(this).css('background-color', colors);

});

 

</script>

</div>

 

 

 

</body>

 

</html>

解决方案

您好,

You could filter SharePoint list data with choice/dropdown with OOB choice filter.

Configure choice filter for list view webpart, check ‘Connect a Choice Filter Web Part to a List View Web Part for SharePoint 2016 and 2013’ section of guideline below.

https://support.office.com/en-us/article/Connect-a-Filter-Web-Part-to-a-List-View-Web-Part-on-a-classic-page-4F3F6C10-0A1B-479D-8B4D-C4F1BF49BB3F  

Tip: you need enable ‘Server Render’ for your list view web part per my testing.


Result:


You could use jQuery datatable to display SharePoint data also, the library contains search function.

http://www.c-sharpcorner.com/article/display-sharepoint-list-data-in-jquery-data-table/

If you do need achieve your requirement as your solution, you’d better provide more details like list definition.

最好的问候,

Lee


  i have custom list  and get data by api rest SharePoint 2013 i need make filter on data and change color data for select item from dropdown  dropdown name   category 

this my name

 var Title = result.Title;

                                 

       var itemlink ="" + result.ID;

      

 // Create the list item:

        var item = document.createElement('div');

            item .setAttribute('class','col-lg-3'+' col-xs-6'+' small-box  clearfix');

 

        // Set its contents:

   //item .setAttribute('onclick',itemlink );

 

  var element1 = document.createElement("a");

      element1.setAttribute('class','link');

  

      

      var HtmlText='<div>'+' <div bg-aqua block-2 ">'+' <div>'+'<p >'+result.Title+'</p>'+'<h3>'+GetNothingFor(result.percentage) +'%'+    '</h3> <div>'+GetNothingForNull(result.Period)+'</div>'  +' <div> ' +'<li>'+GetNothingForNull(result.Amount)+' '+GetNothingForNull(result.Unit)+' | YTD '+GetNothingForNull(result.YTD)+'</li> </p> </div> </div> '

                 

      

      //sult.Title+"<br/>"+result.percentage+"%" +"<br/>"+ '&nbsp;' +'&nbsp;' +'&nbsp;' + result.Period + "<br/>"+ '&nbsp;' + result.Amount  + '&nbsp;' + result.Unit +'&nbsp;' + result.YTD ;

      

  var div = document.createElement("div");

      element1.setAttribute('class','col-lg-3'+'col-xs-6'+'');

      element1.innerHTML=HtmlText;

      

      element1.setAttribute('target','_blank');

      item.appendChild(element1);

     // item.appendChild(document.createTextNode(result.Title));

        // Add it to the list:

        list.appendChild(item);

        });

 

      },

    error:function(){

     // alert("Failed to get items");

    }

  });

// Finally, return the constructed list:

    return list;

 

}

function SPConvertDate(t){

   if (t != null)

   {

     var d = new Date(t.substr(0,4), parseInt(t.substr(5,2)) - 1, t.substr(8,2), t.substr(11,2), t.substr(14,2), t.substr(17,2));

     d.setHours(d.getHours()+3);

     var month = ((d.getMonth()+1) < 10) ? "0" + (d.getMonth()+1) : (d.getMonth()+1);

     var date = (d.getDate() < 10) ? "0" + d.getDate() : d.getDate();

     var minutes = (d.getMinutes() < 10) ? "0" + d.getMinutes() : d.getMinutes();

     var amPm = (d.getHours() < 12) ? "am" : "pm";

 

     //return month + "-" + date + "-" + d.getFullYear();

     return date + "-" + month + "-" + d.getFullYear();

 

    

   }

   else

   {

   return t;

   }

}

 

     

 

 

function GetNothingForNull(value)

{

//alert(value);

if (value == null)

{

return ("");

}

else

{

return value;

}

}

 

function GetNothingFor(value)

{

//alert(value);

if (value == null)

{

return 0;

}

else

{

return value;

}

}

 

 

function changeColor()

     {

 

  

     }

 

 

 

</script>

 

<style>

.small-box>.inner{

                padding:0px;

}

.inner .footer2 {

    font-size: 18px;

    padding: 10px;

    font-weight: bold;

}

.small-box.bg-aqua.bg-aqua.block-2 {

    min-height: 164px;

}

 

.small-box.bg-aqua.bg-aqua.block-2 {

 

    box-shadow: -1px 3px 2px rgba(128, 128, 128, 0.4) !Important;

}

.small-box h3 {

   

    padding: 10px;

    margin: 0px;

}

.icon2 li {

   font-style: normal;

   

    right: 0px;

    

    bottom: 0px;

}

.pe {

       margin-bottom: 10px;

           padding-bottom: 40px;

}

.p{

                text-align:center;

                font-size:medium;

}

.small-box.bg-aqua.block-2 {

                transition:all 0.6s ease;

}

.footer2{

                                transition:all 0.6s ease ;

 

}

 

.small-box.bg-aqua.block-2{

                opacity:1;

                transition:all 0.5s ease;

                }

 

.small-box.bg-aqua.block-2:hover {

transform:scale(1.1);

background-color:#0aa4ca !Important;

 

}

 

.small-box.bg-aqua.block-2:hover .footer2{

               

                transform:scale(1.1);

               

    text-shadow: 1px 1px 1px #969696;

}

#tit{

               

                margin:10px;

}

 

 

</style>

 

</head>

 

<body>

<!-- Small boxes (Stat box) -->

<div>

<select id="drpcountries" onchange="changeColor()" style="width:300px ;float:right">

<option   value="All">ALL</option>

 

</select >

</div>

 

<div id="foo" style="width:100%;height:50% ">

<script type="text/javascript">

document.getElementById('foo').appendChild(GridViewList());

 

//add different colors to div

 

 

var colors =['#599aef','#45c1eb','#3bd3ad','#9ad861','#ffcc4b','#ff6b49','#ec5062','#ad8fea','#e688c3','#636676'];

$(".bg-aqua").each(function(i){

$(this).css('background-color', colors);

});

 

</script>

</div>

 

 

 

</body>

 

</html>

解决方案

Hi,

You could filter SharePoint list data with choice/dropdown with OOB choice filter.

Configure choice filter for list view webpart, check ‘Connect a Choice Filter Web Part to a List View Web Part for SharePoint 2016 and 2013’ section of guideline below.

https://support.office.com/en-us/article/Connect-a-Filter-Web-Part-to-a-List-View-Web-Part-on-a-classic-page-4F3F6C10-0A1B-479D-8B4D-C4F1BF49BB3F  

Tip: you need enable ‘Server Render’ for your list view web part per my testing.


Result:


You could use jQuery datatable to display SharePoint data also, the library contains search function.

http://www.c-sharpcorner.com/article/display-sharepoint-list-data-in-jquery-data-table/

If you do need achieve your requirement as your solution, you’d better provide more details like list definition.

Best Regards,

Lee


这篇关于我需要筛选SharePoint列表中的下拉列表并更改颜色以更改数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆