Spelling is important, isn't it? Rick On Jun 9, 2015 9:08 AM, "Shafqat Ayaz" <[email protected]> wrote:
> ** > while looking at the Remedy website came across this... > > - > - BMC Atrium Integrator Server is not detected | BMC Communities > <https://communities.bmc.com/thread/105058> > Apr 15, 2014 ... Getting the error message "BMC Atrium integrator > Server is not ... You need to install atrium integrator which is a > desperate download on the ... > desperate download indeed!! > - > - > > > > *Shafqat Ayaz* > > > ------------------------------ > *From:* "Grooms, Frederick W" <[email protected]> > *To:* [email protected] > *Sent:* Monday, June 8, 2015 5:24 PM > *Subject:* Re: Set field SQL statement correction > > You should be able to search the forms "AR System Metadata: actlink_sql" > and "AR System Metadata: filter_sql" looking for the double quotes. From > those forms you can take the Actlink ID or Filter ID to the Actlink or > filter metadata forms to find the workflow to update > > Fred > > > > -----Original Message----- > From: Action Request System discussion list(ARSList) [mailto: > [email protected]] On Behalf Of MalviyaSaurabh > Sent: Friday, June 05, 2015 10:07 AM > To: [email protected] > Subject: Set field SQL statement correction > > Hi All, > > We have migrated our custom (non-ITSM) ARS application from 7.1 > (Solaris-Sybase) to 8.1 (Linux-Oracle). > Currently facing issues with Set Field SQL action in various workflows due > to difference in SQL statments in Sybase and Oracle. > For instance in one of the activelinks, > on sybase > select Install_History from CM_Change_Mgmt where Change_Request__ = > "$Change_RequetID$" > which gets error on Oracle, to rectify it I made the below change > select Install_History from AOL_CM_Change_Mgmt where Change_Request__ = > '$Change_RequetID$' > single-quote > > Since I don't know for the presence of "double-quotes" in the workflows for > similar actions, what would be the best way to rectify the set-fields > actions,push field, direct sql?? > > Regards, > Saurabh > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
