Hi all,
I'm trying to display a new tab with objects selected in a query overwriting the DisplayBareRelations following this tutorial.
It works perfect when only selecting one object
$oSearch = new DBObjectSearch::FromOQL("SELECT object1 JOIN lnkObjetc1ToObject2 ON ..........
But if my query selects 2 objects
$oSearch = new DBObjectSearch::FromOQL("SELECT object1, object2 FROM object1 JOIN lnkObjetc1ToObject2 ON........
It only returns the first object.
The query tested in the "Run queries" works ok, returning the join of both objects.
Is it a bug? any workaround?
Thanks in advance,
Regards,
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
We have done it for reports and it works :)
I have tested my query in the "Run queries" and it works
From the documentation https://www.itophub.io/wiki/page?id=2_4_0%3Aoql%3Aexample
SELECT
Artist, Book FROM
Book
JOIN Artist ON Book.written_by = Artist.id
WHERE Book.issued > '2001-01-01'
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi all,
I'm trying to display a new tab with objects selected in a query overwriting the DisplayBareRelations following this tutorial.
It works perfect when only selecting one object
$oSearch = new DBObjectSearch::FromOQL("SELECT object1 JOIN lnkObjetc1ToObject2 ON ..........
But if my query selects 2 objects
$oSearch = new DBObjectSearch::FromOQL("SELECT object1, object2 FROM object1 JOIN lnkObjetc1ToObject2 ON........
It only returns the first object.
The query tested in the "Run queries" works ok, returning the join of both objects.
Is it a bug? any workaround?
Thanks in advance,
Regards,
Are you sure you can use
SELECT object1, object2?We have done it for reports and it works :)
I have tested my query in the "Run queries" and it works
From the documentation https://www.itophub.io/wiki/page?id=2_4_0%3Aoql%3Aexample
SELECT
Artist, Book FROM
Book
JOIN Artist ON Book.written_by = Artist.id
WHERE Book.issued > '2001-01-01'