I'm trying to filter on the field BG_PROJECT however I'm finding no results are returned when there are multipole levels of folders in the list. For example, I can retrieve the correct results when the prpject list is the top level such as myFilter.Filter("BG_PROJECT") = "Project" but having trouble filtering when the project is a couple of levels down such as ProjectA\SubProject\ProjectB.
Has anyone had experiencing filtering down mulitiple levels and know the correct format. I have tried several combinaltions and can't seem to get any results back
Have you tried looking at the data actually stored in the field when you've selected a value that isn't the root of the list? I did this, and found that only the very last node of the path is stored in the field. So, if you want to filter on defects that had the project value "ProjectA\SubProject\ProjectB", you need to filter for just "ProjectB".
(Opinions and information contained in this post are wholly my own and do not reflect the opinions of my employer.)