mORMot Open Source

gothbert

Member

Registered: 2017-11-08

Posts: 12

FTS: best practice for multiple documents per object

Hi,

my use case is as follows:
- several classes (TSQLRecordPerson, TSQLRecordLocation, ...) with one-to-many relationships to documents
- one document belongs to exactly one object
The documents are derived from TSQLRecordFTS5Unicode61.

According to SAD and this post, it is best to use TRecordReferenceToBeDeleted as DocID. Thus the returned DocID set from an FTS query allows direct access to the related TSQLRecordPerson, TSQLRecordLocation, ... objects.

Question is how to extend this to the case of several documents per object.

Some help would be appreciated.

Best regards
Boris