SharePoint Online中的URL OData查询? [英] URL OData query in SharePoint Online?
问题描述
Any help needed to get me in the right direction would be greatly appreciated. I'm looking for a URL query I can enter to obtain all list items with a specific chosen field.
示例:我有子站点A，B和C，并且在那些子站点中的每个子站点中都有一个同名列表，名为列表B".我希望返回列表B中所有带有状态"条目的子站点名称.列标记为已关闭".
Example: I have subsites A, B, and C, and on each of those subsites has a same-name list in them, named "List B". I am looking to return all subsite names with List B with entries that have a "Status" column marked as "Closed".
是否可以作为URL OData查询来显示浏览器中的结果或将结果导出到Excel工作表?或者可能是Power Bi的工作?
Is this possible as a URL OData query that would show the results in-browsers or export the results to an Excel sheet? Or possibly a job for Power Bi?
谢谢！
推荐答案
Hi,
您可以使用Content Search Web部件实现您的目的:
You can use the Content Search web part to achieve your purpose:
(但是，您需要输入所有子站点的路径.我对此进行了大量测试，但仍然找不到更好的方法来自动显示所有子站点查询)
(However, you need to enter the path of all the subsites. I have done a lot of test about this but still cannot find a better way to automatically display all subsites in one query)
1.编辑要显示内容的页面，然后添加内容搜索Web部件.
1. Edit the page that you want to display content and add a Content Search Web Part.
2. Edit the web part, click "change query" button and specify you query.
路径:http://{子站点A的URL}或路径:http://{子站点B的URL}或路径:http://{子站点C的URL } AND Status =已关闭
Path:http://{ URL of subsite A} OR Path:http://{ URL of subsite B} OR Path:http://{ URL of subsite C} AND Status= Closed
然后保存您的更改.
请注意:
以上查询中的状态"是托管属性.
The Status in above query is a managed property.
如果状态"列是网站"列，则它会出现在您抓取的属性中，并且相关的托管属性也将可用.您可以直接在查询中使用它；
If the "Status" column is a Site Column, it will come in your crawled properties and an associated Managed Property will also be available. And you can use it in your query directly;
但是，如果状态"列是列表列(通过列表创建)，则在完成完全爬网之后，它应该出现在已爬网的属性中，但是它将不能是任何映射到它的托管属性.您必须手动映射此已爬网 财产到托管财产.
However, if the "Status" column is a List Column (Created through a list), after the full crawl is done, it should appear in the crawled property, but it will not be any managed property mapped to it. You must manually map this crawled property to a Managed Property.
最诚挚的问候，
艾伦·白
这篇关于SharePoint Online中的URL OData查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
