RE: [Arsperl-users] Remedy Query to SQL

[Jeff M. <jcm...@je...>]

On Thu, 2005-04-07 at 14:16 -0400, Bowman, Brent A wrote:
> Is this the only way?  How does remedy do it.  And how do I turn logging on from the same perl script?  Also, how do I know that the log entry is from my query and not from another users' request?  Really, the algorithm would be better here.


you can examine a query and derive the algorithm. i think they replace
spaces and non-alphanum characters in field and form names with
underscores. some forms are special ("User" is "USER_X"). 

so if you have "My Form #1" and it contains a field "Phone #" and
"Entry-Id". the view should be "MY_FORM__1" and it should contain
"PHONE__" and "ENTRY_ID".

you'll need to grant your oracle users permission to query the view.

jeff