Re: Active link Else Action not working

2010-06-08 Thread Joe D'Souza
Angus,

Do you want to check for 'digits' equal to null or 'digits' equal to .
They are not the same thing.. Null is when there is no value (absence of
value) in the character field and  is a value - its just empty. Most
databases recognize the difference.. You would need to check with your
database what is applicable..

Cheers

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Angus Comber
  Sent: Saturday, June 05, 2010 4:40 PM
  To: arslist@ARSLIST.ORG
  Subject: Re: Active link Else Action not working


  **
  Hi Chintan

  Same effect even if I remove the Run If.  I think that it means that it
will only run the active link if there is text in the digits field.  Then
applies the if test and I assumed if the If test fails it would execvute
tyhe else - but for some reason it does not :(

  I can't understand why it won't execute the Else.  Is there another way to
do this?

  Angus

- Original Message -
From: Chintan Shah
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Sent: Saturday, June 05, 2010 8:46 PM
Subject: Re: Active link Else Action not working


** Hi Angus,

   if the qualification does not find any match
  --Where are you checking this part? in Run If?

  If I understand your question correctly, then this 'digits' != 
is not equal to Employee not found. If if I input a number which does not
exist in database digits field is still not empty and hence 'digits' != 
will not fail, in which case If action is executed and If No Requests
Match: Do Not Show Any Message and suppress empty list. happens.

  In other words, the only time I see your Else action getting
executed is when there is no data entered in digits field (as per Run If
that you have provided here).

  Correct me if I am wrong in understanding your question.

  Thanks,
  Chintan

  --- On Sat, 6/5/10, Angus Comber arsl...@iteloffice.com wrote:


From: Angus Comber arsl...@iteloffice.com
Subject: Active link Else Action not working
To: arslist@ARSLIST.ORG
Date: Saturday, June 5, 2010, 8:58 AM


**
Hello

I have a button on a form which fires an active link which is
configured like this:

1. active link named processdigits.  Run if 'digits' !=  and
execute on button (on my form).

2. If action tab, action=Open Window, window type=Modify,
Display Type=Detail Only, Form name=employees

Qualification 'employeeid' = $digits$

If No Requests Match: Do Not Show Any Message and suppress empty
list.

The If Action part works fine.

In the Else Action Tab I have:
Current Action=Open window
Window Type=Submit
Form name=employees

Field mapping
employeeid mapped to $digits$

My problem is that the Else Action never gets called.

So, if the qualification in the If Action finds a match then
this executes ok and I see the found employee ok.

But if the qualification does not find any match then the Else
Action is not executed.

What am I doing wrong?

Angus

_attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_

_attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_
  _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are


Re: Active link Else Action not working

2010-06-06 Thread Chintan Shah
Wonderful. This is exactly what I was going to suggest..just to add up..you can 
make the 'temp field' as display-only character field since it will not occupy 
DB space and still its value can be used in transaction.

Thnx
Chintan.

--- On Sat, 6/5/10, JD Hood hood...@gmail.com wrote:

From: JD Hood hood...@gmail.com
Subject: Re: Active link Else Action not working
To: arslist@ARSLIST.ORG
Date: Saturday, June 5, 2010, 5:07 PM

If I'm reading you correctly, it seems like you expect the else action to 
fire based on the results of the if-action qualification of 'employeeid' = 
$digits$. 

That's not how it works. The Else action only fires if the main run-if 
('digits' != ) evaluates to false.

What you might need to do is add another active link that fires just before 
this one. You will use it to see if the employee exists. 

Run if: 'digits' != $NULL$

If Action: set fields from employees; set 'temp-field' to $digits$ where 
'employeeid' = $digits$. 
If no match found: set fields to null.
If multi-match: Use first matching request.

Now, back to your original active link...
New run-if: 'temp-field' != $NULL$  (means we *did* find an employee in the 
previous active link)

If action: Do your modify window open
Else action: Do your submit window open

-JDHood-


On Sat, 5 Jun 2010 21:40:02 +0100, Angus Comber arsl...@iteloffice.com 
wrote:

Hi Chintan

Same effect even if I remove the Run If.  I think that it means that it 
will only run the active link if there is text in the digits field.  Then 
applies the if test and I assumed if the If test fails it would execvute 
tyhe else - but for some reason it does not :(

I can't understand why it won't execute the Else.  Is there another way to 
do this?

Angus

  - Original Message - 
  From: Chintan Shah 
  Newsgroups: public.remedy.arsystem.general
  To: arslist@ARSLIST.ORG 
  Sent: Saturday, June 05, 2010 8:46 PM
  Subject: Re: Active link Else Action not working


  ** Hi Angus,

         if the qualification does not find any match
        --Where are you checking this part? in Run If?

        If I understand your question correctly, then this 'digits' !=  
is not equal to Employee not found. If if I input a number which does not 
exist in database digits field is still not empty and hence 'digits' !=  
will not fail, in which case If action is executed and If No Requests 
Match: Do Not Show Any Message and suppress empty list. happens.

        In other words, the only time I see your Else action getting 
executed is when there is no data entered in digits field (as per Run If 
that you have provided here).

        Correct me if I am wrong in understanding your question.

        Thanks,
        Chintan

        --- On Sat, 6/5/10, Angus Comber arsl...@iteloffice.com wrote:


          From: Angus Comber arsl...@iteloffice.com
          Subject: Active link Else Action not working
          To: arslist@ARSLIST.ORG
          Date: Saturday, June 5, 2010, 8:58 AM


          ** 
          Hello

          I have a button on a form which fires an active link which is 
configured like this:

          1. active link named processdigits.  Run if 'digits' !=  and 
execute on button (on my form).

          2. If action tab, action=Open Window, window type=Modify, Display 
Type=Detail Only, Form name=employees

          Qualification 'employeeid' = $digits$

          If No Requests Match: Do Not Show Any Message and suppress empty 
list.

          The If Action part works fine.

          In the Else Action Tab I have:
          Current Action=Open window
          Window Type=Submit
          Form name=employees

          Field mapping
          employeeid mapped to $digits$

          My problem is that the Else Action never gets called.

          So, if the qualification in the If Action finds a match then this 
executes ok and I see the found employee ok.

          But if the qualification does not find any match then the Else 
Action is not executed.

          What am I doing wrong?

          Angus

          _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_  

  _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_

___

UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are






___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

Active link Else Action not working

2010-06-05 Thread Angus Comber
Hello

I have a button on a form which fires an active link which is configured like 
this:

1. active link named processdigits.  Run if 'digits' !=  and execute on 
button (on my form).

2. If action tab, action=Open Window, window type=Modify, Display Type=Detail 
Only, Form name=employees

Qualification 'employeeid' = $digits$

If No Requests Match: Do Not Show Any Message and suppress empty list.

The If Action part works fine.

In the Else Action Tab I have:
Current Action=Open window
Window Type=Submit
Form name=employees

Field mapping
employeeid mapped to $digits$

My problem is that the Else Action never gets called.

So, if the qualification in the If Action finds a match then this executes ok 
and I see the found employee ok.

But if the qualification does not find any match then the Else Action is not 
executed.

What am I doing wrong?

Angus

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are


Re: Active link Else Action not working

2010-06-05 Thread Chintan Shah
Hi Angus,

 if the qualification does not find any 
match
--Where are you checking this part? in Run If?

If I understand your question correctly, then this 'digits' !=  is not equal 
to Employee not found. If if I input a number which does not exist in 
database digits field is still not empty and hence 'digits' !=
  will not fail, in which case If action is executed and If No Requests 
Match: Do Not Show Any 
Message and 
suppress empty list. happens.

In other words, the only time I see your Else action getting executed is when 
there is no data entered in digits field (as per Run If that you have provided 
here).

Correct me if I am wrong in understanding your question.

Thanks,
Chintan

--- On Sat, 6/5/10, Angus Comber arsl...@iteloffice.com wrote:

From: Angus Comber arsl...@iteloffice.com
Subject: Active link Else Action not working
To: arslist@ARSLIST.ORG
Date: Saturday, June 5, 2010, 8:58 AM

**


 
 

Hello
 
I have a button on a form which fires an active 
link which is configured like this:
 
1. active link named processdigits.  Run if 
'digits' !=  and execute on button (on my form).
 
2. If action tab, action=Open Window, window 
type=Modify, Display Type=Detail Only, Form name=employees
 
Qualification 'employeeid' = $digits$
 
If No Requests Match: Do Not Show Any Message and 
suppress empty list.
 
The If Action part works fine.
 
In the Else Action Tab I have:
Current 
Action=Open window
Window Type=Submit
Form name=employees
 
Field mapping
employeeid mapped to 
$digits$
 
My problem is that the Else Action never gets 
called.
 
So, if the qualification in the If Action finds a 
match then this executes ok and I see the found employee ok.
 
But if the qualification does not find any match 
then the Else Action is not executed.
 
What am I doing wrong?
 
Angus
_attend WWRUG10 www.wwrug.com  ARSlist: Where the Answers Are_





___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

Re: Active link Else Action not working

2010-06-05 Thread Angus Comber
Hi Chintan

Same effect even if I remove the Run If.  I think that it means that it will 
only run the active link if there is text in the digits field.  Then applies 
the if test and I assumed if the If test fails it would execvute tyhe else - 
but for some reason it does not :(

I can't understand why it won't execute the Else.  Is there another way to do 
this?

Angus

  - Original Message - 
  From: Chintan Shah 
  Newsgroups: public.remedy.arsystem.general
  To: arslist@ARSLIST.ORG 
  Sent: Saturday, June 05, 2010 8:46 PM
  Subject: Re: Active link Else Action not working


  ** Hi Angus,

 if the qualification does not find any match
--Where are you checking this part? in Run If?

If I understand your question correctly, then this 'digits' !=  is 
not equal to Employee not found. If if I input a number which does not exist 
in database digits field is still not empty and hence 'digits' !=  will not 
fail, in which case If action is executed and If No Requests Match: Do Not 
Show Any Message and suppress empty list. happens.

In other words, the only time I see your Else action getting executed 
is when there is no data entered in digits field (as per Run If that you have 
provided here).

Correct me if I am wrong in understanding your question.

Thanks,
Chintan

--- On Sat, 6/5/10, Angus Comber arsl...@iteloffice.com wrote:


  From: Angus Comber arsl...@iteloffice.com
  Subject: Active link Else Action not working
  To: arslist@ARSLIST.ORG
  Date: Saturday, June 5, 2010, 8:58 AM


  ** 
  Hello

  I have a button on a form which fires an active link which is 
configured like this:

  1. active link named processdigits.  Run if 'digits' !=  and 
execute on button (on my form).

  2. If action tab, action=Open Window, window type=Modify, Display 
Type=Detail Only, Form name=employees

  Qualification 'employeeid' = $digits$

  If No Requests Match: Do Not Show Any Message and suppress empty list.

  The If Action part works fine.

  In the Else Action Tab I have:
  Current Action=Open window
  Window Type=Submit
  Form name=employees

  Field mapping
  employeeid mapped to $digits$

  My problem is that the Else Action never gets called.

  So, if the qualification in the If Action finds a match then this 
executes ok and I see the found employee ok.

  But if the qualification does not find any match then the Else Action 
is not executed.

  What am I doing wrong?

  Angus

  _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_  

  _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

Re: Active link Else Action not working

2010-06-05 Thread JD Hood
If I'm reading you correctly, it seems like you expect the else action to 
fire based on the results of the if-action qualification of 'employeeid' = 
$digits$. 

That's not how it works. The Else action only fires if the main run-if 
('digits' != ) evaluates to false.

What you might need to do is add another active link that fires just before 
this one. You will use it to see if the employee exists. 

Run if: 'digits' != $NULL$

If Action: set fields from employees; set 'temp-field' to $digits$ where 
'employeeid' = $digits$. 
If no match found: set fields to null.
If multi-match: Use first matching request.

Now, back to your original active link...
New run-if: 'temp-field' != $NULL$  (means we *did* find an employee in the 
previous active link)

If action: Do your modify window open
Else action: Do your submit window open

-JDHood-


On Sat, 5 Jun 2010 21:40:02 +0100, Angus Comber arsl...@iteloffice.com 
wrote:

Hi Chintan

Same effect even if I remove the Run If.  I think that it means that it 
will only run the active link if there is text in the digits field.  Then 
applies the if test and I assumed if the If test fails it would execvute 
tyhe else - but for some reason it does not :(

I can't understand why it won't execute the Else.  Is there another way to 
do this?

Angus

  - Original Message - 
  From: Chintan Shah 
  Newsgroups: public.remedy.arsystem.general
  To: arslist@ARSLIST.ORG 
  Sent: Saturday, June 05, 2010 8:46 PM
  Subject: Re: Active link Else Action not working


  ** Hi Angus,

 if the qualification does not find any match
--Where are you checking this part? in Run If?

If I understand your question correctly, then this 'digits' !=  
is not equal to Employee not found. If if I input a number which does not 
exist in database digits field is still not empty and hence 'digits' !=  
will not fail, in which case If action is executed and If No Requests 
Match: Do Not Show Any Message and suppress empty list. happens.

In other words, the only time I see your Else action getting 
executed is when there is no data entered in digits field (as per Run If 
that you have provided here).

Correct me if I am wrong in understanding your question.

Thanks,
Chintan

--- On Sat, 6/5/10, Angus Comber arsl...@iteloffice.com wrote:


  From: Angus Comber arsl...@iteloffice.com
  Subject: Active link Else Action not working
  To: arslist@ARSLIST.ORG
  Date: Saturday, June 5, 2010, 8:58 AM


  ** 
  Hello

  I have a button on a form which fires an active link which is 
configured like this:

  1. active link named processdigits.  Run if 'digits' !=  and 
execute on button (on my form).

  2. If action tab, action=Open Window, window type=Modify, Display 
Type=Detail Only, Form name=employees

  Qualification 'employeeid' = $digits$

  If No Requests Match: Do Not Show Any Message and suppress empty 
list.

  The If Action part works fine.

  In the Else Action Tab I have:
  Current Action=Open window
  Window Type=Submit
  Form name=employees

  Field mapping
  employeeid mapped to $digits$

  My problem is that the Else Action never gets called.

  So, if the qualification in the If Action finds a match then this 
executes ok and I see the found employee ok.

  But if the qualification does not find any match then the Else 
Action is not executed.

  What am I doing wrong?

  Angus

  _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_  

  _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_

___

UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are


Re: Active link Else Action not working

2010-06-05 Thread Angus Comber
Could I move the qualification to the Run If field?  If so I need to specify 
that the active link should run if the digits field on the current form finds a 
match in the employeeid field in the Employees form/table?  Is this possible?


  - Original Message - 
  From: Chintan Shah 
  Newsgroups: public.remedy.arsystem.general
  To: arslist@ARSLIST.ORG 
  Sent: Saturday, June 05, 2010 8:46 PM
  Subject: Re: Active link Else Action not working


  ** Hi Angus,

 if the qualification does not find any match
--Where are you checking this part? in Run If?

If I understand your question correctly, then this 'digits' !=  is 
not equal to Employee not found. If if I input a number which does not exist 
in database digits field is still not empty and hence 'digits' !=  will not 
fail, in which case If action is executed and If No Requests Match: Do Not 
Show Any Message and suppress empty list. happens.

In other words, the only time I see your Else action getting executed 
is when there is no data entered in digits field (as per Run If that you have 
provided here).

Correct me if I am wrong in understanding your question.

Thanks,
Chintan

--- On Sat, 6/5/10, Angus Comber arsl...@iteloffice.com wrote:


  From: Angus Comber arsl...@iteloffice.com
  Subject: Active link Else Action not working
  To: arslist@ARSLIST.ORG
  Date: Saturday, June 5, 2010, 8:58 AM


  ** 
  Hello

  I have a button on a form which fires an active link which is 
configured like this:

  1. active link named processdigits.  Run if 'digits' !=  and 
execute on button (on my form).

  2. If action tab, action=Open Window, window type=Modify, Display 
Type=Detail Only, Form name=employees

  Qualification 'employeeid' = $digits$

  If No Requests Match: Do Not Show Any Message and suppress empty list.

  The If Action part works fine.

  In the Else Action Tab I have:
  Current Action=Open window
  Window Type=Submit
  Form name=employees

  Field mapping
  employeeid mapped to $digits$

  My problem is that the Else Action never gets called.

  So, if the qualification in the If Action finds a match then this 
executes ok and I see the found employee ok.

  But if the qualification does not find any match then the Else Action 
is not executed.

  What am I doing wrong?

  Angus

  _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_  

  _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

Re: Active link Else Action not working

2010-06-05 Thread Angus Comber

Brilliant, thanks a lot.

I have used Remedy for a while, but only very simple tasks.  So I can see I 
have a lot to learn.


Really helpful, thank you.

Angus



- Original Message - 
From: JD Hood hood...@gmail.com

Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Sent: Sunday, June 06, 2010 1:07 AM
Subject: Re: Active link Else Action not working



If I'm reading you correctly, it seems like you expect the else action to
fire based on the results of the if-action qualification of 'employeeid' =
$digits$.

That's not how it works. The Else action only fires if the main run-if
('digits' != ) evaluates to false.

What you might need to do is add another active link that fires just 
before

this one. You will use it to see if the employee exists.

Run if: 'digits' != $NULL$

If Action: set fields from employees; set 'temp-field' to $digits$ where
'employeeid' = $digits$.
If no match found: set fields to null.
If multi-match: Use first matching request.

Now, back to your original active link...
New run-if: 'temp-field' != $NULL$  (means we *did* find an employee in 
the

previous active link)

If action: Do your modify window open
Else action: Do your submit window open

-JDHood-


On Sat, 5 Jun 2010 21:40:02 +0100, Angus Comber arsl...@iteloffice.com
wrote:


Hi Chintan

Same effect even if I remove the Run If.  I think that it means that it

will only run the active link if there is text in the digits field.  Then
applies the if test and I assumed if the If test fails it would execvute
tyhe else - but for some reason it does not :(


I can't understand why it won't execute the Else.  Is there another way to

do this?


Angus

 - Original Message - 
 From: Chintan Shah

 Newsgroups: public.remedy.arsystem.general
 To: arslist@ARSLIST.ORG
 Sent: Saturday, June 05, 2010 8:46 PM
 Subject: Re: Active link Else Action not working


 ** Hi Angus,

if the qualification does not find any match
   --Where are you checking this part? in Run If?

   If I understand your question correctly, then this 'digits' != 
is not equal to Employee not found. If if I input a number which does 
not

exist in database digits field is still not empty and hence 'digits' != 
will not fail, in which case If action is executed and If No Requests
Match: Do Not Show Any Message and suppress empty list. happens.


   In other words, the only time I see your Else action getting

executed is when there is no data entered in digits field (as per Run If
that you have provided here).


   Correct me if I am wrong in understanding your question.

   Thanks,
   Chintan

   --- On Sat, 6/5/10, Angus Comber arsl...@iteloffice.com wrote:


 From: Angus Comber arsl...@iteloffice.com
 Subject: Active link Else Action not working
 To: arslist@ARSLIST.ORG
 Date: Saturday, June 5, 2010, 8:58 AM


 **
 Hello

 I have a button on a form which fires an active link which is

configured like this:


 1. active link named processdigits.  Run if 'digits' !=  and

execute on button (on my form).


 2. If action tab, action=Open Window, window type=Modify, 
Display

Type=Detail Only, Form name=employees


 Qualification 'employeeid' = $digits$

 If No Requests Match: Do Not Show Any Message and suppress empty

list.


 The If Action part works fine.

 In the Else Action Tab I have:
 Current Action=Open window
 Window Type=Submit
 Form name=employees

 Field mapping
 employeeid mapped to $digits$

 My problem is that the Else Action never gets called.

 So, if the qualification in the If Action finds a match then 
this

executes ok and I see the found employee ok.


 But if the qualification does not find any match then the Else

Action is not executed.


 What am I doing wrong?

 Angus

 _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_

 _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_

___



UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are