在查找字段上使用rest API过滤共享点列表

本文介绍了在查找字段上使用rest API过滤共享点列表的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

嗨 我有一个SharePoint列表如下。 <

col1 col2 col3 印度Sudha黄色非洲Ajay绿色美国Vijay红色

> col1是一个查找字段。 我想使用Rest API并在col1上过滤列表，即使我提供了部分字符串，它也应该搜索记录。 我试过

sharepoint/sites/sitename/_api/web/lists/GetByTitle('listname'）/ items？$ expand = lookupcolumn& $ select =标题，parentlookupcol / lookupcolumn& $ filter = substringof（'US2017 - 0002'，lookupcolumn）

，但没有运气。 我替换substring并使用filter = lookup / col eq'value'，我能够搜索。但是eq会查找完整的字符串匹配，但不符合我的要求。 感谢您的帮助。 提前致谢 Naina 我的尝试：

我试过< pre> https：//sharepoint/sites/sitename/_api/web/lists/GetByTitle（'listname'）/ items？$ expand = lookupcolumn& $ select = Title，parentlookupcol / lookupcolumn& $ filter = substringof（'US2017 - 0002'，lookupcolumn）

，但没有运气。

解决方案

expand = lookupcolumn&

select = Title，parentlookupcol / lookupcolumn&

filter = substringof（'US2017 - 0002'，lookupcolumn）

，但没有运气。 当我替换substring并使用filter = lookup / col eq'value'时，我能够搜索但是eq会查找完整的字符串匹配，但不符合我的要求。 感谢您的帮助。 预付款 Naina 我试过的：

我试过< pre> https：//sharepoint/sites/sitename/_api/web/列表/ GetByTitle（ 'LISTNAME'）/项目？

Hi I have a SharePoint list as below. <

col1 col2 col3 India Sudha Yellow Africa Ajay Green America Vijay Red

> col1 is a lookup field. I want to use Rest API and filter the list on a col1 in such a way that even if i give part of the string, it should search the record. I tried "

sharepoint/sites/sitename/_api/web/lists/GetByTitle('listname')/items?$expand=lookupcolumn&$select=Title,parentlookupcol/lookupcolumn&$filter=substringof('US2017 - 0002',lookupcolumn)

", but no luck. When i replace substring and use filter = lookup/col eq 'value' , i was able to search. But "eq" will look for complete string match which fails my requirement. Appreciate your help. Thanks in Advance Naina What I have tried:

I tried "<pre>sharepoint/sites/sitename/_api/web/lists/GetByTitle('listname')/items?$expand=lookupcolumn&$select=Title,parentlookupcol/lookupcolumn&$filter=substringof('US2017 - 0002',lookupcolumn)

", but no luck.

解决方案

expand=lookupcolumn&

select=Title,parentlookupcol/lookupcolumn&

filter=substringof('US2017 - 0002',lookupcolumn)

", but no luck. When i replace substring and use filter = lookup/col eq 'value' , i was able to search. But "eq" will look for complete string match which fails my requirement. Appreciate your help. Thanks in Advance Naina What I have tried:

I tried "<pre>sharepoint/sites/sitename/_api/web/lists/GetByTitle('listname')/items?