It's all about the answers!

Ask a question

Query studio error, CROSS Joins


Aziz Sharafi (16132) | asked Feb 26 '12, 5:05 a.m.
hello,

I am getting the following error when i attempt to build a query from the Request Area using Request ID, and Request History Area.

Cross joins (between query subjects: ., .) are not permitted for the user who has the identity '*'.

I am logging in as insight administrator, who is also a JAZZADMIN.. i am using JAZZ name space.

1) Is this message expected, or something is not health here?
2) I want to build a report that displays each defect, and recorded date for each state and time spent in each state. AGING Report

Thanks

2 answers



permanent link
Junli Wang (5512) | answered Feb 27 '12, 2:48 a.m.
JAZZ DEVELOPER
I think it's a defect, 2 problems here
1. view request history is supposed to have request_id column
2. query subject request history is supposed to have a relationship with query subject request.
opened defects:
188891: REQUEST_ID is missing in VW_RQST_HISTORY
188892: Request History needs a relationship with Request

permanent link
Junli Wang (5512) | answered Mar 02 '12, 12:10 a.m.
JAZZ DEVELOPER
the fix will be available in RTC 4.0, expected in June,2012

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.