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":739.9000000000233,"ttfb":156.30000000004657,"pageVisibility":"visible","entityId":10801,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":16,"apdex":1,"journeyId":"7f08e499-d3d5-45ed-ba78-980e65ac7990","navigationType":0,"readyForUser":810.9000000000233,"redirectCount":0,"resourceLoadedEnd":859.0999999999767,"resourceLoadedStart":166.30000000004657,"resourceTiming":[{"duration":150.5,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":166.30000000004657,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":166.30000000004657,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":316.80000000004657,"responseStart":0,"secureConnectionStart":0},{"duration":150.30000000004657,"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":166.59999999997672,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":166.59999999997672,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":316.9000000000233,"responseStart":0,"secureConnectionStart":0},{"duration":191,"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":166.80000000004657,"connectEnd":166.80000000004657,"connectStart":166.80000000004657,"domainLookupEnd":166.80000000004657,"domainLookupStart":166.80000000004657,"fetchStart":166.80000000004657,"redirectEnd":0,"redirectStart":0,"requestStart":166.80000000004657,"responseEnd":357.80000000004657,"responseStart":357.80000000004657,"secureConnectionStart":166.80000000004657},{"duration":255,"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":167.09999999997672,"connectEnd":167.09999999997672,"connectStart":167.09999999997672,"domainLookupEnd":167.09999999997672,"domainLookupStart":167.09999999997672,"fetchStart":167.09999999997672,"redirectEnd":0,"redirectStart":0,"requestStart":167.09999999997672,"responseEnd":422.0999999999767,"responseStart":422.0999999999767,"secureConnectionStart":167.09999999997672},{"duration":279.5999999999767,"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":167.20000000006985,"connectEnd":167.20000000006985,"connectStart":167.20000000006985,"domainLookupEnd":167.20000000006985,"domainLookupStart":167.20000000006985,"fetchStart":167.20000000006985,"redirectEnd":0,"redirectStart":0,"requestStart":167.20000000006985,"responseEnd":446.80000000004657,"responseStart":446.80000000004657,"secureConnectionStart":167.20000000006985},{"duration":280.89999999990687,"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":167.20000000006985,"connectEnd":167.20000000006985,"connectStart":167.20000000006985,"domainLookupEnd":167.20000000006985,"domainLookupStart":167.20000000006985,"fetchStart":167.20000000006985,"redirectEnd":0,"redirectStart":0,"requestStart":167.20000000006985,"responseEnd":448.0999999999767,"responseStart":448.0999999999767,"secureConnectionStart":167.20000000006985},{"duration":282.5,"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":167.30000000004657,"connectEnd":167.30000000004657,"connectStart":167.30000000004657,"domainLookupEnd":167.30000000004657,"domainLookupStart":167.30000000004657,"fetchStart":167.30000000004657,"redirectEnd":0,"redirectStart":0,"requestStart":167.30000000004657,"responseEnd":449.80000000004657,"responseStart":449.80000000004657,"secureConnectionStart":167.30000000004657},{"duration":283.80000000004657,"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":167.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":167.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":451.30000000004657,"responseStart":0,"secureConnectionStart":0},{"duration":284.0999999999767,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/766848d8ff8ea3676a80e44dfb51696a/shortcuts.js?context=issuenavigation&context=issueaction","startTime":167.5,"connectEnd":167.5,"connectStart":167.5,"domainLookupEnd":167.5,"domainLookupStart":167.5,"fetchStart":167.5,"redirectEnd":0,"redirectStart":0,"requestStart":167.5,"responseEnd":451.5999999999767,"responseStart":451.5999999999767,"secureConnectionStart":167.5},{"duration":257.9000000000233,"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":198.40000000002328,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":198.40000000002328,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":456.30000000004657,"responseStart":0,"secureConnectionStart":0},{"duration":258.20000000006985,"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":198.59999999997672,"connectEnd":198.59999999997672,"connectStart":198.59999999997672,"domainLookupEnd":198.59999999997672,"domainLookupStart":198.59999999997672,"fetchStart":198.59999999997672,"redirectEnd":0,"redirectStart":0,"requestStart":198.59999999997672,"responseEnd":456.80000000004657,"responseStart":456.80000000004657,"secureConnectionStart":198.59999999997672},{"duration":643.5999999999767,"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":206.40000000002328,"connectEnd":206.40000000002328,"connectStart":206.40000000002328,"domainLookupEnd":206.40000000002328,"domainLookupStart":206.40000000002328,"fetchStart":206.40000000002328,"redirectEnd":0,"redirectStart":0,"requestStart":206.40000000002328,"responseEnd":850,"responseStart":850,"secureConnectionStart":206.40000000002328},{"duration":645.3999999999069,"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":213.70000000006985,"connectEnd":213.70000000006985,"connectStart":213.70000000006985,"domainLookupEnd":213.70000000006985,"domainLookupStart":213.70000000006985,"fetchStart":213.70000000006985,"redirectEnd":0,"redirectStart":0,"requestStart":213.70000000006985,"responseEnd":859.0999999999767,"responseStart":859.0999999999767,"secureConnectionStart":213.70000000006985},{"duration":206.90000000002328,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":656.4000000000233,"connectEnd":656.4000000000233,"connectStart":656.4000000000233,"domainLookupEnd":656.4000000000233,"domainLookupStart":656.4000000000233,"fetchStart":656.4000000000233,"redirectEnd":0,"redirectStart":0,"requestStart":656.4000000000233,"responseEnd":863.3000000000466,"responseStart":863.2000000000698,"secureConnectionStart":656.4000000000233},{"duration":71.5,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-atl.general/batch.js","startTime":896.5999999999767,"connectEnd":896.5999999999767,"connectStart":896.5999999999767,"domainLookupEnd":896.5999999999767,"domainLookupStart":896.5999999999767,"fetchStart":896.5999999999767,"redirectEnd":0,"redirectStart":0,"requestStart":896.5999999999767,"responseEnd":968.0999999999767,"responseStart":968.0999999999767,"secureConnectionStart":896.5999999999767}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":95,"connectEnd":126,"secureConnectionStart":109,"requestStart":126,"responseStart":156,"responseEnd":213,"domLoading":160,"domInteractive":949,"domContentLoadedEventStart":949,"domContentLoadedEventEnd":999,"domComplete":1290,"loadEventStart":1290,"loadEventEnd":1292,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":899.2000000000698},{"name":"bigPipe.sidebar-id.end","time":899.9000000000233},{"name":"bigPipe.activity-panel-pipe-id.start","time":900.0999999999767},{"name":"bigPipe.activity-panel-pipe-id.end","time":902.5999999999767},{"name":"activityTabFullyLoaded","time":1006.9000000000233}],"measures":[],"correlationId":"1cf301a9926906","effectiveType":"4g","downlink":9.1,"rtt":0,"serverDuration":72,"dbReadsTimeInMs":9,"dbConnsTimeInMs":11,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}