LOL. Is that what you've all been waiting for?! :) Well, everything is now working as best as can be expected. My only question mark is surrounding the correct mappings to add to the CreatedBy property. Some have suggested Office:4(Text) but this is also present in the Author property.
It seems not even MS have the answer to that. If anyone knows where I can find a list of all these properties and their respective values I'll gladly do some more digging. Office SDK perhaps?? From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Turner Sent: Monday, 19 October 2009 1:31 PM To: ozMOSS Subject: RE: Advanced Search properties Thanks Paul... were knew you would find the answer for all of us... :) Regards, Paul Turner Senior Solutions Specialist M: 0412 748 168 P: 08 8238 0912 F: 08 8234 5966 A: 66 Henley Beach Road, Mile End SA 5031 E: paul.tur...@dws.com.au<mailto:paul.tur...@dws.com.au> W: www.dws.com.au [cid:image001.jpg@01CA50C1.2C9D3190] ADVANCED BUSINESS SOLUTIONS LTD This email and any files transmitted with it are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient you have received this email in error and are requested to delete it immediately. Any opinion expressed in this e-mail may not necessarily be that of DWS Pty Ltd. Please consider the environment before printing this email. From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Monday, 19 October 2009 11:48 AM To: ozMOSS Subject: RE: Advanced Search properties 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: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] 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: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] 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
<<inline: image001.jpg>>
_______________________________________________ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
