I believe it is the same on 7.0.1 for Oracle 10G (and I would expect it to be the same for 7.1 since some of the details are dependant on how it is stored in the database, and I think 7.X is recent enough that Oracle hasn't changed enough to alter that ). However, you are now mentioning testing the field against the data base stored value, whereas I would expect you to merely test the separate new field before you set tot to the Diary field for the <something or nothing>[<something>]<something or nothing>. So, you have the field that you enter new diary entries into that is not a diary field, test it for the %[%]% (where % means a string or not) and then set it to the diary field in a filter. I suggest the filter unless having the brackets is an error that the end user needs to know about. If it is a case of wanting to remove them because it causes an issue, or to take what is between the brackets and store it elsewhere, then the filter is more efficient. Active Link for feedback and reentry, filter for merely altering what is stored. Well, that uses up my usefull posts for 2008 (Friday humour). ... Daniel
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Robert Molenda Sent: January 11, 2008 7:21 PM To: [email protected] Subject: Re: LIKE Operator ** Diary fields are a bit odd, since you are talking about Active Links, I will only discuss those for certainty of clarity. I assume that you are executing your AL on "Loose Focus" for the 'diary' field, and you are true, it executes on the CLIENT with the data that IS IN the field currently, NOT what is in the previous 'diary entries'. (after submit / after modify the 'diary field' will be NULL) In order to test the 'diary contents' in AL's you must have a seperate 'unlimited character field' (length 0) and then set-fields the contents of the diary field into that field, and then you can test that field against the data-base-stored-value via your Char-0 field.. Just ensured that it still works this way on 7.1 HTH On Jan 11, 2008 3:47 PM, Guillermo Alfredo Torres Barron <[EMAIL PROTECTED]> wrote: ** Hi Yes, only I care about the current new information being added to the Diary Field for the user in that moment. We have AR Server 7.0.1 patch 005, OS Solaris 9 and Oracle 10g database I want to know if this correct uses this condition in a Run IF Active Link or a filter; I know that Run IF conditions are evaluated in memory, not in database Thanks Greetings _____ De: Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] En nombre de arslist Enviado el: Viernes, 11 de Enero de 2008 03:10 p.m. Para: [email protected] Asunto: Re: LIKE Operator Maybe I am in a fog because it is Friday afternoon, but a Run If on an Active Link seems like local processing not a database query? If it were a filter with DB.<whatever> okay, but then we also get into it being a Diary Field, which brings up a bunch of other considerations, so I will assume he only cares about the current new information being added to the Diary field. [we may need some clarification]. Version/DB would help, FTS as well. ... Dan _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: January 11, 2008 1:00 PM To: [email protected] Subject: Re: LIKE Operator ** Same thing, a query to the db is a query to the db. Axton On Jan 11, 2008 12:47 PM, Guillermo Alfredo Torres Barron <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > wrote: Hi dear lister I want to use this qualification in an active link condition (Run If) 'Diary Field' LIKE "%[']%" OR 'Diary Field' LIKE "%[|]%" OR 'Diary Field' LIKE "%[""]%" Can I have problem with this qualification on the performance of my remedy server?, in others words, this qualification will full scan on the database?, what happen if use in a filter? Thanks in advance Greetings ............................................................................ ............... Este correo electronico es confidencial y/o puede contener informacion privilegiada. Si usted no es su destinatario o no es alguna persona autorizada por este para recibir sus correos electronicos, NO debera usted utilizar, copiar, revelar, o tomar ninguna accion basada en este correo electronico o cualquier otra informacion incluida en el, favor de notificar al remitente de inmediato mediante el reenvio de este correo electronico y borrar a continuacion totalmente este correo electronico y sus anexos. Nota: Los acentos y caracteres especiales fueron omitidos para su correcta lectura en cualquier medio electronico. This e-mail is confidential and/or may contain privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any other information herein, please advise the sender immediately by reply this e-mail and delete this e-mail and its attachments. ............................................................................ ............... ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org <http://www.arslist.org/> Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" __Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" html___ ............................................................................ ............... Este correo electronico es confidencial y/o puede contener informacion privilegiada. Si usted no es su destinatario o no es alguna persona autorizada por este para recibir sus correos electronicos, NO debera usted utilizar, copiar, revelar, o tomar ninguna accion basada en este correo electronico o cualquier otra informacion incluida en el, favor de notificar al remitente de inmediato mediante el reenvio de este correo electronico y borrar a continuacion totalmente este correo electronico y sus anexos. Nota: Los acentos y caracteres especiales fueron omitidos para su correcta lectura en cualquier medio electronico. This e-mail is confidential and/or may contain privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any other information herein, please advise the sender immediately by reply this e-mail and delete this e-mail and its attachments. ............................................................................ ............... __Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
