Jump to content

Help with sorting, strange problem.


Doobeh
 Share

This topic is 7309 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi there,

I'll give you a brief overview, I've just finished a database, and one aspect holds date ordered notes in a portal (note,date,user,id_no are the fields in the related file) The relationship is specified to sort the date desending.

Okay. It works, when I enter a new note it gets shuffled depending on the date perfectly. But, and heres the kicker, I imported about.. 10,000 entries into the portal for the clients, for some reason the portal doesnt sort these entries, only new ones. Can you think why? The date is exactly the same format. So basically if i were viewing the portal for X client I might get:

code:


Gone Fishing Dean 27/10/2000

Went to meet Bob Mark 25/06/2001

Client agreed to work June 09/04/1998


Which obviously isnt sorting it, but if i then added 2 new entries [today and tomorrow] I would get:

code:


Gone Fishing Dean 27/10/2000

Went to meet Bob Mark 25/06/2001

Second Entry Doobeh 10/10/2001

First Entry Doobeh 09/10/2001

Client agreed to work June 09/04/1998


So you can see, it sorts my new entries, but totally ignores the old ones.

Any ideas you can think of, it's probably quite easy (or I hope it is), but I'm quite unaware of the workaround smile.gif" border="0

Thankyou!

Doobeh.

Link to comment
Share on other sites

Indexing on doesnt seem to make any difference, good idea though, I'm using file maker pro 5.5, It's just beyond me why it doesn't work, maybe I have to somehow put the notes database in order, oh I not sure, a few more coffee's might help *wanders off to kitchen*

Thanks for the help all, keep those ideas coming smile.gif" border="0

Regards,

Doobeh.

Link to comment
Share on other sites

Try this...

Create another field in the portal (Related File)

Define a calculated number field, to the date field.

cDate = DateField [result number, indexed]

This will generate the numerical value of the date entered from 1/1/0001 till now. Then in the relationship define it to sort decending on this number field.

I think it may have something to do with the field formatting, It appears your formatting is day/month/year...

Link to comment
Share on other sites

Sounds like a plan smile.gif" border="0 I'll try it when I get back to my main computer this evening.

The formatting is day/month/year because I am in England, thats how we deal with them over here across the water, filemaker seems to get the date formatting from the system, so it adapts and works fine (you can still validate via date perfectly).

Thanks for the idea, I'll let you know how I get on smile.gif" border="0 you'll either hear cries of thanks and joy, or woe smile.gif" border="0 hehe, thanks again.

Regards,

Doobeh.

Link to comment
Share on other sites

Unfortunaltly it didn't work, I'll explain how I did it, because maybe I carried out one of the stages incorrectly.

go into the notes db, the related one used for the portal, create a new field cdate, its indexed and is a calculation, the calculation is:

dbdate (this is the date field in the notes db)

with the result as a number. I dont think I could have had made a mistake about that. so I assume the problem is with the next part.

I go to the main database's relationships, I have a relationship set to idno = ::idno (unique identifier for each client) then sort the related file by cdate in descending order.

It doesnt actually seem to change the order of anything in the portal, so once again im lost for what to do, any more ideas, or corrections on how I went about the above?

Regards,

Doobeh.

Link to comment
Share on other sites

!!

Oh my smile.gif" border="0 You hit the nail on the head, I hadn't set the date field as a date field, only the input as the creation date, golly smile.gif" border="0 *rubs the egg off his face*

Thank you a great deal, human stupidity should never be underestimated, especially in my case.

Regards,

Doobeh.

[ October 15, 2001: Message edited by: Doobeh ]

Link to comment
Share on other sites

This topic is 7309 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.