Hello,
one option is, you use a Database-Tool. You can see there, that for each schema exists a view with the name of the schema.
In your SQL-Statement you put the fields you need of the view and the shown viewname as table, like this in an active link - set fields:
Choose "Read Values from" -> SQL
Input you SQL-Command:
SELECT lastname, firstname FROM
In the "Fields-Section" choose you Schema-Field-Name and the corresponding Value from the Menu right of the field "SQL-Result-Column" ($1$ to $10$).
If you've got more than 10 fields in your SQL-Statement, you have to input the Result-Colum $11$ to $x$ manually, because Remedy gives
you only 10 entries in that "SQL-Result-Column".
Thats's all, hope it will help you,
Regards
- Klaus-Jurgen Sprindt -
- - - - - - - - - - - - - - - - - - - - - - - - - - -
sinius GmbH
Call Center Technologies
Buropark Dusseldorf-Grafenberg
Hans-Gunther-Sohl-Str. 7-9
Tel.- Nr.: +49 (0)211 - 6101 -2107
Cell-Phone: 0173-2864 902
e-mail:Juergen.Sprindt@sinius.com
Datum: 03.01.2003 07:18
An: ARSLIST@ARSLIST.ORG
Antwort an: arslist@ARSLIST.ORG
Betreff: SQL in ARS
Nachrichtentext:
How do I use SQL statement in ARS?
What I need is, for example I have a schema and fields
then what should I put in my Select statement in
active link or filters etc.?
Select from
what should be in the and what shuld be in ?
http://movies.yahoo.com.au - Yahoo! Movies
- What's on at your local cinema?
You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org
--
Diese E-Mail enthalt vertrauliche und/oder rechtlich geschutzte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtumlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.
This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.
You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org
|
Top
|
|
Previous Topic
Index