I found a way quite simple but It does not include the Relevance columns. 2012/5/17 Andrew <awillima...@gmail.com>
> If another user has a tag that UserA is looking for, then relevance is +2 > to UserA > If another user is looking for something UserA has, then relevance is +1 > to UserA > If another user lives in the same city as UserA and has something they are > looking for or something to offer then relevance is +1 > > So, is the third similar to the first, but with a city clause. Sounds > like it's a +2 if you have something UserA is looking for, but it's only +1 > if you live in the same city ? > > Andrew W > > > > On Friday, May 18, 2012 4:28:02 AM UTC+12, encompass wrote: > >> I have the event management tool I have been working on for 2 years now >> and I have made some changes to the code that require my most complicated >> query to be rebuilt. >> After thinking about it for several hours I figure I should throw it at >> you guys to see what you can come up with. >> The winner of this query will get 75� with paypal or other means after >> I have it implemented it in the code. >> >> I have the following model: >> model_diagram.png >> event_attender.py >> tag.py >> tag_link.py >> Description: >> I am building a list of connections based on relevance by tag. >> Tags have two states, looking for and attribute. >> Users attach themselves to these tags with the two attributes. >> "I am looking for someone with this tag." >> and/or >> "This tag is something about me that I want to offer." >> >> Now when they do this a list of users will show on the screen. >> ID Nickname Tags your looking for that they have Your Relevance >> Tags they are looking for that you have Their Relevance Total Relevance >> Image city 101 encompass Tag1, Tag2, Tag4 3 Tag4, Tag5, Tag 6 3 10 >> http://.... Oulu 102 encompass Tag1, Tag2, Tag4 3 Tag4, Tag 6 3 8 >> http://.... Oulu 150 encompass Tag1, Tag2, Tag4 3 Tag 6 3 7 >> http://.... Helsinki >> This is build with the following: >> UserA is the user logged in using the system >> If another user has a tag that UserA is looking for, then relevance is +2 >> to UserA >> If another user is looking for something UserA has, then relevance is +1 >> to UserA >> If another user lives in the same city as UserA and has something they >> are looking for or something to offer then relevance is +1 >> Does this make sense? I just need to query that will happen.� I can >> handle the view just fine. Feel free to comment or ask questions. >> If you can think of a good way to connect people better with the data in >> the model diagram attached do tell.� I will give you another 25� for >> that implementation as well. :) >> --- >> BR, >> Jason Brower >> > -- Carlos J. Costa Cientista da Computação Esp. Gestão em Telecom EL MELECH NEEMAN! אָמֵן
