Find record whose field 'name' not contained within any other record
        Posted  
        
            by 
                charlie
            
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by charlie
        
        
        
        Published on 2014-05-31T02:13:57Z
        Indexed on 
            2014/05/31
            3:26 UTC
        
        
        Read the original article
        Hit count: 203
        
I have a model Foo with a String bar and a String name. Some records' bar contain the name of other records in them. This is intentional.
I want to find the "root Foo" records - that is, the ones where their name do not appear in the bar records of any other Foo records.
Example:
Foo
id: 1
name: 'foo1'
bar:  'something something'
id: 2
name: 'foo2'
bar:  'foo1 something'
id: 3
name: 'foo3'
bar:  'foo1, foo4'
My method root_foos would return foo2 and foo3 since their names do not appear in any bar string.
edit: I don't want to use a relation or foreign key here - just this method.
© Stack Overflow or respective owner