Add Query Import/Export functionality

[maxpatiiuk]

Add ability to export and import queries between users and databases

[benritchie]

2 thoughts:
worth noting there's currently a quite good workaround for sharing queries between users: (also works with record sets)

• send the URL of the query to another user.
• They can then click save, to add it to their queries.
  As a side note, assume this will continue to work with the reworked UI?

For me, more useful than import / export would be a concept of shared queries.
the problem with import/export is that everyone ends up with slightly different version of the queries, doesn't get new queries automatically that are added later, etc.
what I'd love to be able to do would be to add "shared" queries, which automatically are available to all users. - and updates to them are again available to all users.

[maxpatiiuk]

Hi,
Yes, you would still be able to share queries by sending the URL to a different user.
Query import/export has been added as it is more explicit, as many users don't know about the "URL hack".
Additionally, this new method allows for importing/exporting queries between different databases.

As far as shared queries (and we already have a bug open for it - #256), there are some complexities. For example, who sees shared queries (would every shared query be visible to all users in the institution? in the collection?). Who has permission to modify or delete them?

Until we add a record-level permission system, a satisfactory implementation of shared queries is difficult.

[benritchie]

good to hear can still share by URL. thanks

[maxpatiiuk]

Screenshots for future reference: