Hi Jason,
Maybe we should change the title of this thread even more...
FLTR:
- If you want to control something 100%, as ACTL can be bypassed.
Everything MUST be controlled by filters, if it DEPENDS on ACTLs I think
it is bad design.
- If corresponding ACTLs would access the server many times (do multiple
API-calls in loops or when displaying entries)
ACTL:
- Fancy stuff that helps the user in the GUI (and in the best case does
not access the server)
- Give users errors/warnings before it gets to the server (but make sure
you have the controls in place in FLTRs as well!)
- Some cases that could give ARERR 298 (Too many filters processed...) can
be put in ACTL, as a Push-Fields that updates thousands of records will do
one API-call per record. In this case it is good.
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> This might start a whole new debate (and kind of what I am looking to
> do)... I remember learning that train of though (use an AL to run on the
> client and use their resources when you can and built filters only when
> you
> have to) but I have started to hear the opposite over the last few
> years...
> Let the server do the work. I think part of it is that server are so fast
> now days and also with server groups you can have multiple load balanced
> AR
> server to share the load. With the move to all web clients, ultimately a
> server will end up doing the work whether it is an MT server or an AR
> server.
>
> We are people's thoughts on this?
>
> Jason
>
> On Thu, Apr 15, 2010 at 3:39 PM, cpgold <[email protected]> wrote:
>
>> ** Does it have to be a filter, an active link is much better suited for
>> this type of processing than to let the server handle it.
>>
>>
>> On Wed, Apr 14, 2010 at 1:58 PM, Joe D'Souza <[email protected]> wrote:
>>
>>> I do not have access to an Oracle instance at the moment to try it, but
>>> I'm
>>> quite sure that
>>>
>>> update tablename set columnname = REPLACE('Does work', 'Does ', NULL);
>>> commit;
>>>
>>> would update the column to 'work'. Which is ideally what you would want
>>> it
>>> to..
>>>
>>> With MS-SQL it sets the column to NULL.
>>>
>>> Joe
>>>
>>> -----Original Message-----
>>> From: Action Request System discussion list(ARSList)
>>> [mailto:[email protected]]on Behalf Of Jim Fox
>>> Sent: Wednesday, April 14, 2010 2:03 PM
>>> To: [email protected]
>>> Subject: Re: Extracting digits from a character field
>>>
>>>
>>> You mean works incorrectly. LOL.
>>>
>>> F
>>> Sent from my Verizon Wireless BlackBerry
>>>
>>> -----Original Message-----
>>> From: Joe D'Souza <[email protected]>
>>> Date: Wed, 14 Apr 2010 13:25:31
>>> To: <[email protected]>
>>> Subject: Re: Extracting digits from a character field
>>>
>>> You are right, I just tried and it sets the whole column to NULL
>>> instead
>>> of
>>> just replacing the specific characters in expression 2 to NULL.. It
>>> works
>>> correctly in Oracle to the best of my knowledge..
>>>
>>> Joe
>>>
>>> -----Original Message-----
>>> From: Action Request System discussion list(ARSList)
>>> [mailto:[email protected]]on Behalf Of Jim Fox
>>> Sent: Wednesday, April 14, 2010 1:00 PM
>>> To: [email protected]
>>> Subject: Re: Extracting digits from a character field
>>>
>>>
>>> Replaciing a character with Null is an oxymoron in MS-SQL. You would
>>> replace
>>> a character with a zero-length string. Null and "" are not the same.
>>>
>>> Fluxman
>>> Sent from my Verizon Wireless BlackBerry
>>>
>>> -----Original Message-----
>>> From: Joe D'Souza <[email protected]>
>>> Date: Wed, 14 Apr 2010 11:42:21
>>> To: <[email protected]>
>>> Subject: Re: Extracting digits from a character field
>>>
>>> Jim,
>>>
>>> Just curious.. What are the limitations that you encountered replacing
>>> a
>>> character or a string with NULL on MS-SQL.. And what version of
>>> MS-SQL??
>>>
>>> Joe
>>>
>>> -----Original Message-----
>>> From: Action Request System discussion list(ARSList)
>>> [mailto:[email protected]]on Behalf Of Jim Fox
>>> Sent: Wednesday, April 14, 2010 11:12 AM
>>> To: [email protected]
>>> Subject: Re: Extracting digits from a character field
>>>
>>>
>>> On MS-SQL, trying to replace one character with Null is not a good
>>> idea.
>>>
>>> Fluxman
>>> ------Original Message------
>>> From: Joe D'Souza
>>> Sender: Action Request System discussion list(ARSList)
>>> To: [email protected]
>>> ReplyTo: [email protected]
>>> Sent: Apr 14, 2010 11:07
>>> Subject: Re: Extracting digits from a character field
>>>
>>> If you are in an Oracle database, use the function TRANSLATE to replace
>>> all
>>> Alpha characters with either NULL or space or whatever else you wish
>>> to..
>>> This will leave the string with only special characters and numerical
>>> characters..
>>>
>>> I am not sure if TRANSLATE works on MS-SQL but you could give it a shot
>>> if
>>> MS-SQL is your underlying database.
>>>
>>> Joe
>>>
>>> -----Original Message-----
>>> From: Action Request System discussion list(ARSList)
>>> [mailto:[email protected]]on Behalf Of Atul Vohra
>>> Sent: Wednesday, April 14, 2010 9:42 AM
>>> To: [email protected]
>>> Subject: Extracting digits from a character field
>>>
>>>
>>> I have a free form character field and need to extract digits from that
>>> field - may be in a filter? Am on v7.1, oracle.
>>>
>>> Any one has some function they used (like in sql or may be combination
>>> of
>>> strstr??) Looks painful to me.
>>>
>>> Help please
>>>
>>> Atul
>>>
>>>
>>> _______________________________________________________________________________
>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>>>
>>
>> _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
