Re: Data Dictionary Menus

[Stephen Lumini]

**

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 <[EMAIL PROTECTED]>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___