TQL

 Tosca Query language (TQL) is one of the most underrated but powerful query language.

The TQL search is context-dependent. This means that the starting point has an effect on the search to be carried out. A search, which is performed on the basis of a project root element, produces different results from one based on the topmost Module folder.

TQL is deeply rooted in Tosca. Even the normal, Simple Search dialog is based on it.

Q.  How we would like to know if all created TestCases have been assigned to ExecutionLists.

=>SUBPARTS:TestCase[COUNT("ExecutionEntries")==0]

Q. Below query can be used to identify modules which are not linked to any test steps. This can be more useful to identify ideal module and further those can be used or deleted.

=>SUBPARTS:XModule[COUNT("TestSteps")==0]
OR
->COMPLEMENT(=>SUBPARTS:XModule,=>return SUBPARTS:XModule->TestSteps)

Q. Below query can be used to identify test cases which are not linked to any execution list and which are 3 years old. this can be used to identify scripts which are likely to be deleted due to less usages.

->INTERSECTION(->COMPLEMENT(=>SUBPARTS:TestCase,=>return SUBPARTS:TestCase->ExecutionEntries),=>SUBPARTS:TestCase[CreatedAt <= "6/29/2020 2:14:36 AM"])

Q. Below query can be used to identify test cases that don’t have reusable Test block. as per best practice your test script must have good amount of RTBS for quick maintenance (there can be few exceptions).

->COMPLEMENT(=>SUBPARTS:TestCase,=>SUBPARTS:TestStepFolderReference->TestCase))

Q. Below query can be used to identify duplicate modules (specially standard modules) with same name. this further can be used to cleanup duplicate modules.

=>SUBPARTS:XModule[Name == "OpenUrl"]

Q. Below query can be used to identify requirements that are having zero weightage.

=>SUBPARTS:Requirement[Weight==0]