Thank you for all the great help and information Kelly! I didn't think about doing it in two mappings.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kelly Deaver Sent: Thursday, June 12, 2008 12:11 PM To: arslist@ARSLIST.ORG Subject: Re: AIE Escape Character? Update from BMC Engineering - Current IF THEN ELSE does not have a provision to support functions,so we cannot use any functions with exiting IF THEN ELSE syntax. Update from Me - Plan A = Add a filter that on submit or modify sets the field Login to Lower($login$) Plan B = do this with 2 mappings - 1. Query for Login = Null Do your set field "no login" 2. Query for Login Not Null Do your set field to function|lower($Login$) --------------------- Kelly Deaver [EMAIL PROTECTED] > -------- Original Message -------- > Subject: RE: AIE Escape Character? > From: [EMAIL PROTECTED] > Date: Thu, June 12, 2008 7:13 am > To: arslist@ARSLIST.ORG > > This looks right to me too. Just to test - > try a simple set field and specific in your qualification a record you know > has a login - VALUE = function|lower($Login$). Does that work? > If yes, try this next. (If not, file a support ticket ;) ) > Next - Try modifying the qualification query to $Login$ NOT Null and VALUE = > function|lower($Login$). Still work? > If yes, try this next. (If not, file a support ticket) > Now try building the statement gain, going with what you know. > STMT|IF $Login$ NOT NULL THEN > VALUE = function|lower($Login$) > ELSE > VALUE = "No Login" > ENDIF > > Hopefully, somewhere along the line you figure out what it doesn't like. If > not, it should definately go to support because some directions aren't clear > or you found a bug. > Do let us know what you find. > > --------------------- > Kelly Deaver > [EMAIL PROTECTED] > > > > -------- Original Message -------- > > Subject: AIE Escape Character? > > From: Brian Gillock <[EMAIL PROTECTED]> > > Date: Wed, June 11, 2008 11:41 am > > To: arslist@ARSLIST.ORG > > > > Hey Listers, > > > > I'm not positive what I'm trying to do is even possible, but > > here's what I'm working on. I'm doing an import of users from source X. > > Problem is X isn't completely reliable and some records are missing $Login$, > > also I want all logins to be lowercase if they do exist. I'm setting > > missing logins to "No Login" so I can fire notifications. Here is my > > mapping statement. > > > > > > > > STMT|IF $Login$ is NULL THEN > > > > VALUE = "No Login" > > > > ELSE > > > > VALUE = function|lower($Login$) > > > > ENDIF > > > > > > > > What I end up with if they have a login is > > > > > > > > function|lower( > > > > > > > > The AIE docs state that literals must be in double quotes, and I have other > > mappings that resolve VALUE = $field$, so I assumed using the function would > > be good. Is it possible to use functions within IF statements? Is there > > some escape character that I'm missing? > > > > > > > > ARS 7.1 patch 2 > > > > AIE 7.1 patch 2 > > > > Windows Server 2003 > > > > SQL Server 2005 > > > > > > > > Thanks! > > > > Brian > > > > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"