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
With more than 30 Kubernetes solutions in the marketplace, it's tempting to think Kubernetes and the vendor ecosystem has solved the problem of operationalizing containers at scale or of automatically managing the elasticity of the underlying infrastructure that these solutions n...
The deluge of IoT sensor data collected from connected devices and the powerful AI required to make that data actionable are giving rise to a hybrid ecosystem in which cloud, on-prem and edge processes become interweaved. Attendees will learn how emerging composable infrastructur...
When building large, cloud-based applications that operate at a high scale, it's important to maintain a high availability and resilience to failures. In order to do that, you must be tolerant of failures, even in light of failures in other areas of your application. "Fly two mis...
Machine learning has taken residence at our cities' cores and now we can finally have "smart cities." Cities are a collection of buildings made to provide the structure and safety necessary for people to function, create and survive. Buildings are a pool of ever-changing performa...
As Cybric's Chief Technology Officer, Mike D. Kail is responsible for the strategic vision and technical direction of the platform. Prior to founding Cybric, Mike was Yahoo's CIO and SVP of Infrastructure, where he led the IT and Data Center functions for the company. He has more...
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