.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Sharepoint 2010 FullTextSqlQuery query problem with where condition

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :SharePoint
 
Hello, i´m developing a webpart under Sharepoint 2010, i need to launch some different query´s to filter data but i´m having problems. First of all, i launch this query and i get all the users; SELECT PreferredName, LastName, Department, OfficeNumber, JobTitle, WorkEmail, PictureUrl FROM Scope() WHERE ("scope" = 'Personas') ORDER BY "Rank" DESC with that results i fill different dropdownlist with each of the columns, then I can filter for each column. For example: I filter by PreferredName, Lastname or WorkEmail, with this query SELECT PreferredName, LastName, Department, OfficeNumber, JobTitle, WorkEmail, PictureUrl FROM Scope() WHERE ("scope" = 'Personas') AND (("LastName" Like '%MOSS%')) ORDER BY "Rank" DESC But when i try to use the columns Department, OfficeNumber and Jobtitle every query returns 0 rows. SELECT PreferredName, LastName, Department, OfficeNumber, JobTitle, WorkEmail, PictureUrl FROM Scope() WHERE ("scope" = 'Personas') AND (("Department" Like '%Dirección%')) ORDER BY "Rank" DESC The main thing is if i get all the data i see that these columns (officeNumber, Jobtitle, Department) are not empty. Some of them have values some of them don´t. All the columns have the property "Reduce storage recquirement for text propert


View Complete Post


More Related Resource Links

Content Query Web Part missing in SharePoint 2010

  
If you don't see content query web part listed in the web parts list, this is because you have not enabled "Search Server Web Parts" feature in site collection features. Enable this feature and content query web part will show in the list of web parts.

Sharepoint 2010 List Added Event Problem

  
Hi All, I have created List Added Event Handler. In that Event I want to Add Custom Field in List as List is created. I get an Error "The Specified Program Requires    a newer version of windows" Is there ant solution for it. I have tried it also creating new instances of spweb and spsite rather than getting it from "Properties" Thanks Saumil Thakkar

problem rename sharepoint 2010 search service application admin database

  
Hi all, i have a problem that hopefully someone has an answer to.  i am not too familiar with sharepoint so please excuse my ignorance. we have sharepoint 2010 on a windows 2008r2 server.  everything seems to work fine.  but as you know, the default database names are horrendous.  i have managed to rename all of them, except for the "search service application" admin database. the default is: Search_Service_Application_DB_<guid> the other 2 databases (crawl and property) were renamed without a problem. we are following the article from technet on how to rename the search service admin db (http://technet.microsoft.com/en-nz/library/ff851878%28en-us%29.aspx).  it says to enter the following command: $searchapp | Set-SPEnterpriseSearchServiceApplication -DatabaseName "new database name" -DatabaseServer "dbserver" however, i get an error about identity being null.  no big deal, i add the -Identity switch and the name of my search service application.  but the real problem comes the error it throws:   Set-SPEnterpriseSearchServiceApplication : The requested database move was aborted as the associated search application is not paused. At line:1 char:54 + $searchapp | Set-SPEnterpriseSearchServiceApplication <<<<  -Identity "Search Service Application" -DatabaseName "ShareP

Problem with Retrieving data from lookup column using SharePoint 2010 Linq Concept

  
Hi I am working with sharepoint linq concept. When I am giving a query with lookup column It's working fine.  But when i am trying to retrieve the data from a look up column to spgridview. I was unable to get the output. Here is the above code which i have worked.   string strTitle = string.Empty; string strStatus=string.Empty; var context = new LinqSampleDataContext(SPContext.Current.Web.Url); EntityList<SharePoint2010ConceptsItem> Concept = context.GetList<SharePoint2010ConceptsItem>("SharePoint 2010 Concepts"); var query = from cs in Concept where cs.Status.Title.ToString()!="Completed" select new { cs.Title, cs.Id, //cs.Status }; sgvConcepts.DataSource =query; sgvConcepts.DataBind();   Any help me plz how to retrieve the data from a lockup column.bvnprasad

Problem With SharePoint Designer 2010 and the Search.asmx Web Service

  
I've created a web service datasource on a 2010 site using SharePoint Designer. When I try to make use of the datasource on a page I get the "The server returned a non-specific error when trying to get data from the data source..." message. The datasource connects to _vti_bin/search.asmx. I am using the QueryServiceSoap port and operation QueryX. I've tried various queryXml strings, including site & people searches using both SQL and keyword syntax. eg <?xml version="1.0" encoding="utf-8" ?><QueryPacket xmlns="urn:Microsoft.Search.Query" Revision="1000"><Query domain="QDomain"> <SupportedFormats><Format>urn:Microsoft.Search.Response.Document.Document</Format></SupportedFormats> <Context>   <QueryText language="en-US" type="MSSQLFT"><![CDATA[ SELECT Size, Rank, Path, Title, Description, Write, Filename, Description, Author FROM scope() WHERE CONTAINS ('"Lorum"') AND  ( ("SCOPE" = 'All Sites') )   ORDER BY "Rank" DESC ]]></QueryText> </Context> <Range><StartAt>1</StartAt><Count>20</Count></Range> <EnableStemming>false</EnableStemming> <TrimDuplicates>true</TrimDuplicates> <IgnoreAllNoiseQuery>true&l

Problem Saving Files to A Sharepoint 2010 Site from Office 2010: Saves locally by default rather tha

  
Hi we are starting to use sharepoint 2010 / word 2010 and have found an interesting bug/problem. Sometimes when a user tries to save a file (by clicking on the save button in the quick access toolbar for word 2010) the save dialog comes up with the users local "Documents" folder as the path (not the correct sharepoint path where the document should be saved).  (I should say that we are creating the file from sharepoint by using a toolbar on the document library, with the new button)  We are using a content type and a template attached to the document library when we create the file.  This is really annoying because the user might not notice that the document is saving locally and not to sharepoint.  I have found a strange workaround which involves clicking the [File] tab on the ribbon in word 2010, then clicking "Save and Send" and then clicking the save button again.  At this point word 2010 seems to "remember" that it is trying to save document to sharepoint and shows the sharepoint document library. This is a real nuisance which could lead to documents being lost/misfiled if people don't realize that this is happening.  Can anyone help me? Thanks Kevin krd

query w.r.t to SharePoint 2010 Performance Planning & Extranet Topology

  
  1.      Which extranet topology to go with in case of exposing Intranet to Remote Employees / Partners ?   My understanding:   There are 3 extranet topologies : Edge Firewall , Back to Back , Split back to back   If Scenario is : a)      Only Employees needs to access Intranet from Home ,we can go for Edge Firewall b)      If partners & Employees , both needs to access Intranet ( it will have some partner sites ) , then we can go for Back to Back OR Split back to back .   Questions: ·         Is Understanding correct ? ·         Is there any factor which can help in making a decision between Back to Back Or Split back to back ?   2.      As part of sizing , I read that we should capture following information -          What should be maximum acceptable CPU utilization in production servers ? ( Example : 70%) -          What will be the concurrent number of users accessing portal during peak hour of a day ? ( Example 1000 users from total of 18000 users ) -          How many request per second are done to portal

FullTextSqlQuery unexpected result ( Sharepoint 2010 Foundation )

  
Hello All,I am trying write webpart related with search functionality in sharepoint and FullTextSqlQuery returns unexprected result. I couldn't understand why. In following code I am expecting results for default sharepoint ( sharepoint:80 ) website but it returns cental administration site search results.DataTable resultDataTable = new DataTable();FullTextSqlQuery FTQ = new FullTextSqlQuery(SPContext.Current.Site);FTQ.ResultTypes = ResultType.RelevantResults;FTQ.QueryText = "SELECT FileExtension, ContentClass, IsDocument, rank, title, path, author from scope() ";     ResultTableCollection resultTableCollection = FTQ.Execute();ResultTable resultTable = resultTableCollection[ResultType.RelevantResults];resultDataTable.Load(resultTable);In resultDataTable (path column) all rows related with Centeral Administration site. So, do you have any idea why?PS: I have tried following way to make sure it is runing on default web site;insted of "new FullTextSqlQuery(SPContext.Current.Site);", I put "new FullTextSqlQuery(new SPSite(http://sharepoint:80));" but result is same.  

Query server not responding in SharePoint 2010

  

When I try to search anything in SharePoint 2010 site its showing

Internal Server Exception.

So when i looked into the Central administraion page ->Manage Service Applications->Shares Services-Search Service:Search Administraion it is showing "Query server not responding (4eb29e88-2523-4f3a-9a7b-4a96d33e570e-query-0)"

Anyone please help me to solve the search error

 


Setting SharePoint 2010 Form Fields Using Query String Variables

  

Hi All,

I have a requirement to populate sharepoint form field value with query string while uploading document to document library.

While uploading the document to document library, I want to populate claim number available from query string in a pop up page i.e in my case EditForm.aspx, Located at http://servername:port/sitename/documentlibraryname/forms/EditForm.aspx.

Additional Information:

  • Created document library and added custom columns like claim number etc..
  • Created a view to filter uploaded documents as per claim number.

Server Details:

  • Windows Server 2008 R2
  • SharePoint 2010
  • SQL Server 2008 R2

I have written javascript for the same, but not sure where exactly to add the code in EditForm.aspx page.

Any help on this would be greatly appreciated.

Thanking you in advacne.

Regards

Seva


InfoPath 2010, People Picker Control - problem with sharepoint group targeting

  

Hello!

I have developed InfoPath 2010 web form with People Picker Control. I want to set sharepoint group which would be used in People Picker Control to search people. Ok, I set sharpoint site url and aftet that - select sharepoint group 'Test InfoPath group' I need. Everything works fine - I can select only people inside sharepoint group 'Test InfoPath group'.

Now I deploy my solutions (wsp package) on different site collection and sharepoint server installations. In this case People Picker Control can't find right sharepoint group 'Test InfoPath group'. Sometimes People Picker Control select another group, not that I have select in InfoPath Designer and sometimes People Picker Control select all users.

What's wrong with it and can I configure People Picker Control to select sharepoint group?


Problem with Sharepoint 2010 - Claims Auth - Windows Auth and FBA. consistent redirects back to "cho

  

We have sharepoint 2010 foundation site that we can successfully login with via IE, Firefox, Chrome both on the domain and externally with Claims Authentication with only Windows Auth type selected (NTLM).

Once we add FBA and use the default signin page, we can still login (we select Windows Auth from the dropdown) BUT it only works on the domain. When we try to access externally, the only browser that works is FireFox. Both Chrome and IE just constantly redirect back to the Choose Authentication dropdown screen.

We have tried for the last 2 days to sort this out. Has anyone else experience this? It looks like the default sign in page somehow doesn't set the cookie for IE and Chrome and just bounces us back to the sign in page...

Thanks for any info...

To clarify, we are not even using the FBA yet. We are trying to login only with the windows auth and domain accounts...


InfoPath 2010, People Picker Control - problem with sharepoint group targeting

  

Hello!

I have developed InfoPath 2010 web form with People Picker Control. I want to set sharepoint group which would be used in People Picker Control to search people. Ok, I set sharpoint site url and aftet that - select sharepoint group 'Test InfoPath group' I need. Everything works fine - I can select only people inside sharepoint group 'Test InfoPath group'.

Now I deploy my solutions (wsp package) on different site collection and sharepoint server installations. In this case People Picker Control can't find right sharepoint group 'Test InfoPath group'. Sometimes People Picker Control select another group, not that I have select in InfoPath Designer and sometimes People Picker Control select all users.

What's wrong with it and can I configure People Picker Control to select sharepoint group?


AAM Problem with SSRS 2008 R2 and Sharepoint 2010

  

I have a single server farm with Sharepoint 2010 and SQL 2008 R2 installed. I have an extranet zone configured - and this is working fine from the internet via a Forefront TMG box.  All features in the farm, including Performance Point pieces (reports/dashboards etc) are working fine via the extranet zone except for Reporting Services reports (these are working fine in the internal/default zone).  I can see the report library, and the individual report items via the extranet, but when I try to view a report, I get this:

" The Web application at https://extranet.company.asia/client/Report Library/Spend by Media Owner.rdl could not be found. Verify that you have typed the URL correctly. If the URL should be serving existing content, the system administrator may need to add a new request URL mapping to the intended application."

My understanding is that multiple zones are now supported in Sharepoint 2010/SSRS 2008 integrations, and that AAM should propagate automatically (?).  Can anyone assist in helping me understand where to look next?


many thanks,

Steve.


Problem with Enable SharePoint 2010 Taxonomy

  
Run from PowerShell: “Enable-SPFeature -Identity 73EF14B1-13A9-416b-A9B5-ECECA2B0604C -Url <http://centaurus>"
It runs fine ... but when I go to the site http://centaurus ... on the list, adding the new field of metadata managed still gives me the same error: not activated the feature taxonomy (ID feature "73EF14B1-13A9-416b-A9B5-ECECA2B0604C").

Problem with content DB planning SharePoint 2010

  

Hi Guys

I need to find out what to do regarding planning out content databases. The problem is that I need to design a solution where I would have two different types of content. I want to keep the site collections as simple as possible so I want to use a records centre with two document libraries for each content type.

Now the problem I have is that there is going to be about 8 Site Collections each with up to 8 terrabytes of content I need to store.

This will obviously affect performance. What can I look at here?

Juran


Problem when creating a Record Center in SharePoint 2010

  

Hi Guys

I have a problem when creating a Record Center in SharePoint 2010 on a publishing Portal. The Record center creates succesfully, but when I try to upload a record sharepoint says that the list does not exist, also when I try to go into the site settings of the record center I get the same issue. When trying to specify the libraries in the record centre management page....same thing! What could this be? 


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend