Include transaction to search results

RT Users
1

Hi,

I have a question about the query builder. Can i include transaction
fields somehow in my query? like these format:
title | transaction create | completed, etc.etc

I require the first transaction record to my result table if its
possible. or it is only possible if i’m write a custom app to query the
database itself?
I can query it with native SQL with these statement:
select
a.*
from Attachments a, Transactions t
where a.Transactionid=t.id and t.objectid=$ticketid;

Any suggestions? :slight_smile:

Thanks for your help!

Regards,
Zoltan Kiss

2

Hi,

I have a question about the query builder. Can i include transaction
fields somehow in my query? like these format:
title | transaction create | completed, etc.etc

I require the first transaction record to my result table if its
possible. or it is only possible if i’m write a custom app to query the
database itself?
I can query it with native SQL with these statement:
select
a.*
from Attachments a, Transactions t
where a.Transactionid=t.id and t.objectid=$ticketid;

Any suggestions? :slight_smile:

Thanks for your help!

Regards,
Zoltan Kiss