Many thanks to you and Joe for your inputs.
My problem was the following:
- people would like to make a insensitive search in some fields. Not all
the fields.
- the Sybase server is case sensitive. And I am not allowed to change
this because I share the development server with other people/applications.
And I'd like to keep some consistency between my dev and my prod.
So I thought I could use this set field to build something.
Eventually I ended up building a Guide which runs direct SQL.
And now I get what I wanted.
The only thing is that it is quiet curious this Display a List. Since
you can't do anything with it, what is its use then?
Serouche
Grooms, Frederick W wrote:
As Joe said it will not work that way. You are trying to mix direct SQL
and Remedy. If you are working against a Remedy form then why are you
needing to do your selection using direct SQL? Can you not use a
standard Set Fields action to query for your records (as that will bring
up the Results list for multiple matches)?
Fred
________________________________________
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza
Sent: Monday, January 05, 2009 6:29 AM
To: arslist@ARSLIST.ORG
Subject: Re: how to open a window on a set field action with multiple
request match
The short answer is you cannot do what you are trying to do with the
current limitations of the product.
To the best of my knowledge you cannot 'set fields' to the Result list
using workflow.
Joe
________________________________________
From: Remedy Maniac <remedy.man...@googlemail.com>
To: arslist@ARSLIST.ORG
Sent: Monday, January 5, 2009 6:06:09 AM
Subject: how to open a window on a set field action with multiple
request match
dear all,
I have a set field action built with a direct SQL.
The query returns several rows.
So I have set the "If Multiple Requests Match" to Display a List.
What I would like to achieve is to have the Result list open instead of
the SelectionPopup window.
Is that possible?
If not, then how can I build a workflow to have the Result list opens ?
I tried with Set the Result List field to $1$ and tried the Open Window
Action but I didn't manage to produce anything with this.
I tried to select from the SelectionPopup window, but nothing opens when
you click on the OK button.
Any idea or tips would be appreciated.
Thank you
Serouche
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
