I'd just love to know how you came up with that list, its a total nitemare.
Do you regularly have to make changes to that? I'd be almost tempted to
make application changes to lump some of those 'Active Org, Org/Group'
entries into specific categories to simplify the query development, or has
that already been tried?
Regards
Dave
On 24/11/06, Sean Harrodine <[EMAIL PROTECTED]> wrote:
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"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
