Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [query]

A precise request for information retrieval with database and information systems.

2
votes
3answers
5k views

Web service based CAML query breaks 5,000 item limit

I have a CAML query of the form shown below which is called via the Sharepoint web service interface to search the entire Sharepoint site containing 600,000 documents looking for documents: <...
1
vote
3answers
366 views

How to raise character limit in FQL Query?

as stated in the msdn, the maximum length of a FQL Query is set to 2048 characters (SharePoint 2010). Is there any way to raise this limit?
1
vote
1answer
1k views

Query list in designer workflow

I have created a approval workflow using SharePoint Designer workflow. I want to query the task list to get the task with minimum due date for the current task approver. Below is the scenario : I ...
4
votes
1answer
751 views

Exclude 'SharePoint' URL from Search results

We have several documents with 'SharePoint' in the title but our Online URL also has sharepoint (https://.sharepoint.com/). When users search for sharepoint, it returns all results because all ...
0
votes
0answers
31 views

Query from a script editor

I need to use a script editor to display list data. The content query web part will display the data the exact way I need to have it display but I need to use a script editor web part on my site - is ...
0
votes
1answer
20 views

Display Query String filter in page

I have query string filter like: Lists/DIIS/Master%20List.aspx?Modality=CT. I would like to display Modality=CT somewhere on the page (not the title since I hide the title). Is there a way to use ...
0
votes
2answers
773 views

SharePoint List Ping IP Address

We have setup a SharePoint page with a list of our office sites. At the moment we have a column called status so in the event of an infrastructure outage, we manually change the status from Connected ...
1
vote
2answers
1k views

hosting an iqy file on a sharepoint

I want to export a list from sharepoint into excel. I can do this export easy with an iqy file. Once I have this iqy file (which by default is saved in my temporary area but I will save it to my ...
0
votes
1answer
18 views

Get a result of a predefined query by one click?

In my SharePoint site, I see a search box at the top of navigation bar left side of the page. I want to avoid manually typing frequently-used query strings (e.g. filename:meeting). Instead, I want to ...
0
votes
1answer
57 views

CAML filtered list views - filter more than one nested level?

do you know if it's possible with CAML to write a SharePoint list view filter query to retrieve a user that is a member of a group which in turn is a member of another group i.e. nested groups? I've ...
0
votes
2answers
913 views

Content Search WebPart: query Date and Time field

I have calendar list, Now trying to query items which is greater than Today. so first I have created new managed property with name EventDate and mapped the crewel property ows_EventDate with type ...
5
votes
7answers
11k views

How to get the ID of a list item with a given GUID in Sharepoint online with REST api?

I tried a request at a url of the following form .../_api/web/Lists/getByTitle('docLib')/items?$select=id,GUID&$top=1&$filter=GUID eq '2779cf8051-381f-4834-93dc-ece6345dde33' and i get "...
1
vote
2answers
41 views

Sharepoint 2010 Query List with SPD Workflow?

Working in Sharepoint 2010, I have to create a Sharepoint Designer Workflow to query all the items in a list. I want to query the list and sort the results from highest to lowest based on project ID. ...
0
votes
0answers
13 views

Workflow Affects Modified Date?

I'm trying to develop a process to programmatically check the last modified date, calculate the retention period, and send an email with the URL to the site owners if the document is past the ...
0
votes
1answer
1k views

Recursive CAML query

I would like to search items between two dates in a DocumentLibrary. The query find the files at root just right. However the query doesn't seem to be considering files in folders. Here is my attempt ...
1
vote
1answer
1k views

Check a property is not null in search rest api

I write this query for search user in a site. /_api/search/query?querytext='*'&sourceid='b09a7990-05ea-4af9-81ef-edfab16c4e31' I want to add a filter that the result must contains WorkEmail. I ...
0
votes
2answers
21 views

Is there a sotfware to create, manager and CAML query SharePoint Lists without having SharePoint installed on a computer?

I'm working on a SharePoint site at work, however due to PCI compliance I am not able to access SharePoint at my house, I was trying to find a software on which I can be able to create lists and use ...
1
vote
1answer
36 views

How to remove duplicates documents from Content Query

Having difficulty removing duplicate documents within Content Query. So far...I have inserted a Content Query Web Part from Content Rollup, SharePoint 2013. This pulls data from a number of different ...
1
vote
0answers
41 views

Multiple items in single query. How to separate them?

What I would like to do is exclude preferred names in a web query in single command. For example, now if I want to exclude some system accounts or user names that are named John and Edward and other I ...
0
votes
1answer
343 views

Can i reach the lookup column's data with CAML query?

I want to reach list's datas. There is look up column. I am using CAML query. But when i create query with CAML, i am seeing look up column like Microsoft.SharePoint.Client.FieldLookupValue[].I want ...
0
votes
1answer
129 views

Caml Query problem, cannot complete this action

I am new in sharepoint development, Can anyone please help me find an error in this query? I am using javascript to retrieve records. The where clause is based on status and priority fields. Query ...
0
votes
1answer
19 views

How can I get specific roles for each user in “SharedWithUsers” field?

I'm doing a REST to get "SharedWithUsers" field. My query is expanding ID and Title of "SharedWithUsers" field: var REST = globalvars.absoluteUrl + "/_api/web/lists(guid '" + globalvars.libraryGUID ...
0
votes
1answer
23 views

How to get value of an event in Calendar

I'm trying to bring the value(Title) of an event to another form in SharePoint. So it's basically a register form. When someone clicks an event, you can click a button "Register" and it brings you to ...
0
votes
1answer
117 views

CAML Query : Where clause not working with View tag & RowLimit

I've reached the maximum view threshold limit on a SharePoint List, with a little more than 5000 item in it. When I raise the limit in the webapp's settings, everything is working fine, but I would ...
2
votes
1answer
238 views

Error while quering using search.asmx Query or ex query method

I am trying to query using search.asmx ex query and query methods using soap api's I am getting the following err "Data at the root level is invalid. Line 1, position 1." Please help . I am ...
0
votes
1answer
55 views

CAML Query to find items with wrong expiry date

I have a library with 65,000 items and for some items the “expiry date“ is not right. The field should actually be calculated automatically from the “creation date“ + 8 years. How can I determine the ...
1
vote
1answer
2k views

Configure Search for a specific Column

I'm creating kind of a knowledge base in SharePoint. I have a list with columns Title, Issue, Solution and Topics. Topics rely on managed metadata from termstore. When People use the search of the ...
1
vote
1answer
277 views

CAML Query multiple Lists with same fields

I have 4 different lists with different fields. Now I would like to retrieve items from all 4 of these lists ordered by user "Created By" ("Author") field using CAML. Also, all of the lists have a ...
2
votes
1answer
114 views

Pnp : create a search query

I need a little remembering on pnp.search() queries. I know from a verified source that you can use either query text, SearchQuery Interface or SearchQuery Builder. No worries about that (except that ...
1
vote
1answer
33 views

Creating a Query or SQL Statement from multiple lists30

I have built out the back end of my database with multiple related tables. What I'm trying to do now is build a view that pulls from those tables based on the relationships and a combo box filter. ...
2
votes
2answers
539 views

Filtering Calendar Items Using REST API

I'am trying to get calendar items and filtering by EventDate and EndDate fields using rest api. DateTime field filtering works fine on other lists but I can not filter calendar items by EventDate and ...
1
vote
1answer
92 views

Query on a table with lookup columns doesn't work

What I have I've got 2 lists (listA, listB). In listA there are several lookup columns to listB. What I want to do I want to create a query that updates a field in all items in listA from 'empty' to '...
0
votes
1answer
608 views

How to get Person or Group user details from REST API query

I am having trouble trying to get the "Title" portion of a Person or Group field from SharePoint Designer 2013 workflow using a REST API query. I have my workflow built similar to the one in this ...
0
votes
0answers
15 views

Performance on checking permissions for a large amount of items

I need to check user specifik permissions on a relatively large set of list items. I know about SPListItem.DoesUserHavePermissions, but then I have to fetch each individual list item to perform the ...
0
votes
1answer
52 views

Random seed in search result webpart query

I am looking for a way to randomize a result table. I used to do this via REST-API like this var randomSeed = parseInt((Math.random() * 1000000), 10), searchUrl = _spPageContextInfo....
0
votes
2answers
113 views

How to exclude a site from search result source but keep its subsites in search results?

How to exclude a site from search result source but keep its subsites in search results? I have a site collection in which i used to make team sites and project sites. In search results i want that ...
0
votes
1answer
16 views

Query.RankingModelID - empty

In SharePoint KeywordQuery, if query attribute RankindModelID will have empty string assigned to it - will search engine use default ranking model for given search application instead?
0
votes
0answers
8 views

Sharepoint Form Autopopulate

I have a Sharepoint List that looks like this: Quarter Year Client Field 1 2017 Client 1 1.5 4 2016 Client 1 1.4 3 2016 Client 1 1.3 2 2016 Client 1 1.45 1 2016 ...
0
votes
1answer
81 views

Displaying Reports on SharePoint

First of all, I must say that I'm new to this. I'm a 3rd year ICT & Business student and an intern in a international company. My assignment is to create a reporting service on the company's ...
3
votes
1answer
344 views

How do I prioritize search results to show file names containing keyword appear first?

I have a document library in sharepoint online and I need to have the search results show any documents that have the searched keyword appear in the file name come up first in results, (i.e. if I have ...
5
votes
2answers
2k views

How to use SPServices search sql query - getting malformed query

I am using the SPServices javascript library to make a search request to sharepoint 2010 search. I am trying this query: queryText = "<QueryPacket xmlns='urn:Microsoft.Search.Query' Revision='1000'...
0
votes
0answers
14 views

How do I prioritize a certain column in searches [duplicate]

I have a document library in Sharepoint Online and each document has a 'Title' column which is basically just the name of the document. When people search the library, results don't prioritize this ...
0
votes
1answer
140 views

Count sub folders in given folder

So this is my query to count items in given folder: /_api/web/GetFolderByServerRelativeUrl('/Shared%20Documents/')/ItemCount And it gives me count of all elements but how I can count only folders ...
0
votes
1answer
94 views

SharePoint Online JavaScript only runs in edit mode

I am trying to run the code below but the success and fail handlers only work in edit mode. I am getting the first alert just fine outside of the edit mode. I am already using executeFunc to load sp....
3
votes
3answers
2k views

SharePoint Query Builder unknown error

On a SharePoint 2013 on-premises, we tried to install the August 2015 CU. However, the installation failed and since then, all Content Search web parts show an error if I try to change the query. The ...
2
votes
1answer
150 views

Search for synonyms without a thesaurus file

We have a SP 2013 on prem site. I am a site collection admin and have no access to central admin. We have a site with a lot of human resource related content for non-HR managers. One thing they search ...
1
vote
1answer
107 views

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. Example: I have subsites ...
1
vote
0answers
266 views

How to write a REST query to obtain all tasks within a Workflow Task list?

I'm trying to write a REST query to obtain all tasks associated with a given list item. The workflow task list is named 'Workflow Tasks'. Under the 'Related Content' column, one can see the title of ...
0
votes
1answer
55 views

How to create query rule group and move the query rule to that group?

I have created 3query rules in SharePoint 2013. I need to create query rule group using powershell and and define the ordering . anyone give me the better idea to create query rule group using ...
0
votes
1answer
1k views

Phonetic / Liguistic Search for People is Not Working in SP2013 Farm

Phonetic search is not working for us in a SharePoint Server 2013 farm. We are also seeing the following in the event logs (I the query text): 04/17/2014 11:40:15.89 NodeRunnerQuery1-e68fd887-...