What about attacking this at the DBMS level? You said you had to use a non-Remedy solution, so why not bribe the DBAs to give you a RO view of the table(s) your reports need, and put them in a place where your reporting system can get to them? I suffer from no delusions that it will be as easy as that, but perhaps it is another avenue worth pursuing?

Rick

-----Original Message-----
From: Zandi Patrick S TSgt AFRL/IFOSS [mailto:Patrick.Zandi@RL.AF.MIL]
Sent: Tuesday, December 31, 2002 6:37 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: "Last Full Month" query options in Remedy?


Whoops -- I was not finished --
There are 2 ideas , 1 is a month by month - with the dates hard
coded
There is also the single idea with the option you put in the dates
as below
I believe there is another way -- with date however you have to do
this one on
the last day of the month only !

-----Original Message-----
From: Zandi Patrick S TSgt AFRL/IFOSS
Sent: Tuesday, December 31, 2002 9:31 AM
To: 'arslist@ARSLIST.ORG'
Subject: RE: "Last Full Month" query options in Remedy?


What about a macro query ?
For Example turn the macro on and in the advanced bar type
'Create-date' >= "$Enter Create Date$" AND 'Create-date' <= "$Enter
Finish Date$"
Then search ... Save macro NAME it the Month you want --Now you will have
12 macro's

-----Original Message-----
From: Rebecca Hammond [mailto:rebecca.hammond@MARSH.COM]
Sent: Tuesday, December 31, 2002 8:09 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: "Last Full Month" query options in Remedy?


Matt/Joel,

Thanks for the replies...both options would absolutely do the trick, but
unfortunately, I have no access to Remedy as an Administrator, nor do I have
access to the server (for this project, I'm just setting up a reporting
system, and since the Remedy applications are owned by a different division
of the company (read - politics), I'm forced to come up with solutions that
don't actually involve remedy development). That's why I was hoping there
was some sort of query syntax that I could actually use within the Remedy
User tool?

Thanks,

Rebecca

On Mon, 30 Dec 2002 14:15:25 -0800, ARSLIST wrote:

>Rebecca,
>Here's an all-ARS approach:
>
>1. Use two temp fields: $mm$ and $yy$
>
>2. In a Link or filter:
> If $Month$ = "January"
> Then $mm$= 13
> $yy$= ($year$ - 1)
> Else $mm$= $month$
> $yy$= $year$
>
>2. Report Start-date = ($mm$-1) / 1 / $yy$
> End-date = $month / 1 / $year$
>
>HTH,
>Joel
>
>QMX Support Services, Inc.
>Joel D. Sender,
>Director of Western Operations
>
>
>
>
>-----Original Message-----
>From: owner-arslist@arslist.org [mailto:owner-arslist@arslist.org]On
>Behalf Of Rebecca Hammond
>Sent: Monday, December 30, 2002 9:32 AM
>To: ARSLIST@ARSLIST.ORG
>Cc: Rebecca Hammond
>Subject: "Last Full Month" query options in Remedy?
>
>
>Hi listers,
>
>Here is my dilemna - I need to run a query in Remedy that returns
>records with a Create Date that falls in the Last Full Month (exactly
>like the Crystal Reports function of the same name). This means,
>although today is the 30th of Dec., the query would only return records
>created between 11/1 and 11/30. Also, I don't (i.e. can't) hard-code
>dates into this query, nor do I want the end-user to type them in.
>Ideally, I'd like to do this through the Client tool (advanced search),
>and unfortunately, I don't have development rights to the schemas I'm
>working with, so I can't construct any workflow to do anything like
>this.
>
>Any suggestions?
>
>Thanks,
>Rebecca Hammond
>
>
>

>
>You may control your subscription options, including UNSUBSCRIBE,and
>ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support,
>please send eMail to support@arslist.org
>
>
>

>You may control your subscription options, including UNSUBSCRIBE,and
ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please
send eMail to support@arslist.org

Matt/Joel,

Thanks for the replies...both options would absolutely do the trick, but
unfortunately, I have no access to Remedy as an Administrator, nor do I have
access to the server (for this project, I'm just setting up a reporting
system, and since the Remedy applications are owned by a different division
of the company (read - politics), I'm forced to come up with solutions that
don't actually involve remedy development). That's why I was hoping there
was some sort of query syntax that I could actually use within the Remedy
User tool?

Thanks,

Rebecca



You may control your subscription options, including UNSUBSCRIBE,and ACCESS
THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send
eMail to support@arslist.org


You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org


You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org

Matt,
I have a question here on your statement
[Not to mention that Macros are in a mode of "do not use them" because the
vender has replaced the functionality with other constructs and is very
unlikely to continue to support it for much longer. ]

Are you saying CLIENT Side Macro's are going away ? I Know Serverside is
going away...
But I have not Even Heard of any Such rumor ...
I do Agree that if someone changes the underlying field names this can cause
an issue -
But I would also Like to know the person who would do such a thing
in a production
database... ((Silly to me))
I would agree sometimes it has to be done.. But this is definitely
Rare
from my standpoint ..

Like matt my son used to say "What say you"


-----Original Message-----
From: Carey Matthew Black [mailto:matt.black@VERIZON.COM]
Sent: Tuesday, December 31, 2002 9:37 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: "Last Full Month" query options in Remedy?


Rebecca,
Hum. Not a Remedy Developer on that server huh? (Been there, hated
it.. :)
I normally do not suggest this approach as it can be a "long way round
the barn", but it can work under the conditions you are forced to work with.

I see your options as these:


1) Either go to those who are Remedy Developers on that server and give them
a case of Beer (or whatever beverage they desire) and get them to help you
out.

OR,

2) Don't use the Remedy User tool. (There are other "clients", so use
them.)

A) Write a JavaAPI based servlet/web application and let your users use it
to do the reporting.
(Since you described your work as "setting up a reporting system" This
may be your best bet with out the help of a Remedy Developer on that
server.)

B) If a command line interface is acceptable then I would suggest an ARSPerl
script.
C) If a command line interface is not acceptable then go to VBA (from
Excel) and use some of the VBA --> C API (COM module?) that is available.
D) You mentioned a Crystal Reports function. Why not use that (ODBC) client?


The root problem is that the macro language is just not very flexible.
[Not to mention that Macros are in a mode of "do not use them" because the
vender has replaced the functionality with other constructs and is very
unlikely to continue to support it for much longer. ] What your trying to
do really does require some "client side programming". In ARS programming
constructs most closely maps to fields. (AKA: a programming variable = ARS
field) If you can not add new variables then you can not do much in the way
of programming at the client level in the User tool. However there are other
client environments that will allow you to make variables and use true
programming constructs. :)


Oh, Why did I not think of this sooner....
3) If you do have Remedy Developer writes on a different server.... (and
you are a Remedy Developer) then see if you can get a def file from the
application. (Again, see those who do have admin writes on the server in
question.) Then build a set of forms that do the reporting you want without
altering the existing application. Then beg/borrow and plead for the admins
to import your forms. :) That way you ask "them" to do two things (Export,
then later import) and your "reporting application" should be "stand alone"
and not interfere with their application.

3.a) If you get really tricky, then you might be able to "hack" your def
file and point the objects at the other server too. Maybe... then your users
can use your ARS server and application to get data from the "other server".
Your users will need access to the "other server" and the account names and
passwords will need to match. However those details should be possible.
[Assuming that you can alter the objects on your server to point at a server
that you do not have admin access on. I think that is possible. Hum....]

Hope that helps. (some)
Good luck.

--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS=Action Request System(Remedy)

Solution = People + Process + Tools
Fast, Accurate, Cheap.... Pick two.



"Rebecca Hammond"
MARSH.COM> cc:
Sent by: "Action Subject: Re: "Last Full
Month" query options in Remedy?
Request System
discussion
list(ARSList)"
ORG>


12/31/2002 07:08
AM
Please respond to
arslist






Matt/Joel,

Thanks for the replies...both options would absolutely do the trick, but
unfortunately, I have no access to Remedy as an Administrator, nor do I have
access to the server (for this project, I'm just setting up a reporting
system, and since the Remedy applications are owned by a different division
of the company (read - politics), I'm forced to come up with solutions that
don't actually involve remedy development). That's why I was hoping there
was some sort of query syntax that I could actually use within the Remedy
User tool?

Thanks,

Rebecca

On Mon, 30 Dec 2002 14:15:25 -0800, ARSLIST wrote:

>Rebecca,
>Here's an all-ARS approach:
>
>1. Use two temp fields: $mm$ and $yy$
>
>2. In a Link or filter:
> If $Month$ = "January"
> Then $mm$= 13
> $yy$= ($year$ - 1)
> Else $mm$= $month$
> $yy$= $year$
>
>2. Report Start-date = ($mm$-1) / 1 / $yy$
> End-date = $month / 1 / $year$
>
>HTH,
>Joel
>
>QMX Support Services, Inc.
>Joel D. Sender,
>Director of Western Operations
>
>
>
>
>-----Original Message-----
>From: owner-arslist@arslist.org [mailto:owner-arslist@arslist.org]On
>Behalf Of Rebecca Hammond
>Sent: Monday, December 30, 2002 9:32 AM
>To: ARSLIST@ARSLIST.ORG
>Cc: Rebecca Hammond
>Subject: "Last Full Month" query options in Remedy?
>
>
>Hi listers,
>
>Here is my dilemna - I need to run a query in Remedy that returns
>records with a Create Date that falls in the Last Full Month (exactly
>like the Crystal Reports function of the same name). This means,
>although today is the 30th of Dec., the query would only return records
>created between 11/1 and 11/30. Also, I don't (i.e. can't) hard-code
>dates into this query,
nor
>do I want the end-user to type them in. Ideally, I'd like to do this
>through the Client tool (advanced search), and unfortunately, I don't
>have development rights to the schemas I'm working with, so I can't
>construct any workflow to do anything like this.
>
>Any suggestions?
>
>Thanks,
>Rebecca Hammond
>
>


>
>You may control your subscription options, including UNSUBSCRIBE,and
ACCESS
>THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please
>send eMail to support@arslist.org
>
>


>You may control your subscription options, including UNSUBSCRIBE,and
ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please
send eMail to support@arslist.org

Matt/Joel,

Thanks for the replies...both options would absolutely do the trick, but
unfortunately, I have no access to Remedy as an Administrator, nor do I have
access to the server (for this project, I'm just setting up a reporting
system, and since the Remedy applications are owned by a different division
of the company (read - politics), I'm forced to come up with solutions that
don't actually involve remedy development). That's why I was hoping there
was some sort of query syntax that I could actually use within the Remedy
User tool?

Thanks,

Rebecca




You may control your subscription options, including UNSUBSCRIBE,and ACCESS
THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send
eMail to support@arslist.org



You may control your subscription options, including UNSUBSCRIBE,and ACCESS
THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send
eMail to support@arslist.org


You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org

Patrick,

I am not privileged to any "end date" (or even to a statement that
Remedy will ever discontinue all support for the Remedy Macro language).
However, I think it stands to reason that, if a vender can do every old
task in a new way (AKA: The new active link actions/Processes) then why
would the vender want to maintain the old way too?
I just expect Remedy v6, v7, or maybe v8 to finally say... "try to
not use macros because we will not support them in v(X+1)."

At the very least, I expect a major substitution to happen. (Maybe
that is why they took the time to write the server side Macro converter?
Maybe it will show up in the User tool to "translate" the old macros into
the "new thing" at some point?)

Personally, I hope for a day that users can define objects that
greatly resemble active links. (without some of the more dangerous actions
like direct SQL, or running processes on the server side, etc..) I tend to
think that would be a faster solution to Remedy's client tools need for a
client side scripting language. Save those things in the "preference
server", and add to them the idea of "Row level access" and you have quite
a good model. (Hum, and again that macro converter code might come in very
handy.... I am just guessing here folks. Do not get your hopes up for that.
:)
[Ultimately, a fully functional client side scripting language would
be a better tool than an "Lite Active Link", but I do not see that
happening anytime soon.]


I try to design my ARS applications around the idea that my ARS
client may "misbehave".
Let me clarify that.
If a person uses the Remedy API then there are no active links in the
model. So if my application depends on Active links to "do the right thing"
then my application design is flawed. Furthermore, I want my users to be
able to do what ever they need to do with the data and be able to show me
how to better relate "this data" to "that data". (Often users better
understand the way an application is used than the way it was designed.)
There are other cases where there might be client side bugs that
might cause things to "go off into the weeds too." So again, planning for
your application to only require server side workflow to function properly
is a "good" design.

IMHO:
Active Links are actions that the users should do for themselves, but
are repetitious. So the repetition can be removed by "helping the user to
do their job".
Active Links can also be used to optimize network traffic, by
verifying/checking field formats/content on the client before the data is
sent to the server. However, if the verification needs data from a
different data row then that will cause network traffic too. So there are
limited "valid" uses in this case.
When you couple that with the idea that Active Links are "optional",
well that really brings home the importance of having your filters do most.
if not all, of the validations too. Once duplicated, then the question
becomes: Is the double work really saving us anything?

In general a great "attack"(hack) on any system is to use a "slightly
broken" client. So as a developer you have to keep in mind that the client
is only as trust worthy as you are willing to be vulnerable to a "slightly
broken" client.


Please do not let the paranoid rambling of one developer scare you.

To date I know of no security risks created by the use of ARS. (Yes you
need to use the enhanced encryption tools to really get security over the
network. However, who does not trust the network wire that they use? Just
ME?)
However, not knowing can be as dangerous as using MicroSwissCheese
programs.

Better to try to plan on controlling the things that you have a chance of
controlling than to try to control the things that you can not control.


--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS=Action Request System(Remedy)

Solution = People + Process + Tools
Fast, Accurate, Cheap.... Pick two.



"Zandi Patrick S
TSgt AFRL/IFOSS" To: ARSLIST@ARSLIST.ORG
.AF.MIL> Subject: Re: "Last Full Month" query options in Remedy?
Sent by: "Action
Request System
discussion
list(ARSList)"
ORG>


12/31/2002 08:58
AM
Please respond to
arslist






Matt,
I have a question here on your statement
[Not to mention that Macros are in a mode of "do not use them" because the
vender has replaced the functionality with other constructs and is very
unlikely to continue to support it for much longer. ]

Are you saying CLIENT Side Macro's are going away ? I Know Serverside is
going away...
But I have not Even Heard of any Such rumor ...
I do Agree that if someone changes the underlying field names this can
cause
an issue -
But I would also Like to know the person who would do such a thing
in a production
database... ((Silly to me))
I would agree sometimes it has to be done.. But this is definitely
Rare
from my standpoint ..

Like matt my son used to say "What say you"


You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org

All,

Thanks so much to everyone for the great ideas...

Matt - I liked your original suggestions (particularly the bribing), but
since I'm a consultant on this project, I just don't have the
relationship/pull/etc. to do it. I don't have Admin rights to any of their
Remedy servers, nor do I have any access to either the Unix box (so I could
put a script on there), or the Oracle DB (so that I could read data
directly from the DB) - at least not yet. I do, however, have fun writing
up my status reports with points outlining how this/that tiny/transparent
Remedy modification would not only ease my tasks, but make their apps run
more efficiently, and offering to write the sample code for them (yes, I am
a remedy developer by trade). The sound of the crickets may be deafening,
but it still makes me feel better.

I really like the outside tool suggestions too, but since I'm 1 month into
a 3 month gig, not sure I'll have the time (and I do have other ideas
floating around in my brain that won't involve pulling the data from the
production server), but I'm going to give them some more thought.

Patrick - I did use your Macro suggestion for a temporary fix, and added on
to it by adding on the extra step of recording the report generation and
export to a *.csv - that way, the end user just has to upload to an Access
table (which their current method of hitting reporting) and point the
Crystal Reports I'm writing to it. Again, this may not be the final
solution, but it goes faster than the purely manual search/report
run/export method they do in Remedy currently.

And I only needed one - they just plug whichever date range in they need
for a given month - not sure why you said I'd have to create twelve
separate macros?

Again, thanks to everyone!

-Rebecca


On Tue, 31 Dec 2002 09:44:30 -0600, Carey Matthew Black
wrote:

>Patrick,
>
> I am not privileged to any "end date" (or even to a statement that
>Remedy will ever discontinue all support for the Remedy Macro language).
>However, I think it stands to reason that, if a vender can do every old
>task in a new way (AKA: The new active link actions/Processes) then why
>would the vender want to maintain the old way too?
> I just expect Remedy v6, v7, or maybe v8 to finally say... "try to
>not use macros because we will not support them in v(X+1)."
>
> At the very least, I expect a major substitution to happen. (Maybe
>that is why they took the time to write the server side Macro converter?
>Maybe it will show up in the User tool to "translate" the old macros into
>the "new thing" at some point?)
>
> Personally, I hope for a day that users can define objects that
>greatly resemble active links. (without some of the more dangerous actions
>like direct SQL, or running processes on the server side, etc..) I tend to
>think that would be a faster solution to Remedy's client tools need for a
>client side scripting language. Save those things in the "preference
>server", and add to them the idea of "Row level access" and you have quite
>a good model. (Hum, and again that macro converter code might come in very
>handy.... I am just guessing here folks. Do not get your hopes up for that.
>:)
> [Ultimately, a fully functional client side scripting language would
>be a better tool than an "Lite Active Link", but I do not see that
>happening anytime soon.]
>
>
> I try to design my ARS applications around the idea that my ARS
>client may "misbehave".
> Let me clarify that.
> If a person uses the Remedy API then there are no active links in the
>model. So if my application depends on Active links to "do the right thing"
>then my application design is flawed. Furthermore, I want my users to be
>able to do what ever they need to do with the data and be able to show me
>how to better relate "this data" to "that data". (Often users better
>understand the way an application is used than the way it was designed.)
> There are other cases where there might be client side bugs that
>might cause things to "go off into the weeds too." So again, planning for
>your application to only require server side workflow to function properly
>is a "good" design.
>
>IMHO:
> Active Links are actions that the users should do for themselves, but
>are repetitious. So the repetition can be removed by "helping the user to
>do their job".
> Active Links can also be used to optimize network traffic, by
>verifying/checking field formats/content on the client before the data is
>sent to the server. However, if the verification needs data from a
>different data row then that will cause network traffic too. So there are
>limited "valid" uses in this case.
> When you couple that with the idea that Active Links are "optional",
>well that really brings home the importance of having your filters do most.
>if not all, of the validations too. Once duplicated, then the question
>becomes: Is the double work really saving us anything?
>
> In general a great "attack"(hack) on any system is to use a "slightly
>broken" client. So as a developer you have to keep in mind that the client
>is only as trust worthy as you are willing to be vulnerable to a "slightly
>broken" client.
>
>
>Please do not let the paranoid rambling of one developer scare you.
>
>To date I know of no security risks created by the use of ARS. (Yes you
>need to use the enhanced encryption tools to really get security over the
>network. However, who does not trust the network wire that they use? Just
>ME?)
>However, not knowing can be as dangerous as using MicroSwissCheese
>programs.
>
>Better to try to plan on controlling the things that you have a chance of
>controlling than to try to control the things that you can not control.
>
>
>--
>Carey Matthew Black
>Remedy Skilled Professional (RSP)
>ARS=Action Request System(Remedy)
>
>Solution = People + Process + Tools
>Fast, Accurate, Cheap.... Pick two.
>
>
>
> "Zandi Patrick S
> TSgt AFRL/IFOSS" To:
ARSLIST@ARSLIST.ORG
> > .AF.MIL> Subject: Re: "Last Full
Month" query options in Remedy?
> Sent by: "Action
> Request System
> discussion
> list(ARSList)"
> > ORG>
>
>
> 12/31/2002 08:58
> AM
> Please respond to
> arslist
>
>
>
>
>
>
>Matt,
> I have a question here on your statement
>[Not to mention that Macros are in a mode of "do not use them" because the
>vender has replaced the functionality with other constructs and is very
>unlikely to continue to support it for much longer. ]
>
>Are you saying CLIENT Side Macro's are going away ? I Know Serverside is
>going away...
> But I have not Even Heard of any Such rumor ...
>I do Agree that if someone changes the underlying field names this can
>cause
>an issue -
> But I would also Like to know the person who would do such a thing
>in a production
> database... ((Silly to me))
> I would agree sometimes it has to be done.. But this is definitely
>Rare
> from my standpoint ..
>
>Like matt my son used to say "What say you"
>
>

>You may control your subscription options, including UNSUBSCRIBE,and
ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please
send eMail to support@arslist.org


You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org

Thanks matt,
A little more than needed - But I appreciate your letter =8-}

Remember I only panic when a 97db Klaxon goes off in my left ear,,
and then I have minutes of some Really fast typing to do, and
another 15 minutes of shaking afterward.
You may Never understand this statement - But I would like you to sleep
well at night,, knowing I am and have guarded successfully
the Land you live in. =8->

-----Original Message-----
From: Carey Matthew Black [mailto:matt.black@VERIZON.COM]
Sent: Tuesday, December 31, 2002 10:45 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: "Last Full Month" query options in Remedy?


Patrick,

I am not privileged to any "end date" (or even to a statement that
Remedy will ever discontinue all support for the Remedy Macro language).
However, I think it stands to reason that, if a vender can do every old task
in a new way (AKA: The new active link actions/Processes) then why would the
vender want to maintain the old way too?
I just expect Remedy v6, v7, or maybe v8 to finally say... "try to not
use macros because we will not support them in v(X+1)."

At the very least, I expect a major substitution to happen. (Maybe
that is why they took the time to write the server side Macro converter?
Maybe it will show up in the User tool to "translate" the old macros into
the "new thing" at some point?)

Personally, I hope for a day that users can define objects that
greatly resemble active links. (without some of the more dangerous actions
like direct SQL, or running processes on the server side, etc..) I tend to
think that would be a faster solution to Remedy's client tools need for a
client side scripting language. Save those things in the "preference
server", and add to them the idea of "Row level access" and you have quite a
good model. (Hum, and again that macro converter code might come in very
handy.... I am just guessing here folks. Do not get your hopes up for that.
:)
[Ultimately, a fully functional client side scripting language would
be a better tool than an "Lite Active Link", but I do not see that happening
anytime soon.]


I try to design my ARS applications around the idea that my ARS client
may "misbehave".
Let me clarify that.
If a person uses the Remedy API then there are no active links in the
model. So if my application depends on Active links to "do the right thing"
then my application design is flawed. Furthermore, I want my users to be
able to do what ever they need to do with the data and be able to show me
how to better relate "this data" to "that data". (Often users better
understand the way an application is used than the way it was designed.)
There are other cases where there might be client side bugs that might
cause things to "go off into the weeds too." So again, planning for your
application to only require server side workflow to function properly is a
"good" design.

IMHO:
Active Links are actions that the users should do for themselves, but
are repetitious. So the repetition can be removed by "helping the user to do
their job".
Active Links can also be used to optimize network traffic, by
verifying/checking field formats/content on the client before the data is
sent to the server. However, if the verification needs data from a different
data row then that will cause network traffic too. So there are limited
"valid" uses in this case.
When you couple that with the idea that Active Links are "optional",
well that really brings home the importance of having your filters do most.
if not all, of the validations too. Once duplicated, then the question
becomes: Is the double work really saving us anything?

In general a great "attack"(hack) on any system is to use a "slightly
broken" client. So as a developer you have to keep in mind that the client
is only as trust worthy as you are willing to be vulnerable to a "slightly
broken" client.


Please do not let the paranoid rambling of one developer scare you.

To date I know of no security risks created by the use of ARS. (Yes you need
to use the enhanced encryption tools to really get security over the
network. However, who does not trust the network wire that they use? Just
ME?)
However, not knowing can be as dangerous as using MicroSwissCheese programs.

Better to try to plan on controlling the things that you have a chance of
controlling than to try to control the things that you can not control.


--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS=Action Request System(Remedy)

Solution = People + Process + Tools
Fast, Accurate, Cheap.... Pick two.



"Zandi Patrick S
TSgt AFRL/IFOSS" To: ARSLIST@ARSLIST.ORG
.AF.MIL> Subject: Re: "Last Full
Month" query options in Remedy?
Sent by: "Action
Request System
discussion
list(ARSList)"
ORG>


12/31/2002 08:58
AM
Please respond to
arslist






Matt,
I have a question here on your statement
[Not to mention that Macros are in a mode of "do not use them" because the
vender has replaced the functionality with other constructs and is very
unlikely to continue to support it for much longer. ]

Are you saying CLIENT Side Macro's are going away ? I Know Serverside is
going away...
But I have not Even Heard of any Such rumor ...
I do Agree that if someone changes the underlying field names this can cause
an issue -
But I would also Like to know the person who would do such a thing
in a production
database... ((Silly to me))
I would agree sometimes it has to be done.. But this is definitely
Rare
from my standpoint ..

Like matt my son used to say "What say you"



You may control your subscription options, including UNSUBSCRIBE,and ACCESS
THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send
eMail to support@arslist.org


You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org

Hi listers,

Here is my dilemna - I need to run a query in Remedy that returns records
with a Create Date that falls in the Last Full Month (exactly like the
Crystal Reports function of the same name). This means, although today is
the 30th of Dec., the query would only return records created between 11/1
and 11/30. Also, I don't (i.e. can't) hard-code dates into this query, nor
do I want the end-user to type them in. Ideally, I'd like to do this
through the Client tool (advanced search), and unfortunately, I don't have
development rights to the schemas I'm working with, so I can't construct
any workflow to do anything like this.

Any suggestions?

Thanks,
Rebecca Hammond


You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org

Rebecca,

I created a perl script (printed below) that I put on our server... then,
when I need to get the first day of the month or year, I create a display
only field on whichever form it is, and set it with a set fields active link
using:
$PROCESS$ @@:/path/to/script/getdate.pl month
(or, if you need the first day of the year... $PROCESS$
@@:/path/to/script/getdate.pl year)

#!/usr/local/bin/perl
###########################################################################
# getdate.pl
# Return the epoch date for the first day of the current month or year
# Author: Matt Reinfeldt - mreinfel@uscellular.com -- US Cellular
# Comments:
###########################################################################
use strict;
use Time::Local;

## change to 1 to see debug code....
my $Verbose = 0;

if ($#ARGV < 0) {
print "usage: getdate.pl \n";
exit;
}

my $timeframe = $ARGV[0];
if ($timeframe ne "month" && $timeframe ne "year") {
print "usage: getdate.pl \n";
exit;
}
my $arrLen = $#ARGV;
#print "Array length is: $arrLen\n";

## set up the date information (find the epoch date of the 1st day of the
## current month)
my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime(time);
if ($Verbose) {
print "mday:\t$mday\nmon:\t$mon\nyear:\t$year\n\n";
}
my @months = ('Jan', 'Feb', 'Mar', 'Apr',
'May','Jun','Jul','Aug','Sep','Oct','Nov','Dec');
#my $yr = substr($year + 1900,0,4);
my $time = '';
if ($timeframe eq "month") {
$time = timelocal(0,0,0,1,$mon,$year);
} elsif ($timeframe eq "year") {
$time = timelocal(0,0,0,1,0,$year);
}

print "$time\n";
exit(0);


there's probably an easier way to do it, but I've found this to be pretty
quick and definitely handy!

enjoy!!

Matt R.

-----Original Message-----
From: Rebecca Hammond [mailto:rebecca.hammond@MARSH.COM]
Sent: Monday, December 30, 2002 11:32 AM
To: ARSLIST@ARSLIST.ORG
Subject: "Last Full Month" query options in Remedy?


Hi listers,

Here is my dilemna - I need to run a query in Remedy that returns records
with a Create Date that falls in the Last Full Month (exactly like the
Crystal Reports function of the same name). This means, although today is
the 30th of Dec., the query would only return records created between 11/1
and 11/30. Also, I don't (i.e. can't) hard-code dates into this query, nor
do I want the end-user to type them in. Ideally, I'd like to do this
through the Client tool (advanced search), and unfortunately, I don't have
development rights to the schemas I'm working with, so I can't construct
any workflow to do anything like this.

Any suggestions?

Thanks,
Rebecca Hammond



You may control your subscription options, including UNSUBSCRIBE,and ACCESS
THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send
eMail to support@arslist.org


You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org

Rebecca,
Here's an all-ARS approach:

1. Use two temp fields: $mm$ and $yy$

2. In a Link or filter:
If $Month$ = "January"
Then $mm$= 13
$yy$= ($year$ - 1)
Else $mm$= $month$
$yy$= $year$

2. Report Start-date = ($mm$-1) / 1 / $yy$
End-date = $month / 1 / $year$

HTH,
Joel

QMX Support Services, Inc.
Joel D. Sender,
Director of Western Operations




-----Original Message-----
From: owner-arslist@arslist.org [mailto:owner-arslist@arslist.org]On
Behalf Of Rebecca Hammond
Sent: Monday, December 30, 2002 9:32 AM
To: ARSLIST@ARSLIST.ORG
Cc: Rebecca Hammond
Subject: "Last Full Month" query options in Remedy?


Hi listers,

Here is my dilemna - I need to run a query in Remedy that returns records
with a Create Date that falls in the Last Full Month (exactly like the
Crystal Reports function of the same name). This means, although today is
the 30th of Dec., the query would only return records created between 11/1
and 11/30. Also, I don't (i.e. can't) hard-code dates into this query, nor
do I want the end-user to type them in. Ideally, I'd like to do this
through the Client tool (advanced search), and unfortunately, I don't have
development rights to the schemas I'm working with, so I can't construct
any workflow to do anything like this.

Any suggestions?

Thanks,
Rebecca Hammond



You may control your subscription options, including UNSUBSCRIBE,and ACCESS
THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send
eMail to support@arslist.org


You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org

Matt/Joel,

Thanks for the replies...both options would absolutely do the trick, but
unfortunately, I have no access to Remedy as an Administrator, nor do I
have access to the server (for this project, I'm just setting up a
reporting system, and since the Remedy applications are owned by a
different division of the company (read - politics), I'm forced to come up
with solutions that don't actually involve remedy development). That's why
I was hoping there was some sort of query syntax that I could actually use
within the Remedy User tool?

Thanks,

Rebecca

On Mon, 30 Dec 2002 14:15:25 -0800, ARSLIST wrote:

>Rebecca,
>Here's an all-ARS approach:
>
>1. Use two temp fields: $mm$ and $yy$
>
>2. In a Link or filter:
> If $Month$ = "January"
> Then $mm$= 13
> $yy$= ($year$ - 1)
> Else $mm$= $month$
> $yy$= $year$
>
>2. Report Start-date = ($mm$-1) / 1 / $yy$
> End-date = $month / 1 / $year$
>
>HTH,
>Joel
>
>QMX Support Services, Inc.
>Joel D. Sender,
>Director of Western Operations
>
>
>
>
>-----Original Message-----
>From: owner-arslist@arslist.org [mailto:owner-arslist@arslist.org]On
>Behalf Of Rebecca Hammond
>Sent: Monday, December 30, 2002 9:32 AM
>To: ARSLIST@ARSLIST.ORG
>Cc: Rebecca Hammond
>Subject: "Last Full Month" query options in Remedy?
>
>
>Hi listers,
>
>Here is my dilemna - I need to run a query in Remedy that returns records
>with a Create Date that falls in the Last Full Month (exactly like the
>Crystal Reports function of the same name). This means, although today is
>the 30th of Dec., the query would only return records created between 11/1
>and 11/30. Also, I don't (i.e. can't) hard-code dates into this query, nor
>do I want the end-user to type them in. Ideally, I'd like to do this
>through the Client tool (advanced search), and unfortunately, I don't have
>development rights to the schemas I'm working with, so I can't construct
>any workflow to do anything like this.
>
>Any suggestions?
>
>Thanks,
>Rebecca Hammond
>
>

>
>You may control your subscription options, including UNSUBSCRIBE,and ACCESS
>THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send
>eMail to support@arslist.org
>
>

>You may control your subscription options, including UNSUBSCRIBE,and
ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please
send eMail to support@arslist.org

Matt/Joel,

Thanks for the replies...both options would absolutely do the trick, but
unfortunately, I have no access to Remedy as an Administrator, nor do I
have access to the server (for this project, I'm just setting up a
reporting system, and since the Remedy applications are owned by a
different division of the company (read - politics), I'm forced to come up
with solutions that don't actually involve remedy development). That's why
I was hoping there was some sort of query syntax that I could actually use
within the Remedy User tool?

Thanks,

Rebecca


You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org

What about a macro query ?
For Example turn the macro on and in the advanced bar type
'Create-date' >= "$Enter Create Date$" AND 'Create-date' <= "$Enter
Finish Date$"
Then search ... Save macro NAME it the Month you want --Now you will have
12 macro's

-----Original Message-----
From: Rebecca Hammond [mailto:rebecca.hammond@MARSH.COM]
Sent: Tuesday, December 31, 2002 8:09 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: "Last Full Month" query options in Remedy?


Matt/Joel,

Thanks for the replies...both options would absolutely do the trick, but
unfortunately, I have no access to Remedy as an Administrator, nor do I have
access to the server (for this project, I'm just setting up a reporting
system, and since the Remedy applications are owned by a different division
of the company (read - politics), I'm forced to come up with solutions that
don't actually involve remedy development). That's why I was hoping there
was some sort of query syntax that I could actually use within the Remedy
User tool?

Thanks,

Rebecca

On Mon, 30 Dec 2002 14:15:25 -0800, ARSLIST wrote:

>Rebecca,
>Here's an all-ARS approach:
>
>1. Use two temp fields: $mm$ and $yy$
>
>2. In a Link or filter:
> If $Month$ = "January"
> Then $mm$= 13
> $yy$= ($year$ - 1)
> Else $mm$= $month$
> $yy$= $year$
>
>2. Report Start-date = ($mm$-1) / 1 / $yy$
> End-date = $month / 1 / $year$
>
>HTH,
>Joel
>
>QMX Support Services, Inc.
>Joel D. Sender,
>Director of Western Operations
>
>
>
>
>-----Original Message-----
>From: owner-arslist@arslist.org [mailto:owner-arslist@arslist.org]On
>Behalf Of Rebecca Hammond
>Sent: Monday, December 30, 2002 9:32 AM
>To: ARSLIST@ARSLIST.ORG
>Cc: Rebecca Hammond
>Subject: "Last Full Month" query options in Remedy?
>
>
>Hi listers,
>
>Here is my dilemna - I need to run a query in Remedy that returns
>records with a Create Date that falls in the Last Full Month (exactly
>like the Crystal Reports function of the same name). This means,
>although today is the 30th of Dec., the query would only return records
>created between 11/1 and 11/30. Also, I don't (i.e. can't) hard-code
>dates into this query, nor do I want the end-user to type them in.
>Ideally, I'd like to do this through the Client tool (advanced search),
>and unfortunately, I don't have development rights to the schemas I'm
>working with, so I can't construct any workflow to do anything like
>this.
>
>Any suggestions?
>
>Thanks,
>Rebecca Hammond
>
>
>

>
>You may control your subscription options, including UNSUBSCRIBE,and
>ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support,
>please send eMail to support@arslist.org
>
>
>

>You may control your subscription options, including UNSUBSCRIBE,and
ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please
send eMail to support@arslist.org

Matt/Joel,

Thanks for the replies...both options would absolutely do the trick, but
unfortunately, I have no access to Remedy as an Administrator, nor do I have
access to the server (for this project, I'm just setting up a reporting
system, and since the Remedy applications are owned by a different division
of the company (read - politics), I'm forced to come up with solutions that
don't actually involve remedy development). That's why I was hoping there
was some sort of query syntax that I could actually use within the Remedy
User tool?

Thanks,

Rebecca



You may control your subscription options, including UNSUBSCRIBE,and ACCESS
THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send
eMail to support@arslist.org


You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org