Submitted by markfoley on 2009/06/15 23:02
I created a new thread for this Pierre.  You mentioned in the 'Access field values of other grid items' that you can access parents and subitems values.
 
Can you iterate up through to parent's parents, or provide guidance on how the below search could be approached?
 
I was going to write a search (unless I can do it using IQ as it is) that would allow me to search as follows:
 
An example tree:
 
Projects
|___Project Blah
...
|___Project Swan
   |___Issues
      |___Cash reconciliation
      |___Cheque reconciliation
         |___Spk: Shane re: new process
 
For the same reason context parents are useful, you would want to search where other parts of the item's lineage contain other key words.  Often important information isn't repeated at every lower level in the tree.
 
Eg searches like:
 
Contains "Shane" and Contains "Swan" to find issues to do with both Shane and project Swan.
Contains "Reconciliation" and contains "Issue"
 
Basically you want to consider the item and all its parents a single string and search within that.  Could I write code to achieve this, or is there another more elegant way?
 
Suggestions?