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

learn more… | top users | synonyms

0
votes
2answers
49 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
265 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
736 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
60 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
218 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
1answer
814 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
60 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
204 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
156 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
1k 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
400 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
125 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
132 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
4k 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 ...
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
87 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
2answers
198 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 ...
0
votes
1answer
64 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 ...
2
votes
1answer
144 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
4
votes
1answer
642 views

Error using javascript to retrieve a SharePoint list's items

I am trying to use this method to query items of a column of a list in my SP site via javascript (the reason I am doing this is to display that info on the page by modifying the html tags in the DOM), ...
1
vote
1answer
281 views

Filter query by site property

I have set a crawled property at the site level using $site.IndexPropertyKey.Add() and $site.Properties.Add() I set the value of that property to "somevalue" I full crawled. I mapped it to a managed ...
0
votes
1answer
112 views

How to write queryXml to search out “88X211.doc” using keyword “211”?

I try to use following codes, but it does not work. Results is Status=ERROR_NO_RESULTS_FOUND Total count =null. If I use "88x211", I can get the right result. How to write queryXml to search out ...
5
votes
2answers
4k views

Get all Files from sub folder of a certain content type

my problem is I have a document library with sub folders. Also the document library got more than one content type. Is there a way to create a CAML or LINQ query to get all files of a certain content ...
0
votes
2answers
92 views

Sorting out lookup values while getting them

I have two lists, List A [Document Number, Name, Title,...] (document library) List B [Information Number, Name, Title, Document Number] (simple list) Now List B is getting all documents from List ...
0
votes
1answer
311 views

Grabbing a filter value via CEWP code behind

I have employed a Query String Filter to parse a value and send it to a chart web part. now I would like to use this value in a CEWP to provide an explaination/clarification for the chart, but the ...
1
vote
1answer
2k views

How to use Content Query by query string parameters

I need my Content Query Web Part to show some content which depends on a Value of a property. Now I had no problem doing it "statically", putting in the properties the filter like: Column is equal to ...
0
votes
1answer
46 views

How to make faster readable elements from the list?

I have an ASP Calendar, which shows elements from the list. If I try to bind the elements to the list, there are a lot of elements for example 35 429 elements. It takes up to 4 minutes to load this ...
1
vote
0answers
52 views

What CMIS services are required if Fast Search is used to query an external CMIS repository

For a repository to be CMIS compliant, it must implement a number of services. Query services are not mandatory. I want to incorporate a CMIS repository in SharePoint 2010 as an External Content Type. ...
4
votes
4answers
4k 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
200 views

“Find Similar results” Fast search for sharepoint 2010

I trying to implement "find similar results" in fast search for sharepoint 2010. Im using the docvector manage property and similarTo property(KeywordQuery property) for this. I hv to pass the ...
0
votes
1answer
473 views

AllItems View of Query String: can I group using value in query string?

Can I somehow how a query string to show a group of documents within a given library. Not one single item, but the AllItems like view. So within the library I have a grouping type of id value in a ...
2
votes
1answer
734 views

Send current user's parameter to External Content Type

Is it possible to send the current user's username as a parameter for my External Content Type query? I am on SharePoint 2010 Standard.
0
votes
1answer
215 views

Query by user field returns wrong number of items

I'm trying to query a list in an eventreceiver through properties.List.GetItems (in the itemadding event). The field I'm filtering on is a 'Person or Group' field. But the query always returns all ...
1
vote
1answer
826 views

How do I convert CAML to use in the CQWP?

I have the following CAML query which returns checked out files. <Query><Where><Eq><FieldRef Name="CheckoutUser" /><Value ...
0
votes
2answers
544 views

DVWP CrossList Paging Does Not Work

I've build a Data View Web Part with SharePoint Designer 2010, using SPDataSource and DataSourceMode="CrossList". The DVWP works great, but when I add paging, it adds the paging placeholder and the ...
1
vote
1answer
268 views

Get all webs with certain property value

If I have a certain number of webs within my site collection, and those web have set some property, eg. web.Properties["foo"] = "bar". I'd like to get list of all the webs which have property foo set ...
0
votes
3answers
1k views

how to check CamlQuery results

.I am running below query against a sharepoint list. How to check the results of below Camlquery? cPop is set with value 'AboutUs'. Result is always zero records although list has valid matching ...
1
vote
3answers
3k views

Page a list via A-Z

So I am trying to create an a to z directory from a list of items which should be an easy task and it is really, however, I am trying to find the most efficient way of doing it. So I was thinking use ...
0
votes
1answer
320 views

PublishingStartDate empty even though the page is published

I've been through the typical publish/approve process and have, seemingly, successfully published a page (I've checked it's approval status in the manage content and structure section of the site ...
2
votes
2answers
68 views

Where can I find a list of fields that can be retrieved when running a sharepoint query?

An SPSiteDataQuery. So far I have: ... query.ViewFields = @"<FieldRef Name=""Title"" /><FieldRef Name=""Author"" />"; ... I just happened to get these two FieldRef's right (purely ...
0
votes
0answers
92 views

Content Query migration

I'm doing a migration from 2007 to 2010 and one of the issues I've run up against is the Content Query Web part seems to come pre populated in my 07 install, and this behaviour overwrites my nice ...
3
votes
1answer
7k views

Querying a simple list with a 'User' column, using CAML

I'm having some trouble getting a CAML Query working against a very simple list. My custom list has the fields: Person : User Date : Date Amount : Lookup My query looks like this: <Query> ...
1
vote
2answers
678 views

Selecting single user from User Information List

I've got a problem with not being able to select a single list item from the User Information List, I have used U2U CAMLbuilder to build a query that extracts an entry with the ID = 1 When run in the ...
1
vote
2answers
111 views

Search Service Property Returns Nothing

I'm using the SharePoint query web service to search and return results. Everything is working great and I'm able to get back plenty of properties from the search. Some of the properties include ...
11
votes
6answers
18k views

How to query Sharepoint 2010 lists with sql?

I think it has to be a common task. We have some applications on sharepoint and we need to prepare reports with data from these applications. It would be great if we could use Reporting Services. We ...
3
votes
2answers
187 views

View SQL Queries/times for page request

SharePoint 2010 has the fancy new developer dashboard where you can view the SQL queries made and how long they took to determine bottlenecks etc. I am not a SQL Sysadmin so I cannot use SQL profiler ...
4
votes
3answers
2k views

How to get visible SPField's for a specific list view

I am trying to enumerate a list based on a selected view - basically, programmatically doing what is visually shown when viewing a list. I will be using this to output a file, so I am first getting ...
5
votes
1answer
2k views

Is it possible to return only the count of the query?

Is there any way to return only the count of the rows from a Sharepoint query? I would like to get only the count of the result returned by sharepoint query.
1
vote
1answer
1k views

External List Error : The query against the database caused an error

I got an SQL Server 2008 R2 and a SharePoint Server. I have put up a BCS between the two servers. Reading data through a External List. This worked fine yesterday. But to day I got this error: The ...
0
votes
1answer
544 views

Removing duplicate results FAST Search Server for SharePoint 2010

I have a custom content type which contain duplicate values. I try to remove duplicate results from Query Web service returns. For specify duplicate data, I created "groupid" managed property which ...