Wish List - Wish List: Wish #1

<Member picture

0 Like 0 Dislike

Chungwook Sim

Title and CASE ID needed in the parameters table

When you click the parameters from dataview, you only see the ID (computer generated) and the parameters.

The title and Case ID should be in the columns for viewing data.  I  acutally think it should both be in dataview and also while doing the bulk update as well.

For now, the user have to copy the computer generated ID from case information and paste that to the parameters bulk update table and use it.

 

But, not only for input but also when you are viewing, it makes no sense to researcher to look back and forth to find which specimen he is looking into.

I wish there are both the Title and Case ID in the parameters table.

Comments (4)

  1. Ann Christine . Catlin

    Sudheera has added this capability to the Case Parameters. Users will see the System ID, Title and Case ID when they get a spreadsheet from the parameter Bulk Upload. They can then put all their parameters data in the spreadsheet while looking at the Title and Case ID.

    Reply Report abuse

    Please login to comment.

  2. Chungwook Sim

    Thank you Ann Christine and Sudheera!!

     

    Reply Report abuse

    Please login to comment.

  3. Diana Moore

    Its indeed a smart blog and after reading such precise top essay writing services content I would like to must try this software.Its really nice one.

    Reply Report abuse

    Please login to comment.

  4. John Stevens

    Wonderful article accurate and to the point . Not everyone can provide information with proper flow. Thanks for the valuable information and insights you have so provided here Oracle 1z0-932 Dumps Questions. Keep it up!!!!

    Reply Report abuse

    Please login to comment.

Debug Console

Close20 MBRequestSessionTimelineDatabase52Events21
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( NO_PROXY => .s2.internal, https_proxy => http://10.8.63.5:3128, http_proxy => http:/... Array(
NO_PROXY => .s2.internal,
https_proxy => http://10.8.63.5:3128,
http_proxy => http://10.8.63.5:3128,
USER => apache,
HOME => /var/www,
FCGI_ROLE => RESPONDER,
REDIRECT_HTTP_AUTHORIZATION => ,
REDIRECT_SCRIPT_URL => /wishlist/general/1/wish/1,
REDIRECT_SCRIPT_URI => https://datacenterhub.org/wishlist/general/1/wish/1,
REDIRECT_HTTPS => on,
REDIRECT_STATUS => 200,
HTTP_AUTHORIZATION => ,
SCRIPT_URL => /wishlist/general/1/wish/1,
SCRIPT_URI => https://datacenterhub.org/wishlist/general/1/wish/1,
HTTPS => on,
HTTP_USER_AGENT => CCBot/2.0 (https://commoncrawl.org/faq/),
HTTP_ACCEPT => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8,
HTTP_ACCEPT_LANGUAGE => en-US,en;q=0.5,
HTTP_ACCEPT_ENCODING => br,gzip,
HTTP_HOST => datacenterhub.org,
HTTP_CONNECTION => Keep-Alive,
PATH => /sbin:/usr/sbin:/bin:/usr/bin,
SERVER_SIGNATURE => ,
SERVER_SOFTWARE => Apache,
SERVER_NAME => datacenterhub.org,
SERVER_ADDR => 10.111.11.100,
SERVER_PORT => 443,
REMOTE_ADDR => 10.111.11.10,
DOCUMENT_ROOT => /var/www/datacenterhub,
SERVER_ADMIN => root@localhost,
SCRIPT_FILENAME => /var/www/datacenterhub/index.php,
REMOTE_PORT => 52570,
REDIRECT_URL => /wishlist/general/1/wish/1,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /wishlist/general/1/wish/1,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1590783346.0352,
REQUEST_TIME => 1590783346,
argv => Array(

)
,
argc => 0
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid 6439cfe1d224898b4d7223b8fea87744
tracker.ssid 6439cfe1d224898b4d7223b8fea87744
tracker.rsid 6439cfe1d224898b4d7223b8fea87744
session.token 67aea42fdc0d543c61e5911bb69c5c9a
  • site 0.049 seconds (+0.049); 12.25 MB (+12.250) - afterInitialise
  • site 0.071 seconds (+0.021); 13.50 MB (+1.250) - afterRoute
  • site 0.197 seconds (+0.126); 19.50 MB (+6.000) - afterDispatch
  • site 0.204 seconds (+0.007); 19.50 MB (0.000) - beforeRenderModule mod_custom (Footer: info and navigation)
  • site 0.206 seconds (+0.002); 19.50 MB (0.000) - afterRenderModule mod_custom (Footer: info and navigation)
  • site 0.207 seconds (+0.000); 19.50 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.222 seconds (+0.015); 20.00 MB (+0.500) - afterRenderModule mod_menu (Main Menu)
  • site 0.227 seconds (+0.005); 20.25 MB (+0.250) - onAfterRender
  • site 0.229 seconds (+0.002); 20.25 MB (0.000) - sessionStore
20 MB

52 Queries Logged: 0.041420221328735 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '8700601f748cbca78acf6e42569e18a9'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = '8700601f748cbca78acf6e42569e18a9'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '6439cfe1d224898b4d7223b8fea87744'
  4. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  5. SELECT session_id
      FROM `jos_session`
      WHERE `session_id` = '6439cfe1d224898b4d7223b8fea87744'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('6439cfe1d224898b4d7223b8fea87744','0','1590783346','10.111.11.10')
  7. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_members'
  8. SELECT b.id
      FROM `jos_usergroups` AS `a`
      LEFT JOIN jos_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE `a`.`id` = '1'
  9. SELECT *
      FROM `jos_viewlevels`
  10. SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
      WHERE `enabled` >= '1'
      AND `type` = 'plugin'
      AND `state` >= '0'
      AND `access` IN ('1','1','4')
      ORDER BY `ordering` ASC
  11. SELECT m.id,m.menutype,m.title,m.alias,m.note,m.path AS route,m.link,m.type,m.level,m.language,m.browserNav,m.access,m.params,m.home,m.img,m.template_style_id,m.component_id,m.parent_id,e.element AS component
      FROM `jos_menu` AS `m`
      LEFT JOIN jos_extensions AS e
      ON e.extension_id = m.component_id
      WHERE `m`.`published` = '1'
      AND `m`.`parent_id` > '0'
      AND `m`.`client_id` = '0'
      ORDER BY `m`.`lft` ASC
  12. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wishlist'
  13. SELECT jos_template_styles.id,jos_template_styles.home,jos_template_styles.template,jos_template_styles.params,jos_extensions.protected
      FROM `jos_template_styles`
      INNER JOIN jos_extensions
      ON jos_extensions.element = jos_template_styles.template
      WHERE `jos_template_styles`.`client_id` = '0'
      AND `jos_extensions`.`enabled` = '1'
      AND `jos_extensions`.`type` = 'template'
      AND jos_extensions.`client_id` = `jos_template_styles`.`client_id`
      ORDER BY `home` DESC
  14. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  15. SELECT *
      FROM `jos_wishlist_item`
      WHERE `jos_wishlist_item`.`id` = '1'
  16. SELECT *
      FROM `jos_wishlist`
      WHERE `jos_wishlist`.`id` = '1'
  17. SELECT a.rules
      FROM `jos_assets` AS `a`
      WHERE `a`.`id` = '1'
      GROUP BY a.id, a.rules, a.lft
  18. SELECT b.rules
      FROM `jos_assets` AS `a`
      LEFT JOIN jos_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE `a`.`name` = 'com_wishlist'
      GROUP BY b.id, b.rules, b.lft
      ORDER BY `b`.`lft` ASC
  19. SELECT *
      FROM `jos_xgroups`
      WHERE cn = 'hubdev';
  20. SELECT *
      FROM `jos_wishlist_ownergroups`
      WHERE `jos_wishlist_ownergroups`.`wishlist` = '1'
  21. SELECT *
      FROM `jos_wishlist_owners`
      WHERE `jos_wishlist_owners`.`wishlist` = '1'
      AND `jos_wishlist_owners`.`type` != '2'
  22. SELECT *
      FROM `jos_wishlist_vote`
      WHERE `jos_wishlist_vote`.`wishid` = '1'
  23. SELECT id AS value,name AS text
      FROM `jos_users`
      WHERE `block` = '0'
      AND `id` IN ('')
      ORDER BY `name` ASC
  24. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1016'
  25. SELECT COUNT(jos_vote_log.id) AS count
      FROM `jos_vote_log`
      WHERE `jos_vote_log`.`referenceid` = '1'
      AND `jos_vote_log`.`category` = 'wish'
      AND `jos_vote_log`.`helpful` = 'yes'
  26. SELECT COUNT(jos_vote_log.id) AS count
      FROM `jos_vote_log`
      WHERE `jos_vote_log`.`referenceid` = '1'
      AND `jos_vote_log`.`category` = 'wish'
      AND `jos_vote_log`.`helpful` = 'no'
  27. SELECT jos_tags_object.label,jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags_object.tagid = jos_tags.id
      WHERE `jos_tags_object`.`tbl` = 'wishlist'
      AND `jos_tags_object`.`objectid` = '1'
      AND `jos_tags`.`admin` NOT IN ('1')
      GROUP BY jos_tags_object.label,jos_tags.id
  28. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  29. SELECT *
      FROM `jos_item_comments`
      WHERE `jos_item_comments`.`item_id` = '1'
      AND `jos_item_comments`.`item_type` = 'wish'
      AND `jos_item_comments`.`parent` = '0'
      AND `jos_item_comments`.`state` IN ('1','3')
  30. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1005'
  31. SELECT *
      FROM `jos_wish_attachments`
      WHERE `jos_wish_attachments`.`comment_id` = '1'
  32. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  33. SELECT *
      FROM `jos_item_comments`
      WHERE `jos_item_comments`.`parent` = '1'
      AND `jos_item_comments`.`item_type` = 'wish'
      AND `jos_item_comments`.`item_id` = '1'
      AND `jos_item_comments`.`state` IN ('1','3')
  34. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1016'
  35. SELECT *
      FROM `jos_wish_attachments`
      WHERE `jos_wish_attachments`.`comment_id` = '2'
  36. SELECT *
      FROM `jos_item_comments`
      WHERE `jos_item_comments`.`parent` = '2'
      AND `jos_item_comments`.`item_type` = 'wish'
      AND `jos_item_comments`.`item_id` = '1'
      AND `jos_item_comments`.`state` IN ('1','3')
  37. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '2379'
  38. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '2379';
  39. SELECT *
      FROM `jos_wish_attachments`
      WHERE `jos_wish_attachments`.`comment_id` = '44'
  40. SELECT *
      FROM `jos_item_comments`
      WHERE `jos_item_comments`.`parent` = '44'
      AND `jos_item_comments`.`item_type` = 'wish'
      AND `jos_item_comments`.`item_id` = '1'
      AND `jos_item_comments`.`state` IN ('1','3')
  41. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '2656'
  42. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '2656';
  43. SELECT *
      FROM `jos_wish_attachments`
      WHERE `jos_wish_attachments`.`comment_id` = '115'
  44. SELECT *
      FROM `jos_item_comments`
      WHERE `jos_item_comments`.`parent` = '115'
      AND `jos_item_comments`.`item_type` = 'wish'
      AND `jos_item_comments`.`item_id` = '1'
      AND `jos_item_comments`.`state` IN ('1','3')
  45. SELECT m.id,m.title,m.module,m.position,m.content,m.showtitle,m.params,mm.menuid,e.protected
      FROM `jos_modules` AS `m`
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jos_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      WHERE `m`.`published` = '1'
      AND `e`.`enabled` = '1'
      AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= '2020-05-29 20:15:46' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2020-05-29 20:15:46' )
      AND `m`.`access` IN ('1','1','4')
      AND `m`.`client_id` = '0'
      AND (`mm`.`menuid` = '92' OR `mm`.`menuid` <= '0' )
      ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
  46. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  47. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  48. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_resources'
  49. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_usage'
  50. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  51. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_feedback'
  52. UPDATE `jos_session`
      SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1590783346;s:18:\"session.timer.last\";i:1590783346;s:17:\"session.timer.now\";i:1590783346;s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:1:\"0\";s:7:\"session\";}s:9:\"separator\";s:1:\".\";}s:4:\"user\";C:17:\"Hubzero\\User\\User\":22:{a:1:{s:5:\"guest\";b:1;}}s:11:\"tracker.sid\";s:32:\"6439cfe1d224898b4d7223b8fea87744\";s:12:\"tracker.ssid\";s:32:\"6439cfe1d224898b4d7223b8fea87744\";s:12:\"tracker.rsid\";s:32:\"6439cfe1d224898b4d7223b8fea87744\";s:13:\"session.token\";s:32:\"67aea42fdc0d543c61e5911bb69c5c9a\";}',`time` = '1590783346',`ip` = '10.111.11.10'
      WHERE `session_id` = '6439cfe1d224898b4d7223b8fea87744'

27 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 12 × SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
  2. 5 × SELECT *
      FROM `jos_users`
  3. 5 × SELECT *
      FROM `jos_item_comments`
  4. 4 × SELECT *
      FROM `jos_wish_attachments`
  5. 2 × SELECT COUNT(jos_vote_log.id) AS count
      FROM `jos_vote_log`
  6. 2 × SELECT data
      FROM `jos_session`
  7. 2 × SELECT *
      FROM `jos_xprofiles`
  8. 1 × SELECT *
      FROM `jos_wishlist_owners`
  9. 1 × SELECT *
      FROM `jos_wishlist_vote`
  10. 1 × SELECT jos_tags_object.label,jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags_object.tagid = jos_tags.id
  11. 1 × SELECT m.id,m.title,m.module,m.position,m.content,m.showtitle,m.params,mm.menuid,e.protected
      FROM `jos_modules` AS `m`
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jos_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
  12. 1 × SELECT *
      FROM `jos_wishlist_ownergroups`
  13. 1 × SELECT id AS value,name AS text
      FROM `jos_users`
  14. 1 × SELECT b.rules
      FROM `jos_assets` AS `a`
      LEFT JOIN jos_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  15. 1 × SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
  16. 1 × SELECT *
      FROM `jos_viewlevels
  17. 1 × SELECT b.id
      FROM `jos_usergroups` AS `a`
      LEFT JOIN jos_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  18. 1 × SELECT session_id
      FROM `jos_session`
  19. 1 × SELECT m.id,m.menutype,m.title,m.alias,m.note,m.path AS route,m.link,m.type,m.level,m.language,m.browserNav,m.access,m.params,m.home,m.img,m.template_style_id,m.component_id,m.parent_id,e.element AS component
      FROM `jos_menu` AS `m`
      LEFT JOIN jos_extensions AS e
      ON e.extension_id = m.component_id
  20. 1 × SELECT jos_template_styles.id,jos_template_styles.home,jos_template_styles.template,jos_template_styles.params,jos_extensions.protected
      FROM `jos_template_styles`
      INNER JOIN jos_extensions
      ON jos_extensions.element = jos_template_styles.template
  21. 1 × SELECT a.rules
      FROM `jos_assets` AS `a`
  22. 1 × SELECT *
      FROM `jos_wishlist`
  23. 1 × SELECT *
      FROM `jos_wishlist_item`
  24. 1 × SELECT *
      FROM `jos_xgroups`
OTHER Tables:
  1. 1 × UPDATE `jos_session`
      SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1590783346;s:18:\"session.timer.last\";i:1590783346;s:17:\"session.timer.now\";i:1590783346;s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:1:\"0\";s:7:\"session\";}s:9:\"separator\";s:1:\".\";}s:4:\"user\";C:17:\"Hubzero\\User\\User\":22:{a:1:{s:5:\"guest\";b:1;}}s:11:\"tracker.sid\";s:32:\"6439cfe1d224898b4d7223b8fea87744\";s:12:\"tracker.ssid\";s:32:\"6439cfe1d224898b4d7223b8fea87744\";s:12:\"tracker.rsid\";s:32:\"6439cfe1d224898b4d7223b8fea87744\";s:13:\"session.token\";s:32:\"67aea42fdc0d543c61e5911bb69c5c9a\";}',`time` = '1590783346',`ip` = '10.111.11.10'
  2. 1 × INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('6439cfe1d224898b4d7223b8fea87744','0','1590783346','10.111.11.10'
  3. 1 × DELETE
      FROM `jos_session`
  • onAfterInitialise Method plgSystemP3p::onAfterInitialise /core/plugins/system/p3p/p3p.php:21
  • onAfterInitialise Method plgSystemRemember::onAfterInitialise /core/plugins/system/remember/remember.php:20
  • onAfterInitialise Method plgSystemHubzero::onAfterInitialise /core/plugins/system/hubzero/hubzero.php:21
  • onAfterInitialise Method plgSystemXFeed::onAfterInitialise /core/plugins/system/xfeed/xfeed.php:21
  • onAfterInitialise Method plgSystemSupergroup::onAfterInitialise /core/plugins/system/supergroup/supergroup.php:113
  • onAfterInitialise Method plgSystemReferrerpolicy::onAfterInitialise /core/plugins/system/referrerpolicy/referrerpolicy.php:21
  • onAfterRoute Method plgSystemJquery::onAfterRoute /core/plugins/system/jquery/jquery.php:21
  • onAfterRoute Method plgSystemSpamjail::onAfterRoute /core/plugins/system/spamjail/spamjail.php:21
  • onAfterRoute Method plgSystemPassword::onAfterRoute /core/plugins/system/password/password.php:21
  • onAfterRoute Method plgSystemIncomplete::onAfterRoute /core/plugins/system/incomplete/incomplete.php:21
  • onAfterRoute Method plgSystemUnconfirmed::onAfterRoute /core/plugins/system/unconfirmed/unconfirmed.php:21
  • onAfterRoute Method plgSystemUnapproved::onAfterRoute /core/plugins/system/unapproved/unapproved.php:21
  • onContentPrepare Method plgContentLoadmodule::onContentPrepare /core/plugins/content/loadmodule/loadmodule.php:35
  • onContentPrepare Method plgContentEmailcloak::onContentPrepare /core/plugins/content/emailcloak/emailcloak.php:25
  • onContentPrepare Method plgContentPagebreak::onContentPrepare /core/plugins/content/pagebreak/pagebreak.php:35
  • onContentPrepare Method plgContentXhubtags::onContentPrepare /core/plugins/content/xhubtags/xhubtags.php:25
  • onContentPrepare Method plgContentFormathtml::onContentPrepare /core/plugins/content/formathtml/formathtml.php:105
  • onContentPrepare Method plgContentExternalhref::onContentPrepare /core/plugins/content/externalhref/externalhref.php:41
  • onAfterDispatch Method plgSystemDebug::onAfterDispatch /core/plugins/system/debug/debug.php:60
  • onAfterDispatch Method PlgSystemHighlight::onAfterDispatch /core/plugins/system/highlight/highlight.php:25
  • onAfterRender Method plgSystemSef::onAfterRender /core/plugins/system/sef/sef.php:21