Query studio error, CROSS Joins
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
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
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
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