Hi guys / gals,
I have a beast of a query that a colleague of mine uses in the advanced tool
bar in the User tool which he needs to edit, but he frequently gets tripped
up by brackets in the wrong places.
Does anyone know of a tool that i can paste this query into to expand all
the brackets out and show him a better view of query ?
TIA
Sean
Here it is..............(dont say i didnt warn you !!!!)
('State' <= "Cleared") AND ('Ticket State' != "Ready to Close") AND
(((('Active Org' LIKE "RD-GNMC-%") OR (('Active Org' != "BE-COPS-VMT") AND
('Active Org' != "AZ-GCSC-RCA") AND ('Active Org' != "AZ-GCSC-HMC") AND
('Active Org' != "MN-GCSC-OOB") AND ('Active Org' != "EM-CSO-EMEA") AND
('Active Org' != "SG-GNMC-GCS") AND ('Active Org' != "US-NTCM-TCH") AND
('Active Org' != "US-NTCM-PRF") AND ('Managing Org' != "US-TEST"))) AND
('Client ID' = "SHAREDSVCS") AND (('Org/Group' = "SIEMENS") OR ('Org/Group'
= "SIEMENSEVPN") OR ('Org/Group' = "SBS") OR ('Org/Group' =
"EMEASIE000-SIEV") OR ('Org/Group' = "INFI"))) OR ('Work Queue' = "SIEMENS")
OR (('Client ID' = "GLOBAL_AM") AND ((('Active Org' = "UK-GCSC-UK") OR
(('Active Org' != "BE-GCSC-BE") AND ('Active Org' != "BE-GCSC-VENDOR") AND
('Active Org' != "AZ-GCSC-RCA") AND ('Active Org' != "MN-GCSC-OOB") AND
('Active Org' != "EM-CSO-EMEA") AND ('Active Org' != "SG-GNMC-GCS") AND
('Active Org' != "US-NTCM-TCH") AND ('Active Org' != "US-NTCM-PRF") AND
('Managing Org' != "US-TEST") AND (('NodeName' = "bhxdms01") OR ('NodeName'
= "bhxdms08")))) AND (('Org/Group' = "EV_GBTYR") OR ('Org/Group' =
"EV_TOYSRUS") OR 'Org/Group' = ("GM_DEEID") OR ('Org/Group' = "GBY28900") OR
('Org/Group' = "MD_GBY28900") OR ('Org/Group' = "GBTOYMA1") OR ('Org/Group'
= "EV_DEYLSTEH") OR ('Org/Group' = "DANISCO") OR ('Org/Group' =
"EV_NLRIALEA") OR ('Org/Group' = "GM_GBKER000") OR ('Org/Group' =
"NLRIALEA") OR ('Org/Group' = "EV_NLKERLEA") OR ('Org/Group' = "NLRIALMF")
OR ('Org/Group' = "NBFKER01F") OR ('Org/Group' = "EV_KERRYGRP") OR
('Org/Group' = "NLBIONET") OR ('Org/Group' = "NLKERAVT") OR ('Org/Group' =
"GM_FRKERNAN") OR ('Org/Group' = "GM_ITKERMIL") OR ('Org/Group' =
"EV_TENNECO") OR ('Org/Group' = "GM_BETAE") OR ('Org/Group' = "MD_BETAE") OR
('Org/Group' = "GBTWU") OR ('Org/Group' = "BETAE") OR ('Org/Group' =
"EV_BPINTL") OR ('Org/Group' = "EV_BSCHSIEM") OR ('Org/Group' = "EV_DEHDRU")
OR ('Org/Group' = "DEEID") OR ('Org/Group' = "EV_HEIDBGDR") OR ('Org/Group'
= "EV_GBPNS") OR ('Org/Group' = "NLPANA") OR ('Org/Group' = "SIEMENS")))))
OR (('State' < "Cancel") AND ('Ticket State' != "Ready to Close") AND
((('Active Org' = "EM-GCSC-IBM") OR ((('Active Org' = "UK-GCSC-UK") OR
(('Active Org' != "US-GNMC-DSW") AND ('Active Org' != "NC-GCSC-HMC") AND
('Active Org' != "SK-GCSC-CRMT") AND ('Active Org' != "EM-PLAT-SVR ") AND
('Active Org' != "BE-GCSC-VENDOR") AND ('Active Org' != "BE-GCSC-BE") AND
('Active Org' != "US-GNMC-DL1") AND ('Active Org' != "EM-GNMC-SL2") AND
('Active Org' != "EM-CSO-EMEA") AND ('Active Org' != "EM-SYKS-MDN") AND
('Active Org' != "US-GNMC-IPS") AND ('Active Org' != "US-NTCM-TCH") AND
('Active Org' != "US-NTCM-PRF") AND (('NodeName' = "bhxdms16") OR
('NodeName' = "bhxdms03") OR ('NodeName' = "bhxms04") OR ('NodeName' =
"bhxdms18") OR ('NodeName' = "strdms18")))) AND (('Org/Group' = "GBI8M") OR
(('Org/Group' = "UNKNOWN") AND ('Active Org' != "BE-GCSC-VENDOR") AND
('Active Org' != "UK-GCSC-UK") ) OR ('Org/Group' = "DEIKG") OR ('Org/Group'
= "IBM_P9_IGA ") OR ('Org/Group' = "IBM_P9_IGA") OR ('Org/Group' =
"IBM_P9IS_EMEA") OR ('Org/Group' = "IBM_P9_EMEA") OR ('Org/Group' =
"EV_VERTEX") OR ('Org/Group' = "IBM_IPNET") OR ('Org/Group' = "GBPW9") OR
('Org/Group' = "DEPW9") OR ('Org/Group' = "DKPW9") OR ('Org/Group' =
"BEPW9") OR ('Org/Group' = "FRPW9") OR ('Org/Group' = "ATPW9") OR
('Org/Group' = "CHPW9") OR ('Org/Group' = "CZPW9") OR ('Org/Group' =
"LVPW9") OR ('Org/Group' = "NLPW9") OR ('Org/Group' = "EEPW9") OR
('Org/Group' = "PLPW9") OR ('Org/Group' = "GBIGAEVE") OR ('Org/Group' =
"EV_GEOLOGIS") OR ('Org/Group' = "GBY14200") OR ('Org/Group' = "GBLEP") OR
('Org/Group' = "BEJNJ") OR ('Org/Group' = "EV_GBAV0") OR ('Org/Group' =
"GBAV0") OR ('Org/Group' = "GBAUL") OR ('Org/Group' = "EV_GBAUL") OR
('Org/Group' = "APALIV") OR ('Org/Group' = "EV_APALIV") OR ('Org/Group' =
"AV1AMM") OR ('Org/Group' = "AV1AMU") OR ('Org/Group' = "AV1AFB") OR
('Org/Group' = "EV_CSOUP") OR ('Org/Group' = "BECAMPB") OR ('Org/Group' =
"BECAMP") OR ('Org/Group' = "EV_BECAMLEA") OR ('Org/Group' = "GBGDV") OR
('Org/Group' = "NLKERBIO") OR ('Org/Group' = "DEGODBEL") OR ('Org/Group' =
"GM_GBUYS") OR ('Org/Group' = "EV_PARKRHAN") OR ('Org/Group' =
"MD_GBY45000") OR ('Org/Group' = "GBY45000") OR ('Org/Group' = "GBJ15600")
OR ('Org/Group' = "MD_GBJ15600") OR ('Org/Group' = "EV_GBDENLEA") OR
('Org/Group' = "GBDEN") OR ('Org/Group' = "DETSP") OR ('Org/Group' =
"EV_BESWIFT" )) AND ('Active Org' != "EM-PLAT-SVR" )) OR ('Work Queue' =
"POWER 9"))))
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
