How to output the list of project area
Accepted answer
Running a DB query is a very ill advised suggestion. You should never try to access the process data directly with SQL. Use either our public Java API or REST API defined at https://jazz.net/wiki/bin/view/Main/DraftTeamProcessRestApi.
Don
_________________
Jazz Team Process
Don
_________________
Jazz Team Process
Comments
To expand a bit on why it is better to use an officially supported external API, this protects your client code both from the kind of database implementation differences identified earlier in this thread, and from release-to-release changes in the underlying database tables that would invalidate your SQL.
Cheers,
Geoff
This is a very ill advised suggestion. You should never try to access the process data directly with SQL. Use either our public Java API or REST API defined at https://jazz.net/wiki/bin/view/Main/DraftTeamProcessRestApi.
Don
_____
Jazz Team Process
One other answer
SELECT
,
FROM ..
WHERE ...ARCHIVED = 0
That SQL can give you the non archived projects. Hope that helps.
,
FROM ..
WHERE ...ARCHIVED = 0
That SQL can give you the non archived projects. Hope that helps.
Comments
Thank you for your suggestion.
I changed the SQL a little and it worked :)
I thinks it depends on what database is being used.
Thank you for your suggestion.
I changed the SQL a little and it worked :)
I thinks it depends on what database is being used.
The syntax chages from DB to DB. I sent you you the MS SQL one :)