Hi Misi,
The string that I posted was in the table qualification now I have added
the last statement ('Status_Reason' != 12000) and created an AL that will
switched between the first qualification and the second one that includes
the statement I have added. I have created a final qualification and assign
it to a field lest say 'MyField' and used that field in the table
qualification as EXTERNAL($MyField$). the new qualification that was
accepted in the set field action is the below one but at execution time
Remedy is frozen.
*((((((((((((((((((((((((((((((((( "(((EXTERNAL( """ + $z1D TableQual01$) +
""")) AND ( """) + $z1D Console View$) + """ != ""Personal"" )) OR ((
""") + $z1D Console View$) + """ = ""Personal"" ) AND (EXTERNAL( """) +
$z1D TableQual02$) + """)))) AND ( 'Status' >= """) + $z1D
ConsoleStatusLow$) + """) AND ( 'Status' <= """) + $z1D
ConsoleStatusHigh$) + """) AND (( 'Reported Date' >= """) + $z1D
ConsoleDateLow$) + """) OR ( """) + $z1D ConsoleDateLow$) + """ = """) +
$z1D ConsoleDateHigh$) + """)) AND (( 'Reported Date' <= """) + $z1D
ConsoleDateHigh$) + """) OR ( """) + $z1D ConsoleDateLow$) + """ = """) +
$z1D ConsoleDateHigh$) + """)) AND (( 'Company' = """) + $z1D Company$) +
""") OR ( """) + $z1D Company$) + """ = "" "" )) AND (( 'SLM Status' =
""") + $z1D SLA Resolution Status$) + """) OR ( """) + $z1D SLA Resolution
Status$) + """ = $\NULL$ )) AND (EXTERNAL( """) + $z1D AdvancedQual$) +
""")) AND ('Status_Reason' != 12000)"*
Thank you
Naoufal El Hilali
On Tue, Nov 27, 2012 at 1:42 PM, Misi Mladoniczky <m...@rrr.se> wrote:
> Hi,
>
> That would mean EXTERNAL within EXTERNAL, and I do not think that is
> allowed.
>
> Also, you seem to have a problem with it, as there is no left hand
> parenthesis after the EXTERNAL keyword, and the "-characters does not have
> the right count. A double-" will be a literal ", but all single-" will be
> the beginning/end of a string.
>
> So where exactly did you grab the string you posted? From DevStudio
> looking at a table-qualification, or did you cut/paste from different
> places?
>
> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>
> Products from RRR Scandinavia (3 x Best R.O.I. Award at WWRUG10/11/12):
> * 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.
>
> > Hello All,
> >
> > Could you please help me pass a qualification to the external operator. I
> > wanted to pass the following table qualification to a field and use that
> > field inside the external operator:
> >
> > *(((EXTERNAL"( $z1D TableQual01$)) AND ( $z1D Console View$ !=
> > ""Personal"" )) OR (( $z1D Console View$ = ""Personal"" ) AND
> (EXTERNAL(
> > $z1D TableQual02$)))) AND ( 'Status' >= $z1D ConsoleStatusLow$) AND (
> > 'Status' <= $z1D ConsoleStatusHigh$) AND (( 'Reported Date' >= $z1D
> > ConsoleDateLow$) OR ( $z1D ConsoleDateLow$ = $z1D ConsoleDateHigh$)) AND
> > ((
> > 'Reported Date' <= $z1D ConsoleDateHigh$) OR ( $z1D ConsoleDateLow$ =
> $z1D
> > ConsoleDateHigh$)) AND (( 'Company' = $z1D Company$) OR ( $z1D Company$ =
> > " " )) AND (( 'SLM Status' = $z1D SLA Resolution Status$) OR ( $z1D SLA
> > Resolution Status$ = $NULL$ )) AND (EXTERNAL( $z1D AdvancedQual$)) AND
> > ('Status_Reason' != 12000)*
> >
> > Thank you very much for your help
> >
> > Naoufal El Hilali
> >
> >
> _______________________________________________________________________________
> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
> >
>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
