Hi,
You might also want to consider creating a StatusHistory-child-form where you
store status-changes for your tickets. It is easier to do a lot of things if
you have each status change as a separate record.
If you do not want to use the existing Status-History data, you might consider
using the Run-Process-Command: PERFORM-ACTION-TABLE-ADD-ROW tableFieldID
rowIndex
Just go through your different status history entries to see if they are NULL
or not, and add rows/set-values as needed. You will probably need to create
one ACTL per Status-value to accomplish this.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
If you create a View form against the H table directly then you will only
receive 1 row back when you query for a specific Entry ID (Separate fields for
each status value and status value date).
If you need multiple rows for a single entry then you can create a database
view against the H table and a View form against that.
As an offhand question ... The Status History menu item is not good enough for
the users?
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Hulmes, Timothy CTR MDA/ICTO
Sent: Wednesday, January 23, 2013 6:22 PM
To: arslist@ARSLIST.ORG
Subject: Reference the H-Table from a table field
**
Does anyone know if it is possible to display the H-Table on a form?
What we are looking at doing is have a table on the form. In that table we
would like to display the status history.
Any ideas?
Tim
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years