Although no one seems terribly interested in this topic I have inevsted three days in trying to resolve it and thought I'd post the final findings for future reference.
Much thanks goes to the author of the PDF below which provides more detail. http://www.susanhanley.com/sitebuildercontent/sitebuilderfiles/searchsyntax.pdf Advanced Search - Property restrictions Author: OOTB metadata mappings will use default Office:4 and Mail:6 values, falling back to Created By for non-Office docs. Results can be very wacky indeed. Size: Requires a byte value with no commas or spaces. i.e. 1000000 = 1Mb Created By and Last Modified By: These searches do not work. This has been reported to Microsoft and is being investigated as a bug (as of June 1, 2007). Last Modified By can be resolved following the information below. Last Modified Date: Requires dd/mm/yy or dd/mm/yyyy (for EN_AU region settings). Only worked for me after changing the PropertyRef and PropertyDef in the XSLT for the Advanced Search web part. <PropertyDef Name="LastModifiedTime" DataType="datetime" DisplayName="Last Modified Date"/> <PropertyRef Name="LastModifiedTime" /> From: [email protected] [mailto:[email protected]] On Behalf Of Paul Noone Sent: Monday, 19 October 2009 10:40 AM To: ozMOSS Subject: RE: Advanced Search properties The answer to getting results for Last Modified By can be found in the link below. I have resolved this using the information provided. http://sharepointinsight.wordpress.com/2009/04/01/how-to-search-on-last-modified-by-field-in-sharepoint-advanced-search/ Unfortunately I'm still not able to get past the Incorrect date format error for Last Modified Date searches. I did not notice that the Name for the "Last Modified ByDate" property within the XSLT for the Advanced Search web part uses a value of Write by default. There is no managed property by this name. The Search Results web part XSLT also uses this same property for the results display and it returns values in dd/mm/yyyy. However I'm still unable to search on this property. Has anyone else got this working? Regards, Paul Online Developer, ICT CEO Sydney From: [email protected] [mailto:[email protected]] On Behalf Of Paul Noone Sent: Friday, 16 October 2009 11:30 AM To: ozMOSS Subject: Advanced Search properties Does anyone know what format is required for date and name fiels such as Last Modified Date and Last Modified By? When searching by "Created By" or "Last Modified By" we receive no results. Seems the username is not the display name. I've also tried domain\user.name and other variations with no success. Also, no matter what format I used for "Last Modified Date" I receive an error. e.g. - Incorrect date format: "2009-10-16" Do they need to be marked as indexed within the metadata mappings? Regards, Paul Online Developer, ICT CEO Sydney
_______________________________________________ ozmoss mailing list [email protected] http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
