HT display the first record of each group ?

General support questions.
Posts: 5
Joined: Fri Aug 12, 2005 7:53 am
Location: Saint-Denis (La Reunion)
PostPosted: Thu Aug 18, 2005 11:34 am
Hi !

I have record with these items:

Group_ID
Item_ID
Item_name
date_start
Status (To do , Done)

Group_ID Item_ID Item_name date_start

100 101 xxx the date
100 102 xxx the date + 1
100 103 xxx the date + 3
200 201 yyy the date
200 202 yyy the date + 4
200 203 yyy the date + 6
300 301 zzz the date

Can a portal, based on a self join, display *only the first record of each group*, ie:

100 101 xxx the date
200 201 yyy the date
300 301 zzz the date

Those records appears in the portal if the status task is defined "to do".

If impossible, another way or workaround ?

Thanks in advance

Best

Patrick
Patrick Odelin
Anaesthesiologist
La Reunion Island (Indian Ocean)
GMT + 4
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Sun Aug 21, 2005 6:39 am
One way to think of this is that you want to see one each of the group records- and for each, the first matching Item ID and Date from todo. To do this you wouldn't make a self join in todos, you'd go to a table occurrence from your Groups Table - showing one row for each record (group) - and from there show records from a relationship from Groups to todos.

One quick to this approach (one advantage?) is that it will show a row for each group even if there is no relevant todo for that group. This can be good in the "group 102" will always be on the second line, not sometimes on the first line if group 101 has not undone todos.

Of course, if you don't already have a table for Groups, you'll need to make one.

Hope that helps.
John Sindelar
SeedCode
Posts: 5
Joined: Fri Aug 12, 2005 7:53 am
Location: Saint-Denis (La Reunion)
PostPosted: Mon Aug 22, 2005 12:46 am
Thank you John !

I'll try this soon

Best

Patrick
Patrick Odelin
Anaesthesiologist
La Reunion Island (Indian Ocean)
GMT + 4

Return to General Support

Who is online

Users browsing this forum: No registered users and 3 guests

cron
(855) SEEDCODE
[email protected]
Follow us: