Is there a way to have the Project Query setup allow for more than one table to be assigned to the Report?
I know Reports in the individual will allow multiple tables to be in the selection.
David -
We haven't built it into the user interface (in part because we were not sure how often people would want it).
That said: If you're familiar with database queries and SQL, it is possible to modify the underlying query for a Project Query report. The project query is stored within the report XML format in the C:\ProgramData\IMAGINiT Technologies\Clarity\ProjectConfigs folder.
The top of the file looks something like this:
<?xml version="1.0" encoding="UTF-8"?>
<ProjectReport>
<Name>Rooms Report</Name>
<Description>
</Description>
<SourceTable>PQ_Rooms</SourceTable>
<Query>SELECT * FROM PQ_Rooms WHERE projectId IN ([ProjectIds])</Query>
<SelectColumns />
...
The query is the SQL query, and the SelectColumns can enable you to further customize the look and behavior of the grid columns.
While the support department can't really help you with SQL, they may be able to assist with other customizations to the file. Or our consulting team can help with SQL-kinds of efforts.
Best Regards,
Matt
