Whenever faced with a situation like you and I need to do stuff within the Remedy application, I so wish the table field had the ability to display information based on a Direct SQL...
There is a way to work around that but it would require the creation of views for a range of data lengths. These views could then be displayed by a dynamic table field based on user selection of length the user requires by selecting it from a menu. The limitation would be that you would require the user to input the data length from a menu so the user has the choice of selecting only a range of lengths and no other. The system would then be able to pick up the right view form to display on the dynamic table field each time the user picks a different value through workflow defined by you.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Tuesday, June 12, 2007 12:14 PM To: [email protected] Subject: Re: Read: Spam: Re: Checking for tickets with more than XXX characters in a field I didn't request a read receipt. On an afterthought, I probably could have worded the subject better. I'm guessing it went into his spam folder, he read it, for some reason it forwarded a receipt to the entire ARS List. I've seen this happen a few times before. Anyways, Norm suggest (off line) to just go directly to the database to look it up. This worked fine, I used the following query in MS SQL Server: SELECT Request-ID, Field, datalength(Field) from Database.Owner.Name where datalength(Field) > 3 Thanks to all who had constructive feedback :) -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shellman, David Sent: Tuesday, June 12, 2007 10:49 AM To: [email protected] Subject: Re: Read: Spam: Re: Checking for tickets with more than XXX character s in a field In that case I hope the person that requested the Read receipt gets one from each of us. Dave -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of L. J. Head Sent: Tuesday, June 12, 2007 11:41 AM To: [email protected] Subject: Re: Read: Spam: Re: Checking for tickets with more than XXX character s in a field Yup -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shellman, David Sent: Tuesday, June 12, 2007 9:38 AM To: [email protected] Subject: Re: Read: Spam: Re: Checking for tickets with more than XXX character s in a field Any one else get this read receipt? Dave -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dunn, Eric Sent: Tuesday, June 12, 2007 9:01 AM To: [email protected] Subject: Read: Spam: Re: Checking for tickets with more than XXX character s in a field Your message To: [email protected] Subject: Spam: Re: Checking for tickets with more than XXX characters in a field Sent: Tue, 12 Jun 2007 07:41:13 -0500 was read on Tue, 12 Jun 2007 08:00:45 -0500 ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ________________________________________________________________________ ____ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.472 / Virus Database: 269.8.14/845 - Release Date: 6/12/2007 6:39 AM No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.472 / Virus Database: 269.8.14/845 - Release Date: 6/12/2007 6:39 AM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
