Hi,
I am not completely sure I follow your requirements, but this is what the
EXTERNAL() keyword is used for.
It is used when querying the database.
For example you could do the following three things which would give exactly
the same result :
ACTL A:
Action 1: Set-Fields from form User:
('Login Name' = "miz")
fullname = $Full Name$
ACTL B:
Action 1: Set-Fields from form User:
EXTERNAL("'Login Name' = ""miz""")
fullname = $Full Name$
ACTL C:
Action 1: Set-Fields on CURRENT FORM:
tmp = "'Login Name' = ""miz"""
Action 2: Set-Fields from form User:
EXTERNAL($tmp$)
fullname = $Full Name$
I think you should get the picture by looking at these.
The only tricky part is understanding how to escape the double quotes and a few
other caveats. For example when using keywords:
ACTL A:
Action 1: Set-Fields from form User:
('Login Name' = $USER$)
fullname = $Full Name$
ACTL B:
Action 1: Set-Fields from form User:
EXTERNAL("'Login Name' = $USER\$")
fullname = $Full Name$
ACTL C:
Action 1: Set-Fields on CURRENT FORM:
tmp = "'Login Name' = $USER\$"
Action 2: Set-Fields from form User:
EXTERNAL($tmp$)
fullname = $Full Name$
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
January 23, 2017 7:34 AM, "Nilesh Uddhavrao Janjire" <[email protected]>
wrote:
> Hello Team,
>
> Hope you guys are rocking!
>
> Now a days I am working on one of development requirement where i need to use
> EXTERNAL Keyword. I
> tried using it but not its not giving me expected output.
> May be i am not using EXTERNAL keyword correctly.
>
> I have requirement where i need to check if query field on form A can be used
> to compare field
> values present on Form B.
>
> I have doubts regarding EXTERNAL Keyword:
> 1. Can we use EXTERNAL Keyword in setfield IF Qualification just to compare
> transanctional values
> of fields on current for with db values of another form?
> 2.If we can use EXTERNAL Keyword in setfield IF Qualification, then where
> should i use, in active
> link or filter? What is best practice?
> 3. Can I use EXTERNAL Keyword as table field qualification to fetch records
> from FORM which is
> pointed to Table field based on run time query in that field.
> e.g. EXTERNAL($Queryfield$)
>
> Many Thanks
> Nilesh
>
> _______________________________________________________________________________
> 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"
