Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to translate queryShort field to remedy values

Status
Not open for further replies.

redshifteric

Programmer
Jan 27, 2003
2
FR
I'm writing a web-php application that directly read into the SQL database of our remedy server.
I juste using this for browsing, no modification are mades from this tool but i have trouble translating the queryShort field.
Example: 1\4\6\1\536870965\2\0\4\6\1\536870981\2\0can be translated into:
( 'Tmp Last Name' != $NULL$ ) AND ( 'Current Equipment Number' != $NULL$ )
I know ho i can find the field name from the field table but how can i translate the opearators ?
I suppose that:
4\6\1 is !=
2\0\ is AND

But i'm not sure on this, do you have more information for me ?


 
Okay, that seems to be very complicated to do without using the ARSPerl interface ?
So at this time i have "builded" a system that query the ar system database in live and show you the result.
You can export (definition and data) from this tool, search for related worlkflow, search for object, browse db structure, run select query, ...
I'm currently writing this application for my personnal use in my society, but i think that other people can be interrested by a live arsystelm documentation tool.
With this tool, no more need to schedule the ARSDoc, just use it, it's live query, but with a cache system.
This tool is made using PHP and ODBC to access the database.
If you have suggestions on how i can retrieve information from the ar system db, useful query , ... please send it to me, i will wtahc if i can integrate it in my app.
My wish is to release this tool as soon as possible (GPL ?)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top