Versions Compared

Old Version 1

changes.mady.by.user Sofia Canario

Saved on

compared with

New Version Current

changes.mady.by.user Ana Teixeira

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Warning

These queries are doing regex search so might be a little expensive to run. We highly recommend you to run them out-of peak time ( like weekends).



Filters

SELECT *
FROM "SEARCHREQUEST"
WHERE REQCONTENT LIKE '%testTestSet%'
   OR REQCONTENT LIKE '%testTestPlan%'
   OR REQCONTENT LIKE '%testTestExecutions%'
   OR REQCONTENT LIKE '%testsWithTestSetVersion%'
   OR REQCONTENT LIKE '%testsWithReqVersion%'
   OR REQCONTENT LIKE '%testsWithoutTestExecution%'
   OR REQCONTENT LIKE '%testsWithNoTestSet%'
   OR REQCONTENT LIKE '%testSetTests%'
   OR REQCONTENT LIKE '%testSetPartiallyIn%'
   OR REQCONTENT LIKE '%testSetFullyIn%'
   OR REQCONTENT LIKE '%testRequirements%'
   OR REQCONTENT LIKE '%testRepositoryFolderTests%'
   OR REQCONTENT LIKE '%testPreConditions%'
   OR REQCONTENT LIKE '%testPlanTests%'
   OR REQCONTENT LIKE '%testPlanTestExecutions%'
   OR REQCONTENT LIKE '%testPlansWithCompletedTestRunsSince%'
   OR REQCONTENT LIKE '%testPlanRequirements%'
   OR REQCONTENT LIKE '%testPlanFolderTests%'
   OR REQCONTENT LIKE '%testExecWithTestRunsAssignedToUser%'
   OR REQCONTENT LIKE '%testExecutionTests%'
   OR REQCONTENT LIKE '%testExecutionsWithCompletedTestRunsSince%'
   OR REQCONTENT LIKE '%requirementTests%'
   OR REQCONTENT LIKE '%requirementsWithStatusByTestPlan%'
   OR REQCONTENT LIKE '%requirements%'
   OR REQCONTENT LIKE '%projectParentRequirements%'
   OR REQCONTENT LIKE '%preConditionTests%'
   OR REQCONTENT LIKE '%manualTestsWithoutSteps%'
   OR REQCONTENT LIKE '%defectsCreatedForRequirement%'
   OR REQCONTENT LIKE '%defectsCreatedDuringTesting%'
   OR REQCONTENT LIKE '%defectsCreatedDuringTestExecution%';


Dashboards


We can update the above a little to find the ones that are being used in dashboards:

SELECT pp.id AS dashboard_id,
       pp.username,
       pp.pagename AS dashboard_name,
       s.filtername,
       s.id AS filter_id,
       gup.USERPREFVALUE
FROM portalpage pp
JOIN portletconfiguration pc
    ON pp.id = pc.portalpage
JOIN gadgetuserpreference gup
    ON pc.ID = gup.portletconfiguration
JOIN searchrequest s
    ON gup.userprefvalue = s.filtername
WHERE s.REQCONTENT LIKE '%testTestSet%'
   OR s.REQCONTENT LIKE '%testTestPlan%'
   OR s.REQCONTENT LIKE '%testTestExecutions%'
   OR s.REQCONTENT LIKE '%testsWithTestSetVersion%'
   OR s.REQCONTENT LIKE '%testsWithReqVersion%'
   OR s.REQCONTENT LIKE '%testsWithoutTestExecution%'
   OR s.REQCONTENT LIKE '%testsWithNoTestSet%'
   OR s.REQCONTENT LIKE '%testSetTests%'
   OR s.REQCONTENT LIKE '%testSetPartiallyIn%'
   OR s.REQCONTENT LIKE '%testSetFullyIn%'
   OR s.REQCONTENT LIKE '%testRequirements%'
   OR s.REQCONTENT LIKE '%testRepositoryFolderTests%'
   OR s.REQCONTENT LIKE '%testPreConditions%'
   OR s.REQCONTENT LIKE '%testPlanTests%'
   OR s.REQCONTENT LIKE '%testPlanTestExecutions%'
   OR s.REQCONTENT LIKE '%testPlansWithCompletedTestRunsSince%'
   OR s.REQCONTENT LIKE '%testPlanRequirements%'
   OR s.REQCONTENT LIKE '%testPlanFolderTests%'
   OR s.REQCONTENT LIKE '%testExecWithTestRunsAssignedToUser%'
   OR s.REQCONTENT LIKE '%testExecutionTests%'
   OR s.REQCONTENT LIKE '%testExecutionsWithCompletedTestRunsSince%'
   OR s.REQCONTENT LIKE '%requirementTests%'
   OR s.REQCONTENT LIKE '%requirementsWithStatusByTestPlan%'
   OR s.REQCONTENT LIKE '%requirements%'
   OR s.REQCONTENT LIKE '%projectParentRequirements%'
   OR s.REQCONTENT LIKE '%preConditionTests%'
   OR s.REQCONTENT LIKE '%manualTestsWithoutSteps%'
   OR s.REQCONTENT LIKE '%defectsCreatedForRequirement%'
   OR s.REQCONTENT LIKE '%defectsCreatedDuringTesting%'
   OR s.REQCONTENT LIKE '%defectsCreatedDuringTestExecution%'
ORDER BY pp.pagename, s.filtername;