Qualification EXTERNAL() Issue - Returns Nothing

2009-09-04 Thread koray
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

Re: Qualification EXTERNAL() Issue - Returns Nothing

2009-09-04 Thread koray
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

Re: Qualification EXTERNAL() Issue - Returns Nothing

2009-09-04 Thread Frank Caruso
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

Re: Qualification EXTERNAL() Issue - Returns Nothing

2009-09-04 Thread Mark Lev
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

SLM 7.1 patch 2

2009-09-04 Thread Patrick St-Pierre
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

Re: Qualification EXTERNAL() Issue - Returns Nothing

2009-09-04 Thread koray
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

Re: Qualification EXTERNAL() Issue - Returns Nothing

2009-09-04 Thread Mark Lev
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

Re: Qualification EXTERNAL() Issue - Returns Nothing

2009-09-04 Thread koray
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

SQL Date Comparison Using ODBC Connector

2009-09-04 Thread JanetB
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:

Re: Qualification EXTERNAL() Issue - Returns Nothing

2009-09-04 Thread koray
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

Re: AREmial using MAPI protocol

2009-09-04 Thread Jordan, Franklin
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

Modifying Service Types

2009-09-04 Thread Foy, Nathan
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

Re: Modifying Service Types

2009-09-04 Thread Roger Justice
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

Re: Qualification EXTERNAL() Issue - Returns Nothing

2009-09-04 Thread Shafqat Ayaz
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

Re: Qualification EXTERNAL() Issue - Returns Nothing

2009-09-04 Thread Shafqat Ayaz
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