You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Is your feature request related to a problem? Please describe.
We have been inconsistently implementing a modifiedBy (and others) reference field across numerous projects. This is causing an unintended side effect of slowing down the list view due to multiple queries to go and grab the reference value.
Describe the solution you'd like
Create a mongoose plugin that:
The ...By fields should be objectids referencing the linz user model.
The date... fields should be date fields.
These fields should be hidden and disabled from all forms by default. This includes things like exports and filters.
By doing this we can populate the field so that only 1 query is needed.
Describe alternatives you've considered
We can implement this per project, but I think it is something that would be useful as an audit across all projects.
Additional context
Add mongoose.set('debug', true); to a project which uses the modifiedBy and view the mongo logs. There should be 1 additional query per line.
The text was updated successfully, but these errors were encountered:
Is your feature request related to a problem? Please describe.
We have been inconsistently implementing a
modifiedBy
(and others) reference field across numerous projects. This is causing an unintended side effect of slowing down the list view due to multiple queries to go and grab the reference value.Describe the solution you'd like
Create a mongoose plugin that:
modifiedBy
,createdBy
,dateModified
,dateCreated
fields....By
fields should be objectids referencing the linz user model.date...
fields should be date fields.By doing this we can
populate
the field so that only 1 query is needed.Describe alternatives you've considered
We can implement this per project, but I think it is something that would be useful as an audit across all projects.
Additional context
Add
mongoose.set('debug', true);
to a project which uses themodifiedBy
and view the mongo logs. There should be 1 additional query per line.The text was updated successfully, but these errors were encountered: