It's all about the answers!

Ask a question

How do you get Report Builder not to return all Module instances of Artifacts


Ben Sharples (56839) | asked Jun 27 '19, 5:11 p.m.
I am trying to use Report Builder to report on all the Artifacts of a particular type in my project area, however as well as the base artifact it also brings in every instance in any modules as well.

I just want a report using the base artifacts not all the instances across multiple modules.

It would seem pointless to create a Module purely for a reporting perspective as it seems that I set a condition to only show those in a particular module.

I am having to use multiple modules already for reporting purposes as the Dashboard Widgets only allow you to point to views in Modules or the Base level (would be much more useful to point to views in collections)

One answer



permanent link
Sean F (76712234) | answered Jun 28 '19, 3:50 a.m.
edited Jun 28 '19, 3:56 a.m.
You need to add a condition against the artifact to say if it belongs to a module or collection (and if so which one[s]) or if it is unassigned (within the context of the report you are trying to generate).


In this example 'unassigned' has been chosen so only the base artifacts links going to that artifact will be reported even if the artifact also appears in 1 or more modules and has module context links within those modules.

If you instead selected a module in which that artifact appears then only the module context links going to that artifact as it appears in the selected module will appear in the report.



Comments
Ben Sharples commented Jun 28 '19, 6:05 a.m.
That filter returns only those Base Artifacts that are in no modules at all, which is not the use case I am trying to achieve.

Sean F commented Jun 28 '19, 10:22 a.m. | edited Jun 28 '19, 10:23 a.m.
The query actually returns whether the link itself is base artifact or module context.

It does not refer to whether the artifact appears in a module or not.

So if your artifacts are all in modules but the links between them are base artifact links then all those artifacts and their links will be returned by the query in the screenshot.

Ben Sharples commented Jul 01 '19, 6:43 a.m.
The query in the screenshot only returns those Artifacts where they are not currently assigned to a Module.

Where an Artifact is assigned to a module then no returns occur of the Module instance of the Artifact and the Base Artifact is also not returned from this query.

i.e.
Artifact 1: Assigned to a Module
Artifact 2: Assigned to a Module
Artifact 3: Assigned to a Module
Artifact 4

Original Problem was query would return:
Artifact 1
Artifact 1: Module Instance
Artifact 2
Artifact 2: Module Instance
Artifact 3
Artifact 3: Module Instance
Artifact 4

Query in screenshot returns Artifact 4 only

The use case I am looking for is to return
Artifact 1
Artifact 2
Artifact 3
Artifact 4

Your answer


Register or to post your answer.