[OzMOSS] Sorting in document library [SEC=UNCLASSIFIED]
Hi there Aaron I've come across a sorting issue within document libraries (and lists no doubt). I have a number of documents which begin with alpha-numeric characters A.1, A.2, A.3 etc however there is a problem when we reach A.10 because it doesn't list A.10 after A.9 (as it does in Windows Explorer) - it is listed after A.1 i.e. A.1 A.10 A.11 A.2 A.3 A.4 Any ideas of how I can get SharePoint to sort this list in the same way Windows Explorer does? Many thanks Melanie McAlister SharePoint Services Team Business Solutions IT Security The Treasury p: 02 6263 2991 f: 02 6263 3104 e: [EMAIL PROTECTED] ** Please Note: The information contained in this e-mail message and any attached files may be confidential information and may also be the subject of legal professional privilege. If you are not the intended recipient, any use, disclosure or copying of this e-mail is unauthorised. If you have received this e-mail by error please notify the sender immediately by reply e-mail and delete all copies of this transmission together with any attachments. ** --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com
RE: [OzMOSS] Sorting in document library [SEC=UNCLASSIFIED]
Return Receipt Your RE: [OzMOSS] Sorting in document library [SEC=UNCLASSIFIED] document: wasTerry Walsh/AUST/CSC received by: at:05/02/2008 01:31:24 PM ZE10 --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com
[OzMOSS] FW: FullTextSQL query help
Hi All, Can anyone offer any suggestions for Shirley? She basically wants the icons associated with the results to appear as part of the search results.. If the item is a word document, she wants a word icon to appear next to it. That kind of thing. (see her email below) Cheers, Aaron From: Shirley Lee Sent: Friday, 2 May 2008 10:33 AM Subject: FullTextSQL query help Hi All, I have created a custom web part which executes FullTextSQL query and displays results in a datagrid I want to replicate the behaviour of SearchCore Results web part by displaying file-type specific icons. The only way I could think of determining the file type is from the query Select url from Scope() and get the file extension from the urlIs there any other better way of determining the file type? Please let me know your comments/ suggestions... Regards, Shirley. --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com
[OzMOSS] RE: FullTextSQL query help
Yes I think you may be able to get a document icon as a managed property. Navigate to your SSP search settings to the Metadata Property Mappings http://sharedservices/ssp/admin/_layouts/schema.aspx There are managed properties for - PictureThumbnailURL http://sharedservices/ssp/admin/_layouts/managedproperty.aspx?property=PictureThumbnailURL PictureUrl http://sharedservices/ssp/admin/_layouts/managedproperty.aspx?property=PictureThumbnailURL Hopefully they return the path to the image you need. Just use them in your enterprise search query - Select url, PictureUrl, PictureThumbnailURL from Scope() You may need to investigate further. Also, I suggest trying out as many Managed Properties in your query and look into the data returned by each, you can get quite a lot of data out of Enterprise Search, more than you expect. Have fun! Sezai Kömür Senior Developer - BEng, BSc - Microsoft Certified Technology Specialist - http://www.moss2007.com.au/ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Aaron Saikovski Sent: Friday, 2 May 2008 10:36 AM To: listserver@ozMOSS.com Subject: [OzMOSS] FW: FullTextSQL query help Hi All, Can anyone offer any suggestions for Shirley? She basically wants the icons associated with the results to appear as part of the search results.. If the item is a word document, she wants a word icon to appear next to it. That kind of thing. (see her email below) Cheers, Aaron From: Shirley Lee Sent: Friday, 2 May 2008 10:33 AM Subject: FullTextSQL query help Hi All, I have created a custom web part which executes FullTextSQL query and displays results in a datagrid I want to replicate the behaviour of SearchCore Results web part by displaying file-type specific icons. The only way I could think of determining the file type is from the query Select url from Scope() and get the file extension from the urlIs there any other better way of determining the file type? Please let me know your comments/ suggestions... Regards, Shirley. --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com
RE: [OzMOSS] RE: FullTextSQL query help
Thanks...Will pass this on. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sezai KOMUR Sent: Friday, 2 May 2008 12:47 PM To: listserver@ozMOSS.com Subject: [OzMOSS] RE: FullTextSQL query help Yes I think you may be able to get a document icon as a managed property. Navigate to your SSP search settings to the Metadata Property Mappings http://sharedservices/ssp/admin/_layouts/schema.aspx There are managed properties for - PictureThumbnailURL http://sharedservices/ssp/admin/_layouts/managedproperty.aspx?property=PictureThumbnailURL PictureUrl http://sharedservices/ssp/admin/_layouts/managedproperty.aspx?property=PictureThumbnailURL Hopefully they return the path to the image you need. Just use them in your enterprise search query - Select url, PictureUrl, PictureThumbnailURL from Scope() You may need to investigate further. Also, I suggest trying out as many Managed Properties in your query and look into the data returned by each, you can get quite a lot of data out of Enterprise Search, more than you expect. Have fun! Sezai Kömür Senior Developer - BEng, BSc - Microsoft Certified Technology Specialist - http://www.moss2007.com.au/ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Aaron Saikovski Sent: Friday, 2 May 2008 10:36 AM To: listserver@ozMOSS.com Subject: [OzMOSS] FW: FullTextSQL query help Hi All, Can anyone offer any suggestions for Shirley? She basically wants the icons associated with the results to appear as part of the search results.. If the item is a word document, she wants a word icon to appear next to it. That kind of thing. (see her email below) Cheers, Aaron From: Shirley Lee Sent: Friday, 2 May 2008 10:33 AM Subject: FullTextSQL query help Hi All, I have created a custom web part which executes FullTextSQL query and displays results in a datagrid I want to replicate the behaviour of SearchCore Results web part by displaying file-type specific icons. The only way I could think of determining the file type is from the query Select url from Scope() and get the file extension from the urlIs there any other better way of determining the file type? Please let me know your comments/ suggestions... Regards, Shirley. --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com
[OzMOSS] FullTextSQL Query Search
Hi All, I have created a custom web part whichexecutes FullTextSQL query and displays results in a datagrid I want to replicate the behaviour of SearchCore Results web part by displaying file-type specific icons. The only way I could think of determining the file type is from the query "Select url from Scope()" and get the file extension from the urlIs there any other better way of determining the file type? Please let me know your comments/ suggestions... Regards, Shirley. Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject.Powered by mailenable.com
RE: [OzMOSS] National Native Title Tribunal - Built on MOSS 2007
Nice work From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sezai KOMUR Sent: Friday, 2 May 2008 1:57 PM To: listserver@ozMOSS.com Subject: [OzMOSS] National Native Title Tribunal - Built on MOSS 2007 We launched a massive MOSS 2007 Internet website this week. Read more about it here - http://sharepoint-sezai-moss-2007.blogspot.com/2008/05/national-native-title-tribunal-moss.html Sezai Kömür Senior Developer - BEng, BSc Vivid Group Sydney Level 57, MLC Centre Martin Place Sydney, NSW, 2000 Melbourne Level 40 140 William Street Melbourne, Vic, 3000 Perth 200 Wellington Street Perth, WA, 6000 FREECALL: 1800 632 341 FREEFAX: 1800 010 888 www.vividgroup.com.au http://www.vividgroup.com.au/www.moss2007.com.au http://www.moss2007.com.au/ Disclaimer: The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the intended recipient of this message you are hereby notified that any use, review, retransmission, dissemination, distribution, reproduction or any action taken in reliance upon this message is prohibited. If you have received this email in error, please notify us immediately by return email or telephone 1800 632 341 and destroy the original message. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of the company. Thank you. --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com image001.gif