Glorp findings – using count:

Conntinuing on the Customer/Order example from my last post, we might want to only send some ads to customers who have ordered at least twice in the past. For this we'd first have to cunt all orders of our customers who haven't ordered for at least 100 days. So the first step is to create … Continue reading Glorp findings – using count:

Advertisements

Glorp Subqueries – notExists:

I decided to get back to blogging after a very long break. Since I am quite busy with our Kontolino! project, I also decided that I need to get back to blogging with small articles that require little time - but might still be useful. So here is the idea: I am struggling with Glorp … Continue reading Glorp Subqueries – notExists:

Glorp Wisdom (pt. 312): Don’t reuse objects in exclusive relationships!

There are days when you hunt for a bug and almost are close to giving up. On some of these, it's best to go home, play with your kids or watch a good movie and start again the next day. On some, however, you finally find out teh whole problem was just a case of … Continue reading Glorp Wisdom (pt. 312): Don’t reuse objects in exclusive relationships!