Hi Robert,
I'm not sure why it is firing twice, but the 'OR' operators are the reason
it is firing even when the assignee makes the update (using 'AND' would
probably prevent this).
I would recommend trying a much simpler 'Run If' statement:
*'Assignee Login ID' != $USER$*
If the 'Assignee
*
I would recommend running a Filter log in the client to determine what is
triggering the filter to run twice.
--Thomas
On Wed, Nov 18, 2009 at 11:00 AM, Robert Fults rfu...@fiu.edu wrote:
Thanks! That is one issue down. Still firing twice though.
*From:* Thomas Bean [mailto:bea
Hello Satya,
Remedy DATE fields are stored as an integer representing the number of days
elapsed since January 1, 4713 B.C., in the proleptic Gregorian calendar.
I have posted MS-SQL date conversion functions to the list several times in the
past which can convert these integers to a readable
from GMT in
your time zone during standard and daylight saving time.
The other two functions are for converting date-only values.
HTH,
--Thomas
Thomas Bean
Remedy System Administrator
ITS Products Group
Ph: 314-977-3740
[EMAIL PROTECTED
I think I would probably approach this calculation by using a database function
rather than ARS workflow. What database are you using? If you are using
MS-SQL, the following article has some examples that may be helpful:
Yes, that should work.
Although the $DATE$ keyword can be used for both Date and Date/Time fields,
using an arithmetic operation against the keyword seems to force it to
translate into a date/time value (# of seconds instead of # of days) at the
database level. You can observe this by running
Frank,
This syntax will work if searching a Date/Time field, but it will not work with
a Date (only) field. The value on the right side of the qualification
(($TIMESTAMP$ + (60*60*24*182)) would generate an integer value well beyond the
range of the Date field type. If you divided this value
that those would evaluate to
the exact same thing.
Michael A. McManus, SSgt, USAF
Remedy Developer
HQ 754 ELSG/DOMH
-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]
On Behalf Of Thomas Bean
Sent: Thursday, June 19, 2008 10:14 AM
To: arslist
Developer
HQ 754 ELSG/DOMH
-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]
On Behalf Of Thomas Bean
Sent: Thursday, June 19, 2008 10:56 AM
To: arslist@arslist.org
Subject: Re: LIKE qualifications in 7.0
**
Michael,
I tested this in a 'Run
If you are just querying the BGI_SDHP_Modify view, I don't think you can
query for case IDs that don't exist in the source table. You would have to
cross-reference the view with your export, since that is where the missing
case IDs would exist.
However, if you simply set your 'Duplicate
That's a cool trick, I'll have to see if I can replicate that in MS-SQL
(T-SQL).
- Original Message -
From: Grooms, Frederick W [EMAIL PROTECTED]
Newsgroups: gmane.comp.crm.arsystem.general
To: arslist@ARSLIST.ORG
Sent: Wednesday, June 18, 2008 10:25 AM
Subject: Re: SQL to find
(13)));
if not exists (select * from BGI_SDHP_Modify where case_id = @caseid)
print @caseid;
set @intLoopVar = @intLoopVar + 1;
end
- Original Message -
From: Thomas Bean [EMAIL PROTECTED]
Newsgroups: gmane.comp.crm.arsystem.general
To: arslist@ARSLIST.ORG
Sent: Wednesday, June 18
Michael,
I don't think this has anything to do with the way LIKE qualifications are
handled between version 5.1.2 and 7.0.1.
Even if you change % + System + % to %System%, the issue is most likely
related to the fact that the 'Group List' field does not actually store
explicit group names --
Hello Poornima,
You would probably have to create an active link with a set fields action using
the $PROCESS$ keyword to parse the ar.ini file, located in the AR System\home
directory on the client. For example, if the time zone is set to GMT+5:30
(IST) Asia/Calcutta, you should find the
You could accomplish this with an active link with the following properties:
Execute On: Window Loaded
Run If: $OPERATION$ = QUERY
Add a 'Set Fields' action, using the keyword $DEFAULT$ as the value for any
fields that you wish to set to their default values.
--Thomas
- Original
There are actually two special control characters that are used to store diary
field entries in the database. Unicode value 0003 is the END OF TEXT control
character and is used to separate individual entries in a diary field. Unicode
value 0004 is the END OF TRANSMISSION control character
04), then it is converting the epoch
integer value into a readable date and printing the result.
I'm guessing the approach would be similar in MS-SQL.
--Thomas
- Original Message -
From: Thomas Bean
Newsgroups: gmane.comp.crm.arsystem.general
To: arslist@ARSLIST.ORG
Sent
, the permission
change may have to be made at the domain account level in order for it to
'stick'.
--Thomas
- Original Message -
From: Thomas Bean
Newsgroups: gmane.comp.crm.arsystem.general
To: arslist@ARSLIST.ORG
Sent: Tuesday, May 06, 2008 6:22 PM
Subject: Re: User Tool
Koyb,
What version of the user tool did you upgrade from and to?
I ran into some similar issues after the version 7.0.01 Patch 004 upgrade,
which moved the default home directory from the current user's profile into the
All Users profile (C:\Documents and Settings\All Users\Application Data\AR
There is no display option to show the time zone of the client, but you can
calculate this pretty easily.
1.. Set a date/time field to the value 01/01/1970 12:00:00 AM.
2.. Set an integer field to the value of the date/time field.
The result will be the number of seconds offset from GMT in
One other note -- if the client and the AR Server are not in the same time
zone, make sure these set fields actions are performed in an active link (NOT
in a filter).
--Thomas
- Original Message -
From: Thomas Bean
Newsgroups: gmane.comp.crm.arsystem.general
To: arslist
- Original Message -
From: Thomas Bean
Newsgroups: gmane.comp.crm.arsystem.general
To: arslist@ARSLIST.ORG
Sent: Friday, May 02, 2008 6:29 AM
Subject: Re: Timezone info in date/time fields
**
One other note -- if the client and the AR Server are not in the same time
zone, make
Hi Mahesh,
The easiest solution, which doesn't require any workflow, would be to specify
the $ALPHA$ keyword as the pattern in the character field properties. This
will only allow alphabetic characters or blank spaces to be entered into the
character field, and will generate a generic error
One additional note... if you wish to allow both uppercase and lowercase alpha
characters, you would need to use a more explicit qualification, e.g.:
'myField' LIKE %[^A-Za-z]%
- Original Message -
From: Thomas Bean
Newsgroups: gmane.comp.crm.arsystem.general
To: arslist
valid [EMAIL PROTECTED] valid string].[any valid string].
If you use the ARFPerl plugin, you might also be able to use a Perl module such
as Email::Valid to perform the validation for you in a filter.
--Thomas
- Original Message -
From: Mahesh
To: Thomas Bean
Sent: Wednesday
To: arslist@ARSLIST.ORG
Sent: Wednesday, April 23, 2008 1:41 PM
Subject: Re: Error Message on Submit if a field has special characters.
** That worked. Thanks Thomas.
On 4/23/08, Thomas Bean [EMAIL PROTECTED] wrote:
In that case, I think I would probably use two separate active
Hello Jegan,
Assuming you have a mix of fixed and floating licenses, and you need to
optimize the allocation of these licenses among your users, I would recommend a
product such as RRR|License (see http://www.rrr.se/en/products/rrrlic.html).
To use the tool, you simply need to turn on user
Ankur,
Make sure the group category is set to Dynamic for these groups. Also, the
'Submitter' group should be Group ID = 3, and the 'Assignee' group should be
Group ID = 4.
If the manual creation still doesn't work, you might try exporting the groups
from another AR Server and importing them
Server unpatched
-- this will probably *not* work. See the earlier message from David Easter
dated March 12, 2008 under the subject Re: DST update... for more info
(message is attached).
HTH,
Thomas Bean
- Original Message -
From: Amey Bhosale [EMAIL PROTECTED]
Newsgroups
server, database, etc. It
will be a headache to be sure, but it will be a worthwhile effort, IMHO.
Kind regards,
Thomas Bean
- Original Message -
From: AMEY BHOSALE [EMAIL PROTECTED]
Newsgroups: gmane.comp.crm.arsystem.general
To: arslist@ARSLIST.ORG
Sent: Monday, March 31, 2008 5:31 PM
Brian,
Perhaps I am having a slow day, but I'm not quite clear on the scenario you are
describing.
I have 4500 records on an LDAP form that need to be updated.
Is this an ARDBC LDAP form? Are you wishing to update the original data from
your LDAP data source, or are you attempting to
hope that helps.
Still,
Brian Goralczyk
On Thu, Mar 20, 2008 at 1:49 PM, Thomas Bean [EMAIL PROTECTED] wrote:
**
Brian,
Perhaps I am having a slow day, but I'm not quite clear on the scenario you
are describing.
I have 4500 records on an LDAP form that need to be updated
Michelle,
I'm not sure off hand where the content is on the new site, but you can always
plug in the URLs at the Internet Archive Wayback Machine:
http://www.archive.org/
It's a very handy tool for finding obsolete web content.
HTH,
Thomas
- Original Message -
From: Michelle L
Hi Michelle,
I believe I encountered the same issue you are describing on a 5.01.02 AR
Server back in 2006. I reported the issue to BMC Support, and the issue was
closed with a defect (SW00220325). See attached for a copy of the issue. I
never received any follow up on the defect (go
# of days since January 1, 4713 B.C., using a hybrid of the Julian and
Gregorian calendar systems (similar to the Oracle calendar -- see
http://www.orafaq.com/papers/dates_o.doc).
- Original Message -
From: Shawn Stonequist [EMAIL PROTECTED]
Newsgroups:
Kathy,
I believe that means it is pulling the form/view names from a character field
reference on the current form that the active link is attached to. These are
most likely display-only character fields.
--Thomas
- Original Message -
From: Kathy Morris
Newsgroups:
Hi Guillermo,
In order for the date to be converted correctly from the character field to
the date/time field, the format of the date string probably needs to match
the format you are seeing in the date/time field. So, if the date/time is
showing up under this format:
12/31/69 18:00:11
$MENU$ patterns below version will work in earlier versions of ARS, but not if
the search qualification defined in the search menu contains a dynamic field
reference.
e.g.:
'Equipment Category' = $536870913$
There was a workaround for this, however (see attached).
This workaround should still
SoLinc: 10*19140
--
From: Action Request System discussion list(ARSList) [mailto:[EMAIL
PROTECTED] On Behalf Of Thomas Bean
Sent: Thursday, March 06, 2008 1:15 PM
To: arslist@ARSLIST.ORG
Subject: Re: Pattern of $MENU
Hi Maria,
I would guess that your LDAP server has an entry count limit on the number of
records that can be returned by a search. This is fairly common -- usually
LDAP servers are set to an entry count limit of 1 or 2 thousand records. If
the LDAP admin is unwilling or unable to alter this
Rick,
This is NOT the normal, default behavior for a the Request ID assignment on a
standard Remedy form.
Unless there is workflow to get the next ID value prior to saving the entry,
the default behavior is for the Request ID not to be assigned until the entry
is initially saved.
In the form
didn't build it...
Rick
On Wed, Mar 5, 2008 at 11:33 AM, Thomas Bean [EMAIL PROTECTED] wrote:
**
Rick,
This is NOT the normal, default behavior for a the Request ID assignment on
a standard Remedy form.
Unless there is workflow to get the next ID value prior to saving
PROTECTED] On Behalf Of Thomas Bean
Sent: Friday, February 22, 2008 4:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: Incoming email that generates record needs escape character?
**
You might try encapsulating the Summary value between [$$ and $$]. This is
normally used for field
MessageYou might try encapsulating the Summary value between [$$ and $$]. This
is normally used for field values that span multiple lines in the e-mail, but
it might also work to escape the and characters. The Summary line would
need to be formatted as follows in the incoming e-mail:
Isn't that what the $SERVERTIMESTAMP$ keyword is for?
- Original Message -
From: Wheeler, Dylan [EMAIL PROTECTED]
Newsgroups: gmane.comp.crm.arsystem.general
To: arslist@ARSLIST.ORG
Sent: Wednesday, February 06, 2008 11:55 AM
Subject: Re: Use the Server time rather than the Client Time
What date format do you have set in Windows (Control Panel Regional and
Language Options)? I believe the client will use these settings by default.
You should be able to set a different date format for the client under Tools
Options Locale.
HTH,
Thomas
- Original Message -
Hi Warren,
That defect came from an issue that I submitted to BMC Support on 3/22/2007.
This was the last update I received before the issue was closed:
SNIP
- Original Message -
From: BMC Customer Support [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 13, 2007 7:22
.
- Original Message
From: Thomas Bean [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Thursday, January 31, 2008 3:33:52 PM
Subject: Re: SW00263488 - Problems with $DATE$ Keyword.
Hi Warren,
That defect came from an issue that I submitted to BMC Support on 3/22/2007
Calculating a Date only FieldFred,
This won't work in a search qualification, because the $DATE$ keyword will
resolve to epoch time (# of seconds since January 1, 1970 12:00:00 AM GMT).
Theoretically, the following *should* work (but it returns an error ARERR
[312] Data types are not
): 'Expiration Date' = 'zTmpDate'
--Thomas
- Original Message -
From: Thomas Bean
To: arslist@ARSLIST.ORG
Sent: Wednesday, January 30, 2008 11:35 AM
Subject: Re: Calculating a Date only Field
Fred,
This won't work in a search qualification, because the $DATE$ keyword
If I understand correctly, Jack isn't looking for the integer value for the
date field that is stored in the database -- he is looking to convert the
date into a numeric string in a character field, in MMDD format. This
can be accomplished by using the DATENUM function. For example:
Amy,
If you are creating a standard AR report in the windows user tool, go to the
'Statistics' tab and add the 'Average' operation on the following
expression:
'Status*-History.Resolved.TIME' - 'Status*-History.New.TIME'
The result should appear in HH:MM:SS format.
HTH,
Thomas
-
parameter to the above parameter that we
used for ServletExec.
Hope this helps,
Thomas Bean
- Original Message -
From: Emad Zaky [EMAIL PROTECTED]
Newsgroups: gmane.comp.crm.arsystem.general
To: arslist@ARSLIST.ORG
Sent: Friday, November 09, 2007 4:42 PM
Subject: Re: French
There is also a DATEADD function that is intended for this purpose...
DATEADD(ww, 4, $TIMESTAMP$)
Still have to use a set fields action in an AL.
--Thomas
- Original Message -
From: Joel D. Sender [EMAIL PROTECTED]
Newsgroups: gmane.comp.crm.arsystem.general
To: arslist@ARSLIST.ORG
I believe this should work in a set fields action:
SUBSTR($Name$, 0, LENGTH($Name$) - 2)
HTH,
Thomas
- Original Message -
From: T. Dee [EMAIL PROTECTED]
Newsgroups: gmane.comp.crm.arsystem.general
To: arslist@ARSLIST.ORG
Sent: Wednesday, October 24, 2007 11:53 AM
Subject: Question:
This should also work:
LEFT($Name$, LENGTH($Name$) - 1)
- Original Message -
From: Thomas Bean [EMAIL PROTECTED]
Newsgroups: gmane.comp.crm.arsystem.general
To: arslist@ARSLIST.ORG
Sent: Wednesday, October 24, 2007 12:02 PM
Subject: Re: Question: Removing Last Character
I believe
Business Objects
To view this email as a Web page, use this link.
October 9th, 2007
Dear Business Objects Customer,
I would like to share with you the exciting news that SAP has
announced their intent to acquire Business Objects. We
return the minimum MS-SQL datetime value
(January 1, 1753) for any Remedy date values prior to this range.
Regards,
Thomas Bean
- Original Message -
From: Atul Vohra [EMAIL PROTECTED]
Newsgroups: gmane.comp.crm.arsystem.general
To: arslist@ARSLIST.ORG
Sent: Monday, October 01, 2007 10:27
Joe,
I can't remember the bug number off the top of my head, but there has been a
longstanding issue with the use of the $DATE$ keyword in workflow
qualifications when used against Date fields. The keyword incorrectly expands
to a Date/Time integer value instead of a Date integer value. It
Julie,
Thanks for pointing this out!
Curiously, I found that my recent Help Desk 6.0 installation had this same bug
you described, but I could not find it on my now inactive Help Desk 5.5
installation. The filter on the old 5.5 app used the correct value of $Arrival
Time$ rather than $DATE$ to
Try doubling up on the double-quotes within the string. For example:
'LISTSummary' LIKE %+ $Details$ +%
HTH,
Thomas
- Original Message -
From: Chris Moore [EMAIL PROTECTED]
Newsgroups: gmane.comp.crm.arsystem.general
To: arslist@ARSLIST.ORG
Sent: Monday, May 14, 2007 11:22
Subject:
: Flash boards Error after ARS 7.0.01 patch 002 Upgrade
Why do you need to change the java install path?
Thanks
Kyle
Thomas Bean wrote:
Kyle,
Try adding this line to the top of your startup.sh script for Tomcat
(after
modifying the java install path):
CATALINA_OPTS=-Xms256m -Xmx1024m
Kyle,
Try adding this line to the top of your startup.sh script for Tomcat (after
modifying the java install path):
CATALINA_OPTS=-Xms256m -Xmx1024m -Djava.awt.headless=true
-Dsun.java2d.fontpath=java
install path/jre/lib/fonts; export CATALINA_OPTS
This resolved the NoClassDefFoundError for
Shyam,
If you are using an Oracle DB, there is a very simple native function you
can use to convert the date fields:
select to_char(to_date(2449992, 'J'), 'MON-DD-') from dual;
In the above example, simply replace the value '2449992' with the column
name of the date field from the
Has anyone else had difficulties applying the DST hotfix to the Visual C++
C-Runtime libraries (msvcp71.dll and msvcr71.dll)?
I obtained the DLLs from BMC Support, and have shut down almost every
process and service running on my Windows 2003 AR Server (7.0.01 Patch 001).
Every time I attempt
It would make more sense to me to set this as a system environment variable,
rather than setting this at the command line...
i.e.:
Right-click 'My Computer'
Select 'Properties'
Select 'Advanced' tab
Select 'Environment Variables'
Add new system variable TZ (assuming ARS runs under local
.
Anyways, I hope this information is of use to anyone else out there
experiencing similar problems applying the Visual C++ C-Runtime hotfix.
--Thomas
- Original Message -
From: Thomas Bean [EMAIL PROTECTED]
Newsgroups: gmane.comp.crm.arsystem.general
To: arslist@ARSLIST.ORG
Sent
:[EMAIL PROTECTED] On Behalf Of Thomas Bean
Sent: Wednesday, March 14, 2007 5:48 PM
To: arslist@ARSLIST.ORG
Subject: Re: Additional information about DST event and how it affects
AR System
OK, I found a nifty little utility that helped me find what processes
were using these DLLs:
Process Explorer
there wasn't anyone who
has maintained this after the passing away of Ed.
Joe
- Original Message
From: Thomas Bean [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, March 12, 2007 6:03:07 PM
Subject: Re: ESP's Permission setter
Joe,
Here is the download page
someone else has an idea how to generate the license file.
--Thomas
- Original Message -
From: Thomas Bean
Newsgroups: gmane.comp.crm.arsystem.general
To: arslist@ARSLIST.ORG
Sent: Tuesday, March 13, 2007 09:38
Subject: Re: ESP's Permission setter
**
Joe,
I didn't
Joe,
Here is the download page for the Permission Setter from my archive of the
ESP site (see attached). Apparently, the program only works with 4.5.X
servers, and the page indicates You must register this version in order to
use it. Registration is FREE.
I'm not sure how you would go about
Re: DST Test Results on March 11th 8:00 AMRoger,
You might check to make sure you don't have the time zone set in the AR User
Preferences form. That could cause the times to be displayed one hour off. As
long as Windows is patched, the User tool should pull the correct time zone
settings from
We had similar problems after applying Patch 20 to our Mid-Tier (Red Hat
Linux), after using the file replace method.
After reapplying the patch using the installer script, the missing library
errors did not occur. If you use this method to apply the patch to your
Mid-Tier, just make sure to
Tyra,
If you need to store a date prior to the Unix epoch, Remedy ARS versions 5.1
and higher include a date field type that accepts dates as far back as January
1, 4713 B.C. The database stores this as the number of days since the start of
this period.
--Thomas
- Original Message
DST Simulated Test - FailedYes, I believe it would matter -- timestamps are
displayed according to the client's offset from GMT, regardless whether the
value was set by server.
--Thomas
- Original Message -
From: Aaron Keller
Newsgroups: gmane.comp.crm.arsystem.general
To:
6.3 Patch 20 - Issues with years prior to 2007Eric,
If you are using SQL server, the attached SQL script may help to resolve some
of the issues with historical reporting.
It will create a function to convert epoch time values to local datetime, using
the old rules for dates prior to 2007 (DST
Jose,
Assuming you are accessing the Mid-Tier from a Windows client, have you
tried using keystroke Alt+0128 to enter the euro symbol (€)? Does this have
the same effect?
The euro symbol is located at different code points in the Windows-1252
character set vs. Unicode, and does not exist at
Hello Ramón,
I archived the entire ESP site before it was taken down. The download page for
the esp_createentry tool lists the following versions:
Create Entry
Create an entry in a schema from the command line.
Versions Available (Last Updated - Feb 14, 2000):
[AIX 4.2] [AIX 4.3]
We ran into problems loading Patch 20 on our Mid-Tier using the File
Replace method (Linux OS), due to missing links in shared object libraries.
The workaround provided by BMC was to rename the original Mid-Tier install
directory, then apply the patch to the original install location using the
Dan,
If this is in an outgoing e-mail notification from ARS, I would guess that the
original quote character was copied and pasted into a Remedy field from a M$
application such as Word or Outlook. The AutoCorrect feature in these
applications will usually transform standard straight quote
Dave,
I think what you would need is to create a function to extract the unix
timestamps from the diary field, then convert them to date/time. Diary
fields are formatted as follows at the db level:
unix timestamp
control char(0004)
user name
control char(0004)
entry text
control
The eid parameter should also work:
e.g.,
http://servername/arsys/servlet/ViewFormServlet?form=HPD%3AHelpDeskserver=servereid=HD000123456
--Thomas
- Original Message -
From: Hennigan, Sandra H CTR OSD-CIO [EMAIL PROTECTED]
Newsgroups: gmane.comp.crm.arsystem.general
Sent:
I have used the rrrLock application for this, it works relatively well. It
doesn't fully lock the record from being updated/overwritten, but it generates
a warning message whenever a 2nd user opens a ticket that is already being
viewed.
http://www.rrr.se/en/products/2.html#rrrlock
--Thomas
Wow, I might actually get a chance to use my passport... they will now be
required for US travelers to Canada (starting January 23, 2007).
http://travel.state.gov/travel/cbpmc/cbpmc_2223.html
- Original Message -
From: Tony Worthington [EMAIL PROTECTED]
Newsgroups:
Brian,
Is the 'Sign In Date' field a date/time field or a date field? If it is
date/time (even if it is only set to display as date-only), then your
qualification would only prevent multiple requests from being created for
the current user for given second of the day, *not* for the given day.
discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Thomas Bean
Sent: Monday, October 30, 2006 12:33 PM
To: arslist@ARSLIST.ORG
Subject: Re: Push Field Problem
Brian,
Is the 'Sign In Date' field a date/time field or a date field? If it is
date/time (even if it is only set to display
Title: RE: ARERR 405 exporting Display Only form to .def file
**
Try this qualification:
NOT ('Group List' LIKE "1;%" OR 'Group List' LIKE "% 1;%" OR
'Group List' LIKE "%;1;%")
--Thomas
- Original Message -
From:
Tyrone
Dee
Newsgroups:
**
Hello Leigh,
Try setting the $TIMESTAMP$ value to hidden, display-only
integer field, then use the integer field name reference in
place of the $TIMESTAMP$ keyword reference in your SQL statement.
--Thomas
- Original Message -
From:
Leigh
Gruber
Newsgroups:
Title: RE: ARERR 405 exporting Display Only form to .def file
**
Check the community downloads section of the AR System
Developer Community site for an application named "RavellingText". I
believe this should do it...
HTH,
Thomas
- Original Message -
From:
Niu, Jason
Title: Cannot find Escalated? Escalation
**
I'm using Help Desk 5.5, but I'm guessing the workflow
probably didn't change much in version 5.6.
The escalation that triggers the process is
"RSM:ESC-SendNotification", this updates the RSM:Escalation
form. A filter on this form named
,
--Audrey
- Original Message -
From: Thomas Bean [EMAIL PROTECTED]
Date: Thursday, October 19, 2006 3:16 pm
Subject: Re: Convert Remedy Date/Only Field
Audrey,
From what type of database are you reading the date values? I
have
previously posted date field conversion functions for MS-SQL
**
Hi Chris,
I created a join form between the Group and User forms.
Before I could create the join, this required adding a field to the
Group form to store the string equivalent of the group ID
integer, and some additional workflow to populate the character
field.
There is a thread in the
Title: RE: Merges Vs. Submit and Modify for Filters
**
Lisa,
This sounds like it could be an issue with filter
phasing. You might try overriding the filter processing phasesby
renaming the filter to end with "`!" (back quote followed by
exclamation mark). This will force the filter actions
**
Hello Antonio,
Without giving any db-specific syntax, you should be able to
accomplish this conversion as follows:
Add or subtract your GMT offset (in seconds) from the integer
valuestored in the database forthe date/time
field (the offset may be different depending upon what part
informix(i INTEGER) RETURNING DATE;DEFINE d
DATE;DEFINE n INTEGER;IF i 2415020 THEN LET d =
MDY(12,31,1899);ELSE LET n = (i - 2415020);
LET d = MDY(12,31,1899) + n UNITS DAY;END IF;RETURN d;END
PROCEDURE;
--Thomas
- Original Message -
From:
Thomas Bean
Hey Steve,
What RDBMS are you working with? I've created several user-defined
functions in MS-SQL and Informix that perform these conversions, also Oracle
has a built-in function that should work.
--Thomas
- Original Message -
From: Steve McDonald [EMAIL PROTECTED]
Newsgroups:
dates cover the same range as Remedy's
Date fields -- back to Jan. 1, 4713 B.C.
HTH,
Thomas
- Original Message -
From: Thomas Bean [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Thursday, September 28, 2006 16:49
Subject: Re: Integer date conversion in Business Object WebIntelligence
Title: Date Field/PHP conversion
**
Brad,
If you need to convert an integer value from a Date field in
Remedy to a PHP date, you should be able to use the "cal_from_jd"
function.
$phpdate = cal_from_jd($remedydate,
CAL_GREGORIAN);
This returns an array of values related to the given
date.
You can find a thread titled Proper Case Text in the ARSList archives from
June of last year that offers a few more suggestions.
--Thomas
- Original Message -
From: T. Dee [EMAIL PROTECTED]
Newsgroups: gmane.comp.crm.arsystem.general
Sent: Monday, September 25, 2006 12:17
Subject:
**
Hi Norm,
I don't think it is stored anywhere -- it seems to be cached
in memory only for the current search. If you close the form and re-open
(or run another search without even closing the form), the auto-refresh option
appears to toggle itself off.
You can disable the feature
1 - 100 of 112 matches
Mail list logo
