For the third one this is to further show the relevance of a user
because they are living near you, but they should be someone that at
least has something in common with you.
BR,
Jason Brower
On 05/17/2012 09:22 PM, Andrew wrote:
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
