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 >
