Hi Stephen, Thanks for this, it appears somehow my gmail swallowed this reply only for me to find it when searching again....
the app looks like it might be very useful.. Thanks again Stephen On 11/05/06, Stephen Lumini <[EMAIL PROTECTED]> wrote:
** Hey Stephen, I'm not sure what your end result you want, but I have a bunch of SQL like this on my app a Quick Search. You can download it at: http://www.geocities.com/stephenlumini/quicksearch.html That version is meant for ARS 5.1.2 / Oracle 9+, but I have another 3/4 done one for MSSQL db's, as well (CASE IF instead of DECODE, etc). I am improving it right now, and will post a newer version eventually. Alot of the SQL is straightforward, and is forward compatible (remedy doesn't change how/where it stores Field DB names, for example) - feel free to grab whatever is useful. If you have any questions, just ask. Later Stephen Carey Matthew Black <[EMAIL PROTECTED]> wrote: Stephen, You can do this. You use the same kind of syntax as you would to reference a local field in a Search Menu qualification. I actually stumbled into an OOB menu that did this before I realised it could be done. I never went looking for this "feature" in the docs, but it appears to work as you would expect it to work. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. Never ascribe to malice, that which can be explained by incompetence. On 5/10/06, Stephen Earl wrote: > ** > All, > > I come once again to ask the wisdom of the 'list' > > I'm working with ARS 6.03.00 patch 11 > > I want to create a form that uses character fields with Data Dictionary > menus one to choose a form and then another to list the fields on the > selected form... > > However it appears in a Data Dictionary menu you can't set the 'form' value > from the contents of a field (unless I'm missing something really obvious, > which as been known in the past) > > Any ideas for a good way of achieving this? > > Constructive comments greatly appreciated. > > Stephen. __20060125_______________________This posting was > submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ________________________________ Now you can have a huge leap forward in email: get the new Yahoo! Mail. ________________________________ Be smarter than spam. See how smart SpamGuard is at giving junk email the boot with the All-new Yahoo! Mail __20060125_______________________This posting was submitted with HTML in it___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
