AND **$USER$
!= "Remedy Application Service"*
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 wrote:
> Thanks! That is one issue down. Still firing twice tho
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 Login
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 da
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:
http://www.databasejournal.com/features/mssql/article.php/3076421/Example
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 b
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
the DB? I guess that makes sense.
Sorry to beat a dead horse, but this seems like decidedly inconsistent behavior
and I'm really not looking forward to parsing 2200 active links when I'm unsure
what the problem is.
Michael A. McManus, SSgt, USAF
Remedy Developer
HQ 754 ELSG/DOMH
-
head around why this:
( 'Group_List' LIKE (( "%" + "System" ) + "%" )) OR (
'Group_List' LIKE (( "%" + "Admin" ) + "%" ))
And this:
('Group_List' LIKE "%System%") OR ('Group_List' L
ot;%" + "Admin" ) + "%" ))
And I received the error message again. It fails the qualification with the
latter query, but it passes with the former query. And to boot, neither
query will return a set of results in the advanced search bar.
Michael A. McManus, SSgt,
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 nam
))) + CAST(@intLoopVar AS VARCHAR(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.gen
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:
Sent: Wednesday, June 18, 2008 10:25 AM
Subject: Re: SQL to find missing records
Try
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 Reque
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 Mess
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 fol
s, text) into an array, using the special control
characters ('' is char 03, '' is char 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 Messa
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
unt in our case. So, 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:
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
. -28800 / -3600 = +8 hours
--Thomas
- 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 A
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
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
From: Mahesh
Newsgroups: gmane.comp.crm.arsystem.general
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 thi
The second active link would throw an error if the field value isn't formatted
as [any 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.
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.g
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 mes
I found a Windows version of wget on this site:
http://users.ugent.be/~bpuype/wget/
- Original Message -
From: Grooms, Frederick W
Newsgroups: gmane.comp.crm.arsystem.general
To: arslist@ARSLIST.ORG
Sent: Monday, April 21, 2008 1:46 PM
Subject: Re: Adding attachment from th
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 lo
Chris,
For MS-SQL, you can use the attached function. It will convert the date
field's integer value into a SQL datetime value. Keep in mind that the
minimum value for a datetime field in MS-SQL is January 1, 1753 (Remedy date
fields go back to January 1, 4713 B.C.). So, I wrote the function
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
t all possible, along
with any additional patches to the OS, Java, web 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]>
Newsgroup
ing the AR 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"
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
using option 2.
I 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 rec
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 update/t
# 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: gmane.comp.crm.arsystem.gen
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 figure)
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
Then
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: gmane.comp.c
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 set
-9140
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$ 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
re viewable by anyone. I 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 t
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 p
on, F.A.
Email: [EMAIL PROTECTED]
-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL
PROTECTED] On Behalf Of Thomas Bean
Sent: Friday, February 22, 2008 4:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: Incoming email that generates reco
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:
Summ
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 -
Isn't that what the $SERVERTIMESTAMP$ keyword is for?
- Original Message -
From: "Wheeler, Dylan" <[EMAIL PROTECTED]>
Newsgroups: gmane.comp.crm.arsystem.general
To:
Sent: Wednesday, February 06, 2008 11:55 AM
Subject: Re: Use the Server time rather than the Client Time in an Active
L
Chicago.
- 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/
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:
- Original Message -
From: "BMC Customer Support" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2007 7:22
rch qualifier:
(Search qual): '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
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 appropria
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:
fiel
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
- Origin
this, but it should be a similar 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:
Sent: Friday, November 09, 20
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:
Sent: Tuesda
This should also work:
LEFT($Name$, LENGTH($Name$) - 1)
- Original Message -
From: "Thomas Bean" <[EMAIL PROTECTED]>
Newsgroups: gmane.comp.crm.arsystem.general
To:
Sent: Wednesday, October 24, 2007 12:02 PM
Subject: Re: Question: Removing Last Character
I believe
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:
Sent: Wednesday, October 24, 2007 11:53 AM
Subject: Question: Removing Last Ch
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 ar
function will always 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:
Sent: Monda
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 wor
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:
Sent: Monday, May 14, 2007 11:22
Subject: Auto
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 ):
>
> CATALINA_OPTS="-Xms256m -Xmx1024m -Djava.awt
Kyle,
Try adding this line to the top of your startup.sh script for Tomcat (after
modifying the ):
CATALINA_OPTS="-Xms256m -Xmx1024m -Djava.awt.headless=true
-Dsun.java2d.fontpath=/jre/lib/fonts"; export CATALINA_OPTS
This resolved the "NoClassDefFoundError" for me.
--Thomas
- Original Me
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 Remed
SList)
[mailto:[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
running on every Windows
system.
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.ars
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
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 t
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'
like 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,
Her
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: ars
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,
This site shows all of the possible keystrokes in Windows to produce the
euro symbol, depending upon your keyboard layout:
http://www.microsoft.com/typography/EuroSymbolFAQ.mspx
(see 'Q. How do I access the euro symbol')
Standard US keyboards do not include the 'AltGr' key, so the keystr
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 al
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] [HPU
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 ch
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
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:
control char(0004)
control char(0004)
control char(0003)
control char(0004)
The "eid" parameter should also work:
e.g.,
http:///arsys/servlet/ViewFormServlet?form=HPD%3AHelpDesk&server=&eid=HD000123456
--Thomas
- Original Message -
From: "Hennigan, Sandra H CTR OSD-CIO" <[EMAIL PROTECTED]>
Newsgroups: gmane.comp.crm.arsystem.general
Sent: Tuesday, Decembe
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: gmane.comp.cr
hing or this is a bug.
-Original Message-
From: Action Request System 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
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.
**
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:
gma
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:
gmane.comp.crm.arsystem.gen
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 "RSM:ESC-
abase.
Will look for your post on the ARSLIST.
Thanks,
--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
p
Audrey,
From what type of database are you reading the date values? I have
previously posted date field conversion functions for MS-SQL, Oracle, and
Informix. You can find these in the ARSList archives under a thread titled
"Integer date conversion in Business Object WebIntelligence", from la
**
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 th
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 phases by
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
value stored in the database for the date/time
field (the offset may be different depending upon what pa
**
Heather,
I don't think this what is causing the cases in the "Pending"
status not to escalate, but there is one other filter I noticed (in HD 5.5) that
you will need to update to check for the "Resolved" status instead of "Work in
Progress" in the Run-If statement:
HPD:HPD-ChangeSetAssig
1 - 100 of 130 matches
Mail list logo