Project and Portfolio Management Practitioners Forum
cancel

Validation not sorting

Highlighted
Shravan Kathuri
Honored Contributor.

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
Acclaimed Contributor.

Re: Validation not sorting

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

Regards,
Mahendran M
Shravan Kathuri
Honored Contributor.

Re: Validation not sorting

I have changed the expected length from "Short" to "Long".it worked. Thanks.