{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "### Requirements\n", "\n", "- Installed git. More on how to use and install git can be found [here][git]. \n", "- A zip of the certificate. Particularly, you'll need the crt and key files.\n", "- A labkey access configuration file. A sample for [linux][linuxConfig] or [Windows][windowsConfig]. The file paths point to locations of extracted files from certificate zip on your disk.\n", "\n", "[git]: https://git-scm.com/\n", "[linuxConfig]: https://git0.fmf.uni-lj.si/studen/labkeyInterface/src/master/network-config-sample.json\n", "[windowsConfig]: https://git0.fmf.uni-lj.si/studen/labkeyInterface/src/master/network-config-sample.json" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "loadLibrary\n", "remoteSourcesURL https://git0.fmf.uni-lj.si/studen/nixSuite/raw/master/remoteResources/resources.json\n", "{'labkeyInterface': {'url': 'https://git0.fmf.uni-lj.si/studen/labkeyInterface/archive/master.zip', 'branch': 'master', 'modules': []}, 'irAEMM': {'url': 'https://git0.fmf.uni-lj.si/studen/iraemm/archive/master.zip', 'branch': 'master', 'modules': ['iraemmBrowser']}, 'SlicerLabkeyExtension': {'url': 'https://git0.fmf.uni-lj.si/studen/SlicerLabkeyExtension/archive/SlicerExtensionIndex.zip', 'branch': 'SlicerExtensionIndex', 'modules': ['labkeyBrowser']}, 'limfomiPET': {'url': 'https://git0.fmf.uni-lj.si/studen/limfomiPET/archive/master.zip', 'branch': 'master', 'modules': ['imageBrowser', 'segmentationBrowser']}, 'parseConfig': {'url': 'https://git0.fmf.uni-lj.si/studen/parseConfig/archive/master.zip', 'branch': 'master', 'modules': []}, 'orthancInterface': {'url': 'https://git0.fmf.uni-lj.si/studen/orthancInterface/archive/master.zip', 'branch': 'master', 'modules': []}}\n", "{'url': 'https://git0.fmf.uni-lj.si/studen/labkeyInterface/archive/master.zip', 'branch': 'master', 'modules': []}\n", "File C:\\Users\\studen\\temp\\labkeyInterface.zip: True\n" ] } ], "source": [ "#load required libraries\n", "import sys\n", "import os\n", "import SimpleITK\n", "import numpy\n", "import matplotlib.pyplot\n", "import chardet\n", "import json\n", "\n", "#you should get nixSuite via git clone https://git0.fmf.uni-lj.si/studen/nixSuite.git\n", "#if you don't put it to $HOME/software/src/, you should update the path\n", "nixSuite=os.path.join(os.path.expanduser('~'),'software','src','nixSuite')\n", "sys.path.append(os.path.join(nixSuite,'wrapper'))\n", "import nixWrapper\n", "nixWrapper.loadLibrary('labkeyInterface')\n", "import labkeyInterface\n", "import labkeyDatabaseBrowser\n", "import labkeyFileBrowser\n", "\n", "def connectDB(server):\n", " net=labkeyInterface.labkeyInterface()\n", " fconfig=os.path.join(os.path.expanduser('~'),'.labkey','{}.json'.format(server))\n", " \n", " net.init(fconfig)\n", " #this reports the certificate used\n", " #This gets a deafult CSRF code; It should report user name plus a long string of random hex numbers\n", " net.getCSRF()\n", " return labkeyDatabaseBrowser.labkeyDB(net)" ] }, { "cell_type": "code", "execution_count": 22, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "User: andrej studen CSRF: 9d9762bd7dfbb0e54d684e522df3a22f\n", "Queries ['imageTransferReport']\n", "List 1678913582089 imageTransferReport 1\n", "Study 1678913582089 imageTransferReport 1\n", "User: andrej studen CSRF: 69507afcb824ac3464a82e657e410604\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 544,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20180105\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:10:21\",\\n \"SequenceNum\" : 913582089.0000,\\n \"ParticipantId\" : \"6780/05\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.6780/05.913582089.0000\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678913582089\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.6780/05.805281932.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: eb8f34720c5a08e9eea573765a2b9d79\n", "List 1678913677872 imageTransferReport 1\n", "Study 1678913677872 imageTransferReport 1\n", "User: andrej studen CSRF: 0e11d1e18598dd3ff05b8019eefef28d\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 545,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20180720\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 913677872.0000,\\n \"Created\" : \"2023/03/20 16:10:22\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.6780/05.913677872.0000\",\\n \"ParticipantId\" : \"6780/05\",\\n \"imagingVisitId\" : 2,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678913677872\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.6780/05.805281932.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 59f7ecfbfc44645b87f14619b1ac4a34\n", "List 1678913756244 imageTransferReport 1\n", "Study 1678913756244 imageTransferReport 1\n", "User: andrej studen CSRF: 077fc01a01ae82e28735bfa947d8c9e3\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 546,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20200326\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:10:24\",\\n \"SequenceNum\" : 913756244.0000,\\n \"ParticipantId\" : \"676/96\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.676/96.913756244.0000\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678913756244\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.676/96.77842022.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: b9f159fc6c5f5b871f7747fe1904d054\n", "List 1678913789731 imageTransferReport 1\n", "Study 1678913789731 imageTransferReport 1\n", "User: andrej studen CSRF: fbfea65e03ec11635725635d408a50b8\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 547,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20201006\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:10:25\",\\n \"SequenceNum\" : 913789731.0000,\\n \"ParticipantId\" : \"676/96\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.676/96.913789731.0000\",\\n \"imagingVisitId\" : 2,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678913789731\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.676/96.77842022.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: e750c8c86fd8f1c4a182fdcdc0de8c14\n", "List 1678913833288 imageTransferReport 1\n", "Study 1678913833288 imageTransferReport 1\n", "User: andrej studen CSRF: 87ed94e8477c08d9b1f2885ddc51b281\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 548,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20180221\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 913833288.0000,\\n \"Created\" : \"2023/03/20 16:10:26\",\\n \"ParticipantId\" : \"691/18\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.691/18.913833288.0000\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678913833288\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.691/18.85720306.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 04f6eaac9559912d194fadc785f6c477\n", "List 1678913865491 imageTransferReport 1\n", "Study 1678913865491 imageTransferReport 1\n", "User: andrej studen CSRF: 7dd0deefaa75824e82e79f50f310780b\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 549,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20180724\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 913865491.0000,\\n \"Created\" : \"2023/03/20 16:10:27\",\\n \"ParticipantId\" : \"691/18\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.691/18.913865491.0000\",\\n \"imagingVisitId\" : 2,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678913865491\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.691/18.85720306.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 6326a527a66ff3f55ed750cbc454ce98\n", "List 1678913893349 imageTransferReport 1\n", "Study 1678913893349 imageTransferReport 1\n", "User: andrej studen CSRF: a2111c57f79c4c32b6d8bc508619f1f2\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 550,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20200922\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:10:29\",\\n \"SequenceNum\" : 913893349.0000,\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.5503/20.913893349.0000\",\\n \"ParticipantId\" : \"5503/20\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678913893349\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.5503/20.85753455.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: d530e637b88d3462f8034ca810dae3cd\n", "List 1678913917882 imageTransferReport 1\n", "Study 1678913917882 imageTransferReport 1\n", "User: andrej studen CSRF: 23da9f02816ac40f0601e5bb6e593e81\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 551,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20210325\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 913917882.0000,\\n \"Created\" : \"2023/03/20 16:10:30\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.5503/20.913917882.0000\",\\n \"ParticipantId\" : \"5503/20\",\\n \"imagingVisitId\" : 2,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678913917882\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.5503/20.85753455.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 3393e86ab2e3985d2efb1c442f74cb7c\n", "List 1678913955250 imageTransferReport 1\n", "Study 1678913955250 imageTransferReport 1\n", "User: andrej studen CSRF: d2118de843a05111784a722e6eb3ea6e\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 552,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20190306\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:10:31\",\\n \"SequenceNum\" : 913955250.0000,\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.951/19.913955250.0000\",\\n \"ParticipantId\" : \"951/19\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678913955250\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.951/19.85785081.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 43e4087a453adde53547cc8c35efdc25\n", "List 1678913983202 imageTransferReport 1\n", "Study 1678913983202 imageTransferReport 1\n", "User: andrej studen CSRF: 9ee492a5f196a4c47b3b3b34f1459fde\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 553,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20190717\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:10:32\",\\n \"SequenceNum\" : 913983202.0000,\\n \"ParticipantId\" : \"951/19\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.951/19.913983202.0000\",\\n \"imagingVisitId\" : 2,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678913983202\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.951/19.85785081.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: b49144231b7e1176c0350fb98abfedf2\n", "List 1678914006471 imageTransferReport 1\n", "Study 1678914006471 imageTransferReport 1\n", "User: andrej studen CSRF: 148673422f46f7b2520327287342e17b\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 554,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20180925\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:10:33\",\\n \"SequenceNum\" : 914006471.0000,\\n \"ParticipantId\" : \"195/06\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.195/06.914006471.0000\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914006471\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.195/06.85826231.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 3feb9a288f88665ec3d97122bdb4407a\n", "List 1678914032927 imageTransferReport 1\n", "Study 1678914032927 imageTransferReport 1\n", "User: andrej studen CSRF: 5b5d762d2b03662cd8b09edd6e87b189\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 555,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20190408\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 914032927.0000,\\n \"Created\" : \"2023/03/20 16:10:34\",\\n \"ParticipantId\" : \"195/06\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.195/06.914032927.0000\",\\n \"imagingVisitId\" : 2,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914032927\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.195/06.85826231.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 35144c67c94cdabb2d0f4196eebb9d6a\n", "List 1678914060412 imageTransferReport 1\n", "Study 1678914060412 imageTransferReport 1\n", "User: andrej studen CSRF: 2ef7983dd78795205396c6d8090ce84e\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 556,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20190715\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:10:36\",\\n \"SequenceNum\" : 914060412.0000,\\n \"ParticipantId\" : \"195/06\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.195/06.914060412.0000\",\\n \"imagingVisitId\" : 3,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914060412\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.195/06.85826231.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: e7268a5eaefc10d98ee9c95600b3eb3f\n", "List 1678914086129 imageTransferReport 1\n", "Study 1678914086129 imageTransferReport 1\n", "User: andrej studen CSRF: 30cc21ce13418c8246bfeff213dc9856\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 557,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20180226\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:10:37\",\\n \"SequenceNum\" : 914086129.0000,\\n \"ParticipantId\" : \"1041/18\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.1041/18.914086129.0000\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914086129\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.1041/18.85858415.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 4d837f715a5010613ee368762eb600d9\n", "List 1678914112560 imageTransferReport 1\n", "Study 1678914112560 imageTransferReport 1\n", "User: andrej studen CSRF: 7622cd03e2f47ddba405bb042060fd9e\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 558,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20180921\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 914112560.0000,\\n \"Created\" : \"2023/03/20 16:10:38\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.1041/18.914112560.0000\",\\n \"ParticipantId\" : \"1041/18\",\\n \"imagingVisitId\" : 2,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914112560\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.1041/18.85858415.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 65b4c57ed9b59049dd1042ed9efa296f\n", "List 1678914143318 imageTransferReport 1\n", "Study 1678914143318 imageTransferReport 1\n", "User: andrej studen CSRF: f3fc8f1ab23ab8181d11ead8a7bd5c79\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 559,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20181029\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 914143318.0000,\\n \"Created\" : \"2023/03/20 16:10:39\",\\n \"ParticipantId\" : \"6176/18\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.6176/18.914143318.0000\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914143318\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.6176/18.85893927.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 8de150c0d97b57b5e16b253cda986ca9\n", "List 1678914171174 imageTransferReport 1\n", "Study 1678914171174 imageTransferReport 1\n", "User: andrej studen CSRF: 8a1b3661e46e3c586e8acf990660dc3a\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 560,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20190503\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:10:40\",\\n \"SequenceNum\" : 914171174.0000,\\n \"ParticipantId\" : \"6176/18\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.6176/18.914171174.0000\",\\n \"imagingVisitId\" : 2,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914171174\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.6176/18.85893927.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: a26fdab4fd37aba5cc62d6f6b8f49b8f\n", "List 1678914194582 imageTransferReport 1\n", "Study 1678914194582 imageTransferReport 1\n", "User: andrej studen CSRF: 15851308d88f8ea61baa5d456385bba3\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 561,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20200518\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:10:42\",\\n \"SequenceNum\" : 914194582.0000,\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.2352/20.914194582.0000\",\\n \"ParticipantId\" : \"2352/20\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914194582\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.2352/20.85925151.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 8dd7f2970a023376b3ed75c87da3448e\n", "List 1678914220091 imageTransferReport 1\n", "Study 1678914220091 imageTransferReport 1\n", "User: andrej studen CSRF: 69094ee13378d3dedd5d06256797ad6e\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 562,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20201001\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 914220091.0000,\\n \"Created\" : \"2023/03/20 16:10:43\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.2352/20.914220091.0000\",\\n \"ParticipantId\" : \"2352/20\",\\n \"imagingVisitId\" : 2,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914220091\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.2352/20.85925151.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 027b6e8f6803b568973ff51bfbef3aa7\n", "List 1678914261370 imageTransferReport 1\n", "Study 1678914261370 imageTransferReport 1\n", "User: andrej studen CSRF: 2adfed4bba2cce8390232d3a79fdf471\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 563,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20181022\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 914261370.0000,\\n \"Created\" : \"2023/03/20 16:10:44\",\\n \"ParticipantId\" : \"7211/90\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.7211/90.914261370.0000\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914261370\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.7211/90.85955178.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: b7dbd79b9a10acb2fd32a27a1826ff36\n", "List 1678914285336 imageTransferReport 1\n", "Study 1678914285336 imageTransferReport 1\n", "User: andrej studen CSRF: 8adfab41d89e6f5fc37dfa57e27d835e\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 564,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20190514\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 914285336.0000,\\n \"Created\" : \"2023/03/20 16:10:45\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.7211/90.914285336.0000\",\\n \"ParticipantId\" : \"7211/90\",\\n \"imagingVisitId\" : 2,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914285336\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.7211/90.85955178.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: ddc312c0d17b12153c2df17051216079\n", "List 1678914308320 imageTransferReport 1\n", "Study 1678914308320 imageTransferReport 1\n", "User: andrej studen CSRF: 36b231d868173bdc6dbc8130f98515aa\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 565,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20190902\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:10:46\",\\n \"SequenceNum\" : 914308320.0000,\\n \"ParticipantId\" : \"7211/90\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.7211/90.914308320.0000\",\\n \"imagingVisitId\" : 3,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914308320\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.7211/90.85955178.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: f1677f625fa315652bc5110739ebc8f0\n", "List 1678914330974 imageTransferReport 1\n", "Study 1678914330974 imageTransferReport 1\n", "User: andrej studen CSRF: cfd5b50cdf153b216743d444ce4d1570\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 566,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20190517\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 914330974.0000,\\n \"Created\" : \"2023/03/20 16:10:48\",\\n \"ParticipantId\" : \"2074/19\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.2074/19.914330974.0000\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914330974\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.2074/19.85994148.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 2074b67a8e75475e75179f8c81e58bb2\n", "List 1678914355532 imageTransferReport 1\n", "Study 1678914355532 imageTransferReport 1\n", "User: andrej studen CSRF: 5074f7662d12fcb7c868dff68d87db6b\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 567,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20191118\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:10:49\",\\n \"SequenceNum\" : 914355532.0000,\\n \"ParticipantId\" : \"2074/19\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.2074/19.914355532.0000\",\\n \"imagingVisitId\" : 2,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914355532\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.2074/19.85994148.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: c713efcccec002f6203979979bb6eacb\n", "List 1678914380420 imageTransferReport 1\n", "Study 1678914380420 imageTransferReport 1\n", "User: andrej studen CSRF: ae160288fad0e29e1653fb3f2aa79f09\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 568,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20200806\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:10:50\",\\n \"SequenceNum\" : 914380420.0000,\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.5321/20.914380420.0000\",\\n \"ParticipantId\" : \"5321/20\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914380420\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.5321/20.315526020.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 17a23f1ebe7e7f3aa938133b70ae369f\n", "List 1678914405818 imageTransferReport 1\n", "Study 1678914405818 imageTransferReport 1\n", "User: andrej studen CSRF: 7d2665160f3870e8345d1026e6ff7775\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 569,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20210302\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 914405818.0000,\\n \"Created\" : \"2023/03/20 16:10:51\",\\n \"ParticipantId\" : \"5321/20\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.5321/20.914405818.0000\",\\n \"imagingVisitId\" : 2,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914405818\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.5321/20.315526020.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: cb40ddc805b470d132b83f34a73844dc\n", "List 1678914431363 imageTransferReport 1\n", "Study 1678914431363 imageTransferReport 1\n", "User: andrej studen CSRF: 660c3071caeb71aa5ac0ee0ef841e0c4\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 570,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20200406\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:10:52\",\\n \"SequenceNum\" : 914431363.0000,\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.1649/20.914431363.0000\",\\n \"ParticipantId\" : \"1649/20\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914431363\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.1649/20.315554353.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 53e49195f0a62d8d372f75205b0da4c0\n", "List 1678914453184 imageTransferReport 1\n", "Study 1678914453184 imageTransferReport 1\n", "User: andrej studen CSRF: e5f411634b0253dde3cf28b2628d1a05\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 571,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20200929\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 914453184.0000,\\n \"Created\" : \"2023/03/20 16:10:54\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.1649/20.914453184.0000\",\\n \"ParticipantId\" : \"1649/20\",\\n \"imagingVisitId\" : 2,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914453184\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.1649/20.315554353.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 5e76e4e568d5245e8176101669222ac4\n", "List 1678914481682 imageTransferReport 1\n", "Study 1678914481682 imageTransferReport 1\n", "User: andrej studen CSRF: 2d11b17f39e4b9c300bdc7155e11e98f\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 572,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20180601\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:10:55\",\\n \"SequenceNum\" : 914481682.0000,\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.2749/18.914481682.0000\",\\n \"ParticipantId\" : \"2749/18\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914481682\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.2749/18.315577408.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 6f79ea3371dbed4a7c02bb79d156755d\n", "List 1678914506856 imageTransferReport 1\n", "Study 1678914506856 imageTransferReport 1\n", "User: andrej studen CSRF: 45900878b032792f4e7a32961ef82c61\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 573,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20181214\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:10:56\",\\n \"SequenceNum\" : 914506856.0000,\\n \"ParticipantId\" : \"2749/18\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.2749/18.914506856.0000\",\\n \"imagingVisitId\" : 2,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914506856\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.2749/18.315577408.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 46c768cf1bbbe4a8f96ff4bdca94c44d\n", "List 1678914530441 imageTransferReport 1\n", "Study 1678914530441 imageTransferReport 1\n", "User: andrej studen CSRF: ca4036f3e5959fee60806a544b8ea11f\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 574,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20190314\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:10:58\",\\n \"SequenceNum\" : 914530441.0000,\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.2749/18.914530441.0000\",\\n \"ParticipantId\" : \"2749/18\",\\n \"imagingVisitId\" : 3,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914530441\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.2749/18.315577408.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: a05be90a522e12c4ccc1991143dc3a14\n", "List 1678914627792 imageTransferReport 1\n", "Study 1678914627792 imageTransferReport 1\n", "User: andrej studen CSRF: 4e92bc9bfb832e680ebff9b4eb92e296\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 575,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20180118\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:10:59\",\\n \"SequenceNum\" : 914627792.0000,\\n \"ParticipantId\" : \"94/18\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.94/18.914627792.0000\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914627792\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.94/18.316119610.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 019abc6afa44c86c884b3ee1b1dfd13e\n", "List 1678914654428 imageTransferReport 1\n", "Study 1678914654428 imageTransferReport 1\n", "User: andrej studen CSRF: 563a4341d149882434b96571d8c2575b\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 576,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20191018\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 914654428.0000,\\n \"Created\" : \"2023/03/20 16:11:00\",\\n \"ParticipantId\" : \"6647/19\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.6647/19.914654428.0000\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914654428\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.6647/19.316137488.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: fe8ddd0b21677aabda79b1282fdb22c7\n", "List 1678914678726 imageTransferReport 1\n", "Study 1678914678726 imageTransferReport 1\n", "User: andrej studen CSRF: 304763f536970350a2f70ffb1f2eb852\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 577,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20200120\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 914678726.0000,\\n \"Created\" : \"2023/03/20 16:11:01\",\\n \"ParticipantId\" : \"6647/19\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.6647/19.914678726.0000\",\\n \"imagingVisitId\" : 2,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914678726\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.6647/19.316137488.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 5c59ca672dbe0003429025a109b6d201\n", "List 1678914700222 imageTransferReport 1\n", "Study 1678914700222 imageTransferReport 1\n", "User: andrej studen CSRF: 87772004a8864d4fde2192d5d4349dc0\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 578,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20200323\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:11:02\",\\n \"SequenceNum\" : 914700222.0000,\\n \"ParticipantId\" : \"6647/19\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.6647/19.914700222.0000\",\\n \"imagingVisitId\" : 3,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914700222\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.6647/19.316137488.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: aef3772092ddcf10ec4d0a165a94bdde\n", "List 1678914722172 imageTransferReport 1\n", "Study 1678914722172 imageTransferReport 1\n", "User: andrej studen CSRF: 698b322084e9d263f1d7c6c7dd43886a\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 579,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20200118\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:11:04\",\\n \"SequenceNum\" : 914722172.0000,\\n \"ParticipantId\" : \"138/20\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.138/20.914722172.0000\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914722172\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.138/20.316171862.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 07138ca836c9f82f31b50c48dd6e458f\n", "List 1678914747987 imageTransferReport 1\n", "Study 1678914747987 imageTransferReport 1\n", "User: andrej studen CSRF: 28a3155903cacd1e748c86ccb9fdf776\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 580,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20200602\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 914747987.0000,\\n \"Created\" : \"2023/03/20 16:11:05\",\\n \"ParticipantId\" : \"138/20\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.138/20.914747987.0000\",\\n \"imagingVisitId\" : 2,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914747987\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.138/20.316171862.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: bed22b5d6ee57770b80ecb339098e934\n", "List 1678914770915 imageTransferReport 1\n", "Study 1678914770915 imageTransferReport 1\n", "User: andrej studen CSRF: 99afe885e485e6343694269a641ea953\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 581,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20200907\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:11:06\",\\n \"SequenceNum\" : 914770915.0000,\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.4847/20.914770915.0000\",\\n \"ParticipantId\" : \"4847/20\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914770915\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.4847/20.316194822.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 7c0207dc3866b706fb6c5fa1c4b9ae84\n", "List 1678914791768 imageTransferReport 1\n", "Study 1678914791768 imageTransferReport 1\n", "User: andrej studen CSRF: 2204afe9a6e7fa07de6fb1c606f46e5e\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 582,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20210204\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:11:08\",\\n \"SequenceNum\" : 914791768.0000,\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.4847/20.914791768.0000\",\\n \"ParticipantId\" : \"4847/20\",\\n \"imagingVisitId\" : 2,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914791768\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.4847/20.316194822.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 3ac837e8dd3134db895ab5eb0cfb88be\n", "List 1678914831439 imageTransferReport 1\n", "Study 1678914831439 imageTransferReport 1\n", "User: andrej studen CSRF: 2821f08d1c5aad2549325a20086bd73e\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 583,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20190419\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 914831439.0000,\\n \"Created\" : \"2023/03/20 16:11:09\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.2029/19.914831439.0000\",\\n \"ParticipantId\" : \"2029/19\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914831439\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.2029/19.316577458.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 119dc28466015a5c59e161ab7fda3a21\n", "List 1678914859377 imageTransferReport 1\n", "Study 1678914859377 imageTransferReport 1\n", "User: andrej studen CSRF: c1602c59578a4e751b103f0ee69499d5\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 584,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20191015\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 914859377.0000,\\n \"Created\" : \"2023/03/20 16:11:10\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.2029/19.914859377.0000\",\\n \"ParticipantId\" : \"2029/19\",\\n \"imagingVisitId\" : 2,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914859377\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.2029/19.316577458.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: f903350f94f9be97ddca0dc323f2d555\n", "List 1678914880449 imageTransferReport 1\n", "Study 1678914880449 imageTransferReport 1\n", "User: andrej studen CSRF: 79cf516da11b33084f4ec6b2962e9800\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 585,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20200406\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:11:11\",\\n \"SequenceNum\" : 914880449.0000,\\n \"ParticipantId\" : \"1692/20\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.1692/20.914880449.0000\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914880449\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.1692/20.316547572.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 18db7a1b163cc99161000d7cee93db77\n", "List 1678914902327 imageTransferReport 1\n", "Study 1678914902327 imageTransferReport 1\n", "User: andrej studen CSRF: 22f1c5bc5d2d8d053ccf337b158fc3e9\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 586,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20201111\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:11:12\",\\n \"SequenceNum\" : 914902327.0000,\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.1692/20.914902327.0000\",\\n \"ParticipantId\" : \"1692/20\",\\n \"imagingVisitId\" : 2,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914902327\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.1692/20.316547572.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 033fcabcf57a8a01d53c2dc5ff0158a8\n", "List 1678914922947 imageTransferReport 1\n", "Study 1678914922947 imageTransferReport 1\n", "User: andrej studen CSRF: 00943d333a3212930fcd0ddd34936b5d\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 587,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20210318\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:11:13\",\\n \"SequenceNum\" : 914922947.0000,\\n \"ParticipantId\" : \"1692/20\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.1692/20.914922947.0000\",\\n \"imagingVisitId\" : 3,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914922947\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.1692/20.316547572.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 16ae336bb3e145ad62d1783409995e71\n", "List 1678914945309 imageTransferReport 1\n", "Study 1678914945309 imageTransferReport 1\n", "User: andrej studen CSRF: 1d17306a041d57d2cfc5a232042dd697\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 588,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20190615\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 914945309.0000,\\n \"Created\" : \"2023/03/20 16:11:15\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.2966/19.914945309.0000\",\\n \"ParticipantId\" : \"2966/19\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914945309\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.2966/19.316527206.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 367a47b19fb434a2c08995a6ca126a62\n", "List 1678914964945 imageTransferReport 1\n", "Study 1678914964945 imageTransferReport 1\n", "User: andrej studen CSRF: 38063440269bc47c7b45dc9f7f6d201e\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 589,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20191113\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 914964945.0000,\\n \"Created\" : \"2023/03/20 16:11:16\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.2966/19.914964945.0000\",\\n \"ParticipantId\" : \"2966/19\",\\n \"imagingVisitId\" : 2,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914964945\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.2966/19.316527206.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: d4af33a24935672a048f78e4fe59adfe\n", "List 1678914992427 imageTransferReport 1\n", "Study 1678914992427 imageTransferReport 1\n", "User: andrej studen CSRF: ba38a7b57984673db189e2d410292fb3\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 590,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20160420\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 914992427.0000,\\n \"Created\" : \"2023/03/20 16:11:17\",\\n \"ParticipantId\" : \"1719/19\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.1719/19.914992427.0000\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678914992427\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.1719/19.316505239.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 6b9113a954e549df0f0c104670099e42\n", "List 1678915012829 imageTransferReport 1\n", "Study 1678915012829 imageTransferReport 1\n", "User: andrej studen CSRF: 4ca97a2ac456095355f5019a51d8d869\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 591,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20190408\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 915012829.0000,\\n \"Created\" : \"2023/03/20 16:11:18\",\\n \"ParticipantId\" : \"1719/19\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.1719/19.915012829.0000\",\\n \"imagingVisitId\" : 2,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678915012829\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.1719/19.316505239.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 1532242093d0e0f0cfff3e51cc7f69ca\n", "List 1678915042005 imageTransferReport 1\n", "Study 1678915042005 imageTransferReport 1\n", "User: andrej studen CSRF: f3d96ac8a981dfdc27c2b629d4b4385d\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 592,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20190830\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 915042005.0000,\\n \"Created\" : \"2023/03/20 16:11:20\",\\n \"ParticipantId\" : \"1719/19\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.1719/19.915042005.0000\",\\n \"imagingVisitId\" : 3,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678915042005\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.1719/19.316505239.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: c75b227b274b5954afba24fd7de03310\n", "List 1678916454071 imageTransferReport 1\n", "Study 1678916454071 imageTransferReport 1\n", "User: andrej studen CSRF: 24537f11e1ba4a5f54f460bdd872afc3\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 593,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20201123\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:11:21\",\\n \"SequenceNum\" : 916454071.0000,\\n \"ParticipantId\" : \"6799/20\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.6799/20.916454071.0000\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678916454071\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.6799/20.316454597.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 7ff00fec345c67a2b6d24da9ab3416f3\n", "List 1678916482395 imageTransferReport 1\n", "Study 1678916482395 imageTransferReport 1\n", "User: andrej studen CSRF: a47c3d039155535b77e78634f0bccdc3\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 594,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20210527\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 916482395.0000,\\n \"Created\" : \"2023/03/20 16:11:23\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.6799/20.916482395.0000\",\\n \"ParticipantId\" : \"6799/20\",\\n \"imagingVisitId\" : 2,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678916482395\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.6799/20.316454597.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: a7bf849ffc14d8719dec8542ffcbf415\n", "List 1678916505503 imageTransferReport 1\n", "Study 1678916505503 imageTransferReport 1\n", "User: andrej studen CSRF: 35c9a9cb47641563868e22cd085319e1\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 595,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20210727\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:11:24\",\\n \"SequenceNum\" : 916505503.0000,\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.6799/20.916505503.0000\",\\n \"ParticipantId\" : \"6799/20\",\\n \"imagingVisitId\" : 3,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678916505503\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.6799/20.316454597.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 283aca53bcde635dd9d89e3a1dd6ed5d\n", "List 1678916531804 imageTransferReport 1\n", "Study 1678916531804 imageTransferReport 1\n", "User: andrej studen CSRF: 4616bff9683ce84614a1abf234c8adea\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 596,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20190709\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:11:25\",\\n \"SequenceNum\" : 916531804.0000,\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.269/19.916531804.0000\",\\n \"ParticipantId\" : \"269/19\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678916531804\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.269/19.316428837.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 9de75c86fff682189cdaa469b99ad3f7\n", "List 1678916553013 imageTransferReport 1\n", "Study 1678916553013 imageTransferReport 1\n", "User: andrej studen CSRF: b4f4d0b65f4651dbf0412c2fddbe21a1\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 597,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20191216\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:11:26\",\\n \"SequenceNum\" : 916553013.0000,\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.269/19.916553013.0000\",\\n \"ParticipantId\" : \"269/19\",\\n \"imagingVisitId\" : 2,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678916553013\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.269/19.316428837.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: aa5dd5656bb3a624dcafb51087ac78e0\n", "List 1678916574996 imageTransferReport 1\n", "Study 1678916574996 imageTransferReport 1\n", "User: andrej studen CSRF: e7d482106e473b6d472b2afe153006d4\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 598,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20190527\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:11:28\",\\n \"SequenceNum\" : 916574996.0000,\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.2472/19.916574996.0000\",\\n \"ParticipantId\" : \"2472/19\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678916574996\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.2472/19.316407799.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 05207a883c9f50f25739620c15f1c49c\n", "List 1678916595887 imageTransferReport 1\n", "Study 1678916595887 imageTransferReport 1\n", "User: andrej studen CSRF: 3241e448349926beb58bb1c48ddef4fe\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 599,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20200127\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 916595887.0000,\\n \"Created\" : \"2023/03/20 16:11:29\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.2472/19.916595887.0000\",\\n \"ParticipantId\" : \"2472/19\",\\n \"imagingVisitId\" : 2,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678916595887\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.2472/19.316407799.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 81570280786f7abba0951a30a9ef7f85\n", "List 1678916615560 imageTransferReport 1\n", "Study 1678916615560 imageTransferReport 1\n", "User: andrej studen CSRF: d26c3560ab6ad1ca26c211a0475b3938\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 600,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20200722\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:11:30\",\\n \"SequenceNum\" : 916615560.0000,\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.2472/19.916615560.0000\",\\n \"ParticipantId\" : \"2472/19\",\\n \"imagingVisitId\" : 3,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678916615560\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.2472/19.316407799.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: c42ebec160252d617c853c475572babd\n", "List 1678916637199 imageTransferReport 1\n", "Study 1678916637199 imageTransferReport 1\n", "User: andrej studen CSRF: 6cc77a622b9b723865a7ceee4cdd86c4\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 601,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20191230\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 916637199.0000,\\n \"Created\" : \"2023/03/20 16:11:31\",\\n \"ParticipantId\" : \"172/20\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.172/20.916637199.0000\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678916637199\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.172/20.316380848.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 303e735f17385480b050c95199f039e9\n", "List 1678916658309 imageTransferReport 1\n", "Study 1678916658309 imageTransferReport 1\n", "User: andrej studen CSRF: 2d116af3c8681bc9bcea2a59eca8ea9d\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 602,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20200708\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:11:33\",\\n \"SequenceNum\" : 916658309.0000,\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.172/20.916658309.0000\",\\n \"ParticipantId\" : \"172/20\",\\n \"imagingVisitId\" : 2,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678916658309\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.172/20.316380848.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 04e9cb2c6cb246d05fbf0c2fa969bfbe\n", "List 1678916684813 imageTransferReport 1\n", "Study 1678916684813 imageTransferReport 1\n", "User: andrej studen CSRF: 7d7afe8d7c587bee0ea89c0dc4b30db6\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 603,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20180508\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:11:34\",\\n \"SequenceNum\" : 916684813.0000,\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.2185/18.916684813.0000\",\\n \"ParticipantId\" : \"2185/18\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678916684813\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.2185/18.316356714.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: b541fc1ee1257cf467159a0458ce0503\n", "List 1678916709722 imageTransferReport 1\n", "Study 1678916709722 imageTransferReport 1\n", "User: andrej studen CSRF: c449e294d4b7f8b307943d5c479cfb2e\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 604,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20191120\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:11:35\",\\n \"SequenceNum\" : 916709722.0000,\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.6985/19.916709722.0000\",\\n \"ParticipantId\" : \"6985/19\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678916709722\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.6985/19.316333139.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 030930ac59be70ac21ed028180fa51e0\n", "List 1678916736177 imageTransferReport 1\n", "Study 1678916736177 imageTransferReport 1\n", "User: andrej studen CSRF: 71dda24de598dab89316dc904557f93d\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 605,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20200401\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 916736177.0000,\\n \"Created\" : \"2023/03/20 16:11:36\",\\n \"ParticipantId\" : \"6985/19\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.6985/19.916736177.0000\",\\n \"imagingVisitId\" : 2,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678916736177\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.6985/19.316333139.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 8e82d719c56eb43a4ec6673f8b43a77d\n", "List 1678916757873 imageTransferReport 1\n", "Study 1678916757873 imageTransferReport 1\n", "User: andrej studen CSRF: 07118cfee492bcd9d07646478ea501a2\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 606,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20181214\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:11:37\",\\n \"SequenceNum\" : 916757873.0000,\\n \"ParticipantId\" : \"7790/18\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.7790/18.916757873.0000\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678916757873\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.7790/18.316313037.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 62f1bb0b64bad60c3174a51ff331d992\n", "List 1678916782920 imageTransferReport 1\n", "Study 1678916782920 imageTransferReport 1\n", "User: andrej studen CSRF: 619c461075a2d15c98e682d1feb1dd84\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 607,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20180615\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:11:38\",\\n \"SequenceNum\" : 916782920.0000,\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.2799/18.916782920.0000\",\\n \"ParticipantId\" : \"2799/18\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678916782920\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.2799/18.316284119.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 98b6fde53cb04a172a12989ae0e35de2\n", "List 1678916805574 imageTransferReport 1\n", "Study 1678916805574 imageTransferReport 1\n", "User: andrej studen CSRF: d517e48314cd348626b24354a372a906\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 608,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20200410\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 916805574.0000,\\n \"Created\" : \"2023/03/20 16:11:39\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.1545/20.916805574.0000\",\\n \"ParticipantId\" : \"1545/20\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678916805574\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.1545/20.316264160.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: d051ebb8ba00f6f286d009ebec53adb3\n", "List 1678916828446 imageTransferReport 1\n", "Study 1678916828446 imageTransferReport 1\n", "User: andrej studen CSRF: c98d8fe1a2c8751c8a97a9380ddb39c1\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 609,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20201006\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 916828446.0000,\\n \"Created\" : \"2023/03/20 16:11:41\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.1545/20.916828446.0000\",\\n \"ParticipantId\" : \"1545/20\",\\n \"imagingVisitId\" : 2,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678916828446\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.1545/20.316264160.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: c999804596e0aa30a7c56bee447a0a76\n", "List 1678916848137 imageTransferReport 1\n", "Study 1678916848137 imageTransferReport 1\n", "User: andrej studen CSRF: a431a41a861dafbe5a9239eded89f8ca\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 610,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20210420\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:11:42\",\\n \"SequenceNum\" : 916848137.0000,\\n \"ParticipantId\" : \"1545/20\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.1545/20.916848137.0000\",\\n \"imagingVisitId\" : 3,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678916848137\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.1545/20.316264160.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 92817fc85049e11a7b9bed6f9ca53e48\n", "List 1678916871106 imageTransferReport 1\n", "Study 1678916871106 imageTransferReport 1\n", "User: andrej studen CSRF: 61871d1a510b5c97423e3fcda600181e\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 611,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20191008\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 916871106.0000,\\n \"Created\" : \"2023/03/20 16:11:43\",\\n \"ParticipantId\" : \"5695/19\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.5695/19.916871106.0000\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678916871106\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.5695/19.316238994.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 5eced20bf7ec90fb49bbc3c27f0ff4dd\n", "List 1678916895773 imageTransferReport 1\n", "Study 1678916895773 imageTransferReport 1\n", "User: andrej studen CSRF: a8a7c822e64fbd55fc62654112a77e7f\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 612,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20200218\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"Created\" : \"2023/03/20 16:11:44\",\\n \"SequenceNum\" : 916895773.0000,\\n \"ParticipantId\" : \"5695/19\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.5695/19.916895773.0000\",\\n \"imagingVisitId\" : 2,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678916895773\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.5695/19.316238994.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: d1ab84a151428590570f160d06946017\n", "List 1678916919973 imageTransferReport 1\n", "Study 1678916919973 imageTransferReport 1\n", "User: andrej studen CSRF: eb0c394710b86483dcbeb05271a5eea0\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 613,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20190503\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 916919973.0000,\\n \"Created\" : \"2023/03/20 16:11:46\",\\n \"ParticipantId\" : \"2181/19\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.2181/19.916919973.0000\",\\n \"imagingVisitId\" : 1,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678916919973\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.2181/19.316217675.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: a3886104d26efc7b287b7e786d5f323d\n", "List 1678916943501 imageTransferReport 1\n", "Study 1678916943501 imageTransferReport 1\n", "User: andrej studen CSRF: 4f9c294a07b4ca0adedf36a49c284a85\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"imageTransferReport\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/limfomiPET/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"dsrowid\" : 614,\\n \"CreatedBy\" : 1003,\\n \"imageDate\" : \"20191008\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2023/03/15 13:00:00\",\\n \"SequenceNum\" : 916943501.0000,\\n \"Created\" : \"2023/03/20 16:11:47\",\\n \"ParticipantId\" : \"2181/19\",\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-38:5002.2181/19.916943501.0000\",\\n \"imagingVisitId\" : 2,\\n \"sourcelsid\" : null,\\n \"crfRef\" : \"1678916943501\",\\n \"participantCode\" : \"urn:lsid:labkey.com:Study.Data-38:5001.2181/19.316217675.0000\"\\n } ],\\n \"command\" : \"update\"\\n}'\n", "User: andrej studen CSRF: 4190a7c4e913e112cde959facdfd987c\n" ] } ], "source": [ "#confirm Forms (equialent to onDatabaseUpload of CRF)\n", "#works only for old version of crf on onko-nix\n", "\n", "db=connectDB('onko-nix')\n", "#select a project\n", "project='limfomiPET/Study'\n", "#dataset='Segmentation'\n", "schema='lists'\n", "\n", "formNameFilter={'variable':'formName','value':'10','oper':'eq'}#imageTransferReport\n", "dsFormSetup=db.selectRows(project,schema,'FormSetup',[formNameFilter])\n", "\n", "dsInputLists=db.selectRows(project,schema,'inputLists',[])\n", "\n", "dsDemo=db.selectRows(project,'study','demographicData',[])\n", "idData={r['lsid']:r['ParticipantId'] for r in dsDemo['rows']}\n", "\n", "iLists={r['Key']:r['queryName'] for r in dsInputLists['rows']}\n", "queries=[iLists[r['queryName']] for r in dsFormSetup['rows']]\n", "\n", "print('Queries {}'.format(queries))\n", "\n", "query='crfEntry'\n", "formFilter={'variable':'Form','value':'10','oper':'eq'}\n", "statusFilter={'variable':'FormStatus','value':'2','oper':'eq'}\n", "\n", "ds=db.selectRows(project,schema,query,[formFilter,statusFilter])\n", "rows=ds['rows']\n", "for row in rows:\n", " crfEntry=row['entryId']\n", " crfFilter={'variable':'crfRef','value':'{}'.format(crfEntry),'oper':'eq'}\n", " for q in queries:\n", " # get in list\n", " du=db.selectRows(project,'lists',q,[crfFilter])\n", " print('List {} {} {}'.format(crfEntry,q,len(du['rows'])))\n", " # get in study\n", " dus=db.selectRows(project,'study',q,[crfFilter])\n", " print('Study {} {} {}'.format(crfEntry,q,len(dus['rows'])))\n", " \n", " nStudy=len(dus['rows'])\n", " nList=len(du['rows'])\n", " for i in range(nStudy):\n", " #update\n", " targetRow=dus['rows'][i]\n", " sourceRow=du['rows'][i]\n", " sKeys=list(sourceRow.keys())\n", " tKeys=list(targetRow.keys())\n", " keys=[k for k in sKeys if k not in ['Key']]\n", " for k in keys:\n", " targetRow[k]=sourceRow[k]\n", " print(db.modifyRows('update',project,'study',q,[targetRow]))\n", " for i in range(nStudy,nList):\n", " targetRow=du['rows'][i]\n", " targetRow['SequenceNum']=(int(crfEntry) % 1000000000)+i/100\n", " \n", " targetRow['ParticipantId']=idData[targetRow['participantCode']]\n", " print('Target row {}'.format(targetRow))\n", " print(db.modifyRows('insert',project,'study',q,[targetRow]))\n", " \n", " #assume the same ordering, only that rows(study)<=rows(lists)\n", " row['FormStatus']=3 \n", " print(db.modifyRows('update',project,schema,query,[row]))\n", " \n", " #print(row)\n", " #change the value of the field in database \n", " #if field is not in database, it will NOT be added and no changes will occur\n", " #db.modifyRows('update',project,schema,query,[row]) \n", " " ] }, { "cell_type": "code", "execution_count": 36, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "User: andrej studen CSRF: 8d5073a5a0f98622de543f64ab8319cc\n", "User: andrej studen CSRF: 826b45d185e85d1780e89b3aac079a39\n", "{'ParticipantId': 'JOHN003', 'followUpDuration': 1, 'lsid': 'urn:lsid:labkey.com:Study.Data-61:5011.JOHN003.243390879.0000', '_labkeyurl_followUpDuration': '/labkey/hypoAfrica/Study/list-details.view?listId=141&pk=1', '_labkeyurl_ParticipantId': '/labkey/hypoAfrica/Study/study-participant.view?participantId=JOHN003', 'crfRef': '1649243390879', 'submissionDate': '2022/04/06 14:00:00', 'SequenceNum': 243390879.0}\n", "User: andrej studen CSRF: b0d3f22a0a97552c9877c12e0c15c803\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"consentList\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/hypoAfrica/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"followUpDuration\" : 1,\\n \"ParticipantVisit\" : \"JOHN003|243390879.0000\",\\n \"dsrowid\" : 1,\\n \"CreatedBy\" : 1003,\\n \"Modified\" : \"2022-11-29 16:16:05.479\",\\n \"DataSets\" : \"JOHN003\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2022-04-06 14:00:00.000\",\\n \"ModifiedBy\" : 1003,\\n \"Created\" : \"2022-11-29 16:16:05.479\",\\n \"SequenceNum\" : 243390879.0000,\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-14:5010.JOHN003.243390879.0000\",\\n \"ParticipantId\" : \"JOHN003\",\\n \"diImportHash\" : null,\\n \"sourcelsid\" : null,\\n \"VisitRowId\" : 12,\\n \"crfRef\" : \"1649243390879\"\\n } ],\\n \"command\" : \"insert\"\\n}'\n", "{'ParticipantId': 'NLHA001', 'followUpDuration': 3, 'lsid': 'urn:lsid:labkey.com:Study.Data-61:5011.NLHA001.640728995.0000', '_labkeyurl_followUpDuration': '/labkey/hypoAfrica/Study/list-details.view?listId=141&pk=3', '_labkeyurl_ParticipantId': '/labkey/hypoAfrica/Study/study-participant.view?participantId=NLHA001', 'crfRef': '1650640728995', 'submissionDate': '2022/04/22 14:00:00', 'SequenceNum': 640728995.0}\n", "User: andrej studen CSRF: 671b0eb80a773813544ab14ee68273d8\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"consentList\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/hypoAfrica/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"followUpDuration\" : 3,\\n \"ParticipantVisit\" : \"NLHA001|640728995.0000\",\\n \"dsrowid\" : 2,\\n \"CreatedBy\" : 1003,\\n \"Modified\" : \"2022-11-29 16:16:05.977\",\\n \"DataSets\" : \"NLHA001\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2022-04-22 14:00:00.000\",\\n \"ModifiedBy\" : 1003,\\n \"Created\" : \"2022-11-29 16:16:05.977\",\\n \"SequenceNum\" : 640728995.0000,\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-14:5010.NLHA001.640728995.0000\",\\n \"ParticipantId\" : \"NLHA001\",\\n \"diImportHash\" : null,\\n \"sourcelsid\" : null,\\n \"VisitRowId\" : 11,\\n \"crfRef\" : \"1650640728995\"\\n } ],\\n \"command\" : \"insert\"\\n}'\n", "{'ParticipantId': 'TEST001', 'followUpDuration': 1, 'lsid': 'urn:lsid:labkey.com:Study.Data-61:5011.TEST001.831036294.0000', '_labkeyurl_followUpDuration': '/labkey/hypoAfrica/Study/list-details.view?listId=141&pk=1', '_labkeyurl_ParticipantId': '/labkey/hypoAfrica/Study/study-participant.view?participantId=TEST001', 'crfRef': '1648831036294', 'submissionDate': '2022/04/01 14:00:00', 'SequenceNum': 831036294.0}\n", "User: andrej studen CSRF: 4197622f8e01491fbaba7c5f7ce6dfd8\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"consentList\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/hypoAfrica/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"followUpDuration\" : 1,\\n \"ParticipantVisit\" : \"TEST001|831036294.0000\",\\n \"dsrowid\" : 3,\\n \"CreatedBy\" : 1003,\\n \"Modified\" : \"2022-11-29 16:16:06.428\",\\n \"DataSets\" : \"TEST001\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2022-04-01 14:00:00.000\",\\n \"ModifiedBy\" : 1003,\\n \"Created\" : \"2022-11-29 16:16:06.428\",\\n \"SequenceNum\" : 831036294.0000,\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-14:5010.TEST001.831036294.0000\",\\n \"ParticipantId\" : \"TEST001\",\\n \"diImportHash\" : null,\\n \"sourcelsid\" : null,\\n \"VisitRowId\" : 7,\\n \"crfRef\" : \"1648831036294\"\\n } ],\\n \"command\" : \"insert\"\\n}'\n", "{'ParticipantId': 'TEST02', 'followUpDuration': 3, 'lsid': 'urn:lsid:labkey.com:Study.Data-61:5011.TEST02.953000497.0000', '_labkeyurl_followUpDuration': '/labkey/hypoAfrica/Study/list-details.view?listId=141&pk=3', '_labkeyurl_ParticipantId': '/labkey/hypoAfrica/Study/study-participant.view?participantId=TEST02', 'crfRef': '1668953000497', 'submissionDate': '2022/11/22 13:00:00', 'SequenceNum': 953000497.0}\n", "User: andrej studen CSRF: 38717387d1d774658ac0e25920f0fef2\n", "b'{\\n \"rowsAffected\" : 1,\\n \"queryName\" : \"consentList\",\\n \"schemaName\" : \"study\",\\n \"containerPath\" : \"/hypoAfrica/Study\",\\n \"rows\" : [ {\\n \"date\" : null,\\n \"followUpDuration\" : 3,\\n \"ParticipantVisit\" : \"TEST02|953000497.0000\",\\n \"dsrowid\" : 4,\\n \"CreatedBy\" : 1003,\\n \"Modified\" : \"2022-11-29 16:16:06.933\",\\n \"DataSets\" : \"TEST02\",\\n \"QCState\" : null,\\n \"submissionDate\" : \"2022-11-22 13:00:00.000\",\\n \"ModifiedBy\" : 1003,\\n \"Created\" : \"2022-11-29 16:16:06.933\",\\n \"SequenceNum\" : 953000497.0000,\\n \"lsid\" : \"urn:lsid:labkey.com:Study.Data-14:5010.TEST02.953000497.0000\",\\n \"ParticipantId\" : \"TEST02\",\\n \"diImportHash\" : null,\\n \"sourcelsid\" : null,\\n \"VisitRowId\" : 8,\\n \"crfRef\" : \"1668953000497\"\\n } ],\\n \"command\" : \"insert\"\\n}'\n" ] } ], "source": [ "net1=labkeyInterface.labkeyInterface()\n", "fconfig1=os.path.join(os.path.expanduser('~'),'.labkey','labkey-public.json')\n", "net1.init(fconfig1)\n", "net1.getCSRF()\n", "\n", "net2=labkeyInterface.labkeyInterface()\n", "fconfig2=os.path.join(os.path.expanduser('~'),'.labkey','labkey-klimt.json')\n", "net2.init(fconfig2)\n", "net2.getCSRF()\n", "\n", "db1=labkeyDatabaseBrowser.labkeyDB(net1)\n", "#select a project\n", "project1='hypoAfrica/Study'\n", "schema1='study'\n", "query1='consentList'\n", "\n", "db2=labkeyDatabaseBrowser.labkeyDB(net2)\n", "#select a project\n", "project2='hypoAfrica/Study'\n", "schema2='study'\n", "query2=query1\n", "#idFilter={'variable':'ParticipantId','value':'VUB_PA3','oper':'eq'}\n", "#aliasFilter={'variable':'aliasID','value':'3OBR','oper':'eq'}\n", "#empty filter\n", "qFilter=[]\n", "#qFilter can be a list of filters used in conjugation (logical AND)\n", "#qFilter=[aliasFilter]\n", "ds=db1.selectRows(project1,schema1,query1,qFilter)\n", "rows=ds['rows']\n", "for row in rows:\n", " #row as a dictionary\n", " print(row)\n", " #update row\n", " #depending on field type adjust newValue\n", " #change the value of the field in database \n", " #if field is not in database, it will NOT be added and no changes will occur\n", " print(db2.modifyRows('insert',project2,schema2,query2,[row]))\n", " " ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.9.0" } }, "nbformat": 4, "nbformat_minor": 4 }