Re: Run If check for a Diary field

2011-08-15 Thread Reiser, John J 
The SET FIELD action should be against the arserver|arform that you just
opened with a 'Request_ID' = $Request_ID$ qualification.

On the CURRENT form the Diary field will only display the edit section which
is null.

 

--- 
John J. Reiser 
Remedy Developer/Administrator 

Senior Software Development Analyst 
Lockheed Martin - MS2 
The star that burns twice as bright burns half as long. 
Pay close attention and be illuminated by its brilliance. - paraphrased by
me 

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew C Goodall
Sent: Friday, August 12, 2011 8:01 PM
To: arslist@ARSLIST.ORG
Subject: EXTERNAL: Re: Run If check for a Diary field

 

** 

This might be a silly answer if you've already tried, but what about 'Diary
field' != ""

 

Regards,

 

Andrew Goodall

Software Engineer 2 | Development Services |  jcpenney . www.jcp.com
<http://www.jcp.com/>   |  972.431.1518

  _  

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Schryver, Curt
Sent: Friday, August 12, 2011 6:58 PM
To: arslist@ARSLIST.ORG
Subject: Re: Run If check for a Diary field

 

Sorry it took so long to get back on this.  I just assumed it would work
since it seems so logical, but it does not.  No errors, just no data showing
up in my temporary field.  I also tried LENGTHC($field$) and that didn't
work either.  Just stays blank.

 

Any other suggestions?

 

Curt A. Schryver 
Action Request System Administrator
TE Connectivity
717-810-2109 tel
717-810-2124 fax
cschry...@te.com

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Tuesday, August 02, 2011 4:25 PM
To: arslist@ARSLIST.ORG
Subject: Re: Run If check for a Diary field

 

** 

Do a setfields from the current record into a 0 length hidden char field,
then run a != $NULL$ against that.

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Schryver, Curt
Sent: Tuesday, August 02, 2011 2:01 PM
To: arslist@ARSLIST.ORG
Subject: Run If check for a Diary field

 

** 

Hope this isn't TOO much of a silly question, but I can't seem to figure it
out.

 

I want to display more of an indicator that there is data in a Diary field
than the built-in "there is writing" or "there isn't writing" in the little
book icon.  Using 'Diary field' != $NULL$ doesn't work in the Run If check -
it always resolves that it's Null.  Is there some way to determine that
there is data in a Diary field?

 

Curt A. Schryver 
Action Request System Administrator
TE Connectivity
717-810-2109 tel
717-810-2124 fax
cschry...@te.com

100 AMP Drive
MS 161-043
Harrisburg, PA 17105

 <http://www.te.com/> Description: Logo for emails

 

_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ 

_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_


The information transmitted is intended only for the person or entity to
which it is addressed and 
may contain confidential and/or privileged material. If the reader of this
message is not the intended
recipient, you are hereby notified that your access is unauthorized, and any
review, dissemination,
distribution or copying of this message including any attachments is
strictly prohibited. If you are not
the intended recipient, please contact the sender and delete the material
from any computer.

 

_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend
WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
<>

smime.p7s
Description: S/MIME cryptographic signature

Re: Run If check for a Diary field

2011-08-12 Thread Ben Chernys 
I think this was already replied to correctly earlier.

 

Diary fields, when referenced in qualifications only reference transaction
data.  To see if there are previous entries in a Diary field, simply set a
DO integer field from direct SQL.  

 

For example, in field "diary_field" in table "mytable" with field '1' named
"request_id" and field xxx being a DO integer with change off:

 

  select length(diary_field) from mytable where request_id = $request_id$

 

set field xxx with that value ($1$).

 

Then, if xxx contains 0, no previous data in a diary field.  Else, previous
data exists in that field.

 

Cheers

 

Ben Chernys

Senior Software Architect
Software Tool House Inc.

Canada / Deutschland / Germany
Mobile:  +49 171 380 2329GMT + 1 + [ DST ]
Email:<mailto:ben.cher...@softwaretoolhouse.com> Ben.Chernys _AT_
softwaretoolhouse.com
Web:  <http://www.softwaretoolhouse.com> www.softwaretoolhouse.com

Check out Software Tool House's free Diary Editor.

Meta-Update, our premium ARS Data tool, lets you automate 
your imports, migrations, in no time at all, without programming, 
without staging forms, without merge workflow. 
 <http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/  

 

 

 

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew C Goodall
Sent: August-12-11 18:01
To: arslist@ARSLIST.ORG
Subject: Re: Run If check for a Diary field

 

** 

This might be a silly answer if you've already tried, but what about 'Diary
field' != ""

 

Regards,

 

Andrew Goodall

Software Engineer 2 | Development Services |  jcpenney . www.jcp.com
<http://www.jcp.com/>   |  972.431.1518

  _  

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Schryver, Curt
Sent: Friday, August 12, 2011 6:58 PM
To: arslist@ARSLIST.ORG
Subject: Re: Run If check for a Diary field

 

Sorry it took so long to get back on this.  I just assumed it would work
since it seems so logical, but it does not.  No errors, just no data showing
up in my temporary field.  I also tried LENGTHC($field$) and that didn't
work either.  Just stays blank.

 

Any other suggestions?

 

Curt A. Schryver 
Action Request System Administrator
TE Connectivity
717-810-2109 tel
717-810-2124 fax
cschry...@te.com

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Tuesday, August 02, 2011 4:25 PM
To: arslist@ARSLIST.ORG
Subject: Re: Run If check for a Diary field

 

** 

Do a setfields from the current record into a 0 length hidden char field,
then run a != $NULL$ against that.

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Schryver, Curt
Sent: Tuesday, August 02, 2011 2:01 PM
To: arslist@ARSLIST.ORG
Subject: Run If check for a Diary field

 

** 

Hope this isn't TOO much of a silly question, but I can't seem to figure it
out.

 

I want to display more of an indicator that there is data in a Diary field
than the built-in "there is writing" or "there isn't writing" in the little
book icon.  Using 'Diary field' != $NULL$ doesn't work in the Run If check -
it always resolves that it's Null.  Is there some way to determine that
there is data in a Diary field?

 

Curt A. Schryver 
Action Request System Administrator
TE Connectivity
717-810-2109 tel
717-810-2124 fax
cschry...@te.com

100 AMP Drive
MS 161-043
Harrisburg, PA 17105

 <http://www.te.com/> Description: Logo for emails

 

_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ 

_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_


The information transmitted is intended only for the person or entity to
which it is addressed and 
may contain confidential and/or privileged material. If the reader of this
message is not the intended
recipient, you are hereby notified that your access is unauthorized, and any
review, dissemination,
distribution or copying of this message including any attachments is
strictly prohibited. If you are not
the intended recipient, please contact the sender and delete the material
from any computer.

 

_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend
WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
<>

Re: Run If check for a Diary field

2011-08-12 Thread Andrew C Goodall 
This might be a silly answer if you've already tried, but what about
'Diary field' != ""

 

Regards,

 

Andrew Goodall

Software Engineer 2 | Development Services |  jcpenney . www.jcp.com
<http://www.jcp.com/>  |  972.431.1518



From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Schryver, Curt
Sent: Friday, August 12, 2011 6:58 PM
To: arslist@ARSLIST.ORG
Subject: Re: Run If check for a Diary field

 

Sorry it took so long to get back on this.  I just assumed it would work
since it seems so logical, but it does not.  No errors, just no data
showing up in my temporary field.  I also tried LENGTHC($field$) and
that didn't work either.  Just stays blank.

 

Any other suggestions?

 

Curt A. Schryver 
Action Request System Administrator
TE Connectivity
717-810-2109 tel
717-810-2124 fax
cschry...@te.com

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Tuesday, August 02, 2011 4:25 PM
To: arslist@ARSLIST.ORG
Subject: Re: Run If check for a Diary field

 

** 

Do a setfields from the current record into a 0 length hidden char
field, then run a != $NULL$ against that.

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Schryver, Curt
Sent: Tuesday, August 02, 2011 2:01 PM
To: arslist@ARSLIST.ORG
Subject: Run If check for a Diary field

 

** 

Hope this isn't TOO much of a silly question, but I can't seem to figure
it out.

 

I want to display more of an indicator that there is data in a Diary
field than the built-in "there is writing" or "there isn't writing" in
the little book icon.  Using 'Diary field' != $NULL$ doesn't work in the
Run If check - it always resolves that it's Null.  Is there some way to
determine that there is data in a Diary field?

 

Curt A. Schryver 
Action Request System Administrator
TE Connectivity
717-810-2109 tel
717-810-2124 fax
cschry...@te.com

100 AMP Drive
MS 161-043
Harrisburg, PA 17105

  <http://www.te.com/> 

 

_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ 

_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_

_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
The information transmitted is 
intended only for the person or entity to which it is addressed and may 
contain confidential and/or privileged material.  If the reader of this message 
is not the intendedrecipient, you are hereby notified that your access is 
unauthorized, and any review, dissemination,distribution or copying of this 
message including any attachments is strictly prohibited.   If you are 
notthe intended recipient, please contact the sender and delete the 
material from any computer.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
<>

Re: Run If check for a Diary field

2011-08-12 Thread Schryver, Curt 
Sorry it took so long to get back on this.  I just assumed it would work since 
it seems so logical, but it does not.  No errors, just no data showing up in my 
temporary field.  I also tried LENGTHC($field$) and that didn't work either.  
Just stays blank.

Any other suggestions?

Curt A. Schryver
Action Request System Administrator
TE Connectivity
717-810-2109 tel
717-810-2124 fax
cschry...@te.com

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Tuesday, August 02, 2011 4:25 PM
To: arslist@ARSLIST.ORG
Subject: Re: Run If check for a Diary field

**
Do a setfields from the current record into a 0 length hidden char field, then 
run a != $NULL$ against that.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Schryver, Curt
Sent: Tuesday, August 02, 2011 2:01 PM
To: arslist@ARSLIST.ORG
Subject: Run If check for a Diary field

**
Hope this isn't TOO much of a silly question, but I can't seem to figure it out.

I want to display more of an indicator that there is data in a Diary field than 
the built-in "there is writing" or "there isn't writing" in the little book 
icon.  Using 'Diary field' != $NULL$ doesn't work in the Run If check - it 
always resolves that it's Null.  Is there some way to determine that there is 
data in a Diary field?

Curt A. Schryver
Action Request System Administrator
TE Connectivity
717-810-2109 tel
717-810-2124 fax
cschry...@te.com<mailto:cschry...@te.com>
100 AMP Drive
MS 161-043
Harrisburg, PA 17105
[cid:image001.png@01CC5929.3DA5D0B0]<http://www.te.com/>

_attend WWRUG11 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers 
Are"_
_attend WWRUG11 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers 
Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
<>

Re: Run If check for a Diary field

2011-08-02 Thread LJ LongWing 
Do a setfields from the current record into a 0 length hidden char field,
then run a != $NULL$ against that.

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Schryver, Curt
Sent: Tuesday, August 02, 2011 2:01 PM
To: arslist@ARSLIST.ORG
Subject: Run If check for a Diary field

 

** 

Hope this isn't TOO much of a silly question, but I can't seem to figure it
out.

 

I want to display more of an indicator that there is data in a Diary field
than the built-in "there is writing" or "there isn't writing" in the little
book icon.  Using 'Diary field' != $NULL$ doesn't work in the Run If check -
it always resolves that it's Null.  Is there some way to determine that
there is data in a Diary field?

 

Curt A. Schryver 
Action Request System Administrator
TE Connectivity
717-810-2109 tel
717-810-2124 fax
cschry...@te.com

100 AMP Drive
MS 161-043
Harrisburg, PA 17105

 <http://www.te.com/>  

 

_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
<>

Run If check for a Diary field

2011-08-02 Thread Schryver, Curt 
Hope this isn't TOO much of a silly question, but I can't seem to figure it out.

I want to display more of an indicator that there is data in a Diary field than 
the built-in "there is writing" or "there isn't writing" in the little book 
icon.  Using 'Diary field' != $NULL$ doesn't work in the Run If check - it 
always resolves that it's Null.  Is there some way to determine that there is 
data in a Diary field?

Curt A. Schryver
Action Request System Administrator
TE Connectivity
717-810-2109 tel
717-810-2124 fax
cschry...@te.com
100 AMP Drive
MS 161-043
Harrisburg, PA 17105
[cid:image001.png@01CC512D.55E17980]


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
<>