Attempting transaction search filtering for a custom field. The search works fine until I attempt to add the field to the displayed columns. At that point it throws an “internal error”. I’ve found a few previous submissions related to this same issue but they are a) very old, and b) have no additional replies.
Log activity:
comp called without component - must pass a path or component object at /opt/rt5/local/lib/perl5/HTML/Mason/Request.pm
RT Version 5.0.6 on Debian
Can you send your query? I’ve tried the following successfully in transactions search:
CFName = 'Àmbit SASTIC' AND NewCFValue LIKE 'Patrimoni'
The query I’m sending is, where CF.{Changes} is a transaction custom field. The query works fine, but the results don’t display the contents of the changes field, just the associated content of the comment. Here’s current transaction query I’m using:
TicketQueue = ‘Support’ AND CF.{Changes} LIKE ‘%’
OK. I’m sorry but I have no experience about CF in transactions yet.
Is there any clue in the log?
When I use the query builder to make a transaction search (as opposed to a ticket search), I get a similar syntax to sollericos:
CFName = 'Tag Field' AND TicketQueue = 'it.services' AND NewCFValue LIKE '%'
If I do a ticket SQL search my query has a syntax more like yours:
Queue = 'it.services' AND 'CF.{Tag Field}' LIKE '%'
You might want to check you’re using the right syntax for the search type you’re using.
So I’ve seen that recommendation somewhere else; but when I attempt to use that syntax, the list of CFName options only includes ticket custom fields (severity, resolution, type, category). I can only reference the transaction custom field using the ‘Select Custom Field’ dropdown.
I’ve been banging my head against this again recently and just wanted to give an update and ensure my use case is clear. I’m trying to separate comments from actual applied changes during a support session. Likewise, I want to be able to search transactions of a ticket to identify all changes applied. When I use the search query I referenced previously, it returns the expected list of transactions, but if I attempt to add the CF.Changes via ‘Show Columns’ that’s when I get the internal error. Below is a shot of the field representation in RT.
So I tried that same syntax again and it gives no results. I tried selecting from the ‘CF Name’ dropdown and it doesn’t offer the TransactionCF as an option:
However, it does offer the TransactionCF under the ‘Select Custom Field’ dropdown. This is what returns the transactions, but throws the internal error if I try to add the CF to the columns.
