Title: External query
Last modified: August 22, 2016

---

# External query

 *  Resolved [thesmartpoint](https://wordpress.org/support/users/thesmartpoint/)
 * (@thesmartpoint)
 * [11 years, 9 months ago](https://wordpress.org/support/topic/external-query/)
 * Dear President MCCheese,
 * I would like to use the ummquery shortcode to query another table on the db using
   the current user key.
 * I explain more in detail:
 * 1) I have a user with id 27
    2) When logged in if the user go to the page where
   there is the shortcode [usermeta key=”contract_type”], he can see his contract
   type. 3) I have another table in the DB with the following fields: – user_id –
   ticket_id – support_hours_spent_on_ticket I would like to be able to execute 
   a SQL statement like this: “SELECT sum( support_hours_spent_on_ticket ) FROM `
   support_tickets` WHERE user_id =27″
 * I know I can use thid shortode, but I would like to ask if there’s a way to query
   external tables using the current user_id as reference:
 * [ummquery before_result=”” after_result=”” before_item=”” after_item=”” item=”%
   v” key_format=”ucwords” value_format=”ucfirst” list=”meta_value” where=”usermeta.
   meta_key=’Company'”]
 * Thank you very much in advance for your help!
 * [https://wordpress.org/plugins/user-meta-manager/](https://wordpress.org/plugins/user-meta-manager/)

Viewing 1 replies (of 1 total)

 *  Thread Starter [thesmartpoint](https://wordpress.org/support/users/thesmartpoint/)
 * (@thesmartpoint)
 * [11 years, 9 months ago](https://wordpress.org/support/topic/external-query/#post-5278281)
 * Please close this ticket. I developed my own plugin to do this and I realized
   I was asking really to much.
 * Please accept my apologize
 * TheSmartPoint

Viewing 1 replies (of 1 total)

The topic ‘External query’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/user-meta-manager.svg)
 * [User Meta Manager](https://wordpress.org/plugins/user-meta-manager/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/user-meta-manager/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/user-meta-manager/)
 * [Active Topics](https://wordpress.org/support/plugin/user-meta-manager/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/user-meta-manager/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/user-meta-manager/reviews/)

 * 1 reply
 * 1 participant
 * Last reply from: [thesmartpoint](https://wordpress.org/support/users/thesmartpoint/)
 * Last activity: [11 years, 9 months ago](https://wordpress.org/support/topic/external-query/#post-5278281)
 * Status: resolved