I am wondering how to implement a more free-form search. For example, a search for "will" would get a direct hit on someone named "Robin Williams", but say I have a reference out to favorite movie in another table, I also want to find someone else who points to "Good Will Hunting" in that over table.
I can certainly hard code all the fields to search and all the joins necessary to get to those fields, but I was hoping for some introspective help to make the search less brittle. Given a starting table I can see the fields in that table (db.person.fields), but is there a good way to get from db.person.favorite_movie to db.movies? Looking at SQLFORM() sources it seems to get it from the SQLField object. I don't know that I should be poking inside there... Suggestions? Thanks, -kb P.S. Once I figure out how to do this introspection I expect I don't want to search everything I can crawl to from the starting table; I am also wondering how to say something about what joins to make and what fields to look at when getting to the next table... --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
