Re: [web2py] Re: 75€ BOUNTY - Massively Complicated Query Required

2012-05-19 Thread Jason Brower
It is not totally implemented or verified at this point. But so far it seems to be working. I will post the answer later along with a special module I also made that uses this method. I think you guys will like it. BR, Jason Brower On 05/18/2012 09:15 PM, Carlos Costa wrote: The answer? 20

Re: [web2py] Re: 75€ BOUNTY - Massively Complicated Query Required

2012-05-18 Thread Carlos Costa
The answer? 2012/5/18 Jason Brower > This bounty has, thankfully, been solved. Thank you to all those that > have participated! It has saved me so much time! > BR, > Jason Brower > > > On 05/17/2012 07:28 PM, Jason Brower wrote: > > I have the event management tool I have been working on for

[web2py] Re: 75€ BOUNTY - Massively Complicated Query Required

2012-05-18 Thread Jason Brower
This bounty has, thankfully, been solved. Thank you to all those that have participated! It has saved me so much time! BR, Jason Brower On 05/17/2012 07:28 PM, Jason Brower 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

Re: [web2py] Re: 75€ BOUNTY - Massively Complicated Query Required

2012-05-17 Thread Jason Brower
The relevance columns are vital as I need to know how strong the relation is to UserA. It's used in a tag cloud module that I have built. BR, Jason On 05/17/2012 09:30 PM, Carlos Costa wrote: I found a way quite simple but It does not include the Relevance columns. 2012/5/17 Andrew mailto:awil

Re: [web2py] Re: 75€ BOUNTY - Massively Complicated Query Required

2012-05-17 Thread Jason Brower
On 05/17/2012 09:29 PM, Andrew wrote: "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 ? " Oh, I see from your example that it is an _additional_ +1 if you are in th

Re: [web2py] Re: 75€ BOUNTY - Massively Complicated Query Required

2012-05-17 Thread Carlos Costa
I found a way quite simple but It does not include the Relevance columns. 2012/5/17 Andrew > 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 s

Re: [web2py] Re: 75€ BOUNTY - Massively Complicated Query Required

2012-05-17 Thread Jason Brower
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 relevan

[web2py] Re: 75€ BOUNTY - Massively Complicated Query Required

2012-05-17 Thread Andrew
"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 ? " Oh, I see from your example that it is an *additional* +1 if you are in the same city. Got it.

[web2py] Re: 75€ BOUNTY - Massively Complicated Query Required

2012-05-17 Thread Andrew
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