It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,884
×7,482
×1,230

question asked: Sep 05 '14, 10:10 a.m.
question was seen: 3,942 times
last updated: Sep 08 '14, 1:40 p.m.

Related questions

Filtering RRDI Query by selecting multiple Custom RTC Enumeration values

0
Matthew Bradshaw (5●13●15) | asked Sep 05 '14, 10:10 a.m.
 Hi,

I am trying to create a report to give me a list of defects using multiple detail filters.  Defects have had a custom enumeration drop down list added to it.  I want to filter the results to show defects that have a combination of the values.

e.g. defects can have a value 1, 2 or 3 for the custom drop down enumeration.  I want to filter the list to show defects with value 1 or 2 but not 3.

Using the Literal name attribute and trying to filter like this 

[Literal Name]=('1', '2')

which is what rrdi suggests when you select multiple values returns this error: 

QE-DEF-0261 QFWP - Parsing text: [Literal Name]='1 - High', '2 - Medium'QE-DEF-0260 Parsing error before or near position: 27 of: "[Literal Name]='1 - High',"QE-DEF-0261 QFWP - Parsing text: [Literal Name]='1 - High', '2 - Medium'RSV-SRV-0042 Trace back:RSReportService.cpp(725): QFException: CCL_CAUGHT: RSReportService::processImpl()RSReportServiceMethod.cpp(258): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(838): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(293): QFException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(894): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRunSpecification_RequestExecution/RSRenderExecution.cpp(684): QFException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(303): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(79): QFException: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(397): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(179): QFException: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(347): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp(303): QFException: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(347): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp(177): QFException: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(347): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(137): QFException: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(397): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSAssembly.cpp(676): QFException: CCL_RETHROW: RSAssembly::createListIteratorAssembly/RSAssembly.cpp(731): QFException: CCL_RETHROW: RSAssembly::createListIteratorRSQueryMgr.cpp(514): QFException: CCL_RETHROW: RSQueryMgr::getListIteratorRSQueryMgr.cpp(581): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(673): QFException: CCL_RETHROW: RSQueryMgr::createIteratorRSQueryMgrBasic.cpp(275): QFException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommandRSQueryMgrBasic.cpp(265): QFException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cpp(170): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()RSQueryMgrExecutionHandlerImpl.cpp(162): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()QFSSession.cpp(1147): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1145): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(1102): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1078): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSConnection.cpp(788): QFException: CCL_RETHROW: QFSConnection::ExecuteQFSQuery.cpp(213): QFException: CCL_RETHROW: QFSQuery::Execute v2CoordinationQFSQuery.cpp(4469): QFException: CCL_THROW: CoordinationPlanner

Any help is appreciated.

One answer

Most liked answers ↑|Newest answers|Oldest answers

1
permanent link
Benjamin Silverman (4.1k●6●10) | answered Sep 05 '14, 3:06 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Seems you can use a filter like this instead of using equals.  I used the JKE Sample data which contains these enumeration attributes and my list is then filtered to only contain these values.  Hope it helps,

[Literal Name] in ('1 pt', '2 pts')
Comments
Matthew Bradshaw commented Sep 08 '14, 9:32 a.m.

  That get's past the Parser error above but the results of my query in a table show the same work items repeated with a different priority set each time.... One for each of the selected values in the list.


e.g.

Work Item ID  |          Priority
1                        1 - High
1                         2 - Medium
2                         1 - High
2                          2 - Medium

Benjamin Silverman commented Sep 08 '14, 1:40 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

Hi Matthew,

Which version of CLM/RRDI are you using, and what does your query look like?  Are you loading data from multiple CCM instances in to a single DW?  Have you checked the RIODS.REQUEST table in the DW to confirm there are not actually duplicates?

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.