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

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Adv Search not returning calcuated field

Posted By:      Posted Date: September 02, 2010    Points: 0   Category :SharePoint
I have a custom column associated with one of my content types, which I've set up as a Managed Property under Central Administration, and added to the Properties filter on my Adv Search page.  When I select this property in Adv Search, and specify a value that I now exists (on several documents), I get no results.  Non-calculated custom properties that I've set up work fine. Any ideas if there is some special config/requirement for search to return results based on caclulated column values? I set this up as follows: 1. Created the custom column on the content type 2. Created a managed property that maps to the crawled column "ows_MyCalculatedField" (in the mapped properties page this column showed up under Crawled Properties) 3. I reset the index and then ran a full crawl 4. I updated the Adv Search screen web part and added the column to the web part XML that defines what properties appear in the Properties picker list (the property shows up fine and I can select it and run a search) However, when i run the search for any value in the field, I get no results.  And I know there are documents that have the values I entered. Thanks

View Complete Post

More Related Resource Links

Search query returning 0 results

I'm using a query which returns 0 results but was working some weeks ago.  I checked the code and nothing has changed since then.  I created a Search Center Site on another port and using the same terms I get many results there.  I checked my scopes and they are all right. Nothing changed there either. Could someone help me figure out what may be the problem in my query.  Or maybe it's my Scopes/Content Sources configuration. SELECT URL, FileName, Title, Description, Rank, Size, HitHighlightedSummary, Path FROM SCOPE() WHERE freetext(defaultproperties, ' +légumes')  AND ( "scope" = 'Scope - My Portal - All Site - fr'  )    ORDER BY Rank DESCDaniel Siconnelli There is neither good nor evil... only mogwais and gremlins

SharePoint Server 2010 Search - not returning results but crawling without errors

I have created a Search Service Application on a SharePoint Server 2010 (RTM) Farm and used the default Content Source. I started a Full Crawl and it suceeded with no errors etc. I ran it a few times and no issues. But if I go to the Intranet Portal Web Appliaction and do a search for a document that would have been crawled it does not show up in search results...nothing does. I am not getting any errors in Event Log or ULS Logs relevant to Search. How can I troubleshoot this problem further?SharePoint Solution Architect, Perth Australia - Microsoft Virtual Technology Specialist - MCTS WSS Dev, WSS Adm, MOSS Dev, MOSS Adm - http://wss.made4the.net/ - Founder of http://www.sharepointdevwiki.com/

Search field question

hi guysin my database i have one table that has basic patient information (id,name,dob etc, visit date etc)i would like for the user to be able to search for a patient based on his unique personal id number and return the fields i specify (name,lastname) in the gridview. my problem in that one patient may have multiple visit dates. i would like the gridview to return the following as an exampleName     Lastname   Visit dateJoe         Johnson      10/05/10Joe         Johnson      13/08/10joe         Johnson       20/09/10from that the user will be able to click on the visit date that he wants to see the details aboutmy problem in that since the user ID is a unique field in my table i dont know how to create multiple visit dates. i think i should put the visit date in a different table and create a relationship but then i dont know how to present details from 2 tables in one gridviewthank you

Multible search criteria with empty field option

I have a gridview with two textboxes (first name & last name) and a linkbutton to search results inside the gridview.I have made select parameters as well and the search works if i write in both textboxes. However, if I leave one textbox blank, i don't get any results.------------------------------First Name: <asp:TextBox ID="txtSearch_FName" Width="100px" runat="server"></asp:TextBox>&nbsp;&nbsp;&nbsp;Last Name: <asp:TextBox ID="txtSearch_LName" Width="100px" runat="server"></asp:TextBox> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<asp:LinkButton ID="LinkButton1" Text="Find" runat="server" OnClientClick="return check();" /><asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="ID" DataSourceID="Searching" CellPadding="4" PageSize="15" GridLines="Vertical" onrowcreated="GridView1_RowCreated" Width="100%"><PagerSettings Mode="NumericFirstLast" /><HeaderStyle BackColor="#666666" /><AlternatingRowStyle BackColor="#f4f4f4" /><FooterStyle BackColor="#666666" />  &

How can I get search to work for a Custom Document Library with a few third-party field types?

Hi, Using WSS 3.0 with SQL Server 2008 for Workgroups I have created a Custom Document Library (2,462 files - copied from folder into Explorer view and then renamed using Batch Update in web services i.e. "BaseName" field) - basically it uses three fields that are of "Filtered Lookup" (a field type from a third party). The document library is included in the search (i.e. Advanced Settings), but it displays none of the files - bascially not included in search at all with all testing I have done. I created a new Document Library called "Test" and uploaded a document and it is included in the search. Is there any way I can debug this. Is there a log file? Is there something in the Search Database that might help? Your help would be really appreciated as this is my last issue - and its soooo important to the deliverable. Thanks. John.

Why is GetListItems returning rubbish as field names?

Always wondered, why? I need to write a complex SSIS package that will copy all of the sharepoint lists into sql database (because M$ were too stupid to let users do rich reporting on the sharepoint server, you have to dupe the lists into another database to do reports on them) Problem is, if i query for list, i get something like this: <Field Type="User" DisplayName="??? ??????????" List="UserInfo" Required="FALSE" ShowField="ImnName" UserSelectionMode="PeopleOnly" UserSelectionScope="0" Group="??????????м?? ???????" ID="{888f100e-1488-4662-af86-413a05dc3506}" SourceID="{bfad9184-4660-4714-a773-b2803c9941f3}" StaticName="???_x0020_??????????" Name="_x0424__x0418__x041e__x0020__x04" Hidden="FALSE" Customization="" ReadOnly="FALSE" PITarget="" PrimaryPITarget="" PIAttribute="" PrimaryPIAttribute="" Aggregation="" Node="" ColName="int1" RowOrdinal="0" /> <Field Type="DateTime" DisplayName="?????? ?" Required="TRUE" Format="DateOnly" Group="??????????м?? ???????" ID="{635dd517-ab59-4cd3-91eb-54a1f679a07b}" SourceID="{bfad9184-4660-4714-a773-b2803c9941f3}" StaticN

MOSS Search Not Returning Results from A List

Hello All,   Problem: The MOSS Search is not returning results from a subsite (and list within it). It however returns results for most of the other sites in the web application. Environment: 2 Application Servers. One of these is the index and query server. The same server is also the search server for the content databases. 5 web front end servers. Other Notes: The MOSS installation has several web applications. We however have one site within it that is not returning the required results. The results that we are looking for are located in a particular list. When one searches against the items in the list, some appear and others do not. We also get results from RSS feeds that track changes to the list in the last week. Also, some of the results returned are links to the new item in the list (that is, when you click on new to create a new item). There are no search errors in the application log. The web application was recently upgraded from WSS 3.0 on a single server to MOSS 2007 in a server farm. There are no sql index errors. The WSS Search and Office Search Services are working and have been restarted. The credentials have also been re-entered. We get less than 20 errors in the crawl logs (out of close to 800k docs). I have checked the rights for the default content access account, and it has dbo rights to the content db and search db. It also has read (and now admin

search field

hi, I want to have a search field in mvc2 asp.net that with click on search button redirects to page with address: "xyz/search/?name=&amp; FolderNum="  But get this error: A potentially dangerous Request.Path value was detected from the client (?).

Why is SharePoint people search returning the same results as all sites search?


I've been having issues with the people search in that it doesn't return any results and the scope is 0.

I deleted the scope and recreated it adding the rule contentclass = urn:content-class:SPSPeople with behaviour : require but now when i search for people it seems to search everything not just people profiles. Please can someone tell me what I have done wrong when I recreated the scope? The scope still cant crawl the profiles but I'd like to at least get back to where i was before!!


QueryExtender Control - Variable field name to search against


FrownI have been alerted to the Query Extender control through previous posts, but I am still seeking the final part of my desired solution.

NB the following is written in conceptual English (programming specification) format, rather than actual asp code.

While I fully understand that I can use the QueryExtender control to pass a parameter from one web page to another, I do not see, and maybe this is not even possible, how I can pass a parameter of which field I want to select on.

Ideally I would like to be able to implement a query which is

SELECT tiles where 'Passed Variable Name' contains 'Passed Test Value'

such as would then generate, for example -

SELECT titles where 'Series Available' contains 'A'


SELECT titles where 'Authors' contains 'Wyndham'

but I just can't work out how I can implement the varying search field.

Is what I am seeking for possible? OR

Am I going to be forced to implement an approach such as the following?

SELECT Calling Web Page

CASE "Series" 

SELECT titles where 'Series Available' contains 'passed variable'

CASE "Authors"

Advanced Search in date field in sharepoint 2010



I have a question about advanced search that field a Date,

When searching the date field the sharepoint can not find any document and writes:

"No results found appropriate."

When going to standart search the sharepoint find documents also in date search .

in central administration in metadata properties- the  Data of the field is set.

What could be the problem?

How is the HitHighlightedSummary field derived in the search results?


Can anybody tell me exactly how this field is derived in the search results?

I have a custom list with various fields. One field is an HTML field which typically contains a large amount of HTML content. This field has been mapped to a managed property and the list is being cawled.

When a search is executed with a keyword, sometimes the HitHighlightedSummary returned from search contains the keyword and sometimes it does not. The only thing that appears to be different between the list items is the position of the keyword within the HTML content. The keyword appears early in the content for the list items that return the keyword in the HitHighlightedSummary but it appears well down in the content when it is not included in the HitHighlightedSummary. When the keyword is not included, HitHighlightedSummary seems to contain a combination of data from a number of fields.

Is it possible that HitHighlightedSummary only considers the first N characters/bytes of fields?


Report Builder returning #Error value in empty fields and working with Date field


Hey guys,

I am trying to build a report using the date field from CRM and only wanting to return the date I am using this expression "=Fields!new_date.Value.ToShortDateString()" but when there is an empty fiel I get #Error. How do I solve this?

Also is there anyway to return the date field with the actual month showing instead of the numerical value? i.e. instead of 1/31/2010 Have it show January 31, 2010 (Doesn't have to be exactly in that format, but want the name value for the month.)

SPQuery returning error "One or more field types are not installed properly. Go to the list settings



SPQuery is not working properly, its throwing following exception.

"One or more field types are not installed properly. Go to the list settings page to delete these fields."

Please check the code snippet below:

SPSite spsite = new SPSite("siteurl");

SPWeb site = spsite.OpenWeb();

SPList list = site.Lists["listname"];

SPQuery query = new SPQuery();

query.Query = "<Where><Eq><FieldRef Name='ServiceLevel'/><Value Type='String'>345</Value></Eq></Where>";

SPListItemCollection items = list.GetItems(query);

Small Search Box Returning No Results




The small search box on the top page of the site returns no results, but when I do the same query in a search page, I get the expected number of results (more than zero).  I've poked around in the search settings on Central Administration, but I can't seem to find anything.  Has anyone run in to anything like this before?  Thanks!


Search does not returning list item


My Scenario is,

I have one document library and that library has multiple documents. I have two user groups like general and contributor group.  Some of the documents does not have permission to general user groups. So when general group users try to search that particular document then the documents are not listing out in search results. But search results return the documents when the user who has permission for the library.

I need to list out all the documents in search result irrespective of the permission but i need to restrict the document at that time of opening the document from the search result. Can we achieve this functionality through  OOTB or custom code ? Can anyone please show some light on this issue.

Thanks in advance.


Thanks, Mubarag Ali

SharePoint Search Not Returning Results

My SharePoint search is not returning results for anything but people. I'm not seeing any errors in the ULS log and my index contains rough 27,000 documents. What could be the problem? Where can I look for details that could shed some light on why there are no results being returned?
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