 | |
Re: sorting in a portal
comp.databases.filemaker comp.databases.filemaker
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: sorting in a portal -
06-17-2007
, 10:11 AM
|
Hi group, I am using FMP5 on a Win2K machine. I have a database with a portal to a second database. The portal shows fields like the following: Date Name Notice Sum 12.02.2002 Meier 2002 150,- 24.03.2003 Iris 2003 75,- 12.02.2001 Doris 2000+2001 150,- I want to have it sorted by date, which is done in the database the portal relies on itself but not in the portal. I don't know exactly if I am right but I do have the impression that the the field "Notice" causes the trouble. It is a text-field but whenever it contains not only the 4-digit-year-number but more this data gets sorted to the end instead of being sorted by date. How can I change this? Thanks Raimund. |
field. You might be able t osplit the date off by using a calculation.
Depending in the format of the date field you will need a number of
functions inside the calculation. Since you haven't given an example I can't
help you here. The end result should be a valid date field on which the
portal can be sorted.
Keep well, Ursus
#2
| |||
| |||
|
|
Hi group, I am using FMP5 on a Win2K machine. I have a database with a portal to a second database. The portal shows fields like the following: Date Name Notice Sum 12.02.2002 Meier 2002 150,- 24.03.2003 Iris 2003 75,- 12.02.2001 Doris 2000+2001 150,- I want to have it sorted by date, which is done in the database the portal relies on itself but not in the portal. I don't know exactly if I am right but I do have the impression that the the field "Notice" causes the trouble. It is a text-field but whenever it contains not only the 4-digit-year-number but more this data gets sorted to the end instead of being sorted by date. How can I change this? Thanks Raimund. |
by the correct field.
Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)
#3
| |||
| |||
|
|
Hi Ursus, I am using FMP5 on a Win2K machine. I have a database with a portal to a second database. The portal shows fields like the following: Date Name Notice Sum 12.02.2002 Meier 2002 150,- 24.03.2003 Iris 2003 75,- 12.02.2001 Doris 2000+2001 150,- I want to have it sorted by date, which is done in the database the portal relies on itself but not in the portal. I don't know exactly if I am right but I do have the impression that the the field "Notice" causes the trouble. It is a text-field but whenever it contains not only the 4-digit-year-number but more this data gets sorted to the end instead of being sorted by date. If the date field has more then just a date then it really is not a date field. You might be able t osplit the date off by using a calculation. Depending in the format of the date field you will need a number of functions inside the calculation. Since you haven't given an example I can't help you here. The end result should be a valid date field on which the portal can be sorted. Sorry for the misunderstanding, but my list above is composed of separate fields: Date = a date-field Name = a text-field Notice = a text-field Sum = a number-field These 4 fields compose a data-"row" and the rows should be sorted by the date-field which is only possible in the databsae itself but not in the portal where I get the sorting as shown above. Thanks for any help, Raimund. |
calculation that is shown in the portal. The portal may be sorted on any
field, this field doesn't need to be inside the portal.
Keep well, Ursus
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.