Remedy create wrong SELECT !!!
Hi, all
I found interesting thing. For example, we have form (Form1) that
contain character field $Name$ and table. Table look at another form
(Form2) that contain only character field $Name$. Table qualification is
( 'Name' = $Name$) OR ( $Name$ = ).
Open Remedy User and turn on database log. Open Form1. Leave $Name$
field empty and refresh table. See log:
SELECT T710.C1,C536870913,T710.C1 FROM T710 WHERE ((T710.C536870913 = '
') OR (' ' = '')) ORDER BY 1 ASC
((T710.C536870913 = ' ') OR (' ' = '')) is ( 'Name' = $Name$) OR (
$Name$ = ). Empty field $Name$ is ' ' (space) in SELECT expression.
Why Remedy replace NULL character fields with space in SELECT.
MS SQL Server convert (' ' = '') to ('' = '') automatically but Oracle
doesn't. Refreshing table works on SQL Server but does not work on
Oracle.
What can I do?
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Remedy create wrong SELECT !!!
Hi!
It has allways worked like that.
Change your qualification to $Name$= instead of $Name$=.
Best Regards - Misi, RRR AB, http://rrr.se
Hi, all
I found interesting thing. For example, we have form (Form1) that
contain character field $Name$ and table. Table look at another form
(Form2) that contain only character field $Name$. Table qualification is
( 'Name' = $Name$) OR ( $Name$ = ).
Open Remedy User and turn on database log. Open Form1. Leave $Name$
field empty and refresh table. See log:
SELECT T710.C1,C536870913,T710.C1 FROM T710 WHERE ((T710.C536870913 = '
') OR (' ' = '')) ORDER BY 1 ASC
((T710.C536870913 = ' ') OR (' ' = '')) is ( 'Name' = $Name$) OR (
$Name$ = ). Empty field $Name$ is ' ' (space) in SELECT expression.
Why Remedy replace NULL character fields with space in SELECT.
MS SQL Server convert (' ' = '') to ('' = '') automatically but Oracle
doesn't. Refreshing table works on SQL Server but does not work on
Oracle.
What can I do?
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
--
This message was scanned by ESVA and is believed to be clean.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Remedy create wrong SELECT !!!
I know it. But I have my own big application that was developed for MS
SQL. Now I need move it to Oracle. Qualification like $Name$= very
much.
How could we correct it?
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Misi Mladoniczky
Sent: Thursday, June 19, 2008 11:05 AM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy create wrong SELECT !!!
Hi!
It has allways worked like that.
Change your qualification to $Name$= instead of $Name$=.
Best Regards - Misi, RRR AB, http://rrr.se
Hi, all
I found interesting thing. For example, we have form (Form1) that
contain character field $Name$ and table. Table look at another form
(Form2) that contain only character field $Name$. Table qualification
is
( 'Name' = $Name$) OR ( $Name$ = ).
Open Remedy User and turn on database log. Open Form1. Leave $Name$
field empty and refresh table. See log:
SELECT T710.C1,C536870913,T710.C1 FROM T710 WHERE ((T710.C536870913 =
'
') OR (' ' = '')) ORDER BY 1 ASC
((T710.C536870913 = ' ') OR (' ' = '')) is ( 'Name' = $Name$) OR (
$Name$ = ). Empty field $Name$ is ' ' (space) in SELECT
expression.
Why Remedy replace NULL character fields with space in SELECT.
MS SQL Server convert (' ' = '') to ('' = '') automatically but Oracle
doesn't. Refreshing table works on SQL Server but does not work on
Oracle.
What can I do?
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
--
This message was scanned by ESVA and is believed to be clean.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Unable to retrieve data from a form
I took the db and API log for the search action on the form. I opened the form in the search mode, put in the request id =001 to search for. In the logs, It starts with ARGetEntry and fetches this record but the last SQL that runs is bit intruding...It selects all request_ID and assigned to SELECT T102.C1,C4 FROM T102 ORDER BY 1 ASC Now this query took 30 mins. there are just 69000 records in this form. Why is this SQL running? or is this normal ? Attached is the excerpt from the log. This Darn issue has extended my stay in Sweden...its funny sometimes when the travel plan gets affected with some technical issues Regards Ankur From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: 18 June 2008 10:59 PM To: arslist@ARSLIST.ORG Subject: Re: Unable to retrieve data from a form ** From the User tool turn on logging (at least API and Database) and see what SQL statement is the one taking so long From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ankur Gulati Sent: Wednesday, June 18, 2008 12:06 PM To: arslist@ARSLIST.ORG Subject: Re: Unable to retrieve data from a form Thank you for the script Fred, All the concerned B Table indexes are coming up as Valid. The selection query for the table does use indexed fields too. Any other things I can check up _ Ankur From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ankur Gulati Sent: 18 June 2008 08:08 PM To: arslist@ARSLIST.ORG Subject: Re: Unable to retrieve data from a form Fred, There are three tables on the form(Email handler Form) First table is attachment table, this brings the attachment to this form from another form. Second table is the attachment pool. Third table fetches the data from AR System Email Attachment Join. I have also turned down the table refreshes on display. No Improvement. I'd be glad if you can fwd me the script to check indexes on tables. Regards Ankur From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: 18 June 2008 07:31 PM To: arslist@ARSLIST.ORG Subject: Re: Unable to retrieve data from a form What table do you have on the form? It still sounds like an index problem (Either you are missing an index on the B table or your selection query for your table on the form is not using an index). Since you are on Oracle I have a script you can use to verify if all tables have their primary (Remedy defined), and User defined indexes. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ankur Gulati Sent: Wednesday, June 18, 2008 5:15 AM To: arslist@ARSLIST.ORG Subject: Re: Unable to retrieve data from a form Hi Guys, Another thing which I forgot to mention, the status bar at the bottom does show that it found the record and it gets stuck saying Refreshing table up to Administrator`s limit Ankur From: Ankur Gulati Sent: 18 June 2008 03:30 PM To: 'arslist@ARSLIST.ORG' Subject: Unable to retrieve data from a form Hi Listers, We have a form which has 5 BLOB fields. There are around 67000 records and it takes around 3-4 hrs to search for a single record. I search on the request_id. We do have couple of other
Re: Walking table, reading and setting hi-liting rows
Thad,
Thanks for the idea. I'll give it a try.
Dwayne
Original message
Date: Wed, 18 Jun 2008 15:16:58 -0700
From: Thad K Esser [EMAIL PROTECTED]
Subject: Re: Walking table, reading and setting hi-liting rows
To: arslist@ARSLIST.ORG
**
Dwayne,
Your original post said you are on version 7.1. I
haven't played with it much, but page 368 of the
Form and Application Objects manual says you can
change the colors of rows in tables based on
selection fields. If you combined that with Fred's
suggestion below, you could set the foreground color
to white and the background color to black when the
status was Yes. It wouldn't truly be a selected
row, but it would look that way to the user. I
don't know how well that would play out in practice
for what you are doing, but its crazy enough that it
just might work.
Thad Esser
Remedy Developer
Argue for your limitations, and sure enough,
they're yours.-- Richard Bach
Grooms, Frederick WTo arslist@ARSLIST.ORG
[EMAIL PROTECTED] cc
Sent by: Action RequestSubject Re: Walking table,
System discussion reading and setting
list(ARSList) hi-liting rows
arslist@ARSLIST.ORG
06/18/2008 02:47 PM
+-+
| Please respond to |
| arslist@ARSLIST.ORG |
+-+
Like I said I could not highlite multiple rows thru
workflow.
My solution was to do the following:
Add a Display Only field on the form (I used a 3
character field)
Add this Display Only field as a column in the table
(Yes you can add
Display only fields from the form that holds the
table as columns in the
table). I called my column Selected
In your Display workflow do the following
Refresh the table
walk the table
while walking the table
if 'your storage field' like % + 'Entry ID
col' + %
then set the display only field to Yes and
set the column to
Yes
else clear the display only field
I also changed it so that users double click on a
row instead of
multiple selecting and that set's the Selected
column to Yes for that
row (If Col = Yes clear the col and the Display
Only else set both.
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne
Martin
Sent: Wednesday, June 18, 2008 2:45 PM
To: arslist@ARSLIST.ORG
Subject: Re: Walking table, reading and setting
hi-liting rows
Thank you, Frederick, Andrew and Frank, for your
replies. I got waylaid
and hope we haven't lost our train of thot.
What I am trying to do is:
1. Let the user hi-lite some rows in a table. When
the entry is saved,
write a list of hi-lited rows into a field, which is
saved with the
record.
2. When the record is displayed, read the field and
use the value in the
field to hi-lite the same rows that were selected in
the previous
session.
The first step turned out to ridiculously simple.
All I had to do is
have an Active Link call a guide that does a table
loop and Table Loop
Selected Rows Only, and it creates a neat little
list of hi-lited rows.
I think Step 2 is impossible. As Frederick has
pointed out you [can]
not set the highlite on multiple rows thru
workflow, The Workflow
Objects 7.1 manual, p223 shows how to select a row
by setting the value
of the table field to the desired row number. But
it says nothing about
selecting multiple rows (ie simulating a
cntrl-click).
It also appears that you can't even read a table on
Display. My storage
field keeps a list based on an Entry ID col field
in the table. I set
up an Active Link to set the table to 0 on Display
(un-hilite the first
row), then call a guide that walks the table, and if
the field where I
was storing the values is LIKE % + $Entry ID col$
+ %, display a
message with the value in the Entry ID col. The
message displayed for
every row, whether the values matched or not, but
the Entry ID col
value was null. The table didn't fill till the
messages stopped
displaying, and when it did, the first row was
hi-lited. It appears
that the Display Active Links fire before the
tables are filled, so
you really can't get any info from a table when a
record is displayed.
I am used to telling my customers that Remedy can
do anything! But it
looks like I have hit a dead end this time. Could
someone please prove
me wrong.
Dwayne Martin
Original message
Date: Mon, 16 Jun 2008 09:28:47 -0500
From: Grooms, Frederick W
[EMAIL
Re: Unable to retrieve data from a form
Ankur, Actually the API call structure in the log shows that the select that you are speaking of is from a GLEWF ARGetListEntryWithFields API call. That most likely means that a table field is being refreshed and the qualification on the table field is unqualified. I would look for any Table field with no qualification, or any table field that is totally dependent on one or more EXTERNAL() operators that may be referencing a field that is still NULL at the time the table field is being refreshed. HTH -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Thu, Jun 19, 2008 at 6:44 AM, Ankur Gulati [EMAIL PROTECTED] wrote: ** I took the db and API log for the search action on the form. I opened the form in the search mode, put in the request id =001 to search for. In the logs, It starts with ARGetEntry and fetches this record but the last SQL that runs is bit intruding...It selects all request_ID and assigned to SELECT T102.C1,C4 FROM T102 ORDER BY 1 ASC Now this query took 30 mins. there are just 69000 records in this form. Why is this SQL running? or is this normal ? Attached is the excerpt from the log. This Darn issue has extended my stay in Sweden...its funny sometimes when the travel plan gets affected with some technical issues Regards Ankur From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: 18 June 2008 10:59 PM To: arslist@ARSLIST.ORG Subject: Re: Unable to retrieve data from a form ** From the User tool turn on logging (at least API and Database) and see what SQL statement is the one taking so long From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ankur Gulati Sent: Wednesday, June 18, 2008 5:15 AM To: arslist@ARSLIST.ORG Subject: Re: Unable to retrieve data from a form Hi Guys, Another thing which I forgot to mention, the status bar at the bottom does show that it found the record and it gets stuck saying Refreshing table up to Administrator`s limit Ankur From: Ankur Gulati Sent: 18 June 2008 03:30 PM To: 'arslist@ARSLIST.ORG' Subject: Unable to retrieve data from a form Hi Listers, We have a form which has 5 BLOB fields. There are around 67000 records and it takes around 3-4 hrs to search for a single record. I search on the request_id. We do have couple of other indexes in place apart on Request ID field. The actual workflow is that an AL does a push field and creates a new record in a form and then second Set field is fired in same AL which opens this new record in modify window. So this is where it fails to open this new record and even if I open the form and search for any record it takes forever to show up and usually it freezes. I have rebuild the indexes but no improvement. On another form without no BLOB data and 100+ fields, it takes less than a sec to search a record. Logs doesn't show anything. AL, SQL and filter log just shows the perfect creation of new record and then on Display it does show the opening of the form in SET Operation. What all should I check? ARS. 7.0 Patch 5 DatabaseOracle 9i Regards Ankur ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
bmc.cmdb.cmdbEngine Filter
Hi All, I am working on CMDB 2.1 Can anyone throw some light on the below command $PROCESS$ Application-Invoke-External-Filter bmc.cmdb.cmdbEngine PHASE=1 CLIENTTYPE=$CLIENT-TYPE$ Where shall I look for filter bmc.cmdb.cmdbEngine and what all validations it does and how can I modify them? Is it documented anywhere. I am not able to find any document on this. Regards, Nidhi DISCLAIMER: --- The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. It shall not attach any liability on the originator or HCL or its affiliates. Any views or opinions presented in this email are solely those of the author and may not necessarily reflect the opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any mail and attachments please check them for viruses and defect. --- ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: LIKE qualifications in 7.0
Very bizarre. If I run the query in the advanced search bar in the WUT, I get
no results. However, I changed the Run If qualification on one of our dev
servers to the following:
('Group_List' LIKE %System%) OR ('Group_List' LIKE %Admin%)
It's a 7.0.01 server and I'm using a 7.0.01 WUT. For some reason, it works. I
logged it, and it passes the qualification.
Just to make sure I'm not out of my mind, I changed it back to:
( 'Group_List' LIKE (( % + System ) + % )) OR ( 'Group_List' LIKE ((
% + 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, 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: Wednesday, June 18, 2008 6:08 PM
To: arslist@arslist.org
Subject: Re: LIKE qualifications in 7.0
**
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 -- it actually stores a semicolon-delimited list of Group
IDs.
I tried a similar search on my User form, using the Advanced Search bar with a
LIKE qualification:
'Group List' LIKE %Administrator%
This returned NO results. However, the following query will return all Users
in the Administrator group (group ID 1).
'Group List' LIKE 1;% OR 'Group List' LIKE % 1;% OR 'Group List'
LIKE %;1;
AFAIK, this has always been the proper method to search the 'Group List' field
(see attached document titled How To Query On The Group List Field, circa ARS
3.x). I'm pretty sure this is still valid.
Now, I am curious why this seems to have worked differently in ARS 5.1...
Perhaps this version allowed searches on the 'Group List' field with explicit
group names, or maybe it was only possible in the Run If statement on an
Active Link???
--Thomas
- Original Message -
From: Grooms, Frederick W mailto:[EMAIL PROTECTED]
Newsgroups: gmane.comp.crm.arsystem.general
To: arslist@ARSLIST.ORG
Sent: Wednesday, June 18, 2008 3:59 PM
Subject: Re: LIKE qualifications in 7.0
**
What happens if you run your qualification in the Advanced Query bar on
your v7 User tool. You should get a list of users.
From: Action Request System discussion list(ARSList) [mailto:[EMAIL
PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH
Sent: Wednesday, June 18, 2008 2:02 PM
To: arslist@ARSLIST.ORG
Subject: LIKE qualifications in 7.0
We're in the process of upgrading our AR System Server and Clients from
version 5.1.2 to 7.0.01 and I've run into a bit of a problem. I was asked to
upgrade my User and Admin tools to 7.0.01 on my PC for testing purposes, and to
draft an implementation plan. Our server is still 5.1.2 but I was under the
impression that the WUT is backwards compatible and I generally do very little
day-to-day work in the WUT anyway.
Anyhow, I upgraded with no problems and was able to login with no
problems. I did a cursory examination of some workflow and everything seemed
okay. This morning, I got a request to change the Group of a user. I went to
the USER form, made the required changes, and clicked a button to Add them as a
System POC and received an error:
Before attempting to add a System POC, their Group List must be set to
System POC or System POC Manager. (ARERR 75001)
The preceding message occurred during the execution of active link
USER:Add A New POC -- action 1. (ARNOTE 1101)
The first line is the Message action in the Else action of the above
Active Link. The problem is, I did in fact change the Group List of the user
to System POC. I went to the Admin tool and checked the Run If qualification
for that Active Link:
( 'Group_List' LIKE (( % + System ) + % )) OR ( 'Group_List'
LIKE (( % + Admin ) + % ))
Just to make sure I hadn't screwed up somewhere along the line, I had
one of my coworkers attempt the change on his 5.1.2 WUT and it worked
perfectly. To make sure it wasn't a backwards compatibility problem, I tested
the workflow on our 7.0.01 dev server and received the same error.
I looked through the Release Notes as well as the What's new in
7.0.01 docs and didn't see any issues about LIKE qualifications being
interpreted differently in 7.0.01 versus 5.1.2 and I checked the patch notes
for 7.0.01 just to see if it was a possible bug. No luck.
I asked an old coworker of mine who now works
Re: Self-Employed Remedy Professionals
I have in the past, but I found a good full-time job that pays well, so I took it. It's easier to deal with in my situation with a family now. When it was just me, or just my wife and I, we could travel, I could work until 2:00am and go in at 6:00am the next day, and we were ok taking more financial risks. Right now it doesn't make a lot of sense to do consulting when I can have a good paycheck for ~40 hours a week in a stable utility company working on new things and being sent to get training and conferences. Shawn Pierson From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Wednesday, June 18, 2008 5:05 PM To: arslist@ARSLIST.ORG Subject: Self-Employed Remedy Professionals ** I'm just curious, how many of you do your own independent thing with remedy? Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Issue with AIE and Oracle
Good morning all, I have the newest release of AIE and I am trying to get it to talk to a remote oracle database. The Server is 7.1 patch 3 and using MSSQL. I have installed the 10g client and can talk to the remote Oracle system using sqlplus from the box where the arserver is running. There is nothing in any log that I can find, that shows any attempt of the AIE trying to connect to the Oracle database. I did try setting up the AIE to talk to a MSSQL database and that worked. I am starting to wonder if, you can only talk to a database that the server talks to (for example in my case only MSSQL, since that is what the server is talking to). Any ideas, as of yet BMC support has had non. Howard -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Self-Employed Remedy Professionals
Thanks all to your responses. This is not something I'm thinking of doing right now, because of my family life, much like Shawn points out below. I was just curious how many people did it. Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pierson, Shawn Sent: Thursday, June 19, 2008 8:16 AM To: arslist@ARSLIST.ORG Subject: Re: Self-Employed Remedy Professionals I have in the past, but I found a good full-time job that pays well, so I took it. It's easier to deal with in my situation with a family now. When it was just me, or just my wife and I, we could travel, I could work until 2:00am and go in at 6:00am the next day, and we were ok taking more financial risks. Right now it doesn't make a lot of sense to do consulting when I can have a good paycheck for ~40 hours a week in a stable utility company working on new things and being sent to get training and conferences. Shawn Pierson From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Wednesday, June 18, 2008 5:05 PM To: arslist@ARSLIST.ORG Subject: Self-Employed Remedy Professionals ** I'm just curious, how many of you do your own independent thing with remedy? Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Private and confidential as detailed herehttp://www.sug.com/disclaimers/default.htm#Mail. If you cannot access hyperlink, please e-mail sender. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Firefox3
I was just trying firefox 3 out with my mid-tier, it's pretty cool. It's really fast, and they've added in spell check that works just like word. You all should try it out if you haven't yet. Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Walking table, reading and setting hi-liting rows
I think you will find that the color is only set for the rows when the table is refreshed. Changing the selection value after refresh does not change the row color. (At least in v6.3 it did not work that way. Maybe 7.1 will be different, but I doubt it.) And frankly, given any ADA requirements, using color is a bad way to communicate with users. I personally prefer the extra column approach. You can even combine the two if you want to as well. The extra column could be 'Display Type' = Read Only-HTML and stuff HTML into each cell to color the page and add text to match the state for the row. So the background could be green and you could put the word green in the cell too. ( Just a thought) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Wed, Jun 18, 2008 at 6:16 PM, Thad K Esser [EMAIL PROTECTED] wrote: ** Dwayne, Your original post said you are on version 7.1. I haven't played with it much, but page 368 of the Form and Application Objects manual says you can change the colors of rows in tables based on selection fields. If you combined that with Fred's suggestion below, you could set the foreground color to white and the background color to black when the status was Yes. It wouldn't truly be a selected row, but it would look that way to the user. I don't know how well that would play out in practice for what you are doing, but its crazy enough that it just might work. Thad Esser Remedy Developer Argue for your limitations, and sure enough, they're yours.-- Richard Bach ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Issue with AIE and Oracle
You must be hitting some sort of oracle-specific issue (on which I will be of no help). My AIE instances draw their data from a dedicated SQL Server that has databases populated from our eDir LDAP and PeopleSoft property systems. The SQL Server hosting the ARSystem database is on yet another, completely different SQL Server. The two SQL Servers, the AR Server, and the AIE server are all on separate machines, with connections limited to their subnet. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Howard Richter Sent: Thursday, June 19, 2008 8:50 AM To: arslist@ARSLIST.ORG Subject: Issue with AIE and Oracle ** Good morning all, I have the newest release of AIE and I am trying to get it to talk to a remote oracle database. The Server is 7.1 patch 3 and using MSSQL. I have installed the 10g client and can talk to the remote Oracle system using sqlplus from the box where the arserver is running. There is nothing in any log that I can find, that shows any attempt of the AIE trying to connect to the Oracle database. I did try setting up the AIE to talk to a MSSQL database and that worked. I am starting to wonder if, you can only talk to a database that the server talks to (for example in my case only MSSQL, since that is what the server is talking to). Any ideas, as of yet BMC support has had non. Howard -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
I'm almost there....
First, a sincere thanks to everyone for their patience, tolerance, help and suggestions during my journey through the wonderful wonderland of Remedy 7x installation and configuration... Todays test of my ability to decode the obscure happened during the installation of the SLM module. I got an error message about something called BMC_SLM_JAVA_HOME not being set as an environment variable. I'm assuming that this is a system variable in the control panel, system properties, advanced, environment variables area and NOT someplace in AR.CFG or some other obscure XML file. Before I change anything which if I'm wrong might render 3 days of work totally trashed I thought I'd ask the experts. Am I correct in my assuming that I need to put it in as a SYSTEM environment variable and give it the path to some module (???) in Java? Thank you for your suggestions. Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Private incidents
Hi List ARS 7.01 Is there a way to set an Indicent request private to one particular group? Here is the reasoning: We have a risk management group that wants to open their own calls in incident management, which should NOT be seen by any other support group. Thanks * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Re: I'm almost there....
This is what we used when installing SLM 7.1:
Set server System Variable BMC_SLM_JAVA_HOME to folder (e.g. c:\Program
Files\java\jre1.5.0_12) (My Computer Properties Adv tab Environment
Variables)
-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]
On Behalf Of Richard Copits
Sent: Thursday, June 19, 2008 7:41 AM
To: arslist@ARSLIST.ORG
Subject: I'm almost there
This is a multi-part message in MIME format.
--_=_NextPart_001_01C8D21A.893EF050
Content-Type: text/plain;
charset=us-ascii
Content-Transfer-Encoding: quoted-printable
First, a sincere thanks to everyone for their patience, tolerance, help
and suggestions during my journey through the wonderful wonderland
of Remedy 7x installation and configuration...
=20
Todays test of my ability to decode the obscure happened during the
installation of the SLM module. I got an error message about something
called BMC_SLM_JAVA_HOME not being set as an environment
variable. I'm assuming that this is a system variable in the control
panel,
system properties, advanced, environment variables area and NOT
someplace
in AR.CFG or some other obscure XML file. Before I change anything which
if I'm wrong might render 3 days of work totally trashed I thought I'd
ask
the experts. Am I correct in my assuming that I need to put it in as a
SYSTEM
environment variable and give it the path to some module (???) in Java?
Thank you for your suggestions.
Portions of this message may be confidential under an exemption to Ohio's=
public records law or under a legal privilege. If you have received this=
message in error or due to an unauthorized transmission or interception,=
please delete all copies from your system without disclosing, copying, o=
r transmitting this message.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
--_=_NextPart_001_01C8D21A.893EF050
Content-Type: text/html;
charset=us-ascii
Content-Transfer-Encoding: quoted-printable
**
html xmlns:v=3Durn:schemas-microsoft-com:vml xmlns:o=3Durn:schemas-mi=
crosoft-com:office:office xmlns:w=3Durn:schemas-microsoft-com:office:wo=
rd xmlns:x=3Durn:schemas-microsoft-com:office:excel xmlns:p=3Durn:sch=
emas-microsoft-com:office:powerpoint xmlns:a=3Durn:schemas-microsoft-co=
m:office:access xmlns:dt=3Duuid:C2F41010-65B3-11d1-A29F-00AA00C14882 x=
mlns:s=3Duuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882 xmlns:rs=3Durn:sche=
mas-microsoft-com:rowset xmlns:z=3D#RowsetSchema xmlns:b=3Durn:schema=
s-microsoft-com:office:publisher xmlns:ss=3Durn:schemas-microsoft-com:o=
ffice:spreadsheet xmlns:c=3Durn:schemas-microsoft-com:office:component:=
spreadsheet xmlns:oa=3Durn:schemas-microsoft-com:office:activation xml=
ns:html=3Dhttp://www.w3.org/TR/REC-html40; xmlns:q=3Dhttp://schemas.xml=
soap.org/soap/envelope/ xmlns:D=3DDAV: xmlns:x2=3Dhttp://schemas.micr=
osoft.com/office/excel/2003/xml xmlns:ois=3Dhttp://schemas.microsoft.co=
m/sharepoint/soap/ois/ xmlns:dir=3Dhttp://schemas.microsoft.com/sharepo=
int/soap/directory/ xmlns:ds=3Dhttp://www.w3.org/2000/09/xmldsig#; xmln=
s:dsp=3Dhttp://schemas.microsoft.com/sharepoint/dsp; xmlns:udc=3Dhttp:/=
/schemas.microsoft.com/data/udc xmlns:xsd=3Dhttp://www.w3.org/2001/XMLS=
chema xmlns:sub=3Dhttp://schemas.microsoft.com/sharepoint/soap/2002/1/a=
lerts/ xmlns:ec=3Dhttp://www.w3.org/2001/04/xmlenc#; xmlns:sp=3Dhttp:/=
/schemas.microsoft.com/sharepoint/ xmlns:sps=3Dhttp://schemas.microsoft=
=2Ecom/sharepoint/soap/ xmlns:xsi=3Dhttp://www.w3.org/2001/XMLSchema-in=
stance xmlns:udcxf=3Dhttp://schemas.microsoft.com/data/udc/xmlfile; xml=
ns:wf=3Dhttp://schemas.microsoft.com/sharepoint/soap/workflow/; xmlns:mv=
er=3Dhttp://schemas.openxmlformats.org/markup-compatibility/2006; xmlns:=
m=3Dhttp://schemas.microsoft.com/office/2004/12/omml; xmlns:mrels=3Dhtt=
p://schemas.openxmlformats.org/package/2006/relationships xmlns:ex12t=3D=
http://schemas.microsoft.com/exchange/services/2006/types; xmlns:ex12m=3D=
http://schemas.microsoft.com/exchange/services/2006/messages; xmlns:Z=3D=
urn:schemas-microsoft-com: xmlns=3Dhttp://www.w3.org/TR/REC-html40;
head
meta http-equiv=3DContent-Type content=3Dtext/html; charset=3Dus-ascii=
meta name=3DGenerator content=3DMicrosoft Word 12 (filtered medium)
titleQuestion: Permission Issues with Infrastructure Change Management =
7.x/title
style
!--
/* Font Definitions */
@font-face
{font-family:Cambria Math;
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:Times New Roman,serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
Re: I'm almost there....
I hate to say it, but you really DO need to read the installation guide (pg. 19 in this case) and the release notes on any BMC Remedy product before you install it. BMC installers barely work as it is, and absolutely don't if you skip those prerequisites that they DO manage to document. You will waste a lot of your own time if you don't. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Richard Copits Sent: Thursday, June 19, 2008 9:41 AM To: arslist@ARSLIST.ORG Subject: I'm almost there ** First, a sincere thanks to everyone for their patience, tolerance, help and suggestions during my journey through the wonderful wonderland of Remedy 7x installation and configuration... Todays test of my ability to decode the obscure happened during the installation of the SLM module. I got an error message about something called BMC_SLM_JAVA_HOME not being set as an environment variable. I'm assuming that this is a system variable in the control panel, system properties, advanced, environment variables area and NOT someplace in AR.CFG or some other obscure XML file. Before I change anything which if I'm wrong might render 3 days of work totally trashed I thought I'd ask the experts. Am I correct in my assuming that I need to put it in as a SYSTEM environment variable and give it the path to some module (???) in Java? Thank you for your suggestions. Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Issue with AIE and Oracle
That is my thought as well or is it looking at what the arserver is talking to. Thanks for the info, Howard On 6/19/08, strauss [EMAIL PROTECTED] wrote: ** You must be hitting some sort of oracle-specific issue (on which I will be of no help). My AIE instances draw their data from a dedicated SQL Server that has databases populated from our eDir LDAP and PeopleSoft property systems. The SQL Server hosting the ARSystem database is on yet another, completely different SQL Server. The two SQL Servers, the AR Server, and the AIE server are all on separate machines, with connections limited to their subnet. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Howard Richter *Sent:* Thursday, June 19, 2008 8:50 AM *To:* arslist@ARSLIST.ORG *Subject:* Issue with AIE and Oracle ** Good morning all, I have the newest release of AIE and I am trying to get it to talk to a remote oracle database. The Server is 7.1 patch 3 and using MSSQL. I have installed the 10g client and can talk to the remote Oracle system using sqlplus from the box where the arserver is running. There is nothing in any log that I can find, that shows any attempt of the AIE trying to connect to the Oracle database. I did try setting up the AIE to talk to a MSSQL database and that worked. I am starting to wonder if, you can only talk to a database that the server talks to (for example in my case only MSSQL, since that is what the server is talking to). Any ideas, as of yet BMC support has had non. Howard -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Self-Employed Remedy Professionals
Did you form an LLC for liability reasons or so you would be ineligible for Social Security Payroll Taxes or some other reason? Fluxman -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rabi Tripathi Sent: 06/18/2008 11:27 PM To: arslist@ARSLIST.ORG Subject: Re: Self-Employed Remedy Professionals Been doing it for 2 1/2 years. It's a mixed bag. Overall, I'm happy. For the longest time, I had no company, just did 1099. Just last year got a LLC. If you don't understand the last two sentences, you've got a lot to learn to operate as an independent. It took me quite some time to learn the terms, the math, the tricks, the caveats and so forth. The paperwork and the regulations and the taxes etc. And negotiations, contracts. Most importantly, avoiding the bad ones who won't pay. Still learning. It's a different life/different job. If you crave stability, certainty, you probably won't like it because it's really like an adventure with its ups and downs and you are on your own in many ways. Call it freedom/opportunity or call it chaos/risk. It is more demanding than, in my opinion, a permanent job especially a non-consulting one. Just my personal opinion, so please don't shoot me. Say, I don't want to be doing this till retirement. --- Gary Opela (Corporate) [EMAIL PROTECTED] wrote: I'm just curious, how many of you do your own independent thing with remedy? Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: I'm almost there....
You may not believe it, but I did read the release notes, installation guide, configuration guide and users guide and I'm totally embarrassed to say that I absolutely did not see that on page 19, but yep, there it is. I think I'm getting loopy from all the reading and correlating. Thank you for diplomatically pointing out that reference. So far I've had to go through well over a thousand pages of reading material and being low-visioned it's a chore. I need a few days on the beach in Nassau with a cold drink. As I said, thanks for your patience and forbearance while I learn this wonderful product that management has decided to install... From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of strauss Sent: Thursday, June 19, 2008 11:00 AM To: arslist@ARSLIST.ORG Subject: Re: I'm almost there ** I hate to say it, but you really DO need to read the installation guide (pg. 19 in this case) and the release notes on any BMC Remedy product before you install it. BMC installers barely work as it is, and absolutely don't if you skip those prerequisites that they DO manage to document. You will waste a lot of your own time if you don't. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Richard Copits Sent: Thursday, June 19, 2008 9:41 AM To: arslist@ARSLIST.ORG Subject: I'm almost there ** First, a sincere thanks to everyone for their patience, tolerance, help and suggestions during my journey through the wonderful wonderland of Remedy 7x installation and configuration... Todays test of my ability to decode the obscure happened during the installation of the SLM module. I got an error message about something called BMC_SLM_JAVA_HOME not being set as an environment variable. I'm assuming that this is a system variable in the control panel, system properties, advanced, environment variables area and NOT someplace in AR.CFG or some other obscure XML file. Before I change anything which if I'm wrong might render 3 days of work totally trashed I thought I'd ask the experts. Am I correct in my assuming that I need to put it in as a SYSTEM environment variable and give it the path to some module (???) in Java? Thank you for your suggestions. Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Firefox3
7.1 Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent: Thursday, June 19, 2008 9:57 AM To: arslist@ARSLIST.ORG Subject: Re: Firefox3 ** What version of Midtier? On Thu, Jun 19, 2008 at 9:56 AM, Gary Opela (Corporate) [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] wrote: ** I was just trying firefox 3 out with my mid-tier, it's pretty cool. It's really fast, and they've added in spell check that works just like word. You all should try it out if you haven't yet. Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company __Platinum Sponsor: www.rmsportal.comhttp://www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Firefox3
Strange, I never noticed it with earlier versions. It's good to know though. Too bad IE doesn't do it. Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shellman, David Sent: Thursday, June 19, 2008 10:25 AM To: arslist@ARSLIST.ORG Subject: Re: Firefox3 Gary, The spell check function has been in Fire Fox for some time. It has been a handy feature. Dave From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Thursday, June 19, 2008 11:24 AM To: arslist@ARSLIST.ORG Subject: Re: Firefox3 ** 7.1 Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent: Thursday, June 19, 2008 9:57 AM To: arslist@ARSLIST.ORG Subject: Re: Firefox3 ** What version of Midtier? On Thu, Jun 19, 2008 at 9:56 AM, Gary Opela (Corporate) [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] wrote: ** I was just trying firefox 3 out with my mid-tier, it's pretty cool. It's really fast, and they've added in spell check that works just like word. You all should try it out if you haven't yet. Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company __Platinum Sponsor: www.rmsportal.comhttp://www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: LIKE qualifications in 7.0
Tell me about it.
I tried the following as the Run If qualification in that active link:
'Group_List' LIKE 275;% OR 'Group_List' LIKE 1;% OR 'Group_List' LIKE
285;%
And it fails the qualification. However, if I run that in the Advanced Query
Bar, I get everyone who belongs to one of those three groups.
If I change the qualification to:
( 'Group_List' = 275; ) OR ( 'Group_List' = 1; ) OR ( 'Group_List' =
285; )
It passes the qualification and that also works in the advanced query bar.
Perhaps I'm just failing to understand the difference between advanced queries
and Run If qualifications and how they're interpreted.
I still can't wrap my head around why this:
( 'Group_List' LIKE (( % + System ) + % )) OR (
'Group_List' LIKE (( % + Admin ) + % ))
And this:
('Group_List' LIKE %System%) OR ('Group_List' LIKE %Admin%)
Are different. I'm a layman, but it seems to me 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@ARSLIST.ORG
Subject: Re: LIKE qualifications in 7.0
Strange. The 'Run If' qualification in an active link would technically not
be issuing a search to the database -- it is simply searching the values
already displayed in the client. That may be why your qualification worked
using group names instead of Group IDs. What happens if you change the 'Run
If' qualification in the active link to search on the Group IDs instead of
the group names? If it works using the Group IDs, I would recommend going
that route. The qualification will be a lot lengthier, but I think this
would be a more consistent solution between ARS versions.
--Thomas
- Original Message -
From: McManus Michael A SSgt HQ 754 ELSG/DOMH
[EMAIL PROTECTED]
Newsgroups: gmane.comp.crm.arsystem.general
To: arslist@ARSLIST.ORG
Sent: Thursday, June 19, 2008 7:23 AM
Subject: Re: LIKE qualifications in 7.0
Very bizarre. If I run the query in the advanced search bar in the WUT, I
get no results. However, I changed the Run If qualification on one of our
dev servers to the following:
('Group_List' LIKE %System%) OR ('Group_List' LIKE %Admin%)
It's a 7.0.01 server and I'm using a 7.0.01 WUT. For some reason, it works.
I logged it, and it passes the qualification.
Just to make sure I'm not out of my mind, I changed it back to:
( 'Group_List' LIKE (( % + System ) + % )) OR ( 'Group_List' LIKE
(( % + 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, 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: Wednesday, June 18, 2008 6:08 PM
To: arslist@arslist.org
Subject: Re: LIKE qualifications in 7.0
**
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 -- it actually stores a semicolon-delimited list
of Group IDs.
I tried a similar search on my User form, using the Advanced Search bar with
a LIKE qualification:
'Group List' LIKE %Administrator%
This returned NO results. However, the following query will return all
Users in the Administrator group (group ID 1).
'Group List' LIKE 1;% OR 'Group List' LIKE % 1;% OR 'Group List'
LIKE %;1;
AFAIK, this has always been the proper method to search the 'Group List'
field (see attached document titled How To Query On The Group List Field,
circa ARS 3.x). I'm pretty sure this is still valid.
Now, I am curious why this seems to have worked differently in ARS 5.1...
Perhaps this version allowed searches on the 'Group List' field with
explicit group names, or maybe it was only possible in the Run If
statement on an Active Link???
--Thomas
- Original Message -
From: Grooms, Frederick W mailto:[EMAIL PROTECTED]
Newsgroups: gmane.comp.crm.arsystem.general
To: arslist@ARSLIST.ORG
Sent: Wednesday, June 18, 2008 3:59 PM
Subject: Re: LIKE qualifications in 7.0
**
What happens if you run your qualification in the Advanced Query bar
on your v7 User tool. You should get a list of users.
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754
ELSG/DOMH
Sent: Wednesday, June 18, 2008 2:02 PM
To: arslist@ARSLIST.ORG
Subject: LIKE
Re: I'm almost there.... (UNCLASSIFIED)
Classification: UNCLASSIFIED Caveats: NONE I hope one of BMC\Remedy's development targets for installers is to consolidate ALL installers into one or a series of connected modules. Remedy Corp was very good at modularity. I'm not so sure BMC has caught on yet. Well tested installers that look alike will result in less support calls and less frustration on the customers part. Less customer frustration equals more profit from additional purchases. Having just installed the entire suite on a new server (UNIX), they are almost there. The Windows installers I've done in the past, do have the same look and feel. They need to apply this to other platforms. If they could consolidate development teams and make the look and feel the same, Release Notes could be a minor thing. They will not go away, but the need to specifically review them to the nats eyelash will be less. Gordon M. Frank Remedy Skilled Professional - 7.x ITIL V3 Foundation Certified DISA\Verizon FNS -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Richard Copits Sent: Thursday, June 19, 2008 11:15 AM To: arslist@ARSLIST.ORG Subject: Re: I'm almost there ** You may not believe it, but I did read the release notes, installation guide, configuration guide and users guide and I'm totally embarrassed to say that I absolutely did not see that on page 19, but yep, there it is. I think I'm getting loopy from all the reading and correlating. Thank you for diplomatically pointing out that reference. So far I've had to go through well over a thousand pages of reading material and being low-visioned it's a chore. I need a few days on the beach in Nassau with a cold drink. As I said, thanks for your patience and forbearance while I learn this wonderful product that management has decided to install... From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of strauss Sent: Thursday, June 19, 2008 11:00 AM To: arslist@ARSLIST.ORG Subject: Re: I'm almost there ** I hate to say it, but you really DO need to read the installation guide (pg. 19 in this case) and the release notes on any BMC Remedy product before you install it. BMC installers barely work as it is, and absolutely don't if you skip those prerequisites that they DO manage to document. You will waste a lot of your own time if you don't. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Richard Copits Sent: Thursday, June 19, 2008 9:41 AM To: arslist@ARSLIST.ORG Subject: I'm almost there ** First, a sincere thanks to everyone for their patience, tolerance, help and suggestions during my journey through the wonderful wonderland of Remedy 7x installation and configuration... Todays test of my ability to decode the obscure happened during the installation of the SLM module. I got an error message about something called BMC_SLM_JAVA_HOME not being set as an environment variable. I'm assuming that this is a system variable in the control panel, system properties, advanced, environment variables area and NOT someplace in AR.CFG or some other obscure XML file. Before I change anything which if I'm wrong might render 3 days of work totally trashed I thought I'd ask the experts. Am I correct in my assuming that I need to put it in as a SYSTEM environment variable and give it the path to some module (???) in Java? Thank you for your suggestions. Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Classification: UNCLASSIFIED Caveats: NONE ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Issue with AIE and Oracle
Having never used AIE my question would be ... Is anyone using it to access multiple database manufacturers at the same time (i.e. MS SQL and Oracle at the same time), or are people using just one manufacturer at a time (i.e.accessing multiple Oracle databases, or accessing multiple MS SQL databases, or accessing multiple Sybase databases)? Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Howard Richter Sent: Thursday, June 19, 2008 10:02 AM To: arslist@ARSLIST.ORG Subject: Re: Issue with AIE and Oracle ** That is my thought as well or is it looking at what the arserver is talking to. Thanks for the info, Howard On 6/19/08, strauss [EMAIL PROTECTED] wrote: ** You must be hitting some sort of oracle-specific issue (on which I will be of no help). My AIE instances draw their data from a dedicated SQL Server that has databases populated from our eDir LDAP and PeopleSoft property systems. The SQL Server hosting the ARSystem database is on yet another, completely different SQL Server. The two SQL Servers, the AR Server, and the AIE server are all on separate machines, with connections limited to their subnet. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Howard Richter Sent: Thursday, June 19, 2008 8:50 AM To: arslist@ARSLIST.ORG Subject: Issue with AIE and Oracle ** Good morning all, I have the newest release of AIE and I am trying to get it to talk to a remote oracle database. The Server is 7.1 patch 3 and using MSSQL. I have installed the 10g client and can talk to the remote Oracle system using sqlplus from the box where the arserver is running. There is nothing in any log that I can find, that shows any attempt of the AIE trying to connect to the Oracle database. I did try setting up the AIE to talk to a MSSQL database and that worked. I am starting to wonder if, you can only talk to a database that the server talks to (for example in my case only MSSQL, since that is what the server is talking to). Any ideas, as of yet BMC support has had non. Howard -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Issue with AIE and Oracle
Hi There... We're kind of in the same boat. We're working on an AIE that is running on a separate Windoze box. I've not worked on that challenge yet. But wouldn't we need to configure an ODBC (System) Name client first using the Oracle Client (If such a thing exist). Once thats set up I believe we need to select a ODBC Adapter through AIE.. -d From: Action Request System discussion list(ARSList) on behalf of Howard Richter Sent: Thu 06/19/2008 6:49 AM To: arslist@ARSLIST.ORG Subject: Issue with AIE and Oracle ** Good morning all, I have the newest release of AIE and I am trying to get it to talk to a remote oracle database. The Server is 7.1 patch 3 and using MSSQL. I have installed the 10g client and can talk to the remote Oracle system using sqlplus from the box where the arserver is running. There is nothing in any log that I can find, that shows any attempt of the AIE trying to connect to the Oracle database. I did try setting up the AIE to talk to a MSSQL database and that worked. I am starting to wonder if, you can only talk to a database that the server talks to (for example in my case only MSSQL, since that is what the server is talking to). Any ideas, as of yet BMC support has had non. Howard -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Issue with AIE and Oracle
I'm not, but one installation of AIE with multiple service instances can host multiple data exchanges. Each data exchange can be configured to use a different database connector, so I see no reason why I could not have four service instances running four data exchanges (1 per) that draw from SQL Server, Oracle, a flat file, and a DB2 database, with all of the data exchanges pushing something to the same AR Server. Based on what I have seen performance-wise, I would try to separate the data exchanges from one another by time slices; I wouldn't want to have all four running simultaneously. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Thursday, June 19, 2008 10:34 AM To: arslist@ARSLIST.ORG Subject: Re: Issue with AIE and Oracle ** Having never used AIE my question would be ... Is anyone using it to access multiple database manufacturers at the same time (i.e. MS SQL and Oracle at the same time), or are people using just one manufacturer at a time (i.e.accessing multiple Oracle databases, or accessing multiple MS SQL databases, or accessing multiple Sybase databases)? Fred _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Howard Richter Sent: Thursday, June 19, 2008 10:02 AM To: arslist@ARSLIST.ORG Subject: Re: Issue with AIE and Oracle ** That is my thought as well or is it looking at what the arserver is talking to. Thanks for the info, Howard On 6/19/08, strauss [EMAIL PROTECTED] wrote: ** You must be hitting some sort of oracle-specific issue (on which I will be of no help). My AIE instances draw their data from a dedicated SQL Server that has databases populated from our eDir LDAP and PeopleSoft property systems. The SQL Server hosting the ARSystem database is on yet another, completely different SQL Server. The two SQL Servers, the AR Server, and the AIE server are all on separate machines, with connections limited to their subnet. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Howard Richter Sent: Thursday, June 19, 2008 8:50 AM To: arslist@ARSLIST.ORG Subject: Issue with AIE and Oracle ** Good morning all, I have the newest release of AIE and I am trying to get it to talk to a remote oracle database. The Server is 7.1 patch 3 and using MSSQL. I have installed the 10g client and can talk to the remote Oracle system using sqlplus from the box where the arserver is running. There is nothing in any log that I can find, that shows any attempt of the AIE trying to connect to the Oracle database. I did try setting up the AIE to talk to a MSSQL database and that worked. I am starting to wonder if, you can only talk to a database that the server talks to (for example in my case only MSSQL, since that is what the server is talking to). Any ideas, as of yet BMC support has had non. Howard -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Walking table, reading and setting hi-liting rows
Thanks, Carey, I did a search in the Form and Application and Workflow Objects manuals for extra column but didn't find anything. Where can I get more info? Dwayne Original message Date: Thu, 19 Jun 2008 10:03:22 -0400 From: Carey Matthew Black [EMAIL PROTECTED] Subject: Re: Walking table, reading and setting hi-liting rows To: arslist@ARSLIST.ORG I think you will find that the color is only set for the rows when the table is refreshed. Changing the selection value after refresh does not change the row color. (At least in v6.3 it did not work that way. Maybe 7.1 will be different, but I doubt it.) And frankly, given any ADA requirements, using color is a bad way to communicate with users. I personally prefer the extra column approach. You can even combine the two if you want to as well. The extra column could be 'Display Type' = Read Only-HTML and stuff HTML into each cell to color the page and add text to match the state for the row. So the background could be green and you could put the word green in the cell too. ( Just a thought) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Wed, Jun 18, 2008 at 6:16 PM, Thad K Esser [EMAIL PROTECTED] wrote: ** Dwayne, Your original post said you are on version 7.1. I haven't played with it much, but page 368 of the Form and Application Objects manual says you can change the colors of rows in tables based on selection fields. If you combined that with Fred's suggestion below, you could set the foreground color to white and the background color to black when the status was Yes. It wouldn't truly be a selected row, but it would look that way to the user. I don't know how well that would play out in practice for what you are doing, but its crazy enough that it just might work. Thad Esser Remedy Developer Argue for your limitations, and sure enough, they're yours.-- Richard Bach ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Stop SLM Emails on Dev?
Hi Jason I was sure that I'd had this working in the past, but I just tried it on a dev server, and you're right, the Send Message field gets set back to Yes. I have used the second approach I described multiple times with no problems. The process you suggested seems similar. Regards David Sanders Remedy Solution Architect Enterprise Service Suite @ Work == ARS List Award Winner 2005 Best 3rd party Remedy Application See the http://www.westoverconsulting.co.uk/downloads/ESS_Concepts_Guide.pdf ESS Concepts Guide tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk http://www.westoverconsulting.co.uk/ _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jason Miller Sent: Wednesday, June 18, 2008 10:18 PM To: arslist@ARSLIST.ORG Subject: Re: Stop SLM Emails on Dev? ** Hi David, Do you have it working where setting the Send field to No suppresses the email from being sent? I have tried over the years with various versions to do this but the filter doesn't seem to take effect. The Send field is always set to Yes any ways. I figured the email engine was setting it to Yes after my filter was firing. My workaround has been to create a filter has a set fields action that adds the contents of the To: field to the end of the subject (so I can see who it should have went to) and another set fields action to chance the To: to my email address. You can take this a step further and add a flag field somewhere (I used the User form, never had a problem with upgrades/patches) that you can set for people that you expect to be testing and allow the email to go to that address. You probably wouldn't want to send all of the emails to yourself if it is a really busy email engine. One advantage of sending all of the emails to myself is that I find email actions that I never knew about and can see when people that I didn't expect to be testing are testing. Jason On Wed, Jun 18, 2008 at 12:49 PM, David Sanders [EMAIL PROTECTED] wrote: Phil You could add a filter to your AR System Email Messages form to set the 'Send Message' field on Submit to No for all records where the 'Message Type' is Outgoing. This will stop the messages being sent out, but the records will still be present in the messages form so you can check what notifications were generated. Alternatively, use a filter On Submit to change the To address to a test mailbox (and perhaps append the original To value to the message body so you know who it would have been sent to). You can then monitor the Test mailbox to see what messages were generated without spamming your users. HTH David Sanders Remedy Solution Architect Enterprise Service Suite @ Work == ARS List Award Winner 2005 Best 3rd party Remedy Application See the ESS Concepts Guide tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Phil Murnane Sent: Wednesday, June 18, 2008 7:29 PM To: arslist@ARSLIST.ORG Subject: Re: Stop SLM Emails on Dev? Christopher: Thanks for the reply. That does work, but part of our customer's requirement is to do acceptance testing on the new version SLM, so we can't leave all the Service Targets disabled. I'm guessing SLM somehow caches the user's Default Notify Mechanism in the records of some form, and this cache is not getting updated when we make the changes to the User records -- I just don't know where to look for this data. Thanks Again, --Phil - Original Message From: strauss [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, June 18, 2008 11:17:54 AM Subject: Re: Stop SLM Emails on Dev? I would expect to have to disable all of the Service Targets and rebuild them. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Phil Murnane Sent: Wednesday, June 18, 2008 1:12 PM To: arslist@ARSLIST.ORG Subject: Stop SLM Emails on Dev? Folks: When we clone a production server running SLM 7.1.0 patch 1 to our dev server, we go through a process where we disable the Email Engine, change all user records' Default Notify Mechanism to Alert, and delete any pending AR System Email Messages. All ITSM emails stop being generated except for some SLM notification. Any suggestions about what we can do to stop all the SLM notifications? Thanks, --Phil ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: LIKE qualifications in 7.0
Michael,
I tested this in a 'Run If' qualification in active link on my system (ARS
7.0.1). Either of the following worked correctly:
a.. 'Group List' LIKE % + Administrator + %
b.. 'Group List' LIKE %Administrator%
However, using the Group ID search method did NOT work.
So, this seems to confirm my suspicion that the 'Run If' on an active link is
just searching the displayed values on the screen, rather than the actual
values stored in the database.
As to why your original syntax (using the concatenation operator between the
search value and the wildcard characters) didn't work in your 7.0.1 client, is
still a mystery to me.
- Original Message -
From: McManus Michael A SSgt HQ 754 ELSG/DOMH [EMAIL PROTECTED]
Newsgroups: gmane.comp.crm.arsystem.general
To: arslist@ARSLIST.ORG
Sent: Thursday, June 19, 2008 10:29 AM
Subject: Re: LIKE qualifications in 7.0
Tell me about it.
I tried the following as the Run If qualification in that active link:
'Group_List' LIKE 275;% OR 'Group_List' LIKE 1;% OR 'Group_List' LIKE
285;%
And it fails the qualification. However, if I run that in the Advanced Query
Bar, I get everyone who belongs to one of those three groups.
If I change the qualification to:
( 'Group_List' = 275; ) OR ( 'Group_List' = 1; ) OR ( 'Group_List' =
285; )
It passes the qualification and that also works in the advanced query bar.
Perhaps I'm just failing to understand the difference between advanced queries
and Run If qualifications and how they're interpreted.
I still can't wrap my head around why this:
( 'Group_List' LIKE (( % + System ) + % )) OR (
'Group_List' LIKE (( % + Admin ) + % ))
And this:
('Group_List' LIKE %System%) OR ('Group_List' LIKE %Admin%)
Are different. I'm a layman, but it seems to me 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@ARSLIST.ORG
Subject: Re: LIKE qualifications in 7.0
Strange. The 'Run If' qualification in an active link would technically not
be issuing a search to the database -- it is simply searching the values
already displayed in the client. That may be why your qualification worked
using group names instead of Group IDs. What happens if you change the 'Run
If' qualification in the active link to search on the Group IDs instead of
the group names? If it works using the Group IDs, I would recommend going
that route. The qualification will be a lot lengthier, but I think this
would be a more consistent solution between ARS versions.
--Thomas
- Original Message -
From: McManus Michael A SSgt HQ 754 ELSG/DOMH
[EMAIL PROTECTED]
Newsgroups: gmane.comp.crm.arsystem.general
To: arslist@ARSLIST.ORG
Sent: Thursday, June 19, 2008 7:23 AM
Subject: Re: LIKE qualifications in 7.0
Very bizarre. If I run the query in the advanced search bar in the WUT, I
get no results. However, I changed the Run If qualification on one of our
dev servers to the following:
('Group_List' LIKE %System%) OR ('Group_List' LIKE %Admin%)
It's a 7.0.01 server and I'm using a 7.0.01 WUT. For some reason, it works.
I logged it, and it passes the qualification.
Just to make sure I'm not out of my mind, I changed it back to:
( 'Group_List' LIKE (( % + System ) + % )) OR ( 'Group_List' LIKE
(( % + 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, 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: Wednesday, June 18, 2008 6:08 PM
To: arslist@arslist.org
Subject: Re: LIKE qualifications in 7.0
**
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 -- it actually stores a semicolon-delimited list
of Group IDs.
I tried a similar search on my User form, using the Advanced Search bar with
a LIKE qualification:
'Group List' LIKE %Administrator%
This returned NO results. However, the following query will return all
Users in the Administrator group (group ID 1).
'Group List' LIKE 1;% OR 'Group List' LIKE % 1;% OR 'Group List'
LIKE %;1;
AFAIK, this has always been the proper method to search the 'Group List'
field (see attached document titled How To Query On The Group List Field,
circa ARS 3.x). I'm pretty sure this is still valid.
Now, I am curious why this seems to have worked
Re: Firefox3
Gary, I've just tried Firefox 3 as well, and can report that screens seem to display faster than with my IE7 or Firefox 2.x. I think they have monkeyed with delaying rendering the screen until all the data has arrived, because I can see some navigation fields redrawing on an in-house app. Drawing the screen on the fly rather than buffering does make it look faster even though the full data might not arrive until the end of the render. Subjective observation of course, YMMV Firefox 3.0.0 Windows XP SP 2 Midtier 7.01 patch 004 on Solaris AR 7.01 on Solaris Doug . Original Message ... On Thu, 19 Jun 2008 08:56:45 -0500 Gary Opela (Corporate) [EMAIL PROTECTED] wrote: ** I was just trying firefox 3 out with my mid-tier, it’s pretty cool. It’s really fast, and they’ve added in spell check that works just like word. You all should try it out if you haven’t yet. Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI® Level 3 Rated Company _ Doug Blair Remedy Skilled Professional doug at blairing dotcom +1 224-558-5462 Sent from my Treo, usual caveats apply ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: I'm almost there.... (UNCLASSIFIED)
Just and FYII spoke with one of the Remedy folk who told me that this is what the next major release of Remedy will be like - the main configurator program will be an upfront all-choices-on-one-page format that will make setting up the whole ball of wax MUCH easier.. I'm all for that!! -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of FRANK, GORDON CTR DISA JSSC Sent: Thursday, June 19, 2008 11:30 AM To: arslist@ARSLIST.ORG Subject: Re: I'm almost there (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE I hope one of BMC\Remedy's development targets for installers is to consolidate ALL installers into one or a series of connected modules. Remedy Corp was very good at modularity. I'm not so sure BMC has caught on yet. Well tested installers that look alike will result in less support calls and less frustration on the customers part. Less customer frustration equals more profit from additional purchases. Having just installed the entire suite on a new server (UNIX), they are almost there. The Windows installers I've done in the past, do have the same look and feel. They need to apply this to other platforms. If they could consolidate development teams and make the look and feel the same, Release Notes could be a minor thing. They will not go away, but the need to specifically review them to the nats eyelash will be less. Gordon M. Frank Remedy Skilled Professional - 7.x ITIL V3 Foundation Certified DISA\Verizon FNS -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Richard Copits Sent: Thursday, June 19, 2008 11:15 AM To: arslist@ARSLIST.ORG Subject: Re: I'm almost there ** You may not believe it, but I did read the release notes, installation guide, configuration guide and users guide and I'm totally embarrassed to say that I absolutely did not see that on page 19, but yep, there it is. I think I'm getting loopy from all the reading and correlating. Thank you for diplomatically pointing out that reference. So far I've had to go through well over a thousand pages of reading material and being low-visioned it's a chore. I need a few days on the beach in Nassau with a cold drink. As I said, thanks for your patience and forbearance while I learn this wonderful product that management has decided to install... From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of strauss Sent: Thursday, June 19, 2008 11:00 AM To: arslist@ARSLIST.ORG Subject: Re: I'm almost there ** I hate to say it, but you really DO need to read the installation guide (pg. 19 in this case) and the release notes on any BMC Remedy product before you install it. BMC installers barely work as it is, and absolutely don't if you skip those prerequisites that they DO manage to document. You will waste a lot of your own time if you don't. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Richard Copits Sent: Thursday, June 19, 2008 9:41 AM To: arslist@ARSLIST.ORG Subject: I'm almost there ** First, a sincere thanks to everyone for their patience, tolerance, help and suggestions during my journey through the wonderful wonderland of Remedy 7x installation and configuration... Todays test of my ability to decode the obscure happened during the installation of the SLM module. I got an error message about something called BMC_SLM_JAVA_HOME not being set as an environment variable. I'm assuming that this is a system variable in the control panel, system properties, advanced, environment variables area and NOT someplace in AR.CFG or some other obscure XML file. Before I change anything which if I'm wrong might render 3 days of work totally trashed I thought I'd ask the experts. Am I correct in my assuming that I need to put it in as a SYSTEM environment variable and give it the path to some module (???) in Java? Thank you for your suggestions. Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting
Re: Private incidents
This can be done via dynamic groups. Contact me off list for more information. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of John Kelley Sent: Thursday, June 19, 2008 9:41 AM To: arslist@ARSLIST.ORG Subject: Private incidents Hi List ARS 7.01 Is there a way to set an Indicent request private to one particular group? Here is the reasoning: We have a risk management group that wants to open their own calls in incident management, which should NOT be seen by any other support group. Thanks * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Where is the background appearance information stored?
Hi Listers I believe that everything in Remedy is stored some where in the table. So I am trying to locate where is the background information on the Appearance tab of the View properties stored? I tried searching in table vui but no luck I tried searching field_dispprop with a guess that the total appearance may be stored as a field. Interestingly I found fieldID = 0 but properties did not reveal anything meaningful (rather interpretable)? Does anybody know about this? Best Regards, Uday Joshi Delivery Manager - BSM Support Technology Infrastructure Services - BSM Unit -- Wipro Technologies, Hinjewadi, Pune 411057 Tel: +91 20 39104092 VOIP 842-5103 Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Where is the background appearance information stored?
Are you asking about background color or background image? Or both? --Tim - Original Message From: Uday Joshi [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, June 19, 2008 11:42:45 AM Subject: [ARSLIST] Where is the background appearance information stored? ** Hi Listers I believe that everything in Remedy is stored some where in the table. So I am trying to locate where is the background information on the Appearance tab of the View properties stored? I tried searching in table vui but no luck I tried searching field_dispprop with a guess that the total appearance may be stored as a field. Interestingly I found fieldID = 0 but properties did not reveal anything meaningful (rather interpretable)? Does anybody know about this? Best Regards, Uday Joshi Delivery Manager - BSM Support Technology Infrastructure Services - BSM Unit -- Wipro Technologies, Hinjewadi, Pune 411057 Tel: +91 20 39104092 VOIP 842-5103 Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: LIKE qualifications in 7.0
Are you patched? I didn't see anything in the patch notes specifically relating
to this, but maybe I just missed it.
I just changed my qualification to the following:
('Group_List' LIKE % + System + %) OR ('Group_List' LIKE % + Admin +
%)
and it still fails the qualification.
Here's the other thing that doesn't make sense to me. You mention that you
think Run If qualifications are compared against the values in the client, and
I'd be inclined to agree except when I change the qualification to the
following:
( 'Group_List' = 275; ) OR ( 'Group_List' = 1; ) OR ( 'Group_List' =
285; )
It passes the qualification. Those Group IDs are not what appears in the
client. Does the LIKE operator compare against the values displayed in the
client and the = operator compare against 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
-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' qualification in active link on my system (ARS
7.0.1). Either of the following worked correctly:
* 'Group List' LIKE % + Administrator + %
* 'Group List' LIKE %Administrator%
However, using the Group ID search method did NOT work.
So, this seems to confirm my suspicion that the 'Run If' on an active link is
just searching the displayed values on the screen, rather than the actual
values stored in the database.
As to why your original syntax (using the concatenation operator between the
search value and the wildcard characters) didn't work in your 7.0.1 client, is
still a mystery to me.
- Original Message -
From: McManus Michael A SSgt HQ 754 ELSG/DOMH [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
Newsgroups: gmane.comp.crm.arsystem.general
To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG
Sent: Thursday, June 19, 2008 10:29 AM
Subject: Re: LIKE qualifications in 7.0
Tell me about it.
I tried the following as the Run If qualification in that active link:
'Group_List' LIKE 275;% OR 'Group_List' LIKE 1;% OR 'Group_List' LIKE
285;%
And it fails the qualification. However, if I run that in the Advanced Query
Bar, I get everyone who belongs to one of those three groups.
If I change the qualification to:
( 'Group_List' = 275; ) OR ( 'Group_List' = 1; ) OR ( 'Group_List' =
285; )
It passes the qualification and that also works in the advanced query bar.
Perhaps I'm just failing to understand the difference between advanced queries
and Run If qualifications and how they're interpreted.
I still can't wrap my head around why this:
( 'Group_List' LIKE (( % + System ) + % )) OR (
'Group_List' LIKE (( % + Admin ) + % ))
And this:
('Group_List' LIKE %System%) OR ('Group_List' LIKE %Admin%)
Are different. I'm a layman, but it seems to me 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@ARSLIST.ORG mailto:arslist@ARSLIST.ORG
Subject: Re: LIKE qualifications in 7.0
Strange. The 'Run If' qualification in an active link would technically not
be issuing a search to the database -- it is simply searching the values
already displayed in the client. That may be why your qualification worked
using group names instead of Group IDs. What happens if you change the 'Run
If' qualification in the active link to search on the Group IDs instead of
the group names? If it works using the Group IDs, I would recommend going
that route. The qualification will be a lot lengthier, but I think this
would be a more consistent solution between ARS versions.
--Thomas
- Original Message -
From: McManus Michael A SSgt HQ 754 ELSG/DOMH
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
Newsgroups: gmane.comp.crm.arsystem.general
To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG
Sent: Thursday, June 19, 2008 7:23 AM
Subject: Re: LIKE qualifications in 7.0
Very bizarre. If I run the query in the advanced search bar in the WUT, I
get no results. However, I changed the Run If qualification on one of our
dev servers to the following:
('Group_List' LIKE %System%) OR ('Group_List' LIKE %Admin%)
It's a 7.0.01 server and I'm using a 7.0.01 WUT. For some reason, it works.
I logged it, and it passes the qualification.
Just to make sure I'm not out of my mind, I changed it back to:
( 'Group_List' LIKE (( % + System ) + % )) OR ( 'Group_List' LIKE
(( % + Admin ) + % ))
And I received
Re: CI Relationship Viewer Error
Hi, You may check the emvironment path variable if it is pointing to midtier directory or not. On Thu, Jun 19, 2008 at 9:57 AM, AR_User [EMAIL PROTECTED] wrote: Hi Vasstudatta, I already did that but still it is not working. Am I missing anything else? Regards, ARUSER vasstudatta wrote: copy the 3 mentioned files again from the cmdb install directiory under sdk/bin folder to web-inf and bounce your webeserver On Wed, Jun 18, 2008 at 5:31 PM, AR_User [EMAIL PROTECTED] wrote: Hi All, Whenever I try to see the CI relationship viewer I get the following error: CMDB libraries are not available. Please install the CI Relationship Viewer on the Mid Tier server. But the fact it is installed properly and all the APIs (cmdbapi20.dll, cmdbapi20.jar, cmdbjni20.jar) are already in the WEB-INF/lib directory. I am on ARS 7.0, CMDB 2.0.1, Mid-Tier 7.0.01 and Apache Tomcat 5.5... Is anything there that I am missing? Please update me... Thanks in advance... ARUSER -- View this message in context: http://www.nabble.com/CI-Relationship-Viewer-Error-tp17981235p17981235.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- Thanks Best Regards, Chinmmay™ Revenge is the best dish Served Cold... http://clubhq23.blogspot.com/ -- View this message in context: http://www.nabble.com/CI-Relationship-Viewer-Error-tp17981235p17997091.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- Thanks Best Regards, Chinmmay™ Revenge is the best dish Served Cold... http://clubhq23.blogspot.com/
User Cache
Can anyone tell me what files to delete to clear the WUT cache? I have a problem where changes are not showing up on one of my workstations. I can login to another and everything shows up. I ran into this once before, but I cannot for the life of me remember what files I deleted to correct the problem. Thanks, Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: User Cache
Andy, You may wish to go to http://developer.bmc.com, log in, and search for Client Cache Purge in the download section. That's a pretty handy .bat file to have in your toolkit. In answer to your question, you're looking for .arv and .arf files. Enjoy, Matt Reinfeldt -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Thursday, June 19, 2008 12:53 PM To: arslist@ARSLIST.ORG Subject: User Cache Can anyone tell me what files to delete to clear the WUT cache? I have a problem where changes are not showing up on one of my workstations. I can login to another and everything shows up. I ran into this once before, but I cannot for the life of me remember what files I deleted to correct the problem. Thanks, Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: User Cache (U)
UNCLASSIFIED *.arf *.arv Sandra Hennigan OSD Enterprise Remedy Administrator Office # 703-602-2525 x248 Apparently, there is nothing that cannot happen today. Mark Twain -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Thursday, June 19, 2008 1:53 PM To: arslist@ARSLIST.ORG Subject: User Cache Can anyone tell me what files to delete to clear the WUT cache? I have a problem where changes are not showing up on one of my workstations. I can login to another and everything shows up. I ran into this once before, but I cannot for the life of me remember what files I deleted to correct the problem. Thanks, Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are smime.p7s Description: S/MIME cryptographic signature
Re: LIKE qualifications in 7.0
When I tried the following in the 'Run If' of my active link I was testing
with, it did NOT work:
'Group List' = 1;
So, it didn't make any difference whether I was using a LIKE operation with
wildcards or an equals operation with an explicit group ID value.
I'm more inclined to believe that the inconsistencies you are observing are
related to the special behavior of the 'Group List' field, and not indicative
of a general issue with LIKE searches in other workflow.
My server is ARS 7.0.01 Patch 001, my user tool is 7.0.01 Patch 007. Are you
running your 7.0.1 client against a 7.0.1 server, or against the 5.1.2 server
that you're planning to upgrade? Also, just out of curiosity, what is the
underlying database you are using?
This is probably trivial, but one other difference I noticed in your search
syntax -- your 'Group List' field appears to contain an underscore character,
which is not the format I have in my User form that was installed with ARS
7.0.1. Just to be sure, is this the same default 'Group List' field that you
are searching in your active link?
- Original Message -
From: McManus Michael A SSgt HQ 754 ELSG/DOMH [EMAIL PROTECTED]
Newsgroups: gmane.comp.crm.arsystem.general
To: arslist@ARSLIST.ORG
Sent: Thursday, June 19, 2008 12:09 PM
Subject: Re: LIKE qualifications in 7.0
Are you patched? I didn't see anything in the patch notes specifically relating
to this, but maybe I just missed it.
I just changed my qualification to the following:
('Group_List' LIKE % + System + %) OR ('Group_List' LIKE % + Admin +
%)
and it still fails the qualification.
Here's the other thing that doesn't make sense to me. You mention that you
think Run If qualifications are compared against the values in the client, and
I'd be inclined to agree except when I change the qualification to the
following:
( 'Group_List' = 275; ) OR ( 'Group_List' = 1; ) OR ( 'Group_List' =
285; )
It passes the qualification. Those Group IDs are not what appears in the
client. Does the LIKE operator compare against the values displayed in the
client and the = operator compare against 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
-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' qualification in active link on my system (ARS
7.0.1). Either of the following worked correctly:
* 'Group List' LIKE % + Administrator + %
* 'Group List' LIKE %Administrator%
However, using the Group ID search method did NOT work.
So, this seems to confirm my suspicion that the 'Run If' on an active link is
just searching the displayed values on the screen, rather than the actual
values stored in the database.
As to why your original syntax (using the concatenation operator between the
search value and the wildcard characters) didn't work in your 7.0.1 client, is
still a mystery to me.
- Original Message -
From: McManus Michael A SSgt HQ 754 ELSG/DOMH [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
Newsgroups: gmane.comp.crm.arsystem.general
To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG
Sent: Thursday, June 19, 2008 10:29 AM
Subject: Re: LIKE qualifications in 7.0
Tell me about it.
I tried the following as the Run If qualification in that active link:
'Group_List' LIKE 275;% OR 'Group_List' LIKE 1;% OR 'Group_List' LIKE
285;%
And it fails the qualification. However, if I run that in the Advanced Query
Bar, I get everyone who belongs to one of those three groups.
If I change the qualification to:
( 'Group_List' = 275; ) OR ( 'Group_List' = 1; ) OR ( 'Group_List' =
285; )
It passes the qualification and that also works in the advanced query bar.
Perhaps I'm just failing to understand the difference between advanced queries
and Run If qualifications and how they're interpreted.
I still can't wrap my head around why this:
( 'Group_List' LIKE (( % + System ) + % )) OR (
'Group_List' LIKE (( % + Admin ) + % ))
And this:
('Group_List' LIKE %System%) OR ('Group_List' LIKE %Admin%)
Are different. I'm a layman, but it seems to me 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@ARSLIST.ORG mailto:arslist@ARSLIST.ORG
Subject: Re: LIKE qualifications in 7.0
Strange. The 'Run If' qualification in an active link would technically not
be issuing a
Re: User Cache
Delete all .arf and .arv files. Thanks, Jonathan Jones Southern Company Services 205-257-4799 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Thursday, June 19, 2008 12:53 PM To: arslist@ARSLIST.ORG Subject: User Cache Can anyone tell me what files to delete to clear the WUT cache? I have a problem where changes are not showing up on one of my workstations. I can login to another and everything shows up. I ran into this once before, but I cannot for the life of me remember what files I deleted to correct the problem. Thanks, Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: User Cache
Try removing all of the *.arf and *.arv files. On Thu, Jun 19, 2008 at 1:52 PM, Mayfield, Andy L. [EMAIL PROTECTED] wrote: Can anyone tell me what files to delete to clear the WUT cache? I have a problem where changes are not showing up on one of my workstations. I can login to another and everything shows up. I ran into this once before, but I cannot for the life of me remember what files I deleted to correct the problem. Thanks, Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: User Cache
set MyHome=c:\Arsystem\Home for /F %%I in ( 'dir /b /ad %MyHome%') do ( if NOT %%I == ARCmds ( rd /S /Q %MyHome%\%%I ) ) Put this into a *.bat or *.cmd file and change the MyHome to where your WUT home folder is. Then run it. I keep this on my desktop and clear the cache whenever things start acting strange. --- J.T. Shyman -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Thursday, June 19, 2008 1:53 PM To: arslist@ARSLIST.ORG Subject: User Cache Can anyone tell me what files to delete to clear the WUT cache? I have a problem where changes are not showing up on one of my workstations. I can login to another and everything shows up. I ran into this once before, but I cannot for the life of me remember what files I deleted to correct the problem. Thanks, Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: User Cache
Something like this should work: J.T. Shyman Column Technologies -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Matt Reinfeldt Sent: Thursday, June 19, 2008 2:03 PM To: arslist@ARSLIST.ORG Subject: Re: User Cache Andy, You may wish to go to http://developer.bmc.com, log in, and search for Client Cache Purge in the download section. That's a pretty handy .bat file to have in your toolkit. In answer to your question, you're looking for .arv and .arf files. Enjoy, Matt Reinfeldt -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Thursday, June 19, 2008 12:53 PM To: arslist@ARSLIST.ORG Subject: User Cache Can anyone tell me what files to delete to clear the WUT cache? I have a problem where changes are not showing up on one of my workstations. I can login to another and everything shows up. I ran into this once before, but I cannot for the life of me remember what files I deleted to correct the problem. Thanks, Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: User Cache
If you want to take it one step further you can actually set up a URL and let people run/download it at their own choice via the midtier. Here are the steps: 1. you can create an attachment pool and embed the batch file into it 2. PERFORM-ACTION-OPEN-ATTACHMENT fieldID can be used to open and run the attachment 3. the user will have to agree to the prompts 4. you can distribute the URL as is or encapsulate it http://arserver/arsys/servlet/ViewFormServlet?form=formNameserver=serverNameusername=guesteid=001 (add pwd if needed) Please contact me offline if you need further info, Subash ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Qualification for Modifying Pre-existing Records
Hello, I am running an escalation on the Help Desk form that runs at a specific time with a RUN IF qualification of ( 'ztmpSub' =? $NULL$ ) AND ( 'Assignee' !=? $NULL$ ) Then push some X into the group field if? (Assignee = Joe Smith) or (Assignee=Jane Doe) or about 7 other names. I want to be able to modify selected old records at a specific time.? When the escalation runs, this hoses the server.? Within the qualification, is there a better way to narrow down the search results? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Walking table, reading and setting hi-liting rows
Excuse me, Carey. I misunderstood what you were saying. You were referring to Frederick’s solution below. That look’s do-able, and I’ll give it a try. Thank you, Carey, and Fred, and all others who responded. Dwayne Date: Thu, 19 Jun 2008 10:03:22 -0400 Reply-To: arslist@ARSLIST.ORG Sender: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG From: Carey Matthew Black [EMAIL PROTECTED] Subject: Re: Walking table, reading and setting hi-liting rows In-Reply-To: [EMAIL PROTECTED] Content-Type: text/plain; charset=ISO-8859-1 Content-Disposition: inline I think you will find that the color is only set for the rows when the table is refreshed. Changing the selection value after refresh does not change the row color. (At least in v6.3 it did not work that way. Maybe 7.1 will be different, but I doubt it.) And frankly, given any ADA requirements, using color is a bad way to communicate with users. I personally prefer the extra column approach. You can even combine the two if you want to as well. The extra column could be 'Display Type' = Read Only-HTML and stuff HTML into each cell to color the page and add text to match the state for the row. So the background could be green and you could put the word green in the cell too. ( Just a thought) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. ** Date: Wed, 18 Jun 2008 16:47:29 -0500 Reply-To: arslist@ARSLIST.ORG Sender: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG From: Grooms, Frederick W [EMAIL PROTECTED] Subject: Re: Walking table, reading and setting hi-liting rows In-Reply-To: A[EMAIL PROTECTED] Content-Type: text/plain; charset=us-ascii Like I said I could not highlite multiple rows thru workflow. My solution was to do the following: Add a Display Only field on the form (I used a 3 character field) Add this Display Only field as a column in the table (Yes you can add Display only fields from the form that holds the table as columns in the table). I called my column Selected In your Display workflow do the following Refresh the table walk the table while walking the table if 'your storage field' like % + 'Entry ID col' + % then set the display only field to Yes and set the column to Yes else clear the display only field I also changed it so that users double click on a row instead of multiple selecting and that set's the Selected column to Yes for that row (If Col = Yes clear the col and the Display Only else set both. Fred
Re: Qualification for Modifying Pre-existing Records
Get rid of your $NULL$ qualifications - they will always force a table scan. Perhaps if you could add something to the qual that would narrow down the number of rows - preferably on an indexed field? Rick On Thu, Jun 19, 2008 at 11:57 AM, Kathy Morris [EMAIL PROTECTED] wrote: ** Hello, I am running an escalation on the Help Desk form that runs at a specific time with a RUN IF qualification of ( 'ztmpSub' = $NULL$ ) AND ( 'Assignee' != $NULL$ ) Then push some X into the group field if (Assignee = Joe Smith) or (Assignee=Jane Doe) or about 7 other names. I want to be able to modify selected old records at a specific time. When the escalation runs, this hoses the server. Within the qualification, is there a better way to narrow down the search results? -- Get the Moviefone Toolbarhttp://toolbar.aol.com/moviefone/download.html?ncid=aolcmp000511. Showtimes, theaters, movie news, more! __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: LIKE qualifications in 7.0
I discovered the initial problem with a 7.0.01 client against the 5.1.2 server. I thought that may have been the problem so I used the 7.0.01 WUT against our 7.0.01 dev server. Still got the same behavior. Neither the WUT nor the server is patched though. Our database is SQL 2000 SP4 build number is 8.00.2039 This is a heavily modded User form, but the Field ID of that field is 104. I think the guy who built this just put underscores in the database name of most fields. 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 1:08 PM To: arslist@arslist.org Subject: Re: LIKE qualifications in 7.0 ** When I tried the following in the 'Run If' of my active link I was testing with, it did NOT work: 'Group List' = 1; So, it didn't make any difference whether I was using a LIKE operation with wildcards or an equals operation with an explicit group ID value. I'm more inclined to believe that the inconsistencies you are observing are related to the special behavior of the 'Group List' field, and not indicative of a general issue with LIKE searches in other workflow. My server is ARS 7.0.01 Patch 001, my user tool is 7.0.01 Patch 007. Are you running your 7.0.1 client against a 7.0.1 server, or against the 5.1.2 server that you're planning to upgrade? Also, just out of curiosity, what is the underlying database you are using? This is probably trivial, but one other difference I noticed in your search syntax -- your 'Group List' field appears to contain an underscore character, which is not the format I have in my User form that was installed with ARS 7.0.1. Just to be sure, is this the same default 'Group List' field that you are searching in your active link? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Firefox3
I just tried to view my home page with Firefox 3.0. All looks fine until I tried to view the page field with an Application List. I don't see the list but I do see a random Flashboard field from another page field. It also has trouble rendering the Flashboards once your view them. Though I don't know if it's a Flashboards problem or a Page Field problem. Firefox 3.0 ARS 6.3 Patch 21 AR Server on Windows 2000 Midtier on Windows 2003 with IIS and ServletExec John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Doug Blair Sent: Thursday, June 19, 2008 12:07 PM To: arslist@ARSLIST.ORG Subject: Re: Firefox3 Gary, I've just tried Firefox 3 as well, and can report that screens seem to display faster than with my IE7 or Firefox 2.x. I think they have monkeyed with delaying rendering the screen until all the data has arrived, because I can see some navigation fields redrawing on an in-house app. Drawing the screen on the fly rather than buffering does make it look faster even though the full data might not arrive until the end of the render. Subjective observation of course, YMMV Firefox 3.0.0 Windows XP SP 2 Midtier 7.01 patch 004 on Solaris AR 7.01 on Solaris Doug . Original Message ... On Thu, 19 Jun 2008 08:56:45 -0500 Gary Opela (Corporate) [EMAIL PROTECTED] wrote: ** I was just trying firefox 3 out with my mid-tier, it's pretty cool. It's really fast, and they've added in spell check that works just like word. You all should try it out if you haven't yet. Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company _ Doug Blair Remedy Skilled Professional doug at blairing dotcom +1 224-558-5462 Sent from my Treo, usual caveats apply ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Qualification for Modifying Pre-existing Records
Kathy,
Like Rick says using $NULL$ forces a table scan. Also using != always forces
a table scan. You could maybe try a RUN IF of ('Assignee' = Joe Smith) or
('Assignee' = Jane Doe) or ('Assignee' = one of 7 other names).
Are you wanting to run this against only open Help Desk records? If so you
could add 'Status' Closed. That would narrow down the search
significantly. Your RUN IF would then look something like:
(('Status' Closed) AND (('Assignee' = Joe Smith) or ('Assignee' =
Jane Doe) or ('Assignee' = one of 7 other names).))
Roger Medsker
Remedy Consultant
Bluestem Consulting Group, LLC
[EMAIL PROTECTED]
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook
Sent: Thursday, June 19, 2008 2:08 PM
To: arslist@ARSLIST.ORG
Subject: Re: Qualification for Modifying Pre-existing Records
** Get rid of your $NULL$ qualifications - they will always force a table
scan. Perhaps if you could add something to the qual that would narrow down
the number of rows - preferably on an indexed field?
Rick
On Thu, Jun 19, 2008 at 11:57 AM, Kathy Morris [EMAIL PROTECTED]
wrote:
** Hello,
I am running an escalation on the Help Desk form that runs at a specific
time with a RUN IF qualification of ( 'ztmpSub' = $NULL$ ) AND ( 'Assignee'
!= $NULL$ )
Then push some X into the group field if (Assignee = Joe Smith) or
(Assignee=Jane Doe) or about 7 other names.
I want to be able to modify selected old records at a specific time. When
the escalation runs, this hoses the server. Within the qualification, is
there a better way to narrow down the search results?
_
Get
http://toolbar.aol.com/moviefone/download.html?ncid=aolcmp000511
the Moviefone Toolbar. Showtimes, theaters, movie news, more!
__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___
__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Firefox3
Strange, my application list shows just fine. I don't have any flashboards to test. All of my page fields work fine as well. ARS 7.1, MT 7.1, Firefox 3 Windows XP SP 2 Windows Server 2k3/Apache Tomcat (no IIS) using JSSE for https MS SQL Server 2k5 Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent: Thursday, June 19, 2008 2:31 PM To: arslist@ARSLIST.ORG Subject: Re: Firefox3 I just tried to view my home page with Firefox 3.0. All looks fine until I tried to view the page field with an Application List. I don't see the list but I do see a random Flashboard field from another page field. It also has trouble rendering the Flashboards once your view them. Though I don't know if it's a Flashboards problem or a Page Field problem. Firefox 3.0 ARS 6.3 Patch 21 AR Server on Windows 2000 Midtier on Windows 2003 with IIS and ServletExec John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Doug Blair Sent: Thursday, June 19, 2008 12:07 PM To: arslist@ARSLIST.ORG Subject: Re: Firefox3 Gary, I've just tried Firefox 3 as well, and can report that screens seem to display faster than with my IE7 or Firefox 2.x. I think they have monkeyed with delaying rendering the screen until all the data has arrived, because I can see some navigation fields redrawing on an in-house app. Drawing the screen on the fly rather than buffering does make it look faster even though the full data might not arrive until the end of the render. Subjective observation of course, YMMV Firefox 3.0.0 Windows XP SP 2 Midtier 7.01 patch 004 on Solaris AR 7.01 on Solaris Doug . Original Message ... On Thu, 19 Jun 2008 08:56:45 -0500 Gary Opela (Corporate) [EMAIL PROTECTED] wrote: ** I was just trying firefox 3 out with my mid-tier, it's pretty cool. It's really fast, and they've added in spell check that works just like word. You all should try it out if you haven't yet. Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company _ Doug Blair Remedy Skilled Professional doug at blairing dotcom +1 224-558-5462 Sent from my Treo, usual caveats apply ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Firefox3
Well, I did manage to break it. I noticed that whenever a window loads, it flashes three to four times. I ran a search that returned a list, clicked in the results list, and used my down arrow key to scroll down the list of tickets. Each time a new ticket loaded, the window flashed again several times as it drew the different areas of the window. So, I got to the last ticket, and just spammed the down key around 20 or 30 times, the screen started flashing violently, then five little blue clocks jumped up on the screen, and when they went away, my screen was very very dark and almost impossible to see. Can someone else running MT 7.1 and Firefox 3 try this please and let me know if you get the same results? Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent: Thursday, June 19, 2008 2:31 PM To: arslist@ARSLIST.ORG Subject: Re: Firefox3 I just tried to view my home page with Firefox 3.0. All looks fine until I tried to view the page field with an Application List. I don't see the list but I do see a random Flashboard field from another page field. It also has trouble rendering the Flashboards once your view them. Though I don't know if it's a Flashboards problem or a Page Field problem. Firefox 3.0 ARS 6.3 Patch 21 AR Server on Windows 2000 Midtier on Windows 2003 with IIS and ServletExec John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Doug Blair Sent: Thursday, June 19, 2008 12:07 PM To: arslist@ARSLIST.ORG Subject: Re: Firefox3 Gary, I've just tried Firefox 3 as well, and can report that screens seem to display faster than with my IE7 or Firefox 2.x. I think they have monkeyed with delaying rendering the screen until all the data has arrived, because I can see some navigation fields redrawing on an in-house app. Drawing the screen on the fly rather than buffering does make it look faster even though the full data might not arrive until the end of the render. Subjective observation of course, YMMV Firefox 3.0.0 Windows XP SP 2 Midtier 7.01 patch 004 on Solaris AR 7.01 on Solaris Doug . Original Message ... On Thu, 19 Jun 2008 08:56:45 -0500 Gary Opela (Corporate) [EMAIL PROTECTED] wrote: ** I was just trying firefox 3 out with my mid-tier, it's pretty cool. It's really fast, and they've added in spell check that works just like word. You all should try it out if you haven't yet. Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company _ Doug Blair Remedy Skilled Professional doug at blairing dotcom +1 224-558-5462 Sent from my Treo, usual caveats apply ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Firefox3
Gary, I refreshed the browser, logged out, back in and viewed the same results. Then I went into the form, moved a few fields around. Then I manually flushed the cache. Now everything looks as it should. The Flashboards stay where they belong and the Application List works. We'll see how long it lasts. John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Thursday, June 19, 2008 3:48 PM To: arslist@ARSLIST.ORG Subject: Re: Firefox3 Strange, my application list shows just fine. I don't have any flashboards to test. All of my page fields work fine as well. ARS 7.1, MT 7.1, Firefox 3 Windows XP SP 2 Windows Server 2k3/Apache Tomcat (no IIS) using JSSE for https MS SQL Server 2k5 Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent: Thursday, June 19, 2008 2:31 PM To: arslist@ARSLIST.ORG Subject: Re: Firefox3 I just tried to view my home page with Firefox 3.0. All looks fine until I tried to view the page field with an Application List. I don't see the list but I do see a random Flashboard field from another page field. It also has trouble rendering the Flashboards once your view them. Though I don't know if it's a Flashboards problem or a Page Field problem. Firefox 3.0 ARS 6.3 Patch 21 AR Server on Windows 2000 Midtier on Windows 2003 with IIS and ServletExec John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Doug Blair Sent: Thursday, June 19, 2008 12:07 PM To: arslist@ARSLIST.ORG Subject: Re: Firefox3 Gary, I've just tried Firefox 3 as well, and can report that screens seem to display faster than with my IE7 or Firefox 2.x. I think they have monkeyed with delaying rendering the screen until all the data has arrived, because I can see some navigation fields redrawing on an in-house app. Drawing the screen on the fly rather than buffering does make it look faster even though the full data might not arrive until the end of the render. Subjective observation of course, YMMV Firefox 3.0.0 Windows XP SP 2 Midtier 7.01 patch 004 on Solaris AR 7.01 on Solaris Doug . Original Message ... On Thu, 19 Jun 2008 08:56:45 -0500 Gary Opela (Corporate) [EMAIL PROTECTED] wrote: ** I was just trying firefox 3 out with my mid-tier, it's pretty cool. It's really fast, and they've added in spell check that works just like word. You all should try it out if you haven't yet. Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company _ Doug Blair Remedy Skilled Professional doug at blairing dotcom +1 224-558-5462 Sent from my Treo, usual caveats apply ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Firefox3
Hey Junior, you should try Lynx and see if it works with the mid-tier. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent: Thursday, June 19, 2008 15:38 To: arslist@ARSLIST.ORG Subject: Re: Firefox3 Gary, I refreshed the browser, logged out, back in and viewed the same results. Then I went into the form, moved a few fields around. Then I manually flushed the cache. Now everything looks as it should. The Flashboards stay where they belong and the Application List works. We'll see how long it lasts. John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Thursday, June 19, 2008 3:48 PM To: arslist@ARSLIST.ORG Subject: Re: Firefox3 Strange, my application list shows just fine. I don't have any flashboards to test. All of my page fields work fine as well. ARS 7.1, MT 7.1, Firefox 3 Windows XP SP 2 Windows Server 2k3/Apache Tomcat (no IIS) using JSSE for https MS SQL Server 2k5 Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent: Thursday, June 19, 2008 2:31 PM To: arslist@ARSLIST.ORG Subject: Re: Firefox3 I just tried to view my home page with Firefox 3.0. All looks fine until I tried to view the page field with an Application List. I don't see the list but I do see a random Flashboard field from another page field. It also has trouble rendering the Flashboards once your view them. Though I don't know if it's a Flashboards problem or a Page Field problem. Firefox 3.0 ARS 6.3 Patch 21 AR Server on Windows 2000 Midtier on Windows 2003 with IIS and ServletExec John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Doug Blair Sent: Thursday, June 19, 2008 12:07 PM To: arslist@ARSLIST.ORG Subject: Re: Firefox3 Gary, I've just tried Firefox 3 as well, and can report that screens seem to display faster than with my IE7 or Firefox 2.x. I think they have monkeyed with delaying rendering the screen until all the data has arrived, because I can see some navigation fields redrawing on an in-house app. Drawing the screen on the fly rather than buffering does make it look faster even though the full data might not arrive until the end of the render. Subjective observation of course, YMMV Firefox 3.0.0 Windows XP SP 2 Midtier 7.01 patch 004 on Solaris AR 7.01 on Solaris Doug . Original Message ... On Thu, 19 Jun 2008 08:56:45 -0500 Gary Opela (Corporate) [EMAIL PROTECTED] wrote: ** I was just trying firefox 3 out with my mid-tier, it's pretty cool. It's really fast, and they've added in spell check that works just like word. You all should try it out if you haven't yet. Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company _ Doug Blair Remedy Skilled Professional doug at blairing dotcom +1 224-558-5462 Sent from my Treo, usual caveats apply ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are - ** This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed.
Unwanted updates on Last Modified Field Incident Mangement form ITSM 7.01
Hi listers. I've got an issue that is skewing the data on the Date/System tab of the Incident Management form. Whenever a work info item is displayed - but not modified - the 'Last Modified By' and 'Last Modified Date' fields are updated. No change to the work info item is necessary effect the change, it just happens from viewing the work note. Has anyone else run across this? We are running: ARS 7.0.01 patch 3 Inc Management patch 3 Windows Server 2003 MS SQL 2005 Thanks John Quinn Pegasus Solutions ITSM Development _ The i’m Talkathon starts 6/24/08. For now, give amongst yourselves. http://www.imtalkathon.com?source=TXT_EML_WLH_LearnMore_GiveAmongst ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Please connect with me :)
Hi, I looked for you on Reunion.com, but you weren't there. Please connect with me so we can keep in touch. -Katherine Do You Know Katherine? YES - Connect with Katherine, and see who's searching for you http://www.reunion.com/showInviteRegistration.do?uid=266015989 NO - I don't know Katherine http://www.reunion.com/showInviteRegistration.do?unsub=trueuid=266015989[EMAIL PROTECTED] Reunion.com - Find Everyone from Your Past. You have received this e-mail because a Reunion.com Member sent an invitation to this e-mail address. For assistance, please refer to our FAQ or Contact Us. http://help.reunion.com/selfhelp?lid=2 Our Address: 2118 Wilshire Blvd., Box 1008, Santa Monica, CA 90403-5784 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Issue with AIE and Oracle
Have you entered your oracle configurations correctly in the helper utility that is bundled with AIE? Oracle home, SID, username, password?? Joe - Original Message From: Howard Richter [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, June 19, 2008 9:49:51 AM Subject: Issue with AIE and Oracle ** Good morning all, I have the newest release of AIE and I am trying to get it to talk to a remote oracle database. The Server is 7.1 patch 3 and using MSSQL. I have installed the 10g client and can talk to the remote Oracle system using sqlplus from the box where the arserver is running. There is nothing in any log that I can find, that shows any attempt of the AIE trying to connect to the Oracle database. I did try setting up the AIE to talk to a MSSQL database and that worked. I am starting to wonder if, you can only talk to a database that the server talks to (for example in my case only MSSQL, since that is what the server is talking to). Any ideas, as of yet BMC support has had non. Howard -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Unwanted updates on Last Modified Field Incident Mangement form ITSM 7.01
Yes, but it may be fixed in a later patch. I'm currently on 6.3
system so I can't check, but I remember some users pointed that out to
me when we were on that version/patch. I recommend searching BMC's
website for a related bug or better still through the release notes for
the latest patch to see if its listed as a fix.
Ben Cantatore
Remedy Manager
(914) 457-6209
Emerging Health IT
3 Odell Plaza
Yonkers, New York 10701
[EMAIL PROTECTED] 06/19/08 4:40 PM
** .hmmessage P{margin:0px;padding:0px}body.hmmessage{FONT-SIZE:
10pt;FONT-FAMILY:Tahoma}Hi listers. I've got an issue that is skewing
the data on the Date/System tab of the Incident Management form.
Whenever a work info item is displayed - but not modified - the 'Last
Modified By' and 'Last Modified Date' fields are updated. No change to
the work info item is necessary effect the change, it just happens from
viewing the work note. Has anyone else run across this?
We are running:
ARS 7.0.01 patch 3
Inc Management patch 3
Windows Server 2003
MS SQL 2005
Thanks
John Quinn
Pegasus Solutions
ITSM Development
The i'm Talkathon starts 6/24/08. For now, give amongst yourselves.
Learn More __Platinum Sponsor: www.rmsportal.com ARSlist: Where the
Answers Are html___
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Job: Largo MD
Burleson and Evans, LLC is looking for a Senior Remedy Developer for long term work in Largo, MD. The candidate should have the following credentials: - Ability to pass a Federal background investigation with drug screen. - Ten years of IT or Software Development experience. - Familiarity with ITILv3, preferably Foundations certification (version 2 is sufficient). - Five years of Remedy Development experience. - Ability and willingness to do Remedy application administration. - Hands on Remedy ITSM v7.x experience in either a lab or production environment. The position is a long term 1099 or corp-corp position, possibly lasting until the end of 2010. The client uses Alternative Work Schedule, every other Friday off. If interested send your resume and expected hourly rate to [EMAIL PROTECTED] -- Bob Lind BMC/Remedy Development Burleson and Evans, LLC www.burlesonandevans.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Where is the background appearance information stored?
Hi Tim, To start with either. or at least background image. Best Regards, Uday Joshi From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tim Widowfield Sent: Thursday, June 19, 2008 10:37 PM To: arslist@ARSLIST.ORG Subject: Re: Where is the background appearance information stored? ** Are you asking about background color or background image? Or both? --Tim - Original Message From: Uday Joshi [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, June 19, 2008 11:42:45 AM Subject: [ARSLIST] Where is the background appearance information stored? ** Hi Listers I believe that everything in Remedy is stored some where in the table. So I am trying to locate where is the background information on the Appearance tab of the View properties stored? I tried searching in table vui but no luck I tried searching field_dispprop with a guess that the total appearance may be stored as a field. Interestingly I found fieldID = 0 but properties did not reveal anything meaningful (rather interpretable)? Does anybody know about this? Best Regards, Uday Joshi Delivery Manager - BSM Support Technology Infrastructure Services - BSM Unit -- Wipro Technologies, Hinjewadi, Pune 411057 Tel: +91 20 39104092 VOIP 842-5103 Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
