Type:
New Feature
Status:
Closed
Priority:
Major
Resolution:
Completed
Affects Version/s:
None
i2b2 Sponsored Project/s:
Developer Notes:
The 4 CRC DBlookup WS Msgs (getAllDblookups, setDblookup, getDblookup, and deleteDblookup) have been checked into GitHUB for 1.7.0.8, and are ready to be tested. Refer to the CRC_Messaging_1-7-0-8.docx
Testing Notes:
Hide
While testing the new db lookup services I verified the following:
1. The get_all_dblookups message returns all the appropriate data for each cell (individual lookups performed).
2. The set_dblookups message enabled me to add a new entry into each of the DB_LOOKUP tables as well as edit existing entries.
3. The get_dblookups message returned all the appropriate data for a single entry in the DB_LOOKUP tables.
4. The delete_dblookups message allowed me to remove an entry from the DB_LOOKUP tables.
These messages are specific to the cell, therefore when testing I ran each of the above services / messages against the following DB_LOOKUP tables:
1. CRC_DB_LOOKUP
2. FR_DB_LOOKUP
3. IM_DB_LOOKUP
4. ONT_DB_LOOKUP
5. WORK_DB_LOOKUP
Show
While testing the new db lookup services I verified the following:
1. The get_all_dblookups message returns all the appropriate data for each cell (individual lookups performed).
2. The set_dblookups message enabled me to add a new entry into each of the DB_LOOKUP tables as well as edit existing entries.
3. The get_dblookups message returned all the appropriate data for a single entry in the DB_LOOKUP tables.
4. The delete_dblookups message allowed me to remove an entry from the DB_LOOKUP tables.
These messages are specific to the cell, therefore when testing I ran each of the above services / messages against the following DB_LOOKUP tables:
1. CRC_DB_LOOKUP
2. FR_DB_LOOKUP
3. IM_DB_LOOKUP
4. ONT_DB_LOOKUP
5. WORK_DB_LOOKUP
Develop a new web service to retrieve the db lookup settings from the cell's configuration files.
Requirements: This service is only available to users who have "admin" privileges.
{"report":{"fcp":850.5999994277954,"ttfb":183.89999961853027,"pageVisibility":"visible","entityId":10801,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"303bc8a7-ecc0-41df-8ce4-74a0fc6bb64d","navigationType":0,"readyForUser":922.8000001907349,"redirectCount":0,"resourceLoadedEnd":705.0999994277954,"resourceLoadedStart":189.30000019073486,"resourceTiming":[{"duration":7.59999942779541,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":189.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":189.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":196.89999961853027,"responseStart":0,"secureConnectionStart":0},{"duration":7.90000057220459,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/898b8076c5e82f53cd816ca393e45a56-CDN/4x9nqn/820011/16zrvj4/f614b50eeb842ebd1ea7ab2903699907/_/download/contextbatch/css/project.issue.navigator,jira.view.issue,jira.global,atl.general,-_super/batch.css?jira.create.linked.issue=true&richediton=true","startTime":189.5999994277954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":189.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":197.5,"responseStart":0,"secureConnectionStart":0},{"duration":389.69999980926514,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/4c9c503fe98f210445831b0d7b0cdc33-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":189.69999980926514,"connectEnd":495.5999994277954,"connectStart":472.5999994277954,"domainLookupEnd":472.5999994277954,"domainLookupStart":472.5999994277954,"fetchStart":189.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":495.5999994277954,"responseEnd":579.3999996185303,"responseStart":514.8999996185303,"secureConnectionStart":483.80000019073486},{"duration":416.5,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/694e598c1ae48b0f96655173631cd247-CDN/4x9nqn/820011/16zrvj4/f614b50eeb842ebd1ea7ab2903699907/_/download/contextbatch/js/project.issue.navigator,jira.view.issue,jira.global,atl.general,-_super/batch.js?jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":190.0999994277954,"connectEnd":503,"connectStart":476.5999994277954,"domainLookupEnd":476.5999994277954,"domainLookupStart":476.5999994277954,"fetchStart":190.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":503.5,"responseEnd":606.5999994277954,"responseStart":522,"secureConnectionStart":489.19999980926514},{"duration":323.29999923706055,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/53f54e0ac3f00bb56b136b4d2fff2853-CDN/4x9nqn/820011/16zrvj4/aae1242f5fc81cc6a5bb8bc963ccda29/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en-US","startTime":190.30000019073486,"connectEnd":496.5,"connectStart":470.80000019073486,"domainLookupEnd":470.80000019073486,"domainLookupStart":470.80000019073486,"fetchStart":190.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":496.69999980926514,"responseEnd":513.5999994277954,"responseStart":511.8999996185303,"secureConnectionStart":483.5},{"duration":341.5,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":190.39999961853027,"connectEnd":516.0999994277954,"connectStart":491.5,"domainLookupEnd":491.5,"domainLookupStart":491.5,"fetchStart":190.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":516.6999998092651,"responseEnd":531.8999996185303,"responseStart":530,"secureConnectionStart":503.0999994277954},{"duration":364.70000076293945,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":190.5999994277954,"connectEnd":539.0999994277954,"connectStart":513.3999996185303,"domainLookupEnd":513.3999996185303,"domainLookupStart":513.3999996185303,"fetchStart":190.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":539.0999994277954,"responseEnd":555.3000001907349,"responseStart":553.8999996185303,"secureConnectionStart":526.0999994277954},{"duration":12.5,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/30748292e4ca68be6947d7969829384b-CDN/4x9nqn/820011/16zrvj4/4f66da484ef7d95a2a604d3ab014374c/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":190.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":190.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":203.19999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":367.6000003814697,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/a9e270f026ecabffc9a59343e5439391/shortcuts.js?context=issuenavigation&context=issueaction","startTime":190.89999961853027,"connectEnd":542.8999996185303,"connectStart":517.0999994277954,"domainLookupEnd":517.0999994277954,"domainLookupStart":517.0999994277954,"fetchStart":190.89999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":542.8999996185303,"responseEnd":558.5,"responseStart":557.1999998092651,"secureConnectionStart":529.8000001907349},{"duration":16.600000381469727,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/4x9nqn/820011/16zrvj4/efa42a25652b26dfd802540c024826b3/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.css?jira.create.linked.issue=true&richediton=true","startTime":293.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":293.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":309.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":370.69999980926514,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/8087506fefd02b4096991c90836b49f6-CDN/4x9nqn/820011/16zrvj4/efa42a25652b26dfd802540c024826b3/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.js?jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":293.30000019073486,"connectEnd":644.5999994277954,"connectStart":617,"domainLookupEnd":617,"domainLookupStart":617,"fetchStart":293.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":644.8999996185303,"responseEnd":664,"responseStart":661.0999994277954,"secureConnectionStart":632.1999998092651},{"duration":380.6000003814697,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":320.8999996185303,"connectEnd":687.0999994277954,"connectStart":663.8000001907349,"domainLookupEnd":663.8000001907349,"domainLookupStart":663.8000001907349,"fetchStart":320.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":687.0999994277954,"responseEnd":701.5,"responseStart":700.1999998092651,"secureConnectionStart":675.1999998092651},{"duration":267,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":438.0999994277954,"connectEnd":689.1999998092651,"connectStart":662.6999998092651,"domainLookupEnd":662.6999998092651,"domainLookupStart":662.5999994277954,"fetchStart":438.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":689.8999996185303,"responseEnd":705.0999994277954,"responseStart":703.8999996185303,"secureConnectionStart":675.5},{"duration":146.4000005722046,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":770.8999996185303,"connectEnd":887.5,"connectStart":861.8000001907349,"domainLookupEnd":861.8000001907349,"domainLookupStart":861.8000001907349,"fetchStart":770.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":887.5,"responseEnd":917.3000001907349,"responseStart":915.3000001907349,"secureConnectionStart":874.3999996185303}],"fetchStart":0,"domainLookupStart":3,"domainLookupEnd":77,"connectStart":78,"connectEnd":115,"secureConnectionStart":89,"requestStart":115,"responseStart":183,"responseEnd":438,"domLoading":187,"domInteractive":974,"domContentLoadedEventStart":974,"domContentLoadedEventEnd":1009,"domComplete":1658,"loadEventStart":1658,"loadEventEnd":1660,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":955.8000001907349},{"name":"bigPipe.sidebar-id.end","time":956.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":956.6999998092651},{"name":"bigPipe.activity-panel-pipe-id.end","time":959.5},{"name":"activityTabFullyLoaded","time":1018.3999996185303}],"measures":[],"correlationId":"44c20161a67ffa","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":310,"dbReadsTimeInMs":60,"dbConnsTimeInMs":64,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}