有没有办法过滤从 AJAX 查询创建的数组？

Question

我有一个查询运行以用 Sharepoint 列表中的条目填充表 - 我要做的是根据列表中特定字段的内容过滤此列表。这是否可能仅使用一个列表和 JavaScript，或者我需要创建不同的视图并根据选择的选项查询每个视图？

function getIncidents(){

 $.ajax({

  url: "SharepointURL/_api/web/lists/getbytitle('Incident List')/items?$select=Title,Id,Priority,IncidentStart,IncidentStatus,IncidentTitle,UpdateResolution,ImpactedArea",

  type: "GET",

  headers: {"accept": "application/json;odata=verbose"},

  success: function (data) {

   var dResponse = data.d.results;

   var results = document.getElementById('Results');

   results.innerHTML += "<tr><td>Incident<br>Reference</td><td style='width:20px'></td><td>Priority</td><td style='width:20px;'></td><td>Start Time</td><td style='width:20px'></td><td style='width:170px'>Issue</td><td style='width:20px'></td><td style='width:170px'>Latest Update</td><td style='width:20px'></td></tr>";

   for(var obj in dResponse){

    results.innerHTML += "<tr style='font-size:10pt'><td>"+dResponse[obj].Title+"</td><td></td><td>"+dResponse[obj].Priority+"</td><td></td><td>"+dResponse[obj].IncidentStart+"</td><td></td><td>"+dResponse[obj].IncidentTitle+"</td><td></td><td>"+dResponse[obj].UpdateResolution+"</td></tr>";

   }

  }

 });

}

<script type="text/javascript" src="https://code.jquery.com/jquery-1.12.4.min.js"></script>

<input type="button" value="Get Incidents" onclick="getIncidents()">

<table id="Results">

</table>

我试图过滤的字段是Incident Satusand Impacted Area，我打算不显示在前面的屏幕上，但我调用它以便我可以使用它来过滤。

Answer 1

您可以filter在dResponse阵列上使用该功能。您没有指定您想要的过滤器，但这是一个基本示例。<script type="text/javascript" src="https://code.jquery.com/jquery-1.12.4.min.js"></script><script>function getIncidents(){&nbsp;$.ajax({&nbsp; url: "https://office4.bt.com/sites/ccim/Mobile/_api/web/lists/getbytitle('Incident List')/items?$select=Title,Id,Priority,IncidentStart,IncidentStatus,IncidentTitle,UpdateResolution,ImpactedArea",&nbsp; type: "GET",&nbsp; headers: {"accept": "application/json;odata=verbose"},&nbsp; success: function (data) {&nbsp; &nbsp;var dResponse = data.d.results;&nbsp; &nbsp;// we filter the data before using it.&nbsp; &nbsp;// we use const because we do not plan on reassigning the variable.&nbsp; &nbsp;const filteredResponse = dResponse.filter((item) => item.someFilteringData);&nbsp; &nbsp;var results = document.getElementById('Results');&nbsp; &nbsp;results.innerHTML += "<tr><td>Incident<br>Reference</td><td style='width:20px'></td><td>Priority</td><td style='width:20px;'></td><td>Start Time</td><td style='width:20px'></td><td style='width:170px'>Issue</td><td style='width:20px'></td><td style='width:170px'>Latest Update</td><td style='width:20px'></td></tr>";&nbsp; &nbsp;for(var obj in filteredResponse){&nbsp; &nbsp; results.innerHTML += "<tr style='font-size:10pt'><td>"+filteredResponse [obj].Title+"</td><td></td><td>"+dResponse[obj].Priority+"</td><td></td><td>"+dResponse[obj].IncidentStart+"</td><td></td><td>"+filteredResponse [obj].IncidentTitle+"</td><td></td><td>"+dResponse[obj].UpdateResolution+"</td></tr>";&nbsp; &nbsp;}&nbsp; }&nbsp;});}</script>

Answer 2

那么最后你想通过一个或多个对象属性过滤一组对象吗？是的，这很容易。let myArray = [ {a: 10, b: 'red'}, {a: 20, b: 'green'} ]let filteredArray = myArray.filter(x=>x.b=='green')一种更优雅的方式（如果可能）是将参数发送到您的 API 并过滤服务器端。