1) For selecting all not completed product defects in OSSreports

'Business Line Id' = "coams" AND 'System Id' = "kccomc" AND 'Product Id' = "ossreports" AND 'Request Type' = "product defect" AND 'Internal Status'  != "completed" AND 'Internal Status'  != "rdyforld" AND 'Internal Status'  != "solved"



2) For selecting all not completed product defects in OSSthnf

'Business Line Id' = "coams" AND 'System Id' = "kccomc" AND 'Product Id' = "ossthnf" AND 'Request Type' = "product defect" AND 'Internal Status'  != "completed" AND 'Internal Status'  != "rdyforld" AND 'Internal Status'  != "solved"


3) For selecting all not completed product defects in OSSuseradmin

'Business Line Id' = "coams" AND 'System Id' = "kccomc" AND 'Product Id' = "ossuseradmin" AND 'Request Type' = "product defect" AND 'Internal Status'  != "completed" AND 'Internal Status'  != "rdyforld" AND 'Internal Status'  != "solved"

4) For selecting all not completed product defects in OSSCTX

'Business Line Id' = "coams" AND 'System Id' = "kccomc" AND 'Product Id' = "ossctx" AND 'Request Type' = "product defect" AND 'Internal Status'  != "completed" AND 'Internal Status'  != "rdyforld" AND 'Internal Status'  != "solved"

5) for selecting all not completed SR's for a given Assignee (Example: "damourni")

'Business Line Id' = "coams"  AND 'Assigned To Login Id' = "damourni" AND 'Request Type' = "product defect" AND 'Internal Status'  != "completed" AND 'Internal Status'  != "rdyforld" AND 'Internal Status'  != "solved"

6) For selecting all product defects in transitory status in all kccomc and DataXTender products

'Business Line Id' = "coams" AND ('System Id' = "kccomc" OR 'System Id' = "DataXtender") AND 'Request Type' = "product defect" AND 'Internal Status'  != "completed" AND 'Internal Status'  != "rdyforld" AND 'Internal Status'  != "solved" AND 'Internal Status'  != "accepted"