Well, I don't think you can already do this, but I could see it coming in use occasionally. I would like to have the ability to set the contents of a table using Direct SQL and external(). This way I could dynamically build a query string, then use external to present it to the table field. I would like to see Direct SQL as an option in the 'Form:' field on the Table Property tab in the admin tool. The 'Field on Form:' and the 'Field as Column' areas would be blank, as they would just pull the list of fields from your SQL statement. You would enter your SQL (hardcoded) or the External() function in the current 'Qualification bar' on the Table Property tab.
They do this functionality with Set Fields. You have the option to select Direct SQL as an option to choose SQL in the 'Read Value for Field From:' field instead of choosing a form or the current transaction. I would like to see this mimicked in a Table field. I've only needed this twice, and both times have had to identify a work-around. I don't want to have to create an SQL view in the database every time I need to work around this. What is your input? Have you come across a situation where this would be handy (such as when you need to join two tables)? Another solution that would have worked for me in the past is if I could have chosen multiple remedy forms to pull in data to my table, using a join statement in the 'Qualification bar', and going through the GUI to choose which fields show up from each form, similar to when you create a join form. The reason why I don't just create a join form to start out with is that in remedy, you cannot create a join form of two view forms, and you can only create joins of other remedy views. I don't want to have to go out to the database, create my own non-remedy join of the tables from which the other views pull from, and then point a view form on top of that join so that I can access it in a table. Also, this would allow me to be much more flexible in which data I present in a table. Instead of having multiple tables layered on top of each other, I can just dynamically send them their own SQL qualification and use only one table, just changing the contents it displays based on the user, or based on some other options the user chooses. This could really eliminate the need for using multiple table fields in a lot of situations which I've seen. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"