yourfanat wrote: I am using another tool for Oracle developers - dbForge Studio for Oracle. This IDE has lots of usefull features, among them: oracle designer, code competion and formatter, query builder, debugger, profiler, erxport/import, reports and many others. The latest version supports Oracle 12C. More information here.
Cloud Expo on Google News
Cloud Expo & Virtualization 2009 East
Smarter Business Solutions Through Dynamic Infrastructure
Smarter Insights: How the CIO Becomes a Hero Again
Windows Azure
Why VDI?
Maximizing the Business Value of Virtualization in Enterprise and Cloud Computing Environments
Messaging in the Cloud - Email, SMS and Voice
Freedom OSS
Stairway to the Cloud
Sun's Incubation Platform: Helping Startups Serve the Enterprise
Cloud Computing & Enterprise IT: Cost & Operational Benefits
How and Why is a Flexible IT Infrastructure the Key To the Future?
Click For 2008 West
Event Webcasts
Displaying Social Ratings in Search Results
I absolutely love the new social ratings site columns that we can easily add to existing SharePoint 2010 document libraries

I absolutely love the new social ratings site columns that we can easily add to existing SharePoint 2010 document libraries.  It gives such an easy way for end users to rate documents in an interface they are probably already familiar with because of iTunes.


I got to thinking.  Seeing these social ratings in my search results sure would be useful.  It would also be nice to be able to query them.  How do we do that?  We use managed properties of course.  I did some digging and found out that there isn’t a managed property already out there for this so we need to create one.  We know the actual name of the site column is AverageRating (the display name is Rating (0-5)).  This means that once we have performed a crawl, we should have a crawled property called ows_AverageRating.  Sure enough if you look in your crawled properties, it is there.  In my screenshot below, you see the result of me mapping it later.  Yours shouldn’t have anything listed under Mapped To yet.



Create a new managed property called AverageRating (or whatever you want to call it).  Choose a data type of Decimal and pick the ows_AverageRating column from the list.


Now you need to go back to your content sources page and do a full crawl.  When your crawl completes, we can now test and see if our new property works.  Go to your Search Center and try the query below.


If all goes well, you should see some search results for documents that have more at least three stars.  Note that there are no spaces in that query at all.  If it doesn’t work, you may not have any documents rated yet or you recently applied ratings and you need to wait for the timer job to run.


This tells us that we can write queries on our managed property, but we want to actually see them in our results as well.  For this we need to customize the properties we return in search results as well as the XSLT.  We can do this in either CoreResutlsWebPart or on the Local Search Results federated location.  I am going to edit the federated location.  Go down to Core Search Results Display Metadata under Display Information and edit the Properties.  Start by adding the following inside the Columns element.

<Column Name="AverageRating" />

This tells Enterprise Search to include this column in the results.


We then need to edit the XSL.  Finding the right spot can be somewhat tricky, but it’s not too difficult.  A good spot for your new rating is in the srch-Metadata2 div.  This is where it already displays things like author, file size, and tags.  Simply add the following right before the blank.gif reference.

Rating: <xsl:value-of select="averagerating"/>

It should look like this when you’re done.


When you finish editing your XSL, save your changes, wait a minute or so and then go and try your query again.  You should now see search results similar to the ones below.  Notice the Rating listed for each result.


This gives us a decent representation of what we can do with social ratings in search results.   Wouldn’t it be nice if we could sort by this new managed property?   Sorry, you’ve got to buy FAST for that or write your own search results screen using the QueryManager class.  Even without sorting though, i think this adds a lot of value to your search results.

The next step would be to display actual stars instead of a numerical representation.  I’ll continue to work on something on how to do that.  In the mean time, someone smarter than me at XSL may be able to provide us all an answer. :)  If you have one, I’d love to see it.

Read the original blog entry...

About Corey Roth
Corey Roth, a SharePoint Server MVP, is an independent consultant specializing in Cloud technologies such as Azure and Office 365. He also specializes in mobile development. Corey serves as the product manager for two cloud-first mobile app platforms: BrewZap and HappenZap.

Latest Cloud Developer Stories
"Storpool does only block-level storage so we do one thing extremely well. The growth in data is what drives the move to software-defined technologies in general and software-defined storage," explained Boyan Ivanov, CEO and co-founder at StorPool, in this interview at...
A strange thing is happening along the way to the Internet of Things, namely far too many devices to work with and manage. It has become clear that we'll need much higher efficiency user experiences that can allow us to more easily and scalably work with the thousands of devices ...
As DevOps methodologies expand their reach across the enterprise, organizations face the daunting challenge of adapting related cloud strategies to ensure optimal alignment, from managing complexity to ensuring proper governance. How can culture, automation, legacy apps and even ...
As Marc Andreessen says software is eating the world. Everything is rapidly moving toward being software-defined – from our phones and cars through our washing machines to the datacenter. However, there are larger challenges when implementing software defined on a larger scale - ...
Blockchain. A day doesn’t seem to go by without seeing articles and discussions about the technology. According to PwC executive Seamus Cushley, approximately $1.4B has been invested in blockchain just last year. In Gartner’s recent hype cycle for emerging technologies, blockchai...
Subscribe to the World's Most Powerful Newsletters
Subscribe to Our Rss Feeds & Get Your SYS-CON News Live!
Click to Add our RSS Feeds to the Service of Your Choice:
Google Reader or Homepage Add to My Yahoo! Subscribe with Bloglines Subscribe in NewsGator Online
myFeedster Add to My AOL Subscribe in Rojo Add 'Hugg' to Newsburst from CNET Kinja Digest View Additional SYS-CON Feeds
Publish Your Article! Please send it to editorial(at)!

Advertise on this site! Contact advertising(at)! 201 802-3021

SYS-CON Featured Whitepapers