Interactive Filter related query

[jkhanddh]

I want to create a filter that filters out the HR Cases on the basis of the following field:

HR Case -> Opened for -> HR profile -> Post Description 

Problem I am facing is that the HR Case table does not have field referenced to HR Profile table but I want to filter according to a field in HR Profile table. How to do it kindly help 

[Mark Manders]

What is 'Post Description'? I don't see that on my OOB instance as field on the HR Profile.

And what is your exact requirement? Do you need this in a report, do you need to create a list for it, or is it meant for a (background) script?

[jkhanddh]

Post Description is a custom field,

If can create a report that'll be awesome but creating an interactive filter with such capability also works

[Mark Manders]

Depending on the kind of field, you can easily make it a filter, although a report would be easy as well. You can just dotwalk in your condition to the field you want. And for your filter (as long as it's not a string), you can dotwalk as well.