Re: OLE spell check active link and performance

This will not impact the server at all. It uses the local client to run and the local MS Word spell check. On Mar 11, 12:13 pm, remedy lee wrote: > Hi, > > I'm using the OLE spell check active link in the Integrating guide. > > I'm wondering if this would have an impact on performance. > I'm pre

Re: Advance Interface Form - really basic question

In that case you dont need to keep OOB workflow attached to your AIF as its duplicate. Yes, disassociate the original Active Links from your AIF.(dont delete). Let me know, if answers your question - Vinay Vermani On Fri, Mar 12, 2010 at 2:41 PM, Christine wrote: > Vinay, > > Thanks for your

Truncate the Distributed Pending tables

All, Due to some runaway workflow (which I've since disabled) I ended up with 2.5 million records in the Distributed Pending table. This is after manually whittling it down from 3.5 million, 1 at a time, via the User client. Given the current transfer rate, it would take 10 days for the rema

Re: Retriving the application name for a form

LJ, just wanted to let you know that I implemented your suggestion, and it works great. For the forms we currently care about, there is no perceptible delay while I determine the group to use from the role. Thanks again for the suggestion! Lyle From: Action Request System discussion list(ARS

[no subject]

http://sites.google.com/site/lkj8hgshd/gnsw3k _ Got a cool Hotmail story? Tell us now http://clk.atdmt.com/UKM/go/195013117/direct/01/ _

Change Template Not Triggering Approvals

We have created an approval mapping record & a change template. The Change Template has some tasks associated to it. But when I select the change template the approval mapping does not get triggered. But If I manually create a change with the EXACT same categories it works. Then I created a cha

Re: ODBC Driver 7.1

Hello, Yes, Kim Olds gave me the fix. Thanks again Kim! If you are using the 64 bit version – you can try this to configure the ODBC driver. It worked for our 64 bit Vista and 7 installs. Go to C:\Windows\SysWOW64 and right click on odbcad32.exe and run as administrator. This lets you enter the

Re: ODBC Driver 7.1

Hi, did you ever find the solution to this? I'm having the exact same problem... Pargeter, Christie :CO IS wrote: > > Hi All - I am trying to install the Remedy User Tool (7.1 p 6) and when > I go to the ODBC Data Source Admin console and try to add a System DSN I > can't find the AR System ODBC

Re: Advance Interface Form - really basic question

Vinay, Thanks for your response. I had already done all the copies of forms, ALs, Filters and Guides. (The manual says to make copies of everything - forms, ALs, filters and guides that are associated with the original form.) My question is do I disassociate the original Active Links and keep only

Announce - Ruby API for Remedy

Quite awhile ago I wrote a Ruby API for Remedy -- I always intended to share it -- but never got the time. Today -- I made the time. Is it perfect - no. Is it documented - no. Does it work - yes. Works with ARS 7.5 back to 6.00. Requires Kinetic Link (free/open source) get it here: http:/

Re: Audit Log data

When upgrading to CMDB 7.6p1 you receive a warning saying that you need to remove any indexes prior to upgrade so keep that in mind as well. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Friday, March 12, 2010 1:58 PM To: arslis

Re: Audit Log data

I have two indexes on the form. One on "Original Request ID" and another on "Log Key 1". Log Key 1 is probably more significant, because I believe that's the field that gets joined to when viewing the Audit Log in the application. Lyle From: Action Request System discussion list(ARSList) [ma

Re: Audit Log data

What field did you add an index on? Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Friday, March 12, 2010 2:46 PM To: arslist@ARSLI

Re: Audit Log data

Yep, I noticed that too. That's a nasty omission IMO. In our case, adding an index took it down to subsecond query times when viewing the audit log. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Matt Reinfeldt Sent: Friday, March 12, 2010

Re: Audit Log data

As an aside. has anyone else noticed that OOB these forms have no indexes? So, if you have a large number of Incidents with lots of activity and you try to 'View Audit Log', it may take a while to open up (I've seen up to 45 seconds or more!).. Adding a single index to the underlying HPD:HelpDesk_A

Re: OT - Junior Remedy Developer - Washington DC (UNCLASSIFIED)

Classification: UNCLASSIFIED Caveats: NONE I agree, a foot in the door beats an unemployment check. However, of the three candidate descriptions the only one that seems viable is the 1yr w/degree. I would imagine that by the time a person gets 6 years of experience they should be at a maturity poi

Re: Audit Log data

Remember that as of 7.5 when you create/ modify a CTM:People record a new BMC_Person is created in the Sandbox then reconciled into BMC_Person. We found out when we ran our People update job and ground the system to a halt due to the reconciliation job running "inline" instead of "scheduled". F

Re: ITSM 7.1 - Change Management

This sounds like a browser caching issue to me - like it's mixing old and new javascript. I would recommend having the user log out, flush their browser's cache (delete temporary internet files) and log in again and try again. I think you general see errors similar to this most often after mig

Re: Audit Log data

If you truly do not use it, then don't bring it over. You are right that imports should create a new audit record for those entries, so nothing should be broken by not importing the old data. You just lose that information. Anne Ramey From: Action Request System discussion list(ARSList) [mai

Audit Log data

We are in the process of testing the move of all necessary data from an ITSM 7.0 system to an ITSM 7.6 system, which we will have to do again or at least update prior to moving the 7.6 system into production. Several of the tables with data are the three aliased identically (by some clueless BM

Re: Auto sending out word document from Remedy.

Wellyou could as you suggested use OLE/DDE to generate the filethis process would require storing the template on the server, getting it to the client machine, edit/save the fileyou could then save that file to an attachment field on the form, then kick off a notification via filter

Re: OT - Junior Remedy Developer - Washington DC

I am going to jump in on this. The reply to Joshua Kitchen's listing was not intended for this list. This was intended to be a forwarded to a personal friend I had just had the salary conversation with. My apologies if this offended anyone. I guess if I knew how to use Outlook and knew the di

Re: OT - Junior Remedy Developer - Washington DC (UNCLASSIFIED)

A junior position is still a step in the right direction for someone who is a geek at Best Buy(no insult intended) and trying to better himself. You get in, you prove yourself, and your salary goes up or you move on with more experience to the next position. The position can be a resume builde

Re: Auto sending out word document from Remedy.

Thanks for the recommendation, but Perl is a complete new language for me. Is there any other way to do it? Thanks, Huiqing From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Friday, March 12, 2010 10:27 AM To: arslist@ARSLIS

Re: Retriving the application name for a form

Glad I could be of use to someone today :) _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Friday, March 12, 2010 10:55 AM To: arslist@ARSLIST.ORG Subject: Re: Retriving the application name for a form ** Perfectly. I

Re: OT - Junior Remedy Developer - Washington DC

now that's Friday humor :D _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Tommy Morris Sent: Friday, March 12, 2010 10:46 AM To: arslist@ARSLIST.ORG Subject: Re: OT - Junior Remedy Developer - Washington DC ** My oldest daughter and I

Re: Retriving the application name for a form

Perfectly. I like it. You're brilliant, LJ! Thanks! Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Friday, March 12, 2010 10:40 AM To: arslist@ARSLIST.ORG Subject: Re: Retriving the application name for a form ** This migh

Re: Remedy 7.6 ITSM Suite documents

Thanks a lot. I confirm that I can see that. Cheers! Arnab On Fri, Mar 12, 2010 at 11:05 PM, Matt Reinfeldt wrote: > ** > > I have seen it here: > http://webapps.bmc.com/support/faces/prodversion.jsp?prodverseqid=175293 > > > > Obviously, you’ll need a Support ID to get in… but you have that. >

Re: OT - Junior Remedy Developer - Washington DC

My oldest daughter and I were discussing our day at work (she is the banking industry) and she looked at me and said "I still don't understand what you do." I replied, "I don't either. That's what makes it so fun." From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org

Re: Is there an extract file that can be produced from Remedy that will list FIELD / ID per form? :

Hi Howard, Abydos Analyser can produce this report easily. The Produce Documentation function can be customised to produce an Excel spreadsheet listing all the fields and their IDs on a single form. Let us know if you'd like to learn more or check out our YouTube channel. http://www.you

Re: OT - Junior Remedy Developer - Washington DC

As a girl who started coding (in basic) back in grade school, I'd have to say that thinking programming is cool could definitely be a girl thing. Anne Ramey From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Friday, March 12, 2010 12

Re: OT - Junior Remedy Developer - Washington DC (UNCLASSIFIED)

Classification: UNCLASSIFIED Caveats: NONE I don't think anyone is saying that they would prefer to starve than work at that rate but from what I've seen 65k is the median rate for a Junior Remedy Dev in my area and the cost of living locally is about half that of the DC area. Add in the requireme

Re: Retriving the application name for a form

This might get a bit complicated...but you have the role ID from the formyou should be able to look in the role form and find out what applications that role belongs to...it doesn't NEED to be unique, but might be, if it's unique then you already have the mapping from role to group and you can

Re: Junior Remedy Developer - Washingotn DC

Good thing is, it gets you a Clearence On Thu, Mar 11, 2010 at 5:27 PM, Dan Wangler wrote: > ** > > Mano > > > > See. Some people don’t want to pay much for ARS developers. > > > > DAn > > > > Dan Wangler > > da...@swbell.com > > 972-979-1970 (Cell) > > http://www.linkedin.com/in/danwangler

Re: Remedy 7.6 ITSM Suite documents

I have seen it here: http://webapps.bmc.com/support/faces/prodversion.jsp?prodverseqid=175293 Obviously, you'll need a Support ID to get in. but you have that. Enjoy, Matt R. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Arnab Baral

Re: OT - Junior Remedy Developer - Washington DC

I can't get my kids to think programming is coolmaybe it's a girl thing... _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault Sent: Friday, March 12, 2010 10:26 AM To: arslist@ARSLIST.ORG Subject: OT - Junior Remedy Devel

Re: Remedy 7.6 ITSM Suite documents

it's definitely there, I just checked it Guillaume From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of Arnab Baral [arnab...@gmail.com] Sent: Friday, March 12, 2010 12:12 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy 7.6 ITS

Re: Retriving the application name for a form

It shouldn't be, but realistically, I need to do it for every application if I want the full set of data, and while each individual application doesn't take too long, getting them all takes a good 30 seconds or so. That wouldn't be so bad, except that that's happening as the result of a user in

OT - Junior Remedy Developer - Washington DC

Interesting Remedy skills being passed from generations, like a craft in the middle ages With the cost of college education going up continuously, and seeing no end in sight to this trend, and on top of that getting a degree that does not provide you with the necessary education and skills f

Re: OT - Junior Remedy Developer - Washington DC

** Also, I'd think that having a security clearance would have a value that should be factored into deciding if this were an acceptable wage.  I've never delved into government work, so I don't know how much value that has, but its gotta be worth something. Thad Esser Remedy Developer From: D

Re: Workflow newbie

What about doing your check with Active Links instead? That way, you can stop the save action before it gets to the server and change the status of the ticket in the display back to what you want. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf

Re: Remedy 7.6 ITSM Suite documents

Its not available. Can you confirm that you have seen it? Regards Arnab On Fri, Mar 12, 2010 at 9:11 PM, Guillaume Rheault wrote: > ** > Why not download them from the BMC support web site? > > Guillaume > -- > *From:* Action Request System discussion list(ARSList)

Re: SRM Error trying to create Process Definition Template

I meant to post this earlier but it had something to do with the data visualizer. Added a different version and all is well Sent from my iPhone On Mar 11, 2010, at 5:13 AM, Simon Urquhart > wrote: ** Hi Kevin, Have you considered using Abydos Designer as an alternative ? This would pro

Re: SRM Error trying to create Process Definition Template

Hi Kevin, Have you considered using Abydos Designer as an alternative ? This would provide you with more flexibility to create whatever SRM processes you need without having to create any PDTs or AOTs Please visit the Abydos website at www.abydos-workflow.com

Workflow newbie

Good morning, I have created 2 Filters that run against any non-Standard Change Request. The first filters executes on "Modify" and the Run If statement is: ( 'Change Request Status' > "Planning In Progress") AND ('Change Type' != "Standard Change") If true it reads a filed from anothe

Re: Advance Interface Form - really basic question

According to me, OOB worflow for AIF is shared workflow and you should attach them to the copied forms. E.g. To make a new AIF. I will open SRS:AdvancedInterface_WithBackendMapping and Save as SRS:AdvanceInterface_MyNewAIFName(to make a copy). Select all the Activelinks and Edit them to attach to

Re: ITSM 7.1 - Change Management

But wouldn't it happen to every one using the web? And all the time? Atul Vohra -Original Message- From: "Pargeter, Christie :CO IS" [cparg...@lhs.org] Date: 03/12/2010 10:00 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7.1 - Change Management This means the Search Results List for the

Advance Interface Form - really basic question

I am testing the use of Advanced Interface forms. I’ve followed the instructions in the SRM 2.2 Admin manual (appendix A) – copied the form SRS:AdvancedInterface_WithBackend Mapping to a new form with a naming convention for our use (pg 341). This is the only form I copied. I then copied the workfl

Robert02 Kern is out of the office.

I will be out of the office starting 12.03.2010 and will not return until 17.03.2010. Hello. Im on business trip with limited email access. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www

Re: OT - Junior Remedy Developer - Washington DC

Claire, I agree completely. I have two sons who like what I do for a living and are learning the ropes and writing their first applications. This is just the kind of post they'll be responding to with a little more experience. Keep them coming! BTW, I just got back from two weeks on the beach

OT - Junior Remedy Developer - Washington DC

(Disclaimer) It is Friday and I am cranky! People need to stop bashing and attacking the people who post jobs here. I am not looking for a job now, but I would appreciate their posts if I was I would think that for those looking for work, something is better than nothing. It is a Junior positi

Re: Remedy 7.6 ITSM Suite documents

Why not download them from the BMC support web site? Guillaume From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of Arnab Baral [arnab...@gmail.com] Sent: Friday, March 12, 2010 5:20 AM To: arslist@ARSLIST.ORG Subject: Remedy 7.6

Re: Need to throw custom error message on attachment size

The only way I think this is possible is to localize the system error message catalog and to modify the message in form "AR System Message Catalog" To localize the system error message catalog, do this: In Server Information , in the Advanced tab, check the Localize Server checkbox. You may need

Re: White screen on refresh

Mark, With regards to the admin tool, I have noticed that if your server window is set to active links and you modify and save an active link, the save takes longer, as the objects in the server window are refreshed in the background. If you haven't selected a specific object type in the server

Re: Auto sending out word document from Remedy.

I would recommend looking into Perl's com interfacethere should be examples online on how to open and edit office files through perlthen you can use ARSPerl to get the info out of remedy and use perl's smtp interface to email the files out. _ From: Action Request System discussion

Re: Retriving the application name for a form

Lyle, Based on my short research this morning, I don't believe that the form knows what application it's a member ofnot independently at least. The process of pulling the applications and doing something similar to a '.contains()' on the form list shouldn't be too time consuming. _ F

Custom CSS Styles

We're using AR System 7.1 p5, Mid-Tier 7.1 p5 with Tomcat 6.0. I've been trying to change a single form to utilize custom CSS styles for the field tags. This form will be displayed during briefings and they want the font size for the fields to be larger than the default. This form is not part o

Re: ITSM 7.1 - Change Management

This means the Search Results List for the web has been corrupted. Remove all the fields and rebuild. Last time this happened I removed all but one field then used migrator to rebuild the whole thing, worked fine after the rebuild. -Original Message- From: Action Request System discussio

ITSM 7.1 - Change Management

All, One of our customer has ARS v7.1 and ITSM 7.1 When they try to save a change request (some times) get the following 'Caught exeception: 't.LoadResultsList' is null or not an object This is all on mid-tier (tomcat / IIS) Atul Vohra _

OLE spell check active link and performance

Hi, I'm using the OLE spell check active link in the Integrating guide. I'm wondering if this would have an impact on performance. I'm pretty sure that it shouldn't since the OLE is a client command. I built the spell check on the HPD:Help Desk notes field. Thanks for the help

OT Friday Humor: Special Letter from Mother to Son

Dearest Redneck Son, I'm writing this slow because I know you can't read fast. We don't live where we did when you left home. Your dad read in the newspaper that most accidents happen within 20 miles of your home, so we moved. I won't be able to send you the address because the last West Virg

Re: Junior Remedy Developer - Washingotn DC

Mano See. Some people don't want to pay much for ARS developers. DAn Dan Wangler da...@swbell.com 972-979-1970 (Cell) http://www.linkedin.com/in/danwangler From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]

ARERR [552] Failure during SQL operation to the database : ORA-04063:view "ARADMIN.T2179" has errors

Hi All, I created a view form on a DB table , while i am trying to do a search on the form i see the below errror *ARERR [552] Failure during SQL operation to the database : ORA-04063:view "ARADMIN.T2179" has errors"* * *has someone seen this issue before? how can i debug the same?? -- Regards

Re: Help Please - Crystal 10 problem

Brian, You may need to go into each report with Crystal Designer (Developer whatever it's called) and "Verify Database" or even use the Update Data Source location. I've had to do these tasks when moving reports to new systems. HTH, --- John J. Reiser Senior Software Development Analyst Reme

OLE spell check active link and performance

Hi, I have created the OLE spell check plug in found in the integrating guide. It works well but I'm wondering if it will have any impact on performance on the server. My understanding is that it shouldn't since everything is run on the client's machine. However, I read that there are some OLE tha

Re: Help Please - Crystal 10 problem

Also when I enter valid credentials it just keeps prompting me again and again. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rod Harris Sent: Thursday, March 11, 2010 12:45 AM To: arslist@ARSLIST.ORG Subject: Re: Help P

ARERR [552] Failure during SQL operation to the database : ORA-04063:view "ARADMIN.T2179" has errors

Hi All, I created a view form on a DB table , while i am trying to do a search on the form i see the below errror *ARERR [552] Failure during SQL operation to the database : ORA-04063:view "ARADMIN.T2179" has errors"* * *has someone seen this issue before? how can i debug the same?? -- Regards

Remedy 7.6 ITSM Suite documents

Hi Listers, Does anybody have Remedy 7.6 ITSM Suite documents? If yes please share them or let me know the links. Its very urgent. Regards Arnab ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug1

AR Email incoming mailbox

All, We are on ARS v7.5 p4 on a windows 2003 server. I have configured 2 incoming mailbox and 1 outgoing mailbox. When I disable the incoming mailbox configuration records, outgoing works. To debug this issue, I ran ar email in debug mode using the EmailStart.bat file and found that after conne

Re: Unable to select desired "key field" for View form

Renjini, The key field must meet a variety of very specific conditions. What you are seeing is that there are 6 fields on the table that meet the specific criteria for being a key. The field you want to select does not meet those criteria. Now, the criteria have changed over time. You did no

Re: test

Did you pass? Dave - dave.shell...@tycoelectronics.com (Wireless) From: Action Request System discussion list(ARSList) To: arslist@ARSLIST.ORG Sent: Fri Mar 12 05:04:02 2010 Subject: test ** _Platinum Sponsor: rmisoluti...@verizon.net ARS

Re: Unable to select desired "key field" for View form(resolved)

Hi All, Thank you for the help and suggestion. I was using Admin tool V7.5 when i was seeing this error. I went back and downloaded Admin V7.1 and its working fine there. I am able to select the desired field as key field. Regards Renjini On Wed, Mar 10, 2010 at 11:24 AM, LJ Longwing wrote: >

Change Mgmt Approval Status Closed Issues

Dears, I have issue when users submit the change request some of the change requests become scheduled and the Approval Status ( Closed ) , and the Audit log for these cases *change Request Status =* Request for Authorization , then find out that the change status is Scheduled and this not recorded

Slow updating associations

I'm having a problem where if I have a relationship between a CI and a change or incident, if I update the CI, it takes anywhere between 5 minutes and 5 hours for the updates to show in the change/incident. The CMDB Association is being updated immediately, but the Change or Incident Associatio

Re: Status = Assigned

This really goes against best practices; if possible I would push back :) Assigned typically implies "Ownership and/or responsibly" has been established Proper notification goes to the Assigned to Group or Individual Work In Progress implies - Active Work is being performed on the "Issue" that not

Re: Trial license for BMC

Hi David, Tried to follow almost all the steps below and it did not work. The only thing I am left with is contact BMC customer support for the same. I will try to do that and will update all Regards Arnab On Wed, Mar 10, 2010 at 8:36 PM, Easter, David wrote: > ** > > Some things you can try:

Auto sending out word document from Remedy.

All, I am working on a requirement that whenever a user closes a Remedy ticket, system should automatically email customer a word document (content of the word document is coming from the Remedy ticket) I have some idea of auto generating word document: * create a word template

CMDB 2.1.00 patch 003

I am in the process of customising the CI relationship viewer. In the BMC.CORE.CONFIG:BMC_UIComponent you can define a list of attributes you want shown up when hovering (if this is the correct word to use) with the mouse over the CI Icon. Is there anyway you can either not show the attribute na

test

___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: Zen of Aeroprise - Resolved

** Thank you to the person that helped me off-list.  For posterity, here was the fix: - The ‘Advanced Search’ is one of the fields in the list of options. If you don’t see it – do this: 1. Login to Admin Console 2. Go to Manage Groups -> Modify Group . Select the Group Name that this rule is

Re: Unable to do a Change Field Action-Attaching Menu to Character field

Raj, Is it really a character menu that you are attaching? If it is a search or sql menu you may have a qualification problem. Have you tried attaching the menu to the field attributes just to make sure the menu will work with the field? --- John J. Reiser Senior Software Development Analyst

Re: Trial license for BMC

Hi Jason, ARS ver. 7.0.3 CMDB ver 2.0 OS : Windows XP The first time when I went ahead with the installation everything was fine. But once the license expired the issue started. Regards Arnab On Wed, Mar 10, 2010 at 9:53 PM, Jason Miller wrote: > ** Hi Arnab, > > You didn't mention what versio

JSP errors on Mid Tier

Hello, This morning my mid tier was displaying JSP errors when trying to access incident module or change module. I couldn't even flush the cache via the Mid Tier Config Tool.. I had to restart IIS. What logs should I check to see what happened? Thanks, Marcelo Martinez ___

Retriving the application name for a form

Hi all, Does anyone know of a way to determine what application a given form belongs to using the Remedy API? So far, the best I've come up with is to pull a list of all the applications and then pull a list of forms for each application and then load that into a lookup data structure. That w

Status = Assigned

I've been asked to look into disabling how an Incident status changes to "Assigned" if one support group assigns the ticket to another support group (or person in a different support group). The request from management is that once the incident is in "work in progress" status, it should stay tha

Re: White screen on refresh

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 thi