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] > > 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 > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > > __Platinum Sponsor: 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 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"
