Dear List,
I again have an issue but this seems a bit meaningless to me.
I have a table on my form retrieving data from X form with every
fields of it added as columns.
I also created a Character Field and set the table's Qualification to
that char field as External().
When I refresh the table
Update on situation:
When the qualification string is empty log files reads
SELECT (..) FROM (...) WHERE (1 = 1) ORDER BY 6 ASC
and lists all the data, as i had mentioned previously.
On Sep 4, 3:13 pm, koray ko...@alkankoray.net wrote:
Dear List,
I again have an issue but this seems a
I have found that you get 1=0 when Remedy does not like the
qualification string. This could be because of incorrect syntax or bad
column names.
On Fri, Sep 4, 2009 at 3:31 PM, korayko...@alkankoray.net wrote:
Update on situation:
When the qualification string is empty log files reads
SELECT
Can you post what the char string is that you're using when it doesn't work?
You have to build it out to include formatting.
As for the 1=1 when you're leaving blank, it is probably building that to show
all, as it likely needs to put in something. I don't see that as anything to
worry
Hi i just need to know if someone have installed this patch is their any
bug ?
thanks
Le pr?sent message est destin? uniquement aux personnes indiqu?es dans
l'en-t?te. Il contient des informations confidentielles qui peuvent ?tre
divulgu?es ? des tiers sans que l'exp?diteur ait pr?alablement
Qualification I am using is something basic like 'Task ID' =
TSK01 just to test it.
Weird thing is that when I enter the qualification string manually on
Table Properties it works perfect, but not via the character field.
On Sep 4, 3:37 pm, Mark Lev mark@rightstarsystems.com wrote:
Can
You need to build the string literally.
String = 'Task ID' = + + TSK1 +
I may be slightly off on syntax of embedding a double quote, that may take a
little tweaking. What I do is make the char string visible and editable, so I
can see what is being populated, and can manually tweak it
Situation Update 2:
EXTERNAL() works on SOME other forms correctly with form 'Task ID' =
TSK1. I have double-checked every field's database name and
there should be no error.
Could there be any other, what i am going to call, weird reason?
Regards,
Koray.
On Sep 4, 4:36 pm, Mark Lev
I am using SQL via the ODBC Connector to pull data from Remedy. I am
attermpting to pull from a join form that joins SRM:Survey and HPD:Help
Desk, however I have had the same issues attempting to pull directly from
HPD:Help Desk as well. Here is a sample of the query I am attempting to run:
Seems like certain forms do not accept ANY External Qualifications.
Even setting 1=1 in Character Field for External Qualification gives
SELECT (..) FROM (...) WHERE (1 = 0) ORDER BY 6 ASC
in log file and returns nothing.
On Sep 4, 5:26 pm, koray ko...@alkankoray.net wrote:
Situation
Ken,
Here is a list of configuration changes;
1. Modified service account to admin privs
2. Added outlook domain\username and password to AREmail
engine services
3. Modified service account to local admin group
4. Added Entrust
Can anyone give me some quick insight on the potential impact to ITSM if the
Service Types on Incident are modified?
Out-of-box they are User Service Restoration, User Service Request,
Infrastructure Restoration, or Infrastructure Event. The possibility of
changing these are being floated
Start by reviewing the AutoAssignment form that lists each service type as a
check box.
-Original Message-
From: Foy, Nathan nathan@servicemaster.com
To: arslist@ARSLIST.ORG
Sent: Fri, Sep 4, 2009 4:39 pm
Subject: Modifying Service Types
**
Can anyone give me some quick insight
Koray
--- On Fri, 9/4/09, koray ko...@alkankoray.net wrote:
From: koray ko...@alkankoray.net
Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing
To: arslist@ARSLIST.ORG
Date: Friday, September 4, 2009, 1:50 PM
Qualification I am using is something basic like 'Task ID' =
TSK01
Koray
if you are entering the qualification as 'Task ID' = TSK01 in an external
qual it will not work, you need to put the double quotes within two double
quotes so the 'TSK01' needs to be something like TSK01 .
I have put spaces to show you the double quotes, you need to remove
15 matches
Mail list logo