Report Resource and Filter

there seems to be a new feature in V10. You can include a report as a resource to a view.

You can select a report and you also can define a filter.

How can I define a filter that limits output to the selected node? Is there a variable that contains the node id? If yes, how can I reference it?

Thanks in advance

Thomas

Find more posts tagged with

filter

nodeid

report

Accepted answers

bshopp

Correct, you will need to edit the advanced sql to get that to work or clone it.

All comments

mkarak

Hi Thomas,

you can do this using following filter condition:
Nodes.NodeID = X (where X is a NodeID of your node).

If you are using the resource on Node Details page and you want to limit it to actually displayed node you can use following filter:
Nodes.NodeID = ${NodeID}

Hope this helps.

Milan

FormerMember

Hi Milan

this works fine for 'normal' reports - but it doesn't work for SQL reports

Thomas

bshopp

Correct, you will need to edit the advanced sql to get that to work or clone it.

FormerMember

Is it possible to use ${NodeID} in an advanced SQL report?