Hi,
I guess you can circumvent the license policy in many ways, but if the
ultimate goal is to do a modification without a license, I would think it
to be a violation of the license agreement.
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
>
>
> Side question -- if you go raw to the database with your mods -- I assume
> that does not take an ARS license.
>
>
> Any comments?
>
>
> -John
>
>
>
>
>
>
> On Jul 16, 2010, at 10:01 AM, AR Admin wrote:
>
> **
> Speaking of databases, does anyone know if it's safe to run update queries
> on remedy database externally with a vb app? Any possible side effects
> from not using remedy C or java api to do this?
>
> Thanks
>
> Date: Fri, 16 Jul 2010 07:18:14 -0600
> From: lj.longw...@gmail.com
> Subject: Re: Capturing SQL Statement
> To: arslist@ARSLIST.ORG
>
> **
> John,
>
> I know the question comes up every once in awhile
.and the common
> agreement is that yes, remedy will pass a 1=0 to the DB
the argument
> typically occurs around what happens when it hits the DB. Well, from
> personal experience, I have seen remedy pass a 1=1 to the DB and have that
> query BLOCK other queries to the table
so in the instance of SQL Server
> 2005, I guarantee you that its passed to the DB, and the DB does a table
> scan.
>
>
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of John Sundberg
> Sent: Thursday, July 15, 2010 6:52 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Capturing SQL Statement
>
>
> **
>
>
> Doug,
>
>
>
> Wondering -- does AR Server eval the string before sending to the DB?
>
>
> Specifically - if the qualification on a filter translates to 1=0 -- does
> the database do a tablescan against the table to see if any records match
> 1=0 ?
>
>
>
> I would think that a cheap ARS optimization would be to grab "false"
> qualifications - and never go to the database at all.
>
>
>
> This comes up every once in awhile -- and I don't think that ARS would
> take a qualification where 1=0 and send it to the database for a result
> list and processing.
>
>
>
> And -- if ARS does pass 1=0 to the database -- why would that be?
>
>
>
> -John
>
>
>
>
> On Jul 15, 2010, at 6:33 PM, Mueller, Doug wrote:
>
>
> **
>
> John,
>
>
> You cannot.
>
>
> You can have workflow that looks at what is entered in fields and what is
> entered in the advanced search bar.
>
>
> You cannot however get ahold of the SQL generated.
>
>
> The way the system is constructed is that the qualification comes across
> the wire as an AR System
>
> qualification. That is parsed and processed by the server. There is no
> workflow on searches at all, but
>
> even if there were, the server layers are
>
>
> Receive call and route to a queue
>
> Data validation/ access control checking
>
> Filters
>
> Translation to SQL and issuing command
>
>
> The only layer you would have access is the Filter layer and that occurs
> before any translation to SQL.
>
>
> There is no way to capture in advance the SQL.
>
>
> You can log SQL statements so you can look at it later, but that is after
> the fact. You cannot get ahold of
>
> the SQL statement in logic.
>
>
> Doug
>
>
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of J Kovalcik
> Sent: Thursday, July 15, 2010 2:43 PM
> To: arslist@ARSLIST.ORG
> Subject: Capturing SQL Statement
>
> **
>
>
> Listers,
>
> I would like to capture the SQL query before it would be submitted
> to the database. For example, if in a search form, the user enters
> search criteria in any fields or the advanced search bar, I would
> like to capture that query before clicking the search button.
>
> Can I use one of the Remedy API's that are already built ? Or are
> there any other ideas ?
>
>
>
> Thanks,
>
>
> John Kovalcik
>
> _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
>
> _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
>
>
> --
>
> John Sundberg
>
> Kinetic Data, Inc.
> "Building a Better Service Experience"
> Recipient of the WWRUG09 Innovator of the Year Award
>
> john.sundb...@kineticdata.com
> 651.556.0930 I www.kineticdata.com
>
>
>
>
>
>
>
>
>
> _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
>
> _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
> The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with
> Hotmail. Get busy.
> _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
>
> --
> John Sundberg
>
> Kinetic Data, Inc.
> "Building a Better Service Experience"
> Recipient of the WWRUG09 Innovator of the Year Award
>
> john.sundb...@kineticdata.com
> 651.556.0930 I www.kineticdata.com
>
>
>
>
>
>
>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
