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.

0
votes
0answers
30 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
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
55 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 ...
1
vote
2answers
39 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
2answers
20 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
127 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
22 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 ...
2
votes
1answer
113 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. ...
1
vote
1answer
90 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
600 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
14 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
51 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
112 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
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
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
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 ...
3
votes
1answer
340 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 ...
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 ...
2
votes
2answers
534 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 ...
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....
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
104 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 ...
1
vote
1answer
178 views

How to make a SP list by using SQL Data through PowerShell

I have the following assignment: Our campus has a SQL database filled with printers. My job is to create a SharePoint list that printer constructors can use to read certain counters. This will be ...
2
votes
2answers
424 views

Sharepoint 2013 Check if path folder exists

I have a query like this: camlQuery.set_viewXml('<View Scope="RecursiveAll"><Query><Where> <In><FieldRef Name="FileDirRef" /> ...
0
votes
1answer
536 views

How to pass variable value in CAML query?

I have a Dropdown list, I want to pass selected value of this dropdown to caml query. Please suggest solutions for this SharePoint online query.
0
votes
1answer
573 views

What is the XSLT query to get items which have date greater than or equal today

I haven't worked on XSL. Scenario: We have a list which has a column called expiry. We want to display only those records which have expiry date greater than or equal to today's date. Trials: ...
0
votes
1answer
23 views

Custom List Accordian Narrative editable

I am looking to enable the Narrative porition of this code to be editable. <!-- Style --> <style type="text/css"> .item-title-clickable{ font-size:1.1em; background-color: #c7e0f4;...
1
vote
1answer
39 views

JS: If 'X' is mentioned anywhere in the LIST. Display

My list categories: Cats Dogs Cats and Dogs What i want to achieve: If 'Cats' is ANYWHERE mentioned in the list field, display data in HTML table. This means category Cats Cats and Dogs will ...
1
vote
2answers
50 views

Display filtered list by category

The current script creates a table showing all Items from the list. e.g. In my list there is a column named 'Category' with 'Cats' and 'Dogs'. What I want to achieve is to FILTER and ONLY display '...
1
vote
0answers
173 views

Searching ID's within a modern SharePoint 2013 list

I have a List with Project Info, it has 500+ items as if for now and it will double over the period of time. I would like an efficient way to search projects with ID (OOB SharePoint column). When 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 ...
2
votes
0answers
965 views

Querying List Item Field Values with PowerShell Problem

I have googled this a lot and have found trouble finding an instance of someone having similar issues with a resolution. I am currently working on querying a medium sized list on a sharepoint farm so ...
1
vote
1answer
27 views

Search Results Query

I have search results that I have looking into a specific document library but I only want specific documents to show that are no older than a certain date. I do have a date field as one of the column ...
1
vote
0answers
211 views

Checking if document library (list) exists takes too long

I need to check if specific document library exists on sharepoint site and I don't know the title of the library, because it is being created dynamically. The only thing I know is RootFolder.Name ...
3
votes
1answer
1k views

Filter Hyperlink field url using SharePoint REST API

I want to filter Hyperlink filed URL using REST API in SharePoint 2013. My URL is like below is working fine https://<siteurl>/_api/Web/Lists/GetByTitle('Pages')/items?$select=NavigateURL/Url ...
2
votes
0answers
1k views

All query processing components are in 'Failed' status

Error logs on Sharepoint 2013 Search Farm: Microsoft.Ceres.InteractionEngine.Component.FlowHandleRegistry : Exceptions occurred when evaluating the flow. Microsoft.Ceres.Evaluation.DataModel....
0
votes
1answer
35 views

Web Service that search by a User credential in a library

I m trying to create a search methode web service in SharePoint 2010 like : i put a username as an imput(without knowing password) and a keywords to search for and the methode return all documents ...
1
vote
0answers
45 views

Change hyperlink display form - content query

I am having a page called https://example.com/sites/nl/view_item.aspx?ID=10 for example, This displays the content in a nice visual way for that specific item. Next to that item I have made a list ...
0
votes
1answer
34 views

Powershell returns different results when it is executed using Farm Admin Account and other Account

Following PowerShell Script always returns null when I run the below script using Farm Account and the same script runs fine when it is run using other account. Can you please suggest me what is ...