OQL Expression

[Ilias Hassar]

Hi all,

Hope you guys are ok and working with iTOP everyday :)

recently it came to me a small doubt, I ´m able to attach documents to a computer in document tab, I was trying to perform a OQL querie to show me the computers, ( pc or laptops) thone only have a document attached to them

Select PC .....>

Is that possible to do it?

[Thiago Arcanjo]

Try this:

SELECT PC JOIN lnkDocumentToFunctionalCI AS l1 ON l1.functionalci_id = PC.id

[Ilias Hassar]

Thiago, I´ve tested the querie and works as hell!! Thank you Sir! It´s amazing how powerful is..

Best!