• State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 3 replies
  • Subscribers 13 subscribers
  • Views 4559 views
  • Users 0 members are here
Options
Related

Tree Grid View Filtering

jeff.stroh
Offline

Hello,

I've got a multi-level BOM that I'd like users to be able to filter by Name or Part Number.  I followed the Query Element Builders Guide and the blog post "Filter a Tree Grid View with Parameters"; however it only works with the parameters at the top level.

So if for instance, I've got a part (top level) with a Name of "Part_1" and I use the parameters on the TGV with that, it filters fine.  But if I have a sub-part to that, with say a name of "Part_2" and I use the parameters on the TGV to that item, nothing shows up.

I'm assuming the problem is in the filter condition... (Name LIKE $name) AND ([Part Number] LIKE $item_number)

Can anyone help?

Parents Reply Children
  • 0 in reply to jeff.stroh

    Well. I said it´s a workaround, I didn´t say it´s a good one. I don´t think my own people really use it very often.Grin

    If you have a subscription, maybe ask Aras if they know a better solution.


    I see a good chance that we will see more flexible filter options in the future.
    Luckily QueryDefinition/TGV is constantly improved by Aras. Especially when the new reporting engine will show up, we will see a boost again. Simply because it will be THE reporting engine to use.
    The best years for TGV and QueryDefinition are yet to come.

    Goodbye Self-Service Reports!