Can we dot walk into document_id field type and use it as interactive filter in the dashboards?

[Akash7]

Hi All,

We have a scenario where the client wants some to use some dynamic filter on the report. But the filter which we want to use is of document_id field type, is there any possible way that we can dot walk and use it as filter in the report.

Thanks

[Mark Manders]

The document_id field is just a sys_id. Why do they want to filter on that (it will return only one record, so it could also be that filtering on 'number' does the same).

Can you explain your use case, because seeing all records where document_id is xxxxx (one record) sounds not really like a good filter to filter anything on. 

[Akash7]

Hi @Mark Manders 

We have to apply filter condition based on the value stored in document_id field, so I was searching whether we can dot walk into the field and get the value which is required.

Thanks

[palanikumar]

Hi,

I think you are trying to use the referenced field in your report. document_id field will not allow dot walking, instead you can create a database view, join the current table with the target table where document id referred to. Generate report from the database view.

Thank you,

Palani

[Akash7]

Hi @palanikumar 

Thanks for the solution,