Post upgrade from RTC-5.0.2 to RTC6.0.6.1 the quering using "is" and "contains" keyword to filter workitems based on custom attributes are returning different results
Post upgrade from RTC-5.0.2 to RTC6.0.6.1 the quering using "is" and "contains" keyword to filter workitems based on custom attributes are returning different results.
How does the RTC querying work? What is the difference between "is" and "contains" keyword from query execution point of view.
|
Accepted answer
David Honey (1.8k●1●7)
| answered Jun 29 '21, 7:10 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER In most query editors, "is" is an exact string match (either case sensitive or case insensitive), and "contains" matches substrings similar to the SQL LIKE operator. Usually you would expect that the results for "is" will be a subset of the results for "contains" for a specific string.
Geoffrey Clemm selected this answer as the correct answer
|
One other answer
Ralph Schoon (63.3k●3●36●46)
| answered Jun 29 '21, 6:49 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
This is the OSLC spec that EWM supports as far as I know https://archive.open-services.net/bin/view/Main/OSLCCoreSpecQuery there is no 'contains' or 'is'.
If you talk about a different API, provide a link to the API spec and when you are at it, provide the query in your question.
Comments
Hi Ralph,
Thanks for quick reply. I am facing this issue in query editor in GUI not oslc APIs.
|
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.