Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Validation not sorting

Highlighted
Shravan Kathuri
Senior Member

Validation not sorting

Hi,

We are using PPM 7.5 sp6. We have one validation which has sql
"select code,meaning from
(
select code,meaning from tb_appmgmt_codes where code_name like 'Marsh - Application'
union
select to_char(Application_id),APPLICATION_NAME from TB_AMS001_APPLICATION
where DELETE_APPLICATION IS NULL
)
where upper(meaning) like upper('?%')
order by upper(meaning)"

In oracle , we are getting values order by meaning, but when i use this validation in one field in the request type, it is not sorting.
Even i tried after running runcachemanager.

What could be the problem?

Thanks
Shravan Kumar.K
2 REPLIES
Mahen M
Honored Contributor

Re: Validation not sorting

Instead of 'order by upper(meaning)' can you use 'Order by 2'?

Regards,
Mahendran M
Shravan Kathuri
Senior Member

Re: Validation not sorting

I have changed the expected length from "Short" to "Long".it worked. Thanks.
//Add this to "OnDomLoad" event