Hi Joe, Frex and the rest of the list,
What I am looking for are the tickets assigned to my group but not to me. The
search is 'Status' < "Closed" AND 'Assigned Group' = "Applications" AND
('Assigned Person' != "Mark Brittain" OR 'Assigned Person = $NULL$)
Is there is a better way to write this? All of the fields are indexed so that
is not the issue. I do know that the index is not used with the NOT operator.
Think it would help if the Assigned Person' != "Mark Brittain" OR 'Assigned
Person = $NULL$) were flipped?
Thanks
Mark
________________________________
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Joe D'Souza
Sent: Thursday, March 11, 2010 2:17 AM
To: [email protected]
Subject: Re: White screen on refresh
Performance of your application is an area you might want to check. Its typical
signs of badly written code, that uses a bad search probably on that table
field since you say that it happens on refresh of a table field..
Make sure that you have used fields that would qualify for writing a good
query, meaning that they have been indexed. Make sure the query is optimized by
way of minimum calculations required to get the results.. constants on one side
with variables on the other side of an equation..
Joe
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]]on Behalf Of Brittain, Mark
Sent: Wednesday, March 10, 2010 3:52 PM
To: [email protected]
Subject: White screen on refresh
**
Hi All
This might be an odd question but I thought worth asking. Sometimes when I do a
search or refresh a table in the RUT or save a change to a form in the admin
tool my screen goes white. Really weird.
Can anyone tell me why this occurs? ARS 6.3 patch 20 on server and client.
SunOS 5.9 server and Windows XP Professional client.
Thanks
Mark
____________________________________________
Mark Brittain
________________________________
This e-mail is the property of NaviSite, Inc. It is intended only for the
person or entity to which it is addressed and may contain information that is
privileged, confidential, or otherwise protected from disclosure. Distribution
or copying of this e-mail, or the information contained herein, to anyone other
than the intended recipient is prohibited.
_Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
