Re: Filter Service Calls data base commits...

Hi, I have used error handling filters extensively in the following way: 1. create two display-only-fields: - errorhandler errno - errorhandler text 2. create two error handler filters - errorhandler Message error run if: ('errorhandler errno' = $ERRNO$) action: message error: $errorhandler

Re: Filter Service Calls data base commits...

Hi, I have used error handling filters extensively in the following way: 1. create two display-only-fields: - errorhandler errno - errorhandler text 2. create two error handler filters - errorhandler Message error run if: ('errorhandler errno' = $ERRNO$) action: message error: $errorhandler

Re: Filter Service Calls data base commits...

I have the same trouble with the error handler feature. I was so excited when it was introduced but then realized it wasn't exactly what I wanted it to be once I used it. It seems you still need many filter qualifications to account for all of the different situations that will cause an error in

Re: View Forms

It should let you add the new field to the existing view, unless like Fred pointed out. if that field is a data type that is not supported by the AR engine.. I have added fields in the past on the fly and have been able to have my view for read the new field.. If the field is a supported data

Re: Active link to check field size

Unfortunately that’s how it is designed.. Those functions are not available at the Run If level. Functions whose result is not a void but a value are used in set field / push field kind of operations.. Only KEYWORDS can be used in Run If qualifications directly to be evaluated in an expression.

Re: Active link to check field size

Bummer. I was hoping it didn’t have to be a 2 step process. Thanks Anne Ramey *** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. F

Re: Active link to check field size

Anne, You are close but not quite that close...You can’t use it that way in a qualification.. Those functions are set field functions that can be used only in set or push fields actions.. So create a temp integer field to hold the value of LENGTH(‘Field’) and then use that temp field in the q

Active link to check field size

I must be being dense, but I'm trying to write an active link that only fires if a field is more than a certain length. Can't figure out how to do that. Know how to trim it and set the length, but not check it in the qualification. I tried this LENGTH('Field') > 500 But it didn't like that.

Re: Question about NULL

Swapping the Assigned person test around will also improve the query - the order of the query tests does matter not matter what DB is being used 'Status' < "Closed" AND ('Assigned Person' = $NULL$ OR NOT ('Assigned Person' == "Mark Brittain")) >How about: > >'Status' < "Closed" AND NOT ('Assign

Re: Question about NULL

DOH!!didn't catch the !=...yea...that certainly won't use an index. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Monday, March 14, 2011 12:56 PM To: arslist@ARSLIST.ORG Subject: Re: Question

Re: Filter Service Calls data base commits...

Hi Robert, Maybe, but the documentation does not say anything about this. This would both limit and extend the use of servive-calls I guess. In my case, when my service picks the next of several counters, it will create holes in my counter-series. I guess I have to redesign... Best Rega

Re: Filter Service Calls data base commits...

My understanding is that since you are calling a Service (just like consuming an external web-service logically) that is an independent transaction. So an ERROR Trap will need to be constructed, and then service X_rollback would need to be called in the error handling... Yes it adds much complicat

Question about NULL

How about: 'Status' < "Closed" AND NOT ('Assigned Person' == "Mark Brittain") ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Filter Service Calls data base commits...

Hi, I have created a Filter Service that I call from a filter. The problem is that data seems to be committed to the database even though there is an ERROR later on in the processing. A1. Modify Filter in form A: Call Service X X2. Service Filter: pushes data to form X A2. Modify Filter in fo

Re: View Forms

This is correct. I updated the View and then opened the view form to add the field. It's not greyed out so it lets me choose "Fields from " but then it doesn't do anything. I added a brand new view form and purposely left out the new field. Created it, then tried to add the new field and it

Re: Question about NULL

I don't think so MarkI believe the reason you are causing the table scan is because of the OR, not because of the $NULL$. You may try a compound index on Status and Assigned Personthis MAY help avoid a table scan, but you must include the $NULL$ to get those...let me know if a compound ind

Question about NULL

I suspect the key question that hasn't been asked is, what database are you using? Getting onto my soap box, Oracle (the last time I checked) is completely clueless to the meaning of null. ie "" == NULL as far as Oracle is concerned, which may have been correct in 1985, but isn't correct now we

Re: Question about NULL

Hi Doug, Great explanation and I appreciate the time taken to reply to the issue. On the display only form I have two table fields. The first looks for open records assigned to me and the second looks for open records not assigned to me. This is why I am using the != Mark clause. Thanks for t

Re: Discovery Tools

Depending on how you seek to integrate it can be easy or simple. For example, if you have an external API or web service that you need to integrate with, it will be a little more challenging than having AIE read values from tables in databases. For client PCs, we have LANDesk and pulling in th

Re: Question about NULL

Mark, First, about why your search is not working as you think it should have. NULL is a strange beast in databases. It is a value. A very special value that means there is no value. The only way to find things that have this special "no value value" is to explicitly look for it. No value d

Re: Question about NULL

The clause ('Assigned Person' != "Mark Brittain") will not use an index since it is a "not equal", so the only Index you could use is one on Status. I was told (a long time ago) it is better to use <= instead of < (supposedly <= helps the database use an index). Can you look and see when the l

Re: FYI undocumented feature / quirk - Request ID (field 1) of length 1 means length is 15 and no zero fill

Hi Doug, Your right about the release. I just never came across it before in any form that I wrote a script against and I generally use Submit when modifying data because I generally want workflow firing. My test was with a 7.0.1 ARS and a test form (hence the admin tool). And yes, that

Re: Question about NULL

$NULL$ 'Status' < "Closed" AND ('Assigned Person' != "Mark Brittain" OR 'Assigned Person' = $NULL$) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Elry Sent: Monday, March 14, 2011 2:40 PM To: arslist@ARSLIST.ORG Subject

Re: Urgent please help! how to refresh table using filters

Sounds right to me - unless she is trying to use a dynamic qualification. If so - I don't think this will work on a server side table walk. On Mar 14, 1:25 pm, Thad Esser wrote: > Mary, > > I think Jason hit the nail on the head.  Just remember: > Server Side Table Field + Filter Guide table lo

Re: Question about NULL

Just a quick question Mark... Did you mean $NULL$ OR NULL. On Mar 14, 2:05 pm, "Brittain, Mark" wrote: > HI All, > > I have a table that uses the following query which searches for any open > record that is not assigned to me. > > 'Status' < "Closed" AND ('Assigned Person' != "Mark Brittain" O

Re: View Forms

You updated the view and then opened the form to add the field? The list of fields able to be added is generated when the form is opened in the Admin tool. Another possibility is you are using a type of field that ARS does not work with. Fred -Original Message- From: Action Request Sy

Re: MidTier and Rich Text

Thanks David! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Easter, David Sent: Monday, March 14, 2011 11:23 AM To: arslist@ARSLIST.ORG Subject: Re: MidTier and Rich Text ** The web client did not support Rich Text formatted fields until AR S

Line Feed and Carriage Return in ARS

Hi there, I'm transfering data to our partner via a Web Service. There is WebMethods middleware on their side. While ARS has no problems processing any kind of line breaks coming from them, they can't process ours. What can I do to explicitly tell ARS to use a Line Feed and Carriage Return as a li

Re: FYI undocumented feature / quirk - Request ID (field 1) of length 1 means length is 15 and no zero fill

Hi Doug, Your right about the release. I just never came across it before in any form that I wrote a script against and I generally use Submit when modifying data because I generally want workflow firing. My test was with a 7.0.1 ARS and a test form (hence the admin tool). And yes, that

View Forms

I recently updated a view on the database with an extra field and I would like to add this field to my View Form. When I right click on my form I get the option to select a field from my view, but when I click on it nothing comes up. Are View Forms sort of locked out if you update your view? D

Re: FYI undocumented feature / quirk - Request ID (field 1) of length 1 means length is 15 and no zero fill

Hi, This has been there even since long before 7.0. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze y

Question about NULL

HI All, I have a table that uses the following query which searches for any open record that is not assigned to me. 'Status' < "Closed" AND ('Assigned Person' != "Mark Brittain" OR 'Assigned Person' = NULL) If I use the query without the Assigned Person' = NULL the result does not include any

Re: FYI undocumented feature / quirk - Request ID (field 1) of length 1 means length is 15 and no zero fill

Ben, This has been a feature of the system for quite a while now. 7.5 most definitely, 7.0 I think so, before that, I am not sure. I did a quick search in the on-line documentation and found a section of the document titled "Working with the Request ID field" This section clearly calls out t

FYI undocumented feature / quirk - Request ID (field 1) of length 1 means length is 15 and no zero fill

Hi Folks, Just discovered a case where a request id (field '1') had a database length of 1 - one of the Task Template schemas in ITSM 7.6. This is valid and means that the length is 15 and there is no leading zero fill. The old Admin tool had a nice error message when setting a field 1 to say

Re: Urgent please help! how to refresh table using filters

Mary, I think Jason hit the nail on the head. Just remember: Server Side Table Field + Filter Guide table looping = Phasing Issues (considerations at least). When using a table field on the server side (i.e. in a filter), it doesn't need to be refreshed, it will always have the current data (wit

Re: Issue with a report

I was able to run the qual on the form. I have also tried hard coding '3'>"1/1/11" (this being the only qual) on the active link (thinking that the adding of seconds might be an issue) and still get the error message. From: Action Request System discussion lis

Re: Discovery Tools

But let's talk integration into 7.6.4 Or 7.6.3. Of those tools. Done that? Sent from my iPhone On Mar 14, 2011, at 12:37 PM, "Hulmes, Timothy CTR MDA/DXCO" wrote: > HP also has a discovery tool set, HP Discovery and Dependency mapping, that > we currently integrate with Remedy. As some ot

Re: Discovery Tools

HP also has a discovery tool set, HP Discovery and Dependency mapping, that we currently integrate with Remedy. As some others have said the trivial part with this tool set is Normalization and Reconciliation. Tim -Original Message- From: Action Request System discussion list(ARSList)

Re: Issue with a report

Christie, Few things you may want to check, - Try an advanced search on the form with the qualification you are trying to use. If it is retrieving the result, probably there would not be a problem with your qualification - Try removing the addition of seconds to your date/time and ch

Re: Using DSO to sync two AR Servers

Hi Vikram, You could try DB triggers to replicate data in tables of other DBs. Regards, SriSamSri Appecherla Mobile# +91 991 610 6008 On Fri, Mar 11, 2011 at 3:42 PM, vikram_k wrote: > Hi listers, > > Greetings, > > I have a new challenge thrown at me.. now the performance of the system is > g

Re: MidTier and Rich Text

The web client did not support Rich Text formatted fields until AR System 7.6.0x. 17-Aug-2010 What's New: BMC Remedy Action Request System 7.6.03 PDF "Rich-text formatting in data fields You can add rich-text formatting (RTF)

Re: Issue with a report

I know that I have done this before in previous versions of ARS but this is the first time I have tried to create a report against the NTE:Notifier Log screen and I wonder if that is part of it. From: Action Request System discussion list(ARSList) [mailto:arsli

Re: Issue with a report

The full qual that I am trying is '3'>=$Start Date$ and '3'<=$End Date$+86399 and '101029'=$Sent From Person$ I want all the records created within a date range by a person. e.g., All records created from 1/1/11 -> 4/1/11 by cpargete From: Action Request

Re: Using DSO to sync two AR Servers

It truly depends upon the complete requirements. I've used DSO for data replication (foundation) as well as ticketing replication quite successfully in "near time" synch. As you might imagine, to circumvent a "DSO Overload" - I implemented a queuing mechanism because of what I term "ticket stabili

MidTier and Rich Text

In the client (we are using 7.5 p7) if you put a URL in a field it automatically makes it a clickable link, but in the MidTier is does not do this. Is there a reason why? Or is this just happening with us? Lisa Kemes AR System Developer +01 717 810 2408 tel +01 717 602 9460 mobile lisa.ke...@te

Urgent : Memory allocation to ARS process

Hello List, I find 2GB as standard memory allocation to ARS process, could you please suggest how to increase this memory allocation. Regards Manish ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend w

Senior SRM Consultant 6 Months North America

Dear All I need an experienced senior ITSM SRM consultant for a 6 month assignment in North America. You will be responsible for designing, implementing and customising the latest SRM module. You must be an American Citizen and be flexible in terms of working location. If you would lik

Re: Urgent please help! how to refresh table using filters

You can tirgger Active Link using Events from Filter and use Change Field Action in Active Link to refresh the table. Thanks, Bala > Date: Sun, 13 Mar 2011 22:49:01 + > From: mestr...@blizzard.com > Subject: Urgent please help! how to refresh table using filters > To: arslist@ARSLIST.ORG >