OraFAQ Forum: Suggestions & Feedback » http://www.orafaq.com/forum/a/136107/

Home » Other » Suggestions & Feedback » http://www.orafaq.com/forum/a/136107/

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

http://www.orafaq.com/forum/a/136107/ [message #479836]

Tue, 19 October 2010 12:06

BlackSwan
Messages: 20243
Registered: January 2009

Senior Member

Frank,

can the order of the displayed lines be changed to be DESCENDING;
Just the opposite as to the way currently displayed

Thanks for this forum in any case.

[Updated on: Tue, 19 October 2010 12:14]

Report message to a moderator

Re: http://www.orafaq.com/forum/a/136107/ [message #479838 is a reply to message #479836]

Tue, 19 October 2010 12:35

Michel Cadot
Messages: 54704
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

May I precise?
In descending order for time then ascending order for user with Anonymous at the end.
Or like now but with Anonymous at the end.
Not sure what will be more useful.

Regards
Michel

Report message to a moderator

Re: http://www.orafaq.com/forum/a/136107/ [message #479839 is a reply to message #479838]

Tue, 19 October 2010 12:42

BlackSwan
Messages: 20243
Registered: January 2009

Senior Member

When I go to the screen which shows what users are doing
1) I never care about the anonymous users
2) the Users I wish to observe are ALWAYS at the bottom of the page.

so I would like to see the page displayed opposite the way it is currently displayed.
I would prefer to NOT have to scroll to the bottom to see that non-anonymous users.

Report message to a moderator

Re: http://www.orafaq.com/forum/a/136107/ [message #479840 is a reply to message #479839]

Tue, 19 October 2010 13:07

Frank Naude
Messages: 4381
Registered: April 1998

Senior Member

OK, I've changed it from
ORDER BY alias, time DESC
to
time DESC

Let me know if it's better.

Report message to a moderator

Re: http://www.orafaq.com/forum/a/136107/ [message #479842 is a reply to message #479840]

Tue, 19 October 2010 13:24

Michel Cadot
Messages: 54704
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Not really, the main point is that we (BlackSwan and I) don't care/want Anonymous.
Something like:
ORDER BY decode(alias,'Anonymous','ZZZZZZZZZ',alias), time desc

Regards
Michel

Report message to a moderator

Re: http://www.orafaq.com/forum/a/136107/ [message #479843 is a reply to message #479838]

Tue, 19 October 2010 13:29

Barbara Boehmer
Messages: 7683
Registered: November 2002
Location: California, USA

Senior Member

Michel Cadot wrote on Tue, 19 October 2010 10:35

May I precise?

In English, precise is only an adjective, not a verb. Please see the link below.

http://dictionary.reference.com/browse/precise

If you need to use a verb, you can substitute clarify or specify. Please see the list of common translations below.

Puis-je préciser?                         May I clarify?
Puis-je être plus précis?                 May I be more precise?
S'il vous plaît être plus précis.         Please be more precise.
S'il vous plaît précisez votre question.  Please specify your question.

Report message to a moderator

Re: http://www.orafaq.com/forum/a/136107/ [message #479844 is a reply to message #479840]

Tue, 19 October 2010 13:33

BlackSwan
Messages: 20243
Registered: January 2009

Senior Member

Frank Naude wrote on Tue, 19 October 2010 11:07

OK, I've changed it from
ORDER BY alias, time DESC
to
time DESC

Let me know if it's better.

Actually In My Opinion, it made things worse.

What about as below:

ORDER BY alias DESC

Report message to a moderator

Re: http://www.orafaq.com/forum/a/136107/ [message #479845 is a reply to message #479844]

Tue, 19 October 2010 13:38

Barbara Boehmer
Messages: 7683
Registered: November 2002
Location: California, USA

Senior Member

Yes, that's worse, because now the regular posters are spaced out within the anonymous posters. It would be best to have the regular posters at the top, but having them together at the bottom is better than having them all over the place.

Report message to a moderator