[rt-users] how to read AT link information

[Tommy Abrahamsson]

Hi 

Anyone had any suggestions on this? 
My problem is very similar, and as Tomasz mentions, it's not really an AT issue but more of a query issue. 

I have the following assettypes or queues: 
customers, servers and software versions 

They are linked together like this: 
customers (referred to by) servers (is running) software versions 

But I can't figure out how to create a proper query that'll show me the values of linked assets. In a pseoudo sql query, it'll look something like this: 

SELECT customers.name, servers.*, softwareversions.* FROM softwareversion INNER JOIN bla bla bla WHERE softwareversion.build=1234 

Hope someone can help out. 
Thanks in advance. 


Best regards 
Tommy Abrahamsson 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070520/ac3dd4dc/attachment.htm>