How to find current Project Area ID/Name to be used in JRS Query condition
I have multiple RTC Project Areas deployed on same server.
I want to write a generic JRS query using Advanced Tab 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 want to write a generic JRS query using Advanced Tab 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
4 answers
Sandhya
How do you define "current" in your case? What does "in use" mean exactly?
There is only one article which explores the advanced capability of the report builder. See https://jazz.net/library/article/1470 It suggests starting with a simple query and its formatting results tab.
Can you create a query using the JRS UI and describe it here so I can get an idea of what you are trying to do?
How do you define "current" in your case? What does "in use" mean exactly?
There is only one article which explores the advanced capability of the report builder. See https://jazz.net/library/article/1470 It suggests starting with a simple query and its formatting results tab.
Can you create a query using the JRS UI and describe it here so I can get an idea of what you are trying to do?
Comments
Hi Rosa,
Let me explain ..I have written JRS query and have edited SQL to suit requirements ( as there were some calculations like summation etc was there)..This works fine for a selected project. My server is shared by multiple projects hence would like use the same query for all projects. Since once we edit the SQL query in Advanced mode it does not give us to choose the project.
Hence I was looking for is there a way in query can we mention THIS project area something.. so that when we run this for particular project it will fetch it's own data.
Hope this answers your question.
Thanks,
Sandhya
I suggest exploring the new features delivered with JRS 6.0 such as Dynamic Conditions and Summary Reports. It's possible that what you had to use Advanced mode for is no longer necessary with 6.0.
Dynamic Conditions - https://jazz.net/downloads/jazz-reporting-service/milestones/6.0M8?p=news
Summary Reports - https://jazz.net/downloads/jazz-reporting-service/milestones/6.0M10?p=news
Dynamic Conditions - https://jazz.net/downloads/jazz-reporting-service/milestones/6.0M8?p=news
Summary Reports - https://jazz.net/downloads/jazz-reporting-service/milestones/6.0M10?p=news
Hi Sandhya,
If if read your question correctly I think you're looking for a query that allows you to discover the PROJECT_ID for each Project name.
Try adding the following in the Advanced Tab of a new Report and it will list all the Project ID's associated to a particular name:
SELECT T1.NAME AS PROJECT_NAME,
T1.PROJECT_ID AS PROJECT_ID
FROM RIDW.D_PROJECT T1
Regards,
-Steve