How do I create a report that has all the assets that i select in it?
When I create a report with the wizard i can only select 1 of the assets in the drop down menu. I would like to create a report that has multiple assets in it. Im not very SQL savvy and I could use a little help
0 Comments
[ + ] Show comments
Answers (2)
Please log in to answer
Posted by:
Hobbsy
8 years ago
Alternatively you can create a view in the Asset section using an advance search that contains the assets that you want, then from the choose action menu select the Create a Report option. Once the report is saved view the SQL.
Posted by:
grayematter
8 years ago
This can be done in SQL, but it is easiest if you create the parts in the wizard and stitch them together later. Note that when you do this, each of the sub queries has to have the same number of columns. Once you have the sub queries, you can UNION them together. More info on the UNION syntax is available here: http://dev.mysql.com/doc/refman/5.7/en/union.html
