Hello Suri,

Start with the APEX_WORKSPACE_ACTIVITY_LOG....

Greetings,
Roel
http://roelhartman.blogspot.com/
You can reward this reply by marking it as either Helpful or Correct

Hello Suri,

Did you take a look at that view? It contains per user the number of times a page is accessed. If you want a real rating (like 'Excellent', 'Bad' etc) than you have to create your own tables and functions. But I guess this view gives you a start. You can spot the popular pages. You can even write queries like: Users that visited this page, visited these other pages also (like a Amazon recommendation type of functionality).

Greetings,
Roel
http://roelhartman.blogspot.com/
You can reward this reply by marking it as either Helpful or Correct

Depends on when you want to give something a 3, 4, or 5 star rating.
But to give you an idea:
select page_name, perc
, case
when perc > 50 then '<img src="/i/stars5.gif" />'
when perc > 40 then '<img src="/i/stars4.gif" />'
when perc > 30 then '<img src="/i/stars3.gif" />'
when perc > 20 then '<img src="/i/stars2.gif" />'
when perc > 10 then '<img src="/i/stars1.gif" />'
else '<img src="/i/white_boxbr.gif" />'
end rating
from
( select page_name
, round(100*hits/total) perc
from
( select distinct page_id
, page_name
, count(*) over (partition by page_id, page_name) hits
, count(*) over (partition by 1) total
from APEX_WORKSPACE_ACTIVITY_LOG
where application_id = :APP_ID
order by 3 desc
)
)

There is an example on : [apex.oracle.com|http://apex.oracle.com/pls/otn/f?p=41715:14]...but it is rather slow on that multi-multi-workspace instance. On my laptop it runs fine..

Suri,

I can't get to the link you provided. Is it an internal Oracle thing?

Roel

That's also "Oracle only"...

Suri,

At Amazon they're using the AREA tag. An AREA is a part of an image (look [here|http://www.w3schools.com/TAGS/tag_area.asp] for more info). On an AREA they defined onmouseover and onclick events. The onmouseover changes the color of the image and the onclick saves the value.

The code for the 3th star is:

<area onclick="amz_js_saveRating(3, 'rating', savedRatingrating); amz_js_swapStars(3, 'rating');" onmouseover="amz_js_swapStars(3, 'rating');" coords="24,0,36,12" alt="3 stars" href="#" shape="rect"/>

And the functions that are used are:

function amz_js_saveRating(rating, formName, variableName) {
  variableName.value = rating;
  document.getElementById(formName).value = rating;
  document.getElementById(formName).savedValue.value = rating;
  amz_js_updateAltText(rating, formName);
}
 
function amz_js_swapStars(rating, formName) {
  imageName = "stars" + formName;
  imageObj = document.getElementById(imageName);
  imageObj.src = getStarsImage(rating).src;
}
 
function amz_js_updateAltText(rating, formName) {
  imageName = "stars" + formName;
  ratingString = getSelectedRatingString(rating);
  imageObj = document.getElementById(imageName);
  imageObj.setAttribute("alt", ratingString);
}

So maybe this gives you an idea how that can be done!

HTH Roel