Skip to content

Make attempt_created faster to query from database #645

@fulldecent

Description

@fulldecent

When the attempt_created event fires, it creates an event keyed against:

  • userid
  • questionnaireid
  • (It does NOT specify a questionnaire_response.id)

If the event could please also set the objecttable to questionnaire_response and set objectid to the questionnaire_response.id, that would help to look up the relevant object in the database.

Or alternatively, please add a database index on (userid, questionnaireid) so that query will not be slow.


Example

Image

And more

And additionally can we please fill in the objecttable and objectid fields

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions