[rt-users] Additional fields in tickets table

[Michael D. Stackhouse]

Thanks - we have been able to set up some keywords that would apply.

We would like to create some of our own reports based on these keywords.  I notice in the
database that the keywords for a given ticket are stored in the KeywordSelects table.  What
is the relationship of the tickets and keywordselects table, so we could perform join
queries for reporting purposes?

Thanks again!


Matt Plec wrote:

> > There are a few fields that we would like to have on the ticket table.
> > Is there some kind of capability in RT that would allow us to have
> > additional fields?  If not, is there a way we can customize the table
>
> If selections (multiple or single items for the field) are sufficient, you can add these
> via keywords, which are documented near the end of the installation instructions
> (http://www.helgrim.com/rtdocs/installation.html).