Hello community!
We have report built on incident table to show the portfolio comments and application services coming from CI.
we are seeing the portfolio comments (Site location) regarding all application services. I want to filter based on site locations.
Portfolio comments field (string type) is having site locations name.
Tried to create a cascading filter on cmdb_ci_service_discovered table. When select site name from the filter and apply the report should show us only given portfolio comments details in the report.
I achieved to create filter to bring the related site location in the filter, but when i apply the location from the filter report is not fetching the exact data related to given filter.
Please see the attachments. And seeking for help. whether i need to customise a dynamic content block filter or interactive filter is enough.
If need to customise dynamic content block filter please help me with script how to do.
Actual result should be like below
@Mad3 Did you set the below Interactivity settings to "True"?
Please mark this as helpful and accept it as a solution if this resolves your query.
Thanks,
Sujatha V.M.
@Mad3 Could you please check this note because I don't see target record in your screenshot
Refer the below steps for validation which might help you to fix it,
Please mark this as helpful and accept it as a solution if this resolves your query.
Thanks,
Sujatha V.M.
Hi @Sujatha V M ,
Yes your right, Since the portfolio comments field is string field on cmdb_ci_service_discovered table. What table table could be target field.
Tried giving cmdb_ci_service_discovered table and same field in the record don't see any difference in filter.
Not able to find the actual target table whether it is incident or cmdb_ci_service_discovered.
