**

I've got a macro kicking off that runs stored queries in a field. I want to query for tickets that the status.history.pending.TIME = $NULL$

The macro looks like:
-------------------
QueryRun
Set-schema: $zQueryForm$
$%$
No-empty-list:
Sort-options: $zQueryForm$
$%$|2|3|$Sort Field1$\$Sort Order1$|$Sort Field2$\$Sort Order2$|$Sort Field3$\$Sort Order3$|
Query: $zQueryString$
Entry-list: $Polling$
end
-------------------

When I put in something like:
( '7' = "Resolved" OR '7' = "Closed" ) AND ('Status-History.Assigned.TIME' = $NULL$)

I end up with a "Field or value expected at this position.: position 78 (...igned.TIME' = )^ (ARERR 1584)

So I tried to use $NULL$ as if it were in an external link.
and when I have the assigned.TIME = $\NULL$
it seems to make no difference.

If I use "$\NULL$" within the " ", I end up getting an error that shows the value as "BLANK".

What am I doing wrong here? I have to run this as a macro, and need to pull the values from a field, so I wanted to figure out what way I could trick the system into showing me tickets where the pending time had never been set (IE: The ticket was never marked as pending.)

Can anyone help me out? Thanks!
This posting was submitted via the Web interface

**
Hi "ARS List" ???

You could try using $NU$NULL$LL$ - the $NULL$ in the center will resolve to nothing and leave you with the string $NULL$. This sort of trick works in some situations - haven't tried it with macros

HTH

David Sanders
Remedy Solution Architect
Enterprise Service Suite @ Work
==========================
ARS List Award Winner 2005
Best 3rd party Remedy Application

tel +44 1494 468980
mobile +44 7710 377761
email david.sanders@westoverconsulting.co.uk

web http://www.westoverconsulting.co.uk


-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]On Behalf Of ARS List
Sent: Monday, December 12, 2005 5:54 PM
To: arslist@ARSLIST.ORG
Subject: $NULL$ when passed to query macro for date field


**

I've got a macro kicking off that runs stored queries in a field. I want to query for tickets that the status.history.pending.TIME = $NULL$

The macro looks like:
-------------------
QueryRun
Set-schema: $zQueryForm$
$%$
No-empty-list:
Sort-options: $zQueryForm$
$%$|2|3|$Sort Field1$\$Sort Order1$|$Sort Field2$\$Sort Order2$|$Sort Field3$\$Sort Order3$|
Query: $zQueryString$
Entry-list: $Polling$
end
-------------------

When I put in something like:
( '7' = "Resolved" OR '7' = "Closed" ) AND ('Status-History.Assigned.TIME' = $NULL$)

I end up with a "Field or value expected at this position.: position 78 (...igned.TIME' = )^ (ARERR 1584)

So I tried to use $NULL$ as if it were in an external link.
and when I have the assigned.TIME = $\NULL$
it seems to make no difference.

If I use "$\NULL$" within the " ", I end up getting an error that shows the value as "BLANK".

What am I doing wrong here? I have to run this as a macro, and need to pull the values from a field, so I wanted to figure out what way I could trick the system into showing me tickets where the pending time had never been set (IE: The ticket was never marked as pending.)

Can anyone help me out? Thanks!
This posting was submitted via the Web interface

This posting was submitted via the Web interface

**
Try $--1$ (note there are two dashes)

Regards
PC Wai
TELUS Corporation Inc.




From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Sanders
Sent: Monday, December 12, 2005 01:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: $NULL$ when passed to query macro for date field


**
Hi "ARS List" ???

You could try using $NU$NULL$LL$ - the $NULL$ in the center will resolve to nothing and leave you with the string $NULL$. This sort of trick works in some situations - haven't tried it with macros

HTH

David Sanders
Remedy Solution Architect
Enterprise Service Suite @ Work
==========================
ARS List Award Winner 2005
Best 3rd party Remedy Application

tel +44 1494 468980
mobile +44 7710 377761
email david.sanders@westoverconsulting.co.uk

web http://www.westoverconsulting.co.uk


-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]On Behalf Of ARS List
Sent: Monday, December 12, 2005 5:54 PM
To: arslist@ARSLIST.ORG
Subject: $NULL$ when passed to query macro for date field


**

I've got a macro kicking off that runs stored queries in a field. I want to query for tickets that the status.history.pending.TIME = $NULL$

The macro looks like:
-------------------
QueryRun
Set-schema: $zQueryForm$
$%$
No-empty-list:
Sort-options: $zQueryForm$
$%$|2|3|$Sort Field1$\$Sort Order1$|$Sort Field2$\$Sort Order2$|$Sort Field3$\$Sort Order3$|
Query: $zQueryString$
Entry-list: $Polling$
end
-------------------

When I put in something like:
( '7' = "Resolved" OR '7' = "Closed" ) AND ('Status-History.Assigned.TIME' = $NULL$)

I end up with a "Field or value expected at this position.: position 78 (...igned.TIME' = )^ (ARERR 1584)

So I tried to use $NULL$ as if it were in an external link.
and when I have the assigned.TIME = $\NULL$
it seems to make no difference.

If I use "$\NULL$" within the " ", I end up getting an error that shows the value as "BLANK".

What am I doing wrong here? I have to run this as a macro, and need to pull the values from a field, so I wanted to figure out what way I could trick the system into showing me tickets where the pending time had never been set (IE: The ticket was never marked as pending.)

Can anyone help me out? Thanks!
This posting was submitted via the Web interface

This posting was submitted via the Web interface
This posting was submitted via the Web interface

** Neither of those seemed to work. Unless I use Null with the $\NULL$ (slash) in front of it, it is evaluated on saving the query. So when I hit save, even with $NU$NULLLL$ and with $--1$, it saves the string without anything there. Any other ideas? I really appreciate the help!


On 12/12/05, PC Wai wrote:

**
Try $--1$ (note there are two dashes)

Regards
PC Wai
TELUS Corporation Inc.




From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG ] On Behalf Of David Sanders
Sent: Monday, December 12, 2005 01:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: $NULL$ when passed to query macro for date field



**
Hi "ARS List" ???

You could try using $NU$NULL$LL$ - the $NULL$ in the center will resolve to nothing and leave you with the string $NULL$. This sort of trick works in some situations - haven't tried it with macros

HTH

David Sanders
Remedy Solution Architect
Enterprise Service Suite @ Work
==========================
ARS List Award Winner 2005
Best 3rd party Remedy Application

tel +44 1494 468980
mobile +44 7710 377761
email david.sanders@westoverconsulting.co.uk

web http://www.westoverconsulting.co.uk


-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG ]On Behalf Of ARS List
Sent: Monday, December 12, 2005 5:54 PM
To: arslist@ARSLIST.ORG
Subject: $NULL$ when passed to query macro for date field


**

I've got a macro kicking off that runs stored queries in a field. I want to query for tickets that the status.history.pending.TIME = $NULL$

The macro looks like:
-------------------
QueryRun
Set-schema: $zQueryForm$
$%$
No-empty-list:
Sort-options: $zQueryForm$
$%$|2|3|$Sort Field1$\$Sort Order1$|$Sort Field2$\$Sort Order2$|$Sort Field3$\$Sort Order3$|
Query: $zQueryString$
Entry-list: $Polling$
end
-------------------

When I put in something like:
( '7' = "Resolved" OR '7' = "Closed" ) AND ('Status-History.Assigned.TIME' = $NULL$)

I end up with a "Field or value expected at this position.: position 78 (...igned.TIME' = )^ (ARERR 1584)

So I tried to use $NULL$ as if it were in an external link.
and when I have the assigned.TIME = $\NULL$
it seems to make no difference.

If I use "$\NULL$" within the " ", I end up getting an error that shows the value as "BLANK".

What am I doing wrong here? I have to run this as a macro, and need to pull the values from a field, so I wanted to figure out what way I could trick the system into showing me tickets where the pending time had never been set (IE: The ticket was never marked as pending.)

Can anyone help me out? Thanks!
This posting was submitted via the Web interface

This posting was submitted via the Web interface This posting was submitted via the Web interface


This posting was submitted via the Web interface

**
ARS 6.3

I was able create a macro that tested for $NULL$. The attached macro file shows the $--1$ value for null. One thing you could try is to edit your macro file in notepad.exe.

HTH



From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of ARS List
Sent: Wednesday, December 14, 2005 3:31 PM
To: arslist@ARSLIST.ORG
Subject: Re: $NULL$ when passed to query macro for date field


** Neither of those seemed to work. Unless I use Null with the $\NULL$ (slash) in front of it, it is evaluated on saving the query. So when I hit save, even with $NU$NULLLL$ and with $--1$, it saves the string without anything there. Any other ideas? I really appreciate the help!


On 12/12/05, PC Wai wrote:

**
Try $--1$ (note there are two dashes)

Regards
PC Wai
TELUS Corporation Inc.




From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG ] On Behalf Of David Sanders
Sent: Monday, December 12, 2005 01:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: $NULL$ when passed to query macro for date field



**
Hi "ARS List" ???

You could try using $NU$NULL$LL$ - the $NULL$ in the center will resolve to nothing and leave you with the string $NULL$. This sort of trick works in some situations - haven't tried it with macros

HTH

David Sanders
Remedy Solution Architect
Enterprise Service Suite @ Work
==========================
ARS List Award Winner 2005
Best 3rd party Remedy Application

tel +44 1494 468980
mobile +44 7710 377761
email david.sanders@westoverconsulting.co.uk

web http://www.westoverconsulting.co.uk


-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG ]On Behalf Of ARS List
Sent: Monday, December 12, 2005 5:54 PM
To: arslist@ARSLIST.ORG
Subject: $NULL$ when passed to query macro for date field


**

I've got a macro kicking off that runs stored queries in a field. I want to query for tickets that the status.history.pending.TIME = $NULL$

The macro looks like:
-------------------
QueryRun
Set-schema: $zQueryForm$
$%$
No-empty-list:
Sort-options: $zQueryForm$
$%$|2|3|$Sort Field1$\$Sort Order1$|$Sort Field2$\$Sort Order2$|$Sort Field3$\$Sort Order3$|
Query: $zQueryString$
Entry-list: $Polling$
end
-------------------

When I put in something like:
( '7' = "Resolved" OR '7' = "Closed" ) AND ('Status-History.Assigned.TIME' = $NULL$)

I end up with a "Field or value expected at this position.: position 78 (...igned.TIME' = )^ (ARERR 1584)

So I tried to use $NULL$ as if it were in an external link.
and when I have the assigned.TIME = $\NULL$
it seems to make no difference.

If I use "$\NULL$" within the " ", I end up getting an error that shows the value as "BLANK".

What am I doing wrong here? I have to run this as a macro, and need to pull the values from a field, so I wanted to figure out what way I could trick the system into showing me tickets where the pending time had never been set (IE: The ticket was never marked as pending.)

Can anyone help me out? Thanks!
This posting was submitted via the Web interface

This posting was submitted via the Web interface This posting was submitted via the Web interface


This posting was submitted via the Web interface
This posting was submitted via the Web interface

** Maybe I should have explained better. The querys get saved in a character field. Then they are passed to the macro. So when I save the query in the character field, and then pass it as $queryfield$ to my macro (from an active link) it removes the $NULL$'s at that point.


On 12/14/05, Heider, Stephen wrote:

**
ARS 6.3

I was able create a macro that tested for $NULL$. The attached macro file shows the $--1$ value for null. One thing you could try is to edit your macro file in notepad.exe.

HTH



From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG ] On Behalf Of ARS List
Sent: Wednesday, December 14, 2005 3:31 PM
To: arslist@ARSLIST.ORG
Subject: Re: $NULL$ when passed to query macro for date field


** Neither of those seemed to work. Unless I use Null with the $\NULL$ (slash) in front of it, it is evaluated on saving the query. So when I hit save, even with $NU$NULLLL$ and with $--1$, it saves the string without anything there. Any other ideas? I really appreciate the help!



On 12/12/05, PC Wai wrote:

**
Try $--1$ (note there are two dashes)

Regards
PC Wai
TELUS Corporation Inc.




From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG ] On Behalf Of David Sanders
Sent: Monday, December 12, 2005 01:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: $NULL$ when passed to query macro for date field



**
Hi "ARS List" ???

You could try using $NU$NULL$LL$ - the $NULL$ in the center will resolve to nothing and leave you with the string $NULL$. This sort of trick works in some situations - haven't tried it with macros

HTH

David Sanders
Remedy Solution Architect
Enterprise Service Suite @ Work
==========================
ARS List Award Winner 2005
Best 3rd party Remedy Application

tel +44 1494 468980
mobile +44 7710 377761
email david.sanders@westoverconsulting.co.uk

web http://www.westoverconsulting.co.uk


-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG ]On Behalf Of ARS List
Sent: Monday, December 12, 2005 5:54 PM
To: arslist@ARSLIST.ORG
Subject: $NULL$ when passed to query macro for date field


**

I've got a macro kicking off that runs stored queries in a field. I want to query for tickets that the status.history.pending.TIME = $NULL$

The macro looks like:
-------------------
QueryRun
Set-schema: $zQueryForm$
$%$
No-empty-list:
Sort-options: $zQueryForm$
$%$|2|3|$Sort Field1$\$Sort Order1$|$Sort Field2$\$Sort Order2$|$Sort Field3$\$Sort Order3$|
Query: $zQueryString$
Entry-list: $Polling$
end
-------------------

When I put in something like:
( '7' = "Resolved" OR '7' = "Closed" ) AND ('Status-History.Assigned.TIME' = $NULL$)

I end up with a "Field or value expected at this position.: position 78 (...igned.TIME' = )^ (ARERR 1584)

So I tried to use $NULL$ as if it were in an external link.
and when I have the assigned.TIME = $\NULL$
it seems to make no difference.

If I use "$\NULL$" within the " ", I end up getting an error that shows the value as "BLANK".

What am I doing wrong here? I have to run this as a macro, and need to pull the values from a field, so I wanted to figure out what way I could trick the system into showing me tickets where the pending time had never been set (IE: The ticket was never marked as pending.)

Can anyone help me out? Thanks!
This posting was submitted via the Web interface

This posting was submitted via the Web interface This posting was submitted via the Web interface


This posting was submitted via the Web interface This posting was submitted via the Web interface



This posting was submitted via the Web interface