Re: Qualification EXTERNAL() Issue - Returns Nothing
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 the spaces. make your char field visible and then have a look at what the qualification looks like and you will what is wrong. you can enter the qual as you have shown in the EXTERNAL qualification field and just right click on the table and refresh it, it will show the correct data, but if you do a Set Fields then you have to triple the double quotes. Let me know if this fixes your problem or you need further help. thanks shafqat ayaz --- On Fri, 9/4/09, koray wrote: From: koray 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" 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 wrote: > 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 about. > > Thanks, > Mark > > > > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of koray > Sent: Friday, September 04, 2009 8:31 AM > To: arsl...@arslist.org > Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing > > 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 wrote: > > 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 without any qualification - in other words > > when the char field is empty - table lists all the data. > > > But, when I enter a valid qualification string in the char field, I > > get nothing. Log file shows like > > > SELECT (..) FROM (...) WHERE (1 = 0) ORDER BY 6 ASC > > > 1) where does 1=0 come from? Isn't it meaningless? > > 2) Although I have not set any Order option from Table Properties > > ORDER BY 6 ASC occurs. > > > Any ideas? > > > Regards, > > > Koray. > > > ___ > > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > ___ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > ___ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Qualification EXTERNAL() Issue - Returns Nothing
Koray --- On Fri, 9/4/09, koray wrote: From: koray 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" 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 wrote: > 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 about. > > Thanks, > Mark > > > > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of koray > Sent: Friday, September 04, 2009 8:31 AM > To: arsl...@arslist.org > Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing > > 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 wrote: > > 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 without any qualification - in other words > > when the char field is empty - table lists all the data. > > > But, when I enter a valid qualification string in the char field, I > > get nothing. Log file shows like > > > SELECT (..) FROM (...) WHERE (1 = 0) ORDER BY 6 ASC > > > 1) where does 1=0 come from? Isn't it meaningless? > > 2) Although I have not set any Order option from Table Properties > > ORDER BY 6 ASC occurs. > > > Any ideas? > > > Regards, > > > Koray. > > > ___ > > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > ___ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > ___ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Modifying Service Types
Start by reviewing the AutoAssignment form that lists each service type as a check box. -Original Message- From: Foy, Nathan To: arslist@ARSLIST.ORG Sent: Fri, Sep 4, 2009 4:39 pm Subject: Modifying Service Types ** 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 around now as an attempt to make the service types "make more sense" to the end user. They've also requested that we tie these Service Types into the available Operational Categorization choices. By selecting a particular Service Type the menu for Operational Categorization Tier 1 would change accordingly. ? I am trying to put together an impact analysis and hopefully persuade them from modifying this data.? Any thoughts and/or insight? ? Thanks, ? Nathan Foy Remedy & Systems Support IBM Global Technology Services E-Mail: n...@us.ibm.com CONFIDENTIALITY NOTICE: The information contained in this e-mail, including any attachment(s), is confidential information that may be privileged and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, or if you received this message in error, then any direct or indirect disclosure, distribution or copying of this message is strictly prohibited. If you have received this message in error, please notify the ServiceMaster Help Desk immediately by calling (866) 597-4321 and by sending a return e-mail; delete this message; and destroy all copies, including attachments. Thank you. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Modifying Service Types
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 around now as an attempt to make the service types "make more sense" to the end user. They've also requested that we tie these Service Types into the available Operational Categorization choices. By selecting a particular Service Type the menu for Operational Categorization Tier 1 would change accordingly. I am trying to put together an impact analysis and hopefully persuade them from modifying this data. Any thoughts and/or insight? Thanks, Nathan Foy Remedy & Systems Support IBM Global Technology Services E-Mail: n...@us.ibm.com CONFIDENTIALITY NOTICE: The information contained in this e-mail, including any attachment(s), is confidential information that may be privileged and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, or if you received this message in error, then any direct or indirect disclosure, distribution or copying of this message is strictly prohibited. If you have received this message in error, please notify the ServiceMaster Help Desk immediately by calling (866) 597-4321 and by sending a return e-mail; delete this message; and destroy all copies, including attachments. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: AREmial using MAPI protocol
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 Cer w/ JAVA keytool to local service account 5. Reinstalled AREmail Email engine -Original Message- From: klapie...@sc.rr.com [mailto:klapie...@sc.rr.com] Sent: Friday, August 28, 2009 9:37 AM To: Jordan, Franklin Subject: Re: AREmial using MAPI protocol Hello Franklin, We got the same exact error yesterday configuring MAPI on Windows 2008 server. We have a BMC ticket open for it. If you hear anything on the issue let us know and vice versus. Thanks, Ken LaPierre SR. BMC Remedy Consultant DOJ/JMD "Jordan wrote: > I am have made successful connection to AR Server, but receiving the > following error msg in the STDERR file. I am using MAPI over HTTPS. > > Aug 28, 2009 8:55:15 AM com.bmc.mail.mapi.MAPINative getStore > SEVERE: MAPILogonEx Failed - Unable to login to MAPI > javax.mail.MessagingException: MAPILogonEx Failed - Unable to login to MAPI > at com.bmc.mail.mapi.MAPINative.getStore(Native Method) > at com.bmc.mail.mapi.MAPIStore.connect(MAPIStore.java:145) > at com.bmc.mail.mapi.MAPIStore.connect(MAPIStore.java:165) > at > com.bmc.arsys.emaildaemon.ReceiverModule.initializeIncommingMailbox(ReceiverModule.java:1875) > at > com.bmc.arsys.emaildaemon.ReceiverModule.initialization(ReceiverModule.java:522) > at com.bmc.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:284) > at java.lang.Thread.run(Unknown Source) Aug 28, 2009 8:55:15 AM > com.bmc.mail.mapi.MAPINative getStore > SEVERE: MAPILogonEx Failed - Unable to login to MAPI > javax.mail.MessagingException: MAPILogonEx Failed - Unable to login to MAPI > at com.bmc.mail.mapi.MAPINative.getStore(Native Method) > at com.bmc.mail.mapi.MAPIStore.connect(MAPIStore.java:145) > at com.bmc.mail.mapi.MAPIStore.connect(MAPIStore.java:165) > at > com.bmc.arsys.emaildaemon.ReceiverModule.initializeIncommingMailbox(ReceiverModule.java:1875) > at > com.bmc.arsys.emaildaemon.ReceiverModule.initialization(ReceiverModule.java:522) > at > com.bmc.arsys.emaildaemon.ReceiverModule.doWork(ReceiverModule.java:171) > at com.bmc.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:288) > at java.lang.Thread.run(Unknown Source) Aug 28, 2009 8:55:15 AM > com.bmc.mail.mapi.MAPINative getStore > SEVERE: MAPILogonEx Failed - Unable to login to MAPI > javax.mail.MessagingException: MAPILogonEx Failed - Unable to login to MAPI > at com.bmc.mail.mapi.MAPINative.getStore(Native Method) > at com.bmc.mail.mapi.MAPIStore.connect(MAPIStore.java:145) > at com.bmc.mail.mapi.MAPIStore.connect(MAPIStore.java:165) > at > com.bmc.arsys.emaildaemon.ReceiverModule.initializeIncommingMailbox(ReceiverModule.java:1875) > at > com.bmc.arsys.emaildaemon.ReceiverModule.doWork(ReceiverModule.java:216) > at com.bmc.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:288) > at java.lang.Thread.run(Unknown Source) Aug 28, 2009 8:59:15 AM > com.bmc.mail.mapi.MAPINative getStore > SEVERE: MAPILogonEx Failed - Unable to login to MAPI > javax.mail.MessagingException: MAPILogonEx Failed - Unable to login to MAPI > at com.bmc.mail.mapi.MAPINative.getStore(Native Method) > at com.bmc.mail.mapi.MAPIStore.connect(MAPIStore.java:145) > at com.bmc.mail.mapi.MAPIStore.connect(MAPIStore.java:165) > at > com.bmc.arsys.emaildaemon.ReceiverModule.initializeIncommingMailbox(ReceiverModule.java:1875) > at > com.bmc.arsys.emaildaemon.ReceiverModule.initialization(ReceiverModule.java:522) > at > com.bmc.arsys.emaildaemon.ReceiverModule.doWork(ReceiverModule.java:171) > at com.bmc.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:288) > at java.lang.Thread.run(Unknown Source) Aug 28, 2009 8:59:15 AM > com.bmc.mail.mapi.MAPINative getStore > SEVERE: MAPILogonEx Failed - Unable to login to MAPI > javax.mail.MessagingException: MAPILogonEx Failed - Unable to login to MAPI > at com.bmc.mail.mapi.MAPINative.getStore(Native Method) > at com.bmc.mail.mapi.MAPIStore.connect(MAPIStore.java:145) > at com.bmc.mail.mapi.MAPIStore.connect(MAPIStore.java:165) > at > com.bmc.arsys.emaildaemon.ReceiverModule.initializeIncommingMailbox(ReceiverModule.java:1875) > at > com.bmc.arsys.emaildaemon.ReceiverModule.doWork(ReceiverModule.java:216) > at com.bmc.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:288) > at java.lang.Thread.run(Unknown Source) Aug 28, 2009 9:03:15 AM > com.bmc.mail.mapi.MAPINative getStore > SEVERE: MAPILogonEx Failed - Unable to login to MAPI > javax.mail.MessagingException: MAPILogonEx Failed - Unable to login to MAPI > at com.bmc.mail.mapi.MAPINative.
SQL Date Comparison Using ODBC Connector
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:
SELECT Assigned_Group, Assignee, Categorization_Tier_1,
Categorization_Tier_2, Categorization_Tier_3, Comment_1, Comment_2,
Comment_3, Comment_4,
Company, Create_date2, Department, Description,
Detailed_Decription, First_Name, Group_Transfers, Incident_Number,
Individual_Transfers,
Last_Name, Modified_date, Original_Incident_Number,
Priority, Product_Categorization_Tier_1, Product_Categorization_Tier_2,
Product_Categorization_Tier_3, Question_1_Rating,
Question_2_Rating, Question_3_Rating, Question_4_Rating, Re_Opened_Date,
Request_ID,
Resolution, Service_Type, Site, Status_, Submit_Date,
Submitted_By2, Survey_ID, Total_Transfers
FROM SAGE_RQC_SurveyReporting
WHERE (Create_date2 >= getdate())
This produces an error "expected lexical element not found". If I replace
getdate() with an actual date i.e. '9/1/2009', it changes this to { ts
'2009-09-01 00:00:00' }) and the query runs succesfully.
What I am trying to accomplish is an automated export of this data that can
be scheduled to run at certain intervals - so I need to be able to use the
GETDATE function along with DATEADD and DATEDIFF functions to calculate the
time frame and use that as a comparison to the Create Date from the Remedy
data to pull those records that fall within the date range. How is this
accomplished using the ODBC connector? I have done multiple internet
searches and tried several methods, including ODBC date functions such as
CURRENT_DATE, CURDATE, etc and continue to get the "lexical element not
found" error. Is there a way to accomplish what I want within SQL using the
ODBC connector?
Please note that I am NOT using SQL against the Remedy backend SQL Server -
I am using the ODBC connector, so it does not appear I need to do the date
conversion functionsm, although I tried those as well with no success.
--
View this message in context:
http://www.nabble.com/SQL-Date-Comparison-Using-ODBC-Connector-tp25296607p25296607.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Qualification EXTERNAL() Issue - Returns Nothing
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 wrote: > 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 wrote: > > > > > > > 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 to figure > > out what is right. If you're embedding a variable, i.e. $USER$, you may > > need to put a \ in front of the var name $\USER$ so it isn't interpreted > > when compiled. Again, you will need to tweak to get it exactly right. > > > Thanks, > > Mark > > > > > -Original Message- > > From: Action Request System discussion list(ARSList) > > [mailto:arsl...@arslist.org] On Behalf Of koray > > Sent: Friday, September 04, 2009 8:51 AM > > To: arsl...@arslist.org > > Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing > > > 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 wrote: > > > 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 about. > > > > Thanks, > > > Mark > > > > > > > -Original Message- > > > From: Action Request System discussion list(ARSList) > > > [mailto:arsl...@arslist.org] On Behalf Of koray > > > Sent: Friday, September 04, 2009 8:31 AM > > > To: arsl...@arslist.org > > > Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing > > > > 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 wrote: > > > > 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 without any qualification - in other words > > > > when the char field is empty - table lists all the data. > > > > > But, when I enter a valid qualification string in the char field, I > > > > get nothing. Log file shows like > > > > > SELECT (..) FROM (...) WHERE (1 = 0) ORDER BY 6 ASC > > > > > 1) where does 1=0 come from? Isn't it meaningless? > > > > 2) Although I have not set any Order option from Table Properties > > > > ORDER BY 6 ASC occurs. > > > > > Any ideas? > > > > > Regards, > > > > > Koray. > > > > > ___ > > > > > > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > > > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers > > > > Are" > > > > ___ > > > > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > > > ___ > > > > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > > ___ > > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > > ___ > > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > ___ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Qualification EXTERNAL() Issue - Returns Nothing
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 wrote: > 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 to figure out > what is right. If you're embedding a variable, i.e. $USER$, you may need to > put a \ in front of the var name $\USER$ so it isn't interpreted when > compiled. Again, you will need to tweak to get it exactly right. > > Thanks, > Mark > > > > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of koray > Sent: Friday, September 04, 2009 8:51 AM > To: arsl...@arslist.org > Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing > > 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 wrote: > > 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 about. > > > Thanks, > > Mark > > > > > -Original Message- > > From: Action Request System discussion list(ARSList) > > [mailto:arsl...@arslist.org] On Behalf Of koray > > Sent: Friday, September 04, 2009 8:31 AM > > To: arsl...@arslist.org > > Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing > > > 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 wrote: > > > 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 without any qualification - in other words > > > when the char field is empty - table lists all the data. > > > > But, when I enter a valid qualification string in the char field, I > > > get nothing. Log file shows like > > > > SELECT (..) FROM (...) WHERE (1 = 0) ORDER BY 6 ASC > > > > 1) where does 1=0 come from? Isn't it meaningless? > > > 2) Although I have not set any Order option from Table Properties > > > ORDER BY 6 ASC occurs. > > > > Any ideas? > > > > Regards, > > > > Koray. > > > > ___ > > > > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > > ___ > > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > > ___ > > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > ___ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > ___ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Qualification EXTERNAL() Issue - Returns Nothing
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 to figure out what is right. If you're embedding a variable, i.e. $USER$, you may need to put a \ in front of the var name $\USER$ so it isn't interpreted when compiled. Again, you will need to tweak to get it exactly right. Thanks, Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of koray Sent: Friday, September 04, 2009 8:51 AM To: arslist@ARSLIST.ORG Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing 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 wrote: > 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 about. > > Thanks, > Mark > > > > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of koray > Sent: Friday, September 04, 2009 8:31 AM > To: arsl...@arslist.org > Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing > > 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 wrote: > > 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 without any qualification - in other words > > when the char field is empty - table lists all the data. > > > But, when I enter a valid qualification string in the char field, I > > get nothing. Log file shows like > > > SELECT (..) FROM (...) WHERE (1 = 0) ORDER BY 6 ASC > > > 1) where does 1=0 come from? Isn't it meaningless? > > 2) Although I have not set any Order option from Table Properties > > ORDER BY 6 ASC occurs. > > > Any ideas? > > > Regards, > > > Koray. > > > ___ > > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > ___ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > ___ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Qualification EXTERNAL() Issue - Returns Nothing
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 wrote: > 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 about. > > Thanks, > Mark > > > > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of koray > Sent: Friday, September 04, 2009 8:31 AM > To: arsl...@arslist.org > Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing > > 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 wrote: > > 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 without any qualification - in other words > > when the char field is empty - table lists all the data. > > > But, when I enter a valid qualification string in the char field, I > > get nothing. Log file shows like > > > SELECT (..) FROM (...) WHERE (1 = 0) ORDER BY 6 ASC > > > 1) where does 1=0 come from? Isn't it meaningless? > > 2) Although I have not set any Order option from Table Properties > > ORDER BY 6 ASC occurs. > > > Any ideas? > > > Regards, > > > Koray. > > > ___ > > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > ___ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > ___ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
SLM 7.1 patch 2
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 accord? son consentement ? cet ?gard. Si vous n'?tes pas un des destinataires concern?s par cette communication ou une des personne autoris?es ? la recevoir, veuillez en aviser l'exp?diteur par courriel et d?truire toutes copies qui peuvent exister. This message is intended solely for the individual or entity to whom it is adresses. It contains privileged and confidential information which is not to be disclosed without the sender's express consent. If you are not the intended recipient of this message or an authorized representative thereof, please notify the sender by email and then destroy this message as well as all other existing copies. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Qualification EXTERNAL() Issue - Returns Nothing
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 about. Thanks, Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of koray Sent: Friday, September 04, 2009 8:31 AM To: arslist@ARSLIST.ORG Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing 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 wrote: > 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 without any qualification - in other words > when the char field is empty - table lists all the data. > > But, when I enter a valid qualification string in the char field, I > get nothing. Log file shows like > > SELECT (..) FROM (...) WHERE (1 = 0) ORDER BY 6 ASC > > 1) where does 1=0 come from? Isn't it meaningless? > 2) Although I have not set any Order option from Table Properties > ORDER BY 6 ASC occurs. > > Any ideas? > > Regards, > > Koray. > > ___ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Qualification EXTERNAL() Issue - Returns Nothing
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, koray wrote: > 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 wrote: >> 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 without any qualification - in other words >> when the char field is empty - table lists all the data. >> >> But, when I enter a valid qualification string in the char field, I >> get nothing. Log file shows like >> >> SELECT (..) FROM (...) WHERE (1 = 0) ORDER BY 6 ASC >> >> 1) where does 1=0 come from? Isn't it meaningless? >> 2) Although I have not set any Order option from Table Properties >> ORDER BY 6 ASC occurs. >> >> Any ideas? >> >> Regards, >> >> Koray. >> >> ___ >> >> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org >> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Qualification EXTERNAL() Issue - Returns Nothing
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 wrote: > 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 without any qualification - in other words > when the char field is empty - table lists all the data. > > But, when I enter a valid qualification string in the char field, I > get nothing. Log file shows like > > SELECT (..) FROM (...) WHERE (1 = 0) ORDER BY 6 ASC > > 1) where does 1=0 come from? Isn't it meaningless? > 2) Although I have not set any Order option from Table Properties > ORDER BY 6 ASC occurs. > > Any ideas? > > Regards, > > Koray. > > ___ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Qualification EXTERNAL() Issue - Returns Nothing
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 without any qualification - in other words when the char field is empty - table lists all the data. But, when I enter a valid qualification string in the char field, I get nothing. Log file shows like SELECT (..) FROM (...) WHERE (1 = 0) ORDER BY 6 ASC 1) where does 1=0 come from? Isn't it meaningless? 2) Although I have not set any Order option from Table Properties ORDER BY 6 ASC occurs. Any ideas? Regards, Koray. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
