Manually entering an SQL Query into RTC
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).
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
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?
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