Questions tagged [query]

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

Filter by
Sorted by
Tagged with
5
votes
1answer
839 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 ...
1
vote
1answer
12 views

REST API to Upload a File inside a Folder (if folder not available create the folder)

I want to Upload a file inside a folder using the REST API. Also if the Folder which I have passed is not there then we need to create the folder and then upload the file. Is this really achievable? ...
0
votes
3answers
190 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 ...
1
vote
1answer
149 views

How to add CAML query results with ListItems to a datasource of a repeater?

I am using SP2010. I have created a CAML query. This query has listItems as results. I would like to add these items to my repeaters datasource. How can I implement this?
0
votes
0answers
5 views

Content search webpart get friendly url parent term

We are using managed navigation with a friendly urlsSo we have the following topics which are used both for tagging documents and for the friendly urls. Topic 1 Topic 2 This creates a url like ...
2
votes
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
2answers
794 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 ...
0
votes
0answers
16 views

Query project server custom fields values when MSP_EpmProject_UserView is missing

Recently, I’d wanted to query one of my custom fields values from project server 2016 database but I couldn’t find MSP_EpmProject_UserView in my content database views!! After a few searches, I found ...
0
votes
2answers
982 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 ...
2
votes
2answers
689 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
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 ...
5
votes
4answers
12k views

Multiple Values in CAML query from Array? SharePoint 2010 using jQuery/SPServices

So if I use SPServices to GetListItems with CAMLQuery, is it possible to insert multiple values inside Value Type='Number'> here I would like to evaluate things throught a flow in my page, add to an ...
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
1answer
24 views

SharePoint - Change List View Threshold Dynamically CodeBehind

My current SP List View exceeds the threshold limit set in SP Central Admin: Changing the limit from SPCA is not an option for me as it impacts the performance of other sites. Question: How can I ...
0
votes
1answer
34 views

Please tell, can we filter data on SharePoint Hyperlink Description but not URL using sharepoint query [closed]

Please tell is there any way or workaround we can filter on hyperlink "Description" using sharepoint query. I know we can filter listview rendering using JSlink and hide rows but problem is when user ...
0
votes
1answer
26 views

Content Search Webpart missing “new” Items from List Query

I've created a Content Search WebPart on my SharePoint 2016 site page, and it's missing items from the list which have the "new" tag on them, meaning they were newly created. The following is what my ...
0
votes
0answers
19 views

Refinement filter in SP-online search query

I have a string attribute WorkPhone in SP user profiles which has format like this: "+123 45-633-2153" I made a query which search by phone extension (user inputs last 4 digits and it returns user ...
4
votes
1answer
1k views

Dynamic Content Editor Text File

I would like to have the text file associated with my content editor change based upon the query string. ?division=Name Content Editor link: /site assets/[QueryStringResult].txt
1
vote
1answer
24 views

Why is Last Modified and Modified having different data?

I am trying to retrieve data using the JSOM model, and trying to figure out the last modified date of a SharePoint List Item, Its really strange when I am trying to retrieve the Last Modfied Date ...
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
370 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 ...
0
votes
0answers
33 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
26 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
87 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 ...
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
62 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
16 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
23 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
43 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
42 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
368 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
172 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
29 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
26 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
153 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
240 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
87 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
320 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
145 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
126 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
887 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
1answer
61 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
1answer
18 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
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
438 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'...