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

learn more… | top users | synonyms

0
votes
1answer
25 views

Retrieve list item information using path

Using: SharePoint 2010, JavaScript, jQuery 1.10.2, SPServices In SharePoint 2010 I have a custom (JavaScript-based) page where users may type in text and link to items in SharePoint lists. A recent ...
0
votes
1answer
37 views

List.GetItems is running slow for certain sites

I'm running a pretty simple query to get back items using List.GetItems and it seems to be performing horribly on some of my sites (differing site collections). The lists being queried are essentially ...
0
votes
1answer
20 views

Query Rules in SharePoint 2013 (regex)

I have a pretty simple requirement to have a best bet (query rule) come up in a SharePoint 2013 search. If the phrase "BQS" is included in the search query, I want to display a recommended link. To ...
1
vote
2answers
32 views

Your query is malformed with a date in where clause

I'm trying to query SharePoint using jQuery and SPServices. When I run the code below, I get the error Your query is malformed. Please rephrase your query. var searchq = ...
1
vote
1answer
38 views

Caml query after modified choices

I have a column with an internal name of: PublicY with 2 choices: Yes/No, the query works but if I change the choice name to Ja/Nej the code will not query the results, why? I have tried to change the ...
2
votes
2answers
46 views

Querying against a note field with the REST API 2013

I'm getting the error The field 'OtherInfo' of type 'Note' cannot be used in the query filter expression whenever I run a query like this: ...
2
votes
0answers
128 views

XsltListViewWebPart Custom Filtering on Query String with paging

We are working on a solution to use custom query and paging inside a XsltListViewWebPart. This work,s but the paging does not work: var doc = new XmlDocument(); ...
1
vote
2answers
66 views

How can I get the correct SPFieldUserValue to use SPSiteDataQuery to aggregate tasks for a certain user?

I'm trying to gather all the tasks of a certain content type for a certain user. To accomplish this I'm using a SPSiteDataQuery which looks like this: string where = String.Format(@"<Where> ...
1
vote
0answers
18 views

MySites URL - use another query paramater other than accountname? GUID? | SP 2013

Is it possible to use a different query parameter other than accountname for Mysites? For example, can we use the GUID to link a person to the person.aspx page? The problem is that because the ...
1
vote
2answers
64 views

Query External Data using BCS

I'm using SharePoint 2013 and I'm developing a webpart that has to query an external data and show the results. I cannot create external list due to the fact that my external table has more than ...
1
vote
0answers
31 views

sorting with querymanager

i see a function orderBy but i don't understand how it works and if it's the correct solution. i'd like know the way to sort the results from querymanager or maybe do this in kql? and then are there ...
2
votes
1answer
65 views

KQL for date range

I've a managed property datetime and i try to use a search for having the result in range. The issue is that i don't know how to format the date myManageProperty=01/02/2014..17/02/2014 but i don't ...
1
vote
2answers
112 views

Why does SPList.GetItems(string fields[]) return more fields than specified?

I'm using SPList.GetItems(string fields[]) to obtain only specific item fields from a document library: SPListItemCollection items = list.GetItems("UniqueId", "Name"); However, iterating the items ...
0
votes
1answer
36 views

FAST Query Language Syntax

I'm running nested Fast Query on SP 2010. Is this syntax correct? OR ( string("London", mode="phrase") , string("ullamcorper et blandit", mode="phrase") , AND (string("publish", mode="phrase"), ...
0
votes
1answer
32 views

LINQ in SharePoint to order listitems

I have tried the following in CAML but it does not seem to be returning them sorted SPQuery query = new SPQuery(); query.Query = "<Query><OrderBy><FieldRef Name='Sequence ...
1
vote
0answers
62 views

Sharepoint 2013 Search File Share result source exclusion

I'm using the query builder to try and get the results excluded containing the string "archive" The content source is a file share, not a web page. This is one of the hundred query transform ...
0
votes
0answers
23 views

Query all items which belong to same model based on article number

I want to create a query which retrieves all items which belong to same model, based on their article number. Every item have an article number which can be something like I-12V2 which is standard ...
1
vote
2answers
41 views

Get all values of a specific column of a specific content type

I have a custom content type. In this content type, I have a text column (Mycolumn). In a site collection, I have several instances of list bound to this content type. Is there a way to retrieve all ...
2
votes
1answer
49 views

creating CAML queries in a 32 bit environment?

I'm currently developing with SharePoint on my 32 bit computer. While I'm able to make simple changes with designer on my PC I'm aware that using visual studio to make changes (CAML queries) without ...
4
votes
1answer
300 views

Errors executing bulk query when updating a Sharepoint Linked List from Access

I have a Sharepoint list that is a Linked List with MS Access (2010). It has just under 5,000 items (4,864), thus meaning it avoids the reduction in functionality lists of greater than 5,000 items ...
0
votes
0answers
20 views

different query for same view showing on different page as list view web part

If you have three pages and want to add Documents library as list view web part to these three pages with different query (Programmatically), Do you need to create three different views for Documents ...
2
votes
1answer
68 views

QueryManager to find all documents modifed by current user

I'm creating a webpart which derives from Microsoft.Office.Server.Search.WebControls.CoreResultsWebPart and the purpose of this webpart is to find all documents modified by current user. I've figured ...
1
vote
0answers
26 views

DataView Webpart Folders

Is there a way to pass the root folder parameter to a page that the DataView webpart consumes? If I have a page, test.aspx with a DVWP on it, it will show all my documents and folders in a list. If I ...
0
votes
1answer
31 views

Call WCF from CoreResults Webpart

I am looking to call a WCF service from CoreResults WebPart before the actual Query occurs We plan on supplementing the Query with information retrieved from the WCF service Is this possible ...
0
votes
1answer
22 views

Best Bets Missing When Query Contains Multiple Keywords

Let's say I have a Keyword "Hello", and a Best Bet associated to it called "Hello There". Let's say I have another Keyword "Goodbye", and a Best Bet associated to it called "Goodbye Son". If I ...
1
vote
2answers
86 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
109 views

Switching Search Results Sort Order if Keyword Term Exists

We have a Course Listing based on results surfaced by a Search Results Web Part that is configured to use a specific Results Source. The web part serves a dual purpose in that by default it should ...
1
vote
1answer
248 views

Choice field not allowing save on choice field value changes

I have a SharePoint 2010 List with a simple Choice column called "RequestType" with values like New Hire, Job Change, Equipment Request, etc. I can add the new records and select any option, but ...
0
votes
0answers
29 views

SharePoint 2010 and InfoPath 2010 Query Tool

I'm attempting to build a tool that will utilize InfoPath 2010 to query a SharePoint 2010 List. The data is a State Information tool. The information per state is different per site (2 sites with an ...
0
votes
2answers
41 views

Get all “new” documents from library with query

Is it possible to get all documents that are marked as "new" in sharepoint 2010? How can this be done? I already have a query where I get all latest documents, but I need to find out what ViewFields I ...
2
votes
0answers
216 views

Sorting in Search.asmx querypacket

I have this querypacket to query Search.asmx service, and get back the results, stored in queryXML object, I can retrieve data successfully, but I can't figure out how to sort this data on any field I ...
1
vote
2answers
512 views

Using a Dynamic Redirect in SharePoint

Here is the situation: I have two libraries, one housing current documents, and another which serves as an archive. I have a workflow which sends the owner a link to their document. The problem is ...
1
vote
1answer
50 views

Combining 1 item from 2 SharePoint lists

I have SPList A which has the columns: Title, Description, Category. and SPList B which has the following columns: Column1, Column2, Category. I want to make one object for items with the same ...
1
vote
1answer
160 views

Compare Date to constant using ACE.OLEDB.12 in Excel VBA [closed]

After a lot of searching, trial and error, I finally managed to come up with an Excel VBA procedure that will return date from a SharePoint list. The query works fine if I do not qualify the Select ...
0
votes
0answers
21 views

How can i place the query in designer

I used this query in CEWP and worked good in new form How can i implement this in Designer. since we are moving all these to designer. Where can i place the src reference link and script <script ...
0
votes
0answers
19 views

Content Query announcement link

I have a Content Query webpart which is showing announcements from a subsite. The announcement title used to link to the announcement but it no longer does - it gives a 404 not found error. What do I ...
0
votes
1answer
510 views

Query String parameter - Multi FilterMultiValue on different columns

Is there a way to combine FilterMultiValue on different columns? ex ?FilterName=HomeCountry&FilterMultiValue=Norway;Global&FilterName=HostCountry&FilterMultiValue=US;Global I want to ...
0
votes
2answers
52 views

Accessing list from variation

I retrieve all the lists in the current web using: foreach (SPList list in SPContext.Current.Web.Lists) {} This works well. The problem is that when a user changes languages, and is routed to the ...
1
vote
1answer
176 views

Appending Google Analytics query string to outbound links in SharePoint 2010

I am looking to append Google Analytics query strings to outbound links but SharePoint 2010 strips it out when you save the page. Is there a way to add those or do I have to use javascript to append ...
1
vote
1answer
119 views

sharepoint 2010 - How to get document ID using spservices sql search query?

Using spservices to make search requests, I am building the query like this: var queryText; queryText = "<QueryPacket xmlns='urn:Microsoft.Search.Query' Revision='1000'>"; queryText += ...
0
votes
1answer
830 views

How can I use one list column to retrieve another column value in a different list

I have a web part that I display a data view of one list say List A (below). This list has one column as a lookup which is already another existing list say List B. Say, List A {Project Name, ID, ...
0
votes
1answer
261 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' ...
1
vote
0answers
110 views

Multiple Column Lookup field from Access to Sharepoint

I have two fields called "Tool ID" and "Tool Name" in my main "Tools" table in Access. "Tool ID" is set as the primary key, in that it gives each tool a unique autogenerated number. When I ...
0
votes
2answers
121 views

Search Core Web part with fixed query duedate

I have a search core web part and i would like to put there a fixed query, which will search all tasks whose duedate is over, i've added duedate to the columns and it works, but when i try to write ...
1
vote
2answers
3k views

query a sharepoint 2010 list from excel vba to retrieve a specific record

I have created a SharePoint 2010 list with 2 relevant columns: - Identification Key - Version Number I want to be able to query this SharePoint list from Excel VBA - passing the Identification Key to ...
0
votes
0answers
38 views

Is there a way to remove code from a sharepoint list?

Ok I have a custom built sharepoint list on a standard aspx page with no sharepoint header. With Sharepoint Designer I have set parameters on my list with several filters. On the page I have several ...
1
vote
3answers
1k 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: ...
0
votes
1answer
74 views

Shorten Search String to get around character limitations

We are trying to use the standard sharepoint search alerts and are currently being limited by some character limitations. I am wondering if there is a way to shorten our search strings... For ...
0
votes
0answers
168 views

Search Refinements and Search Core Results Query

I think this might be a bug in SP2013, but let me know your thoughts. Using SP2013 I have a search page with a refinements panel and a search results web part. At that point all works perfect. The ...
0
votes
2answers
159 views

Where to define Query Rule and when?

We can define Query rule in three places: Search Site > Site Settings > Search > Query Rules Search Site > Site Settings > Site Collection Administration > Search Query Rules Search Service ...