[Date Prev] [Date Next] [Prev in Thread] [Next in Thread] [Date Index] [Thread Index]

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" <remedyissues@gmail.com> 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"