In the documentation it says the order in which the records are returned is undefined. However in my observations FDS always appears to work upwards in terms of record_id so older records are returned first. Can I ask when is it the case that it is not this since from time to time I may have a record that may supersede an earlier record but I cannot use the FDS update function since there be '000s of records sharing the same file ID and record key? The record value contains another key that I can use to determine which one is the current one.
Many thanks in advance.