Dan Hogan - 2018-03-19

I work on a project where a few of non-developers are using SQL Explorer to look directly at database data while doing things like UI testing. We each have test data assigned to us that we can manipulate without interfering with the work of others.

Currently, I save a text copy of a lot of relevent queries each including a WHERE command including my target data. I'd like to keep an offline copy of my assigned record numbers so I can quickly query my list along with the live test database.

Idealy, this would be an offline file that could live on my local PC or in a share folder. It would only need to be a few columns of data -- just the basic reference and maybe two or three columns to track how I use each one -- so managing it could be a very manual process.

Any thoughts on how I might go about doing this? It appears SQL Explorer does not support local files.