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"
