Re: Validate 2 character fields using LIKE
Hi,
You say VALIDATE which seems to indicate that you are running filters in Form A
on a transaction, and you need to validate that the last word of field A can be
found in Form B. Right?
In that case I would suggest that you parse out the last word of the field in
Form B and store "DEF" in a separate field of Form B called
'LastWordFormB-Field'.
You then perform the same operation on Form A during your transaction and store
the last word in form A in a temp-field. Then you search for
('LastWordFormB-Field' = $temp-field$)
You do not even need a LIKE operation.
If you do not want to store the last word you will validate from, you can skip
that part and instead do this search:
'FormB-Field' LIKE "%" + $temp-field$
But you will have to parse out the last part of the string before running a
search. Like will not do this for you.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13)
* 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
November 7, 2016 7:54 PM, "Kaur" wrote:
> Hi all,
>
> I need to write a qualification to validate a field in form A against a field
> in form B using "%"
> and LIKE.The qualification I have written is
>
> $fieldA$ LIKE "%"+'fieldB'+"%" , where
>
> fieldA- field in form A
> fieldB -field in form B
>
> fieldA= ABC DEF
> fieldB= XYZ DEF
>
> I need to do a partial search on the basis of 'DEF'
>
> Please help me in solving this.
>
> Thanks!!
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
Re: Validate 2 character fields using LIKE
Kaur, Your search will only find all of Field-B in Field-A You can search for: "%" + "DEF" + "%" in either field. What are you trying to accomplish with this search? Joel Joel Sender * jdsen...@earthlink.net * 310.829.5552 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kaur Sent: Monday, November 7, 2016 10:52 AM To: arslist@ARSLIST.ORG Subject: Validate 2 character fields using LIKE Hi all, I need to write a qualification to validate a field in form A against a field in form B using "%" and LIKE.The qualification I have written is $fieldA$ LIKE "%"+'fieldB'+"%" , where fieldA- field in form A fieldB -field in form B fieldA= ABC DEF fieldB= XYZ DEF I need to do a partial search on the basis of 'DEF' Please help me in solving this. Thanks!! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Validate 2 character fields using LIKE
Hi all, I need to write a qualification to validate a field in form A against a field in form B using "%" and LIKE.The qualification I have written is $fieldA$ LIKE "%"+'fieldB'+"%" , where fieldA- field in form A fieldB -field in form B fieldA= ABC DEF fieldB= XYZ DEF I need to do a partial search on the basis of 'DEF' Please help me in solving this. Thanks!! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: ADM:timing test
Let's keep our fingers crossed ;-) Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * 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 (http://rrr.se) November 7, 2016 6:41 PM, "Jason Miller" wrote: **Hi Dustin, It is certainly nice to get a confirmation that things are working as expected. Although I am not looking for a reply from everybody, one or two are great. No need for a timing test to be the longest thread of the week :) Jason On Mon, Nov 7, 2016 at 9:07 AM, Fawver, Dustin wrote: ** Jason, I didn't know if you needed a reply to this ping, but here's mine. --Dustin Fawver HelpDesk Technician East Tennessee State University (423) 439-4648 (javascript:false) From: Action Request System discussion list(ARSList) on behalf of Jason Miller Sent: Monday, November 7, 2016 11:34 AM To: arslist@ARSLIST.ORG (mailto:arslist@ARSLIST.ORG) Subject: ADM:timing test **Happy Monday List! _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: ADM:timing test
Hi Dustin, It is certainly nice to get a confirmation that things are working as expected. Although I am not looking for a reply from everybody, one or two are great. No need for a timing test to be the longest thread of the week :) Jason On Mon, Nov 7, 2016 at 9:07 AM, Fawver, Dustin wrote: > ** > > Jason, > > > I didn't know if you needed a reply to this ping, but here's mine. [image: > 😊] > > > --Dustin Fawver > > > HelpDesk Technician > > East Tennessee State University > > (423) 439-4648 > > > -- > *From:* Action Request System discussion list(ARSList) < > arslist@ARSLIST.ORG> on behalf of Jason Miller > *Sent:* Monday, November 7, 2016 11:34 AM > *To:* arslist@ARSLIST.ORG > *Subject:* ADM:timing test > > ** > Happy Monday List! > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: ADM:timing test
Hi, Fortunately for me, but maybe unfortunately for the list, the server seems just fine. It is the actual postings that are lacking ;-) Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * 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 (http://rrr.se) November 7, 2016 6:08 PM, "Fawver, Dustin" wrote: Jason, I didn't know if you needed a reply to this ping, but here's mine. --Dustin Fawver HelpDesk Technician East Tennessee State University (423) 439-4648 From: Action Request System discussion list(ARSList) on behalf of Jason Miller Sent: Monday, November 7, 2016 11:34 AM To: arslist@ARSLIST.ORG (mailto:arslist@ARSLIST.ORG) Subject: ADM:timing test **Happy Monday List! _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: ADM:timing test
Jason, I didn't know if you needed a reply to this ping, but here's mine. [😊] --Dustin Fawver HelpDesk Technician East Tennessee State University (423) 439-4648 From: Action Request System discussion list(ARSList) on behalf of Jason Miller Sent: Monday, November 7, 2016 11:34 AM To: arslist@ARSLIST.ORG Subject: ADM:timing test ** Happy Monday List! _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
ADM:timing test
Happy Monday List! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
