check field for null

2008-06-16 Thread Elinore AR
hi all, i am working on a customization in change management form. i added a new tab on CHG and added fields on the tab. what i want to do is display the tab only when any of the fields inside of the tab has value. is there a way to test the database field value if empty or not and execute an On

Re: check field for null

2008-06-16 Thread Roger Justice
Do the Active Link on Window loaded. -Original Message- From: Elinore AR [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Mon, 16 Jun 2008 4:53 am Subject: check field for null hi all, i am working on a customization in change management form. i added a new tab on CHG and added fields

Re: check field for null

2008-06-16 Thread Misi Mladoniczky
Hi, If you trigger your ACTL on Display, you will, in effect, be checking the DB-values. There are a theoretical chanse that you have modified the values with a FLTR triggering on Display, or that another ACTL fiering before the Show/Hide ACTL has modified the data. All of this can be

Capture NT login on Mid Tier

2008-06-16 Thread Tanner, Doug
DEVELOPMENT - I am running Mid-Tier 7.1 Patch 2 (ARS 7.1 Patch 2) Running a little application (Charity Auction) that allows guest users. 1. What I want to do is capture the NT Login (User) from the workstation that is using the Mid-Tier Auction - (For back end validation and

Re: Get all results from a SQL call

2008-06-16 Thread Dwayne Martin
Here’s my algorithm. There may be better ones. You have an Active Link Guide: FormName:Find Records with these ALs and Label: FormName:Find:INNER 10 Initial get first record Select a from c order by a result = $1$ FormName:Find:INNER 20 add first record, error if empty If result !=

Re: Question: Permission Issues with Infrastructure Change Management 7.x

2008-06-16 Thread Bilinski, John
Lisa, You may be right, we are currently testing Remedy 7 in a lab/development environment and are using 30-day trial licenses until we get within a month of deployment so that we can upgrade and apply our 6x licenses to the 7x environment. I just renewed the AR Server 30-day trial license which

Re: Get all results from a SQL call

2008-06-16 Thread Axton
You do realize, with this approach, that you are pulling a record set for every record, right? If you have 1000 records, you will perform 1000 queries against the db table. A filter table walk would be much more efficient. Alternatively, you could write a stored procedure that returned the

Re: Capture NT login on Mid Tier

2008-06-16 Thread Axton
What web server are you using? Axton On Mon, Jun 16, 2008 at 7:38 AM, Tanner, Doug [EMAIL PROTECTED] wrote: ** DEVELOPMENT - I am running Mid-Tier 7.1 Patch 2 (ARS 7.1 Patch 2) Running a little application (Charity Auction) that allows guest users. 1. What I want to do

Re: Capture NT login on Mid Tier (U)

2008-06-16 Thread Hennigan, Sandra H CTR OSD-CIO
UNCLASSIFIED We are using ARS 6.3 patch 21 Windows 2003 server SQL 2000 Help Desk 5.5 Mid-Tier Windows IIS I have the same type of requirement. Sandra Hennigan OSD Enterprise Remedy Administrator Office # 703-602-2525 x248 Apparently, there is nothing that cannot happen today. Mark Twain

Re: Capture NT login on Mid Tier

2008-06-16 Thread Tanner, Doug
IIS Mid-Tier is running on Server 2003 Thanks, Doug -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Monday, June 16, 2008 9:23 AM To: arslist@ARSLIST.ORG Subject: Re: Capture NT login on Mid Tier What web server

Re: Capture NT login on Mid Tier (U)

2008-06-16 Thread Axton
Since the NT login name is a MS thing, I would look at using MS languages to achieve the result. vbscript and asp/.net come to mind. Since you are running an MS web server, this makes it all the easier, since you can actually use vbscript/asp/.net. Look into using WshNetwork.UserName in a

Re: Get all results from a SQL call

2008-06-16 Thread Grooms, Frederick W
Since you are on Oracle here is my SQL Function to do just what you are trying to do. CREATE OR REPLACE FUNCTION GET_SQL_RESULT (strSQL VARCHAR2, strSeparator CHAR := (Chr(13)) ) RETURN CLOB IS ResultList CLOB; TYPE RefCurTyp IS REF CURSOR; cv RefCurTyp; strTemp VARCHAR2(3999); BEGIN

Re: Capture NT login on Mid Tier (U)

2008-06-16 Thread Tanner, Doug
Right on and thanks so much Doug Tanner -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Monday, June 16, 2008 10:15 AM To: arslist@ARSLIST.ORG Subject: Re: Capture NT login on Mid Tier (U) Since the NT login name

Re: Question: $LASTID$

2008-06-16 Thread T. Dee
THANKS Ty On 6/14/08, Arthur Johnson [EMAIL PROTECTED] wrote: ** If you're at 6.3 or later, try this: Create a character field with ID - 179(named say UniqueGUID) on the Calling form At the Push Field that creates the record in the Called form, push this GUID field value as well, to a

Re: Walking table, reading and setting hi-liting rows

2008-06-16 Thread Grooms, Frederick W
In 6.3 I tried to do just what Dwayne is wanting and found you could not set the highlite on multiple rows thru workflow. I had to settle with making a Selected column and displaying that when re-displaying the list to the user. Fred From: Action Request

FW: Edit Menu List....

2008-06-16 Thread Louis Cobuccio
Good Morning List, I'll apologize up front for what is a very dumb question.I am trying to edit an existing/out of the box Menu. Here is what I've done so far I captured an active link log which allowed me to track both the menu and its corresponding form and field.When I select

Re: OT: BBQ tour

2008-06-16 Thread Joseph Kasell
Rick, I'm a native of Goldsboro, NC (not too far from Wilson) and can recommend Parker's as well. Like David says, pork IS the only real BBQ. You could also travel the 20 or so miles to Goldsboro and try Wilbur's BBQ on Highway 70 near Seymour Johnson AFB. Keep a look out for low-flying planes

Re: Get all results from a SQL call

2008-06-16 Thread Dwayne Martin
You are right! Your way is more effecient. Dwayne Original message Date: Mon, 16 Jun 2008 09:22:19 -0400 From: Axton [EMAIL PROTECTED] Subject: Re: Get all results from a SQL call To: arslist@ARSLIST.ORG You do realize, with this approach, that you are pulling a record set for

SLM-Modify Data Source

2008-06-16 Thread Viswanathan Balakumar
HI ARSList, This is an issue related to SLM - Modify Data Source. When I try to use the Modify Fields in an existing Data Source, the Fields and Join Forms Create Status remains as Create In Progress and not changing to Created Successfully. When I checked the SLMSetup.log it shows the

AIE and Importing Date Fields Question .....

2008-06-16 Thread Garrison, Sean (Norcross)
I am using AIE 7.1 to connect to an Oracle Remedy Database. Which means that dates are stored as integers and not as actual Date fields. How would I use AIE to import an Oracle date field (Remember it was created by remedy as an integer field and not a date field) into a Remedy date field?

test message

2008-06-16 Thread Amit
Test message please ignore ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are

Web serice issue

2008-06-16 Thread Amit
Hello All, Following are my system details: ARS server version 6.03.00 patch 24 hardware -- sun4u operating system --- Sun OS 5.8 oracle -- 10.1.0.4 I have created web service on the form in my system and trying to consume it through the filter. I am performing opget

web service issue

2008-06-16 Thread Amit
Hello All, Following are my system details: ARS server version 6.03.00 patch 24 hardware -- sun4u operating system --- Sun OS 5.8 oracle -- 10.1.0.4 I have created web service on the form in my system and trying to consume it through the filter. I am performing opget

Re: Web serice issue

2008-06-16 Thread Grooms, Frederick W
What web server and MidTier are you using? In the Admin tool, if you open up your Web Service, Do you get any errors when viewing your WSDL? Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Amit Sent: Monday,

Crystal Report Question

2008-06-16 Thread John Atherly
I'm trying to use Cross-Tab to display Incidents that are closed in the first hour after the Helpdesk person takes it. I have my formula that pulls the tickets to be counted. [EMAIL PROTECTED] three months} AND {HPD_HelpDesk.Assigned_To_Group_}= 'Service_Desk_NAM' AND {HPD_HelpDesk.Status} =

Re: AIE and Importing Date Fields Question .....

2008-06-16 Thread Michelle L
Hi, Sean: Someone feel free to correct me if I am wrong. You should be able to import an integer into a Remedy Date field since (as you acknowledged) it is stored as an integer. It will automatically be displayed as a Date when viewed through the GUI. At least I've done that in the past.

Resolved: AIE and Importing Date Fields Question .....

2008-06-16 Thread Garrison, Sean (Norcross)
I was able to figure it out. It isn't the best solution but it works ... I used the SQL option and did the following: SQL|SELECT TO_CHAR(TO_DATE('01/01/1970 00:00:00', 'MM/DD/ HH24:MI:SS') + ((INSERT DATE FIELD HERE -5)/(60*60*24)),'MM/DD/ HH24:MI:SS') FROM INSERT FORM VIEW NAME HERE

Remedy Development Opportunity in Charleston SC

2008-06-16 Thread Dearstyne, Jacob
Hi Everyone, Thank you in advance for reading this post. For those whom I have contacted already, (and those who responded, Thank You) I apologize for being redundant, I was having some complications with the online interface. TEKsystems is looking for two (2) Remedy Developers that would

Product Categorizations

2008-06-16 Thread Kathy Morris
Hi, We are trying to build a list of Product Categorizations and we are getting new Remedy resources so our team does not have the DSL install as high priority right now.? Is there somewhere I can get a list of recommended Product Categorizations??I went thru the Technical Guides and I found

Re: Product Categorizations

2008-06-16 Thread Roger Justice
The last time I installed it was a couple of hours including the transfer from the staging form to the DSL forms. -Original Message- From: Kathy Morris [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Mon, 16 Jun 2008 4:47 pm Subject: Product Categorizations ** Hi, We are trying to

Re: Product Categorizations

2008-06-16 Thread Rick Cook
The DSL IS what BMC intended for us to use as Product Categorizations in ITSM 7. Since you will spend far more time coming up with a non-DSL set than you will installing DSL, I might suggest that the best use of resources would be to go that route. Rick On Mon, Jun 16, 2008 at 2:09 PM, Roger

Re: Product Categorizations

2008-06-16 Thread P Romain ARSlist
The DSL only applies to software. The Foundation/Topology Discovery documentation includes a BMC best practice categorisation you might like to use as a starting point for hardware CIs. Cheers Peter _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL

Re: Product Categorizations

2008-06-16 Thread Rick Cook
Quite right. And another way (the BMC $intended$ way) to get the hardware-based product categorizations is from the CMDB, which would populate via Discovery. I know that not everyone intends to use either or both of those, I'm just saying that if you don't find a plethora of lists out there,

Re: Web serice issue

2008-06-16 Thread AR_User
Hi Amit, First try to check your mid-tier log. It'll give you some hints. Also please check your web-server. And also mention what version of mid-tier you are using. Regards, AR_User Grooms, Frederick W wrote: What web server and MidTier are you using? In the Admin tool, if you open

Re: Resolved: AIE and Importing Date Fields Question .....

2008-06-16 Thread Joe DeSouza
What might have worked is if you mapped it to an integer field and then used that integer field to set to the date field. I haven't tried that so don't be surprised if you get a data type mismatch if you try to set the integer field to the the date field.. but worth a try.. Joe -