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? :)

Thanks for your help!

Regards,
Zoltan Kiss
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [email protected]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Reply via email to