All,
How to capture a single query string.
How can I capture the QBE search criteria and the '1005' search criteria,
combine them into a single search string, without executing the search.
This will then be passed to an EXTERNAL() field for a table qualification.
I can do this with a lot of
I am trying to schedule a web report to run monthly that will pull in all
records that were created in the previous month and not sure how to format the
query. Is there a way to set up a query in Remedy that will pull all the
records created in the previous month? I appreciate any help you
(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Agu, Chike U
Sent: Wednesday, August 12, 2015 11:14 AM
To: arslist@ARSLIST.ORG
Subject: Re: Query question
**
Hi Todd,
Try this:
'Create Date' = ($TIMESTAMP$ - 2678400)
2678400 is in seconds ( 3600 seconds * 24 hours * 31 day in a month
You could do $TIMESTAMP$ - 2629743 to get all records for roughly the last
month. This doesn't take into account the fluctuation in days between
months though.
On Wed, Aug 12, 2015, 10:54 AM Arner, Todd tar...@glhec.org wrote:
**
I am trying to schedule a web report to run monthly that will
To: arslist@ARSLIST.ORG
Subject: Query question
**
I am trying to schedule a web report to run monthly that will pull in all
records that were created in the previous month and not sure how to format the
query. Is there a way to set up a query in Remedy that will pull all the
records created
should be able to help
further.
Regards,
Chike
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Arner, Todd
Sent: Wednesday, August 12, 2015 12:47 PM
To: arslist@ARSLIST.ORG
Subject: Re: Query question
**
Thanks Chike and John for your responses
System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Agu, Chike U
Sent: Wednesday, August 12, 2015 2:02 PM
To: arslist@ARSLIST.ORG
Subject: Re: Query question
**
Todd,
I suppose that would require a little more work. After re-reading your
question, it seems you're just
.
Thanks,
Todd
*From:* Action Request System discussion list(ARSList) [mailto:
arslist@ARSLIST.ORG] *On Behalf Of *Agu, Chike U
*Sent:* Wednesday, August 12, 2015 2:02 PM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: Query question
**
Todd,
I suppose that would require a little
Looks like LJs nailed it.
Regards,
Chike
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Wednesday, August 12, 2015 3:31 PM
To: arslist@ARSLIST.ORG
Subject: Re: Query question
**
Todd,
With that in mind.you can take a MONTH
I have a question about CMDB association reports and queries. I am putting
data into several different classes, computer systems, network ports,
protocol end points etc... The I am building relationships form those to
each other and so on. So for example Protocol Endpoint will have a
Classification: UNCLASSIFIED
Caveats: NONE
Hi all,
Hopefully this is simple, but I'm trying to query 5 oldest open tickets in my
queue. I know I can query all my open tickets and sort on the Create Date to
get the top 5 oldest tickets but I only want 5 oldest open tickets returned
in the
System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Nguyen, AnhThien Mr CTR NG NGB
ARNG
Sent: Wednesday, November 05, 2008 8:10 AM
To: arslist@ARSLIST.ORG
Subject: Query question (UNCLASSIFIED)
Classification: UNCLASSIFIED
Caveats: NONE
Hi all,
Hopefully this is simple, but I'm
, 2007 2:03 PM
*To:* arslist@ARSLIST.ORG
*Subject:* Query Question
Hi I must be doing something wrong but can not see what it is. I have
an Active Link that opens a Display Only dialog with a character
field. I am trying to search the value in that character field against
a field in another table
Hi I must be doing something wrong but can not see what it is. I have an
Active Link that opens a Display Only dialog with a character field. I
am trying to search the value in that character field against a field in
another table. Here is the qualification of the AL that is running the
query:
What is the problem? You've explained what you are trying to do but not what
error\problem.
On 4/18/07, Sokol, Brian [EMAIL PROTECTED] wrote:
**
Hi I must be doing something wrong but can not see what it is. I have an
Active Link that opens a Display Only dialog with a character field. I am
Turn it around. Like this:
'Title' LIKE % + $Title$ + %
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian
Sent: Wednesday, April 18, 2007 2:03 PM
To: arslist@ARSLIST.ORG
Subject: Query Question
Hi
Subject: Query Question
**
Hi I must be doing something wrong but can not see what it is. I have an
Active Link that opens a Display Only dialog with a character field. I am
trying to search the value in that character field against a field in
another table. Here is the qualification of the AL
White
Office: 813-978-2192
E-mail: [EMAIL PROTECTED]
Joran, Peter P
CTR OSD CIO To: arslist@ARSLIST.ORG
Peter.Joran.ctr@cc:
OSD.MIL Subject: Re: Query question
George Mike and Jason
Thanks for the ideas!
Pete
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of George Barsan
Sent: Friday, October 20, 2006 11:12 AM
To: arslist@ARSLIST.ORG
Subject: Re: Query question
In a Oracle
How do you want to present the results, probably in a table? In that
case you could sort the records based on the timestamp and limit the
chunk size to 5..
George
On 10/19/06, Joran, Peter P CTR OSD CIO [EMAIL PROTECTED] wrote:
**
All
This seems like a very simple question but I'm stumped.
Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joran, Peter P CTR OSD CIO
Sent: Thursday, October 19, 2006 2:10 PM
To: arslist@ARSLIST.ORG
Subject: Re: [ARSLIST] Query question
I need to put in a Crystal report.
-Original Message-
From
Peter.Joran.ctr@cc:
OSD.MIL Subject: Re: Query question
Sent by: Action
22 matches
Mail list logo