Book a Demo

Author Topic: Missing resolvedBy criteria for defect search  (Read 3258 times)

Oliver F.

  • EA User
  • **
  • Posts: 573
  • Karma: +2/-1
  • Aren´t we all in the model business ?
    • View Profile
    • Karl Storz homepage
Missing resolvedBy criteria for defect search
« on: November 14, 2009, 02:56:03 am »
Filed a new bug:

==============
The search manager is a powerful instrument, it even lets search for elements with defects which fullfil certain criterias of that defect.
However it is impossible to create a search for an element which is already resolved by a ressource as that filter criteria is not available.
==============

The annoyance comes if one uses the maintenance dialog to manage reviews which are then assigned to a person.

Oliver

Oliver F.

  • EA User
  • **
  • Posts: 573
  • Karma: +2/-1
  • Aren´t we all in the model business ?
    • View Profile
    • Karl Storz homepage
Re: Missing resolvedBy criteria for defect search
« Reply #1 on: November 17, 2009, 04:58:33 pm »
Though the resolvedby field is missing from the standard search criterias the required functionality can be accomplished via SQL search as a workaround.

The SQL select looks like this:
Code: [Select]
SELECT t_object.ea_guid AS CLASSGUID,t_object.Object_Type AS CLASSTYPE, t_object.Name, t_objectproblems.ReportedBy AS Reviewer, t_objectproblems.Priority, t_objectproblems.Problem, t_objectproblems.ProblemNotes FROM t_object, t_objectproblems WHERE t_object.Object_ID=t_objectproblems.Object_ID AND t_objectproblems.ProblemType='Defect' AND t_objectproblems.ResolvedBy LIKE '#WC#<Search Term>#WC#';

Oliver