[closed] How to find current Project Area ID/Name to be used in Query condition
Hi
I have multiple RTC Project Areas deployed on same server.
I want to write a generic query that can be used with any Project Area that is currently in use.
How to find current Project Area ID/Name to be used in Query condition, something like --
e.g. WHERE RIDW.PROJECT_ID = THIS.PROEJCT_ID....
.....<where THIS.PROJECT_ID will be PROJECT_ID for the current Project Area in use>
Please need your help on this .
Thanks,
Sandhya
I have multiple RTC Project Areas deployed on same server.
I want to write a generic query that can be used with any Project Area that is currently in use.
How to find current Project Area ID/Name to be used in Query condition, something like --
e.g. WHERE RIDW.PROJECT_ID = THIS.PROEJCT_ID....
.....<where THIS.PROJECT_ID will be PROJECT_ID for the current Project Area in use>
Please need your help on this .
Thanks,
Sandhya
The question has been closed for the following reason: "Duplicate Question" by rschoon Jun 30 '15, 5:03 a.m.
Comments
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Jun 30 '15, 5:03 a.m.See https://jazz.net/forum/questions/200096/how-to-find-current-project-area-idname-to-be-used-in-jrs-query-condition