Projects - EBS (MOSC)

MOSC Banner

How to sort project list by PROJECT_ID or PROJECT_NUMBER (numeric)

edited Aug 17, 2012 12:00AM in Projects - EBS (MOSC) 1 commentAnswered
We need to sort project list views by PROJECT_ID or project number. We use automatic numberring for all projects. But field "Project number" is character. When I click on this field header, data are sorted (as a characters, not as a numbers).For example, existing ASC sort
100
2
98

We need
2
98
100

How to achieve this ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center