Re: CMDB Driver
Any one can help here please, in logs it says processing, the CMDB driver sync command stuck after entering the pending ID with no error. Thank you in advance Naoufal El Hilali On Tue, Mar 5, 2013 at 4:50 PM, Naoufal El Hilali wrote: > Any one can help here please, in logs it says processing, the CMDB driver > sync command stuck after entering the pending ID with no error. > > Thank you in advance > > Naoufal El Hilali > > > On Fri, Mar 1, 2013 at 2:21 PM, Naoufal El Hilali < > naoufalelhil...@gmail.com> wrote: > >> Thank you Carl, >> >> Could you please show me how to check errors and plugins, I have checked >> the arerror.log but nothing there was related to synchronization. >> >> Regards >> >> Naoufal El Hilali >> >> >> On Fri, Mar 1, 2013 at 2:18 PM, Carl Wilson wrote: >> >>> ** >>> >>> Hi, >>> >>> this should "usually" take less than 1 hour but I have seen this run for >>> longer on certain systems. As this uses the plug-ins to perform the work, >>> you should also look into the error files to see if there are issues with >>> the running of this process and ensure the plug-ins are enabled. >>> >>> ** ** >>> -- >>> >>> >>> >>> Kind Regards, >>> >>> >>> >>> *Carl Wilson* >>> >>> ** ** >>> >>> http://www.missingpiecessoftware.com/ >>> >>> ** ** >>> >>> *From:* Action Request System discussion list(ARSList) [mailto: >>> arslist@ARSLIST.ORG] *On Behalf Of *Naoufal El Hilali >>> *Sent:* 01 March 2013 14:10 >>> *To:* arslist@ARSLIST.ORG >>> *Subject:* Re: CMDB Driver >>> >>> ** ** >>> >>> ** >>> >>> Can I have an answer please ? Still waiting for the synchronization to >>> end, I do not know how much time it will take. It has been almost 4 hours. >>> >>> >>> ** ** >>> >>> Thank you in advance. >>> >>> Regards >>> >>> >>> >>> >>> Naoufal El Hilali >>> >>> ** ** >>> >>> On Fri, Mar 1, 2013 at 11:03 AM, Naoufal El Hilali < >>> naoufalelhil...@gmail.com> wrote: >>> >>> Hello All, >>> >>> ** ** >>> >>> I have created a new attribute in a class in CMDB but it showed as >>> Change Pending, so I used the cmdbdriver to speed up the synchronization. I >>> have done everything from init, log, ssp, to sync and supplied the pending >>> ID. Now it has been almost an hour and I did not get any result, still >>> synchronizing ?? How long does it take usually ? >>> >>> ** ** >>> >>> [image: Inline image 1] >>> >>> ** ** >>> >>> Regards >>> >>> >>> >>> >>> Naoufal El Hilali >>> >>> ** ** >>> >>> _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: CMDB Driver
Any one can help here please, in logs it says processing, the CMDB driver sync command stuck after entering the pending ID with no error. Thank you in advance Naoufal El Hilali On Fri, Mar 1, 2013 at 2:21 PM, Naoufal El Hilali wrote: > Thank you Carl, > > Could you please show me how to check errors and plugins, I have checked > the arerror.log but nothing there was related to synchronization. > > Regards > > Naoufal El Hilali > > > On Fri, Mar 1, 2013 at 2:18 PM, Carl Wilson wrote: > >> ** >> >> Hi, >> >> this should "usually" take less than 1 hour but I have seen this run for >> longer on certain systems. As this uses the plug-ins to perform the work, >> you should also look into the error files to see if there are issues with >> the running of this process and ensure the plug-ins are enabled. >> >> ** ** >> -- >> >> >> >> Kind Regards, >> >> >> >> *Carl Wilson* >> >> ** ** >> >> http://www.missingpiecessoftware.com/ >> >> ** ** >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> arslist@ARSLIST.ORG] *On Behalf Of *Naoufal El Hilali >> *Sent:* 01 March 2013 14:10 >> *To:* arslist@ARSLIST.ORG >> *Subject:* Re: CMDB Driver >> >> ** ** >> >> ** **** >> >> Can I have an answer please ? Still waiting for the synchronization to >> end, I do not know how much time it will take. It has been almost 4 hours. >> >> >> ** ** >> >> Thank you in advance. >> >> Regards >> >> >> >> >> Naoufal El Hilali >> >> ** ** >> >> On Fri, Mar 1, 2013 at 11:03 AM, Naoufal El Hilali < >> naoufalelhil...@gmail.com> wrote: >> >> Hello All, >> >> ** ** >> >> I have created a new attribute in a class in CMDB but it showed as Change >> Pending, so I used the cmdbdriver to speed up the synchronization. I have >> done everything from init, log, ssp, to sync and supplied the pending ID. >> Now it has been almost an hour and I did not get any result, still >> synchronizing ?? How long does it take usually ? >> >> ** ** >> >> [image: Inline image 1] >> >> ** ** >> >> Regards >> >> >> >> >> Naoufal El Hilali >> >> ** ** >> >> _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: CMDB Driver
Thank you Carl, Could you please show me how to check errors and plugins, I have checked the arerror.log but nothing there was related to synchronization. Regards Naoufal El Hilali On Fri, Mar 1, 2013 at 2:18 PM, Carl Wilson wrote: > ** > > Hi, > > this should "usually" take less than 1 hour but I have seen this run for > longer on certain systems. As this uses the plug-ins to perform the work, > you should also look into the error files to see if there are issues with > the running of this process and ensure the plug-ins are enabled. > > ** ** > -- > > > > Kind Regards, > > > > *Carl Wilson* > > ** ** > > http://www.missingpiecessoftware.com/ > > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Naoufal El Hilali > *Sent:* 01 March 2013 14:10 > *To:* arslist@ARSLIST.ORG > *Subject:* Re: CMDB Driver > > ** ** > > ** > > Can I have an answer please ? Still waiting for the synchronization to > end, I do not know how much time it will take. It has been almost 4 hours. > > > ** ** > > Thank you in advance. > > Regards > > > > > Naoufal El Hilali > > ** ** > > On Fri, Mar 1, 2013 at 11:03 AM, Naoufal El Hilali < > naoufalelhil...@gmail.com> wrote: > > Hello All, > > ** ** > > I have created a new attribute in a class in CMDB but it showed as Change > Pending, so I used the cmdbdriver to speed up the synchronization. I have > done everything from init, log, ssp, to sync and supplied the pending ID. > Now it has been almost an hour and I did not get any result, still > synchronizing ?? How long does it take usually ? > > ** ** > > [image: Inline image 1] > > ** ** > > Regards > > > > > Naoufal El Hilali > > ** ** > > _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: CMDB Driver
Thank you Vukrant, I have just checked the OBJSTR:Pending form and there are two logs one is pending that contains the same pending ID and the other one is processing. Regards Naoufal El Hilali On Fri, Mar 1, 2013 at 2:12 PM, Kulkarni, Vikrant wrote: > ** > > It should not take that long. Did you check the pending form to check if > there is some error. > > Sent from my Xperia™ smartphone > > Naoufal El Hilali wrote: > > > ** > Can I have an answer please ? Still waiting for the synchronization to > end, I do not know how much time it will take. It has been almost 4 hours. > > Thank you in advance. > Regards > > Naoufal El Hilali > > > On Fri, Mar 1, 2013 at 11:03 AM, Naoufal El Hilali < > naoufalelhil...@gmail.com> wrote: > >> Hello All, >> >> I have created a new attribute in a class in CMDB but it showed as >> Change Pending, so I used the cmdbdriver to speed up the synchronization. I >> have done everything from init, log, ssp, to sync and supplied the pending >> ID. Now it has been almost an hour and I did not get any result, still >> synchronizing ?? How long does it take usually ? >> >> [image: Inline image 1] >> >> Regards >> >> Naoufal El Hilali >> > > _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: CMDB Driver
Can I have an answer please ? Still waiting for the synchronization to end, I do not know how much time it will take. It has been almost 4 hours. Thank you in advance. Regards Naoufal El Hilali On Fri, Mar 1, 2013 at 11:03 AM, Naoufal El Hilali < naoufalelhil...@gmail.com> wrote: > Hello All, > > I have created a new attribute in a class in CMDB but it showed as Change > Pending, so I used the cmdbdriver to speed up the synchronization. I have > done everything from init, log, ssp, to sync and supplied the pending ID. > Now it has been almost an hour and I did not get any result, still > synchronizing ?? How long does it take usually ? > > [image: Inline image 1] > > Regards > > Naoufal El Hilali > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" <>
Re: count record in form
Thad Esser That's Brilliant, I did a set field with 1=1 and count = $LASTCOUNT$ and it worked :) Thank you very much Naoufal El Hilali On Fri, Jan 25, 2013 at 5:27 PM, Thad Esser wrote: > ** Sounds like you already have an answer, but one other option would be > to do a set fields in combination with LASTCOUNT. > > Action 1: >Set Fields where requestid != $ NULL$ (or some other qualification > that causes a search for all the records you want to count), > tempchar = requestid (set to first match) > Action 2: >Set Fields: > count = $ LASTCOUNT$ (remove the space after the first $) > > That has a little smaller footprint than a table and doesn't involve SQL. > > Thad > > On Fri, Jan 25, 2013 at 9:05 AM, Naoufal El Hilali < > naoufalelhil...@gmail.com> wrote: > >> ** >> Thank you all, it worked for me :) >> >> Naoufal El Hilali >> >> >> On Fri, Jan 25, 2013 at 4:44 PM, Pargeter, Christie :CO IS < >> cparg...@lhs.org> wrote: >> >>> ** >>> >>> They aren’t copied into the table. You setup the table to point to the >>> form and setup a qualification. >>> >>> ** ** >>> >>> E.g., the Work info table in ITSM points to the TMS:WorkInfo form with a >>> qualification of 'TaskOrTaskGroupInstanceId' = $InstanceId$ >>> >>> ** ** >>> >>> *From:* Action Request System discussion list(ARSList) [mailto: >>> arslist@ARSLIST.ORG] *On Behalf Of *Naoufal El Hilali >>> *Sent:* Friday, January 25, 2013 8:17 AM >>> >>> *To:* arslist@ARSLIST.ORG >>> *Subject:* Re: count record in form >>> >>> ** ** >>> >>> ** >>> >>> Thank you Anusha, Direct SQL seems to be good solution I will try that,* >>> *** >>> >>> ** ** >>> >>> Christie, it is a good idea to have a hidden table, but how wil records >>> in form be copied in the table ? >>> >>> ** ** >>> >>> Regards >>> >>> >>> >>> >>> Naoufal El Hilali >>> >>> ** ** >>> >>> On Fri, Jan 25, 2013 at 4:14 PM, Pargeter, Christie :CO IS < >>> cparg...@lhs.org> wrote: >>> >>> ** >>> >>> Another option is to put a hidden table on the form and then refresh the >>> table and do a COLCOUNT($Field$) to get the count too. >>> >>> >>> >>> *From:* Action Request System discussion list(ARSList) [mailto: >>> arslist@ARSLIST.ORG] *On Behalf Of *Naoufal El Hilali >>> *Sent:* Friday, January 25, 2013 8:06 AM >>> *To:* arslist@ARSLIST.ORG >>> *Subject:* Re: count record in form >>> >>> >>> >>> ** >>> >>> Hi Kiran, >>> >>> >>> >>> Thank you for your answer, I dont have database access (login and >>> password), can use a run SQL in set field ? if yes, how ? >>> >>> >>> >>> Thank you a lot >>> >>> >>> >>> >>> Naoufal El Hilali >>> >>> >>> >>> On Fri, Jan 25, 2013 at 4:02 PM, Hullule, Kiran >>> wrote: >>> >>> ** >>> >>> If you have database access, then it’s quite straight forward. >>> >>> >>> >>> Select count (*) from Tx à x is a schemaid of a desire form. >>> >>> >>> >>> *From:* Action Request System discussion list(ARSList) [mailto: >>> arslist@ARSLIST.ORG] *On Behalf Of *Naoufal El Hilali >>> *Sent:* Friday, January 25, 2013 9:22 PM >>> *To:* arslist@ARSLIST.ORG >>> *Subject:* count record in form >>> >>> >>> >>> ** >>> >>> Hi All, >>> >>> >>> >>> I need your help in counting records in a form >>> >>> >>> >>> I have an EIE instance that pushes some records to a form, and I wanted >>> to count the records received by EIE. >>> >>> >>> >>> I have created a display only integer field "count" >>> >>> created a filter that is executed in submit and sets the value of count >>> to 0 and calls a filter guide >>> >>> upon its execution the filter guide calls a filter that increment the >>> count field. >>> >>> >>> >>> This development did not work for me, and I see nothing executed in >>> filter logs >>> >>> >>> >>> Thank you all in advance. >>> >>> >>> >>> Naoufal El Hilali >>> >>> _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_ >>> >>> _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_ >>> >> >> _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: count record in form
Thank you all, it worked for me :) Naoufal El Hilali On Fri, Jan 25, 2013 at 4:44 PM, Pargeter, Christie :CO IS wrote: > ** > > They aren’t copied into the table. You setup the table to point to the > form and setup a qualification. > > ** ** > > E.g., the Work info table in ITSM points to the TMS:WorkInfo form with a > qualification of 'TaskOrTaskGroupInstanceId' = $InstanceId$ > > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Naoufal El Hilali > *Sent:* Friday, January 25, 2013 8:17 AM > > *To:* arslist@ARSLIST.ORG > *Subject:* Re: count record in form > > ** ** > > ** > > Thank you Anusha, Direct SQL seems to be good solution I will try that,*** > * > > ** ** > > Christie, it is a good idea to have a hidden table, but how wil records in > form be copied in the table ? > > ** ** > > Regards > > > > > Naoufal El Hilali > > ** ** > > On Fri, Jan 25, 2013 at 4:14 PM, Pargeter, Christie :CO IS < > cparg...@lhs.org> wrote: > > ** > > Another option is to put a hidden table on the form and then refresh the > table and do a COLCOUNT($Field$) to get the count too. > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Naoufal El Hilali > *Sent:* Friday, January 25, 2013 8:06 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: count record in form > > > > ** > > Hi Kiran,**** > > > > Thank you for your answer, I dont have database access (login and > password), can use a run SQL in set field ? if yes, how ? > > > > Thank you a lot > > > > > Naoufal El Hilali > > > > On Fri, Jan 25, 2013 at 4:02 PM, Hullule, Kiran > wrote: > > ** > > If you have database access, then it’s quite straight forward. > > > > Select count (*) from Tx à x is a schemaid of a desire form. > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Naoufal El Hilali > *Sent:* Friday, January 25, 2013 9:22 PM > *To:* arslist@ARSLIST.ORG > *Subject:* count record in form > > > > ** > > Hi All, > > > > I need your help in counting records in a form > > > > I have an EIE instance that pushes some records to a form, and I wanted to > count the records received by EIE. > > > > I have created a display only integer field "count"**** > > created a filter that is executed in submit and sets the value of count to > 0 and calls a filter guide > > upon its execution the filter guide calls a filter that increment the > count field. > > > > This development did not work for me, and I see nothing executed in filter > logs > > > > Thank you all in advance. > > > > Naoufal El Hilali > > _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_ > > _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: count record in form
Thank you Anusha, Direct SQL seems to be good solution I will try that, Christie, it is a good idea to have a hidden table, but how wil records in form be copied in the table ? Regards Naoufal El Hilali On Fri, Jan 25, 2013 at 4:14 PM, Pargeter, Christie :CO IS wrote: > ** > > Another option is to put a hidden table on the form and then refresh the > table and do a COLCOUNT($Field$) to get the count too. > > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Naoufal El Hilali > *Sent:* Friday, January 25, 2013 8:06 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: count record in form > > ** ** > > ** > > Hi Kiran, > > ** ** > > Thank you for your answer, I dont have database access (login and > password), can use a run SQL in set field ? if yes, how ?**** > > ** ** > > Thank you a lot > > > > > Naoufal El Hilali > > ** ** > > On Fri, Jan 25, 2013 at 4:02 PM, Hullule, Kiran > wrote: > > ** > > If you have database access, then it’s quite straight forward. > > > > Select count (*) from Tx à x is a schemaid of a desire form.**** > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Naoufal El Hilali > *Sent:* Friday, January 25, 2013 9:22 PM > *To:* arslist@ARSLIST.ORG > *Subject:* count record in form > > > > ** > > Hi All, > > > > I need your help in counting records in a form > > > > I have an EIE instance that pushes some records to a form, and I wanted to > count the records received by EIE. > > > > I have created a display only integer field "count" > > created a filter that is executed in submit and sets the value of count to > 0 and calls a filter guide > > upon its execution the filter guide calls a filter that increment the > count field. > > > > This development did not work for me, and I see nothing executed in filter > logs > > > > Thank you all in advance. > > > > Naoufal El Hilali > > _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_ > _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: count record in form
Hi Kiran, Thank you for your answer, I dont have database access (login and password), can use a run SQL in set field ? if yes, how ? Thank you a lot Naoufal El Hilali On Fri, Jan 25, 2013 at 4:02 PM, Hullule, Kiran wrote: > ** > > If you have database access, then it’s quite straight forward. > > ** ** > > Select count (*) from Tx à x is a schemaid of a desire form. > > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Naoufal El Hilali > *Sent:* Friday, January 25, 2013 9:22 PM > *To:* arslist@ARSLIST.ORG > *Subject:* count record in form > > ** ** > > ** > > Hi All, > > ** ** > > I need your help in counting records in a form > > ** ** > > I have an EIE instance that pushes some records to a form, and I wanted to > count the records received by EIE. > > ** ** > > I have created a display only integer field "count" > > created a filter that is executed in submit and sets the value of count to > 0 and calls a filter guide > > upon its execution the filter guide calls a filter that increment the > count field. > > ** ** > > This development did not work for me, and I see nothing executed in filter > logs > > ** ** > > Thank you all in advance. > > ** ** > > Naoufal El Hilali > > _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"
count record in form
Hi All, I need your help in counting records in a form I have an EIE instance that pushes some records to a form, and I wanted to count the records received by EIE. I have created a display only integer field "count" created a filter that is executed in submit and sets the value of count to 0 and calls a filter guide upon its execution the filter guide calls a filter that increment the count field. This development did not work for me, and I see nothing executed in filter logs Thank you all in advance. Naoufal El Hilali ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: External() operator
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 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"
External() operator
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"
Re: Linking Attachment Pool and a Table Field
Misi, When I double click the record in the table it opens the HPD:WorkLog
form, How can I disable that ?
Thanks
Naoufal El Hilali
On Wed, Aug 1, 2012 at 2:24 PM, Naoufal El Hilali wrote:
> Thank you very much Misi, It did work perfectly :)
>
> Naoufal El Hilali
>
>
>
> On Wed, Aug 1, 2012 at 10:23 AM, Misi Mladoniczky wrote:
>
>> Hi,
>>
>> You say that you only use one form. Do you mean that your table-field,
>> attachment-pool and attachments are all in HPD:WorkLog?
>>
>> What I suspect is that you indeed work with two forms.
>>
>> Let us call the one you build things on "DispAttForm" with the following
>> fields:
>> 1. 'IncidentNumber'
>> 2. 'TableField' connected to HPD:WorkLog with ('IncidentNumber' =
>> $IncidentNumber$ AND 'Attach' = "Yes") search
>> 3. 'TableCol' with any field from HPD:WorkLog that would make sense to the
>> user
>> 4. 'TableColReqId' connected to field id 1 of HPD:WorkLog, it can be
>> hidden
>> 5. 'AttPool'
>> 6. 'AttSlot'
>>
>> When you select something in the table field, you must do what Fred says,
>> pull the attachment from HPD:WorkLog and put it into your own attachment
>> slot:
>> ACTL:
>> Execute On: Row Choise
>> Action:
>> Set-Fields: HPD:WorkLog ('1' = $TableColReqId$)
>> AttSlot = $AttachmentSlot$
>>
>> Let us know how it works out for you!
>>
>> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>>
>> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
>> * 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.
>>
>> > Can any one help me here please ?
>> >
>> > Naoufal El Hilali
>> >
>> >
>> >
>> > On Tue, Jul 31, 2012 at 3:20 PM, Naoufal El Hilali <
>> > naoufalelhil...@gmail.com> wrote:
>> >
>> >> Hi Fred,
>> >>
>> >> I am not using two forms, both the table and the attachment pool are in
>> >> one form (regular form). the table displays the worklog entries
>> >> according
>> >> to some qualification, and this works fine, the attachment pool also
>> >> works
>> >> if I used set field action and copy the value of the attachment from
>> >> HPD:WorkLog to the attachment field, but this is not what I wand. I
>> want
>> >> to
>> >> use the table field to filter some entries before I display attachment.
>> >>
>> >> Thank you very much for your help ?
>> >>
>> >> Naoufal El Hilali
>> >>
>> >>
>> >>
>> >> On Tue, Jul 31, 2012 at 3:01 PM, Grooms, Frederick W <
>> >> frederick.w.gro...@xo.com> wrote:
>> >>
>> >>> I think you first need to pull the attachment back to the current
>> form.
>> >>> (You can create a Display Only attachment pool and Display Only
>> >>> Attachment
>> >>> on the current form to hold the attachment from the form referenced in
>> >>> the
>> >>> table). Then you can open the attachment from the current form (The
>> >>> PROCESS action works against the current form not a remote form).
>> >>>
>> >>> Fred
>> >>>
>> >>> -Original Message-
>> >>> From: Action Request System discussion list(ARSList) [mailto:
>> >>> arslist@ARSLIST.ORG] On Behalf Of Naoufal El Hilali
>> >>> Sent: Tuesday, July 31, 2012 8:30 AM
>> >>> To: arslist@ARSLIST.ORG
>> >>> Subject: Re: Linking Attachment Pool and a Table Field
>> >>>
>> >>> ** Thank you Todd, it did not work. Did I make any mistake?
>> >>>
>> >>> Naoufal El Hilali
>> >>>
>> >>> -Original Message-----
>> >>> On Tue, Jul 31, 2012 at 1:23 PM, Arner, Todd wrote:
>> >>> **
>> >>> You should be able to do this with an active link executing on Row
>> >>> choice. You will want to link to the attachment field and not the
>> >>> attachment pool. Use a run process with
>> PERFORM-ACTION-OPEN-ATTACHMENT
>> >>> field ID
>> >>>
>> >>> Hope that
Re: Linking Attachment Pool and a Table Field
Thank you very much Misi, It did work perfectly :)
Naoufal El Hilali
On Wed, Aug 1, 2012 at 10:23 AM, Misi Mladoniczky wrote:
> Hi,
>
> You say that you only use one form. Do you mean that your table-field,
> attachment-pool and attachments are all in HPD:WorkLog?
>
> What I suspect is that you indeed work with two forms.
>
> Let us call the one you build things on "DispAttForm" with the following
> fields:
> 1. 'IncidentNumber'
> 2. 'TableField' connected to HPD:WorkLog with ('IncidentNumber' =
> $IncidentNumber$ AND 'Attach' = "Yes") search
> 3. 'TableCol' with any field from HPD:WorkLog that would make sense to the
> user
> 4. 'TableColReqId' connected to field id 1 of HPD:WorkLog, it can be hidden
> 5. 'AttPool'
> 6. 'AttSlot'
>
> When you select something in the table field, you must do what Fred says,
> pull the attachment from HPD:WorkLog and put it into your own attachment
> slot:
> ACTL:
> Execute On: Row Choise
> Action:
> Set-Fields: HPD:WorkLog ('1' = $TableColReqId$)
> AttSlot = $AttachmentSlot$
>
> Let us know how it works out for you!
>
> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>
> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
> * 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.
>
> > Can any one help me here please ?
> >
> > Naoufal El Hilali
> >
> >
> >
> > On Tue, Jul 31, 2012 at 3:20 PM, Naoufal El Hilali <
> > naoufalelhil...@gmail.com> wrote:
> >
> >> Hi Fred,
> >>
> >> I am not using two forms, both the table and the attachment pool are in
> >> one form (regular form). the table displays the worklog entries
> >> according
> >> to some qualification, and this works fine, the attachment pool also
> >> works
> >> if I used set field action and copy the value of the attachment from
> >> HPD:WorkLog to the attachment field, but this is not what I wand. I want
> >> to
> >> use the table field to filter some entries before I display attachment.
> >>
> >> Thank you very much for your help ?
> >>
> >> Naoufal El Hilali
> >>
> >>
> >>
> >> On Tue, Jul 31, 2012 at 3:01 PM, Grooms, Frederick W <
> >> frederick.w.gro...@xo.com> wrote:
> >>
> >>> I think you first need to pull the attachment back to the current form.
> >>> (You can create a Display Only attachment pool and Display Only
> >>> Attachment
> >>> on the current form to hold the attachment from the form referenced in
> >>> the
> >>> table). Then you can open the attachment from the current form (The
> >>> PROCESS action works against the current form not a remote form).
> >>>
> >>> Fred
> >>>
> >>> -Original Message-
> >>> From: Action Request System discussion list(ARSList) [mailto:
> >>> arslist@ARSLIST.ORG] On Behalf Of Naoufal El Hilali
> >>> Sent: Tuesday, July 31, 2012 8:30 AM
> >>> To: arslist@ARSLIST.ORG
> >>> Subject: Re: Linking Attachment Pool and a Table Field
> >>>
> >>> ** Thank you Todd, it did not work. Did I make any mistake?
> >>>
> >>> Naoufal El Hilali
> >>>
> >>> -Original Message-
> >>> On Tue, Jul 31, 2012 at 1:23 PM, Arner, Todd wrote:
> >>> **
> >>> You should be able to do this with an active link executing on Row
> >>> choice. You will want to link to the attachment field and not the
> >>> attachment pool. Use a run process with PERFORM-ACTION-OPEN-ATTACHMENT
> >>> field ID
> >>>
> >>> Hope that helps,
> >>> Todd Arner
> >>> Great Lakes
> >>>
> >>> -Original Message-
> >>> From: Action Request System discussion list(ARSList) [mailto:
> >>> arslist@ARSLIST.ORG] On Behalf Of Naoufal El Hilali
> >>> Sent: Tuesday, July 31, 2012 6:55 AM
> >>> To: arslist@ARSLIST.ORG
> >>> Subject: Linking Attachment Pool and a Table Field
> >>>
> >>> **
> >>> Hi All,
> >>>
> >>> i would like to link a table field with an attachment pool, when
> >>> selecting a record o
Re: Linking Attachment Pool and a Table Field
Can any one help me here please ? Naoufal El Hilali On Tue, Jul 31, 2012 at 3:20 PM, Naoufal El Hilali < naoufalelhil...@gmail.com> wrote: > Hi Fred, > > I am not using two forms, both the table and the attachment pool are in > one form (regular form). the table displays the worklog entries according > to some qualification, and this works fine, the attachment pool also works > if I used set field action and copy the value of the attachment from > HPD:WorkLog to the attachment field, but this is not what I wand. I want to > use the table field to filter some entries before I display attachment. > > Thank you very much for your help ? > > Naoufal El Hilali > > > > On Tue, Jul 31, 2012 at 3:01 PM, Grooms, Frederick W < > frederick.w.gro...@xo.com> wrote: > >> I think you first need to pull the attachment back to the current form. >> (You can create a Display Only attachment pool and Display Only Attachment >> on the current form to hold the attachment from the form referenced in the >> table). Then you can open the attachment from the current form (The >> PROCESS action works against the current form not a remote form). >> >> Fred >> >> -Original Message- >> From: Action Request System discussion list(ARSList) [mailto: >> arslist@ARSLIST.ORG] On Behalf Of Naoufal El Hilali >> Sent: Tuesday, July 31, 2012 8:30 AM >> To: arslist@ARSLIST.ORG >> Subject: Re: Linking Attachment Pool and a Table Field >> >> ** Thank you Todd, it did not work. Did I make any mistake? >> >> Naoufal El Hilali >> >> -Original Message- >> On Tue, Jul 31, 2012 at 1:23 PM, Arner, Todd wrote: >> ** >> You should be able to do this with an active link executing on Row >> choice. You will want to link to the attachment field and not the >> attachment pool. Use a run process with PERFORM-ACTION-OPEN-ATTACHMENT >> field ID >> >> Hope that helps, >> Todd Arner >> Great Lakes >> >> -Original Message- >> From: Action Request System discussion list(ARSList) [mailto: >> arslist@ARSLIST.ORG] On Behalf Of Naoufal El Hilali >> Sent: Tuesday, July 31, 2012 6:55 AM >> To: arslist@ARSLIST.ORG >> Subject: Linking Attachment Pool and a Table Field >> >> ** >> Hi All, >> >> i would like to link a table field with an attachment pool, when >> selecting a record on the table, the attachment pool should display the >> attached files related to what I select. >> >> I am using Remedy 7.1.00 patch 007 >> >> Thank you in advance >> >> >> 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"
Re: Linking Attachment Pool and a Table Field
Hi Fred, I am not using two forms, both the table and the attachment pool are in one form (regular form). the table displays the worklog entries according to some qualification, and this works fine, the attachment pool also works if I used set field action and copy the value of the attachment from HPD:WorkLog to the attachment field, but this is not what I wand. I want to use the table field to filter some entries before I display attachment. Thank you very much for your help ? Naoufal El Hilali On Tue, Jul 31, 2012 at 3:01 PM, Grooms, Frederick W < frederick.w.gro...@xo.com> wrote: > I think you first need to pull the attachment back to the current form. > (You can create a Display Only attachment pool and Display Only Attachment > on the current form to hold the attachment from the form referenced in the > table). Then you can open the attachment from the current form (The > PROCESS action works against the current form not a remote form). > > Fred > > -Original Message- > From: Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] On Behalf Of Naoufal El Hilali > Sent: Tuesday, July 31, 2012 8:30 AM > To: arslist@ARSLIST.ORG > Subject: Re: Linking Attachment Pool and a Table Field > > ** Thank you Todd, it did not work. Did I make any mistake? > > Naoufal El Hilali > > -Original Message- > On Tue, Jul 31, 2012 at 1:23 PM, Arner, Todd wrote: > ** > You should be able to do this with an active link executing on Row > choice. You will want to link to the attachment field and not the > attachment pool. Use a run process with PERFORM-ACTION-OPEN-ATTACHMENT > field ID > > Hope that helps, > Todd Arner > Great Lakes > > -Original Message- > From: Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] On Behalf Of Naoufal El Hilali > Sent: Tuesday, July 31, 2012 6:55 AM > To: arslist@ARSLIST.ORG > Subject: Linking Attachment Pool and a Table Field > > ** > Hi All, > > i would like to link a table field with an attachment pool, when selecting > a record on the table, the attachment pool should display the attached > files related to what I select. > > I am using Remedy 7.1.00 patch 007 > > Thank you in advance > > > 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"
Re: Linking Attachment Pool and a Table Field
Thank you Todd, it did not work. Did I make any mistake? [image: Inline image 1] [image: Inline image 3] Naoufal El Hilali On Tue, Jul 31, 2012 at 1:23 PM, Arner, Todd wrote: > ** > > You should be able to do this with an active link executing on Row > choice. You will want to link to the attachment field and not the > attachment pool. Use a run process with PERFORM-ACTION-OPEN-ATTACHMENT *field > ID* > > * * > > Hope that helps, > > Todd Arner > > Great Lakes > > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Naoufal El Hilali > *Sent:* Tuesday, July 31, 2012 6:55 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Linking Attachment Pool and a Table Field > > ** ** > > ** > > Hi All, > > ** ** > > i would like to link a table field with an attachment pool, when selecting > a record on the table, the attachment pool should display the attached > files related to what I select. > > ** ** > > I am using Remedy 7.1.00 patch 007 > > ** ** > > Thank you in advance > > > > > Naoufal El Hilali > > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ > -- > The information contained in this communication may be confidential, is > intended only for the use of the recipient(s) named above, and may be > legally privileged. If the reader of this message is not the intended > recipient, you are hereby notified that any dissemination, distribution, or > copying of this communication, or any of its contents, is strictly > prohibited. If you have received this communication in error, please notify > the sender immediately and destroy or delete the original message and any > copy of it from your computer system. If you have any questions concerning > this message, please contact the sender. > _attend WWRUG12 www.wwrug.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" <><>
Linking Attachment Pool and a Table Field
Hi All, i would like to link a table field with an attachment pool, when selecting a record on the table, the attachment pool should display the attached files related to what I select. I am using Remedy 7.1.00 patch 007 Thank you in advance Naoufal El Hilali ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Problem when install ARsystem
Hi Mahmoud, Maybe you need to add JRE path in the environmental variables and restart your PC, search in google on how to do this. Let me know the result. Regards On Thu, Apr 5, 2012 at 11:13 AM, Mahmoud Mahdy-Mohamed wrote: > ** > > Dears, > > I’m facing a problem while installing ARS 7.6.04 first; it is related to > JRE, I already installed JDK 6 but the following error appears:- > > “Enter the path to the JRE that you want to use with AR System. If a JRE is > not installed on your system, install JRE 1.5 or later before continuing.” > > Please help. > > > > > > Thanks, > > Best Regards, > > > > Mahmoud Mahdy Mohammed,PMP | Business Process Automation > Technology | Products & Services Delivery > Phone: +20(0)104999638 > Mail: mahmoud.mahdy-moha...@vodafone.com > > > > * > > The content of this document is classified as Vodafone Egypt S.A.E. > Confidential and Proprietary Information. > > The recipient hereby is committed to hold in strict confidence the contents > of this (e-mail, document, information) and not to disclose to any third > party without the prior written consent of Vodafone Egypt S.A.E. Recipient > will be held liable for any unauthorized disclosure. > > If you have received this message in error, please notify the sender by > return e-mail and delete the message in its entirety, including any > attachments. > > http://www.vodafone.com.eg > > ************* > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ -- Naoufal El Hilali ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
