Advice on debtor calcualtions - newbie still

Classic Servoy
1

Hi All,

I was wondering if someone could give me some advice. I need to show a clients current, 30, 60 , 90 and over amounts from a related table accounts in a client form.

In my previous experience, I would have run seperate SQL queries and displayed the SUM’s in seperate fields. I gather from Servoy and what I have learnt so far, I should be using either relations or calculations/aggregations.

Any input is appreciated as I don’t want to start writing a bunch of queries when I could have set this up via the Dataproviders/Relations.

Dave

2

You can do it with your own SQL query if you want - or you can do it with an aggregation on the CHILD file - and then 3 relations (one for 30, 60, 90 days).

When you use an aggregation in Servoy - we do a separate SUM query for that piece of data (just like you would if you did it yourself).

Hope this helps.