It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,787

question asked: Dec 18 '09, 2:45 p.m.
question was seen: 6,660 times
last updated: Dec 18 '09, 2:45 p.m.

Related questions

FAQ - How this Forum works

Manually entering an SQL Query into RTC

0
Michael Walker (992●15●201●157) | asked Dec 18 '09, 2:45 p.m.
How can I enter an SQL statement manually to create a query in RTC rather than selecting the values through the interface?

For example, I have a query that I need to put into RTC that uses CASE statements and creates a custom computed column.

The output of this query will have a computed column that ranks the work items assigned to a team member based on other criteria passed in the query (i.e Priority, Severity, Customer).

2 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Michael Walker (992●15●201●157) | answered Dec 28 '09, 5:05 p.m.
How can I enter an SQL statement manually to create a query in RTC rather than selecting the values through the interface?

For example, I have a query that I need to put into RTC that uses CASE statements and creates a custom computed column.

The output of this query will have a computed column that ranks the work items assigned to a team member based on other criteria passed in the query (i.e Priority, Severity, Customer).


Does anyone know the answer to this?
0
permanent link
Patrick Streule (4.9k●2●1) | answered Jan 06 '10, 5:38 a.m.
JAZZ DEVELOPER
miwalkerwrote:
How can I enter an SQL statement manually to create a query in RTC
rather than selecting the values through the interface?

For example, I have a query that I need to put into RTC that uses
CASE statements and creates a custom computed column.

The output of this query will have a computed column that ranks the
work items assigned to a team member based on other criteria passed
in the query (i.e Priority, Severity, Customer).

Does anyone know the answer to this?

The DB table structure is internal and we do not support querying items
in the DB directly via SQL. Our higher-level abstractions do not support
CASE statements.

Depending on your needs, a report (instead of a work item query) may be
an option for you.

--
Regards,
Patrick
Jazz Work Item Team

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.