sorting relationship field

steadysnail

2 months ago

4

• 

  notchr

  2 months ago

  @steadysnail You could create a beforeRead hook that sorts the document

  
  

  
  

  That way whenever its read, you control the order

• 

  Raoul

  2 months ago

  is this stilla active?

  
  
  
  

  const beforeReadHook: CollectionBeforeReadHook = async ({

  
  

  doc, // full document data

  
  

  req, // full express request

  
  

  query, // JSON formatted query

  
  

  }) => {

  
  

  //WOULD YOU DO THE SORTING HERE?

  
  

  return doc;

  
  

  };

• 

  notchr

  2 months ago

  @Raoul Yes the sorting would happen on the doc object to be returned

• 

  steadysnail

  last month

  @notchr Thanks for replying, and please excuse my late reply. Trying to sort via a beforeRead hook doesn't seem to work because the hook runs for every record in the collection instead of once for all records. When I console.log ("doc", doc) in the beforeReadHook I get the following:

  
  

  doc: {
    id: '0.0.27',
    sortableTag: 1000100028000,
    createdAt: '2023-08-02T18:42:36.444Z',
    updatedAt: '2023-08-02T18:42:36.444Z'
  }
  doc: {
    id: '0.0.26',
    sortableTag: 1000100027000,
    createdAt: '2023-08-02T18:42:36.444Z',
    updatedAt: '2023-08-02T18:42:36.444Z'
  }
  doc: {
    id: '0.0.25',
    sortableTag: 1000100026000,
    createdAt: '2023-08-02T18:42:36.448Z',
    updatedAt: '2023-08-02T18:42:36.448Z'
  }
  doc: {
    id: '0.0.24',
    sortableTag: 1000100025000,
    createdAt: '2023-08-01T14:43:42.234Z',
    updatedAt: '2023-08-01T14:43:42.234Z'
  }
  doc: {
    id: '0.0.23',
    sortableTag: 1000100024000,
    createdAt: '2023-08-01T14:43:42.234Z',
    updatedAt: '2023-08-01T14:43:42.234Z'
  }
  doc: {
    id: '0.0.22',
    sortableTag: 1000100023000,
    createdAt: '2023-08-01T14:43:42.234Z',
    updatedAt: '2023-08-01T14:43:42.234Z'
  }