Sign in to follow this  
Followers 0
rosaz

BMC Remedy Query

3 posts in this topic

Hello,

Yet another BMC Remedy question... I'm a bit of a slow learner :) I'm trying to open a request management search form and query it for a given request ID, but when I try to query, it just sits there! I don't want to use LoadForm and just use the request ID, because I'll also need to be able to search by other fields as well. I can't tell what's wrong with my query syntax... would be most grateful for any suggestions!

$oMyError = ObjEvent("AutoIt.Error", "MyErrFunc") ; Initialize a COM error handler

$oRemedy = ObjGet("", "Remedy.User.1")

$oRemedyForm = $oRemedy.OpenForm($iSession, "pscars01.ps.net", "Request Management", 2, True)

$oID = $oRemedyForm.GetField("Request ID")

$queryresult = $oRemedyForm.Query("'Request ID' = 1111111")

Share this post


Link to post
Share on other sites



$queryresult = $oRemedyForm.Query("'Request ID' = 1111111")

This should be

$queryresult = $oRemedyForm.Query("'Request ID' = ""1111111""")

Share this post


Link to post
Share on other sites

Pretty sure that the OP doesn't need this information after 5 years of waiting, not to mention s/he hasn't been here in over 2 years.


If I posted any code, assume that code was written using the latest release version unless stated otherwise. Also, if it doesn't work on XP I can't help with that because I don't have access to XP, and I'm not going to.
Give a programmer the correct code and he can do his work for a day. Teach a programmer to debug and he can do his work for a lifetime - by Chirag Gude
How to ask questions the smart way!

I hereby grant any person the right to use any code I post, that I am the original author of, on the autoitscript.com forums, unless I've specifically stated otherwise in the code or the thread post. If you do use my code all I ask, as a courtesy, is to make note of where you got it from.

Back up and restore Windows user files _Array.au3 - Modified array functions that include support for 2D arrays.  -  ColorChooser - An add-on for SciTE that pops up a color dialog so you can select and paste a color code into a script.  -  Customizable Splashscreen GUI w/Progress Bar - Create a custom "splash screen" GUI with a progress bar and custom label.  -  _FileGetProperty - Retrieve the properties of a file  -  SciTE Toolbar - A toolbar demo for use with the SciTE editor  -  GUIRegisterMsg demo - Demo script to show how to use the Windows messages to interact with controls and your GUI.  -   Latin Square password generator

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0