View source for Obsolete:Tool:Query service

{{Archive}}
Often, people on Wikimedia projects have a question they can't get an answer to from MediaWiki, but which can be easily answered by asking the database directly. The '''query service''' aims to help Wikimedians get the answers they need. It's simple:

* If you '''want someone to run a SQL query''' for you, please file a request on [[jira:DBQ]]
** ''Note'': Filing a request on JIRA requires creating an account and logging in.
** After doing so, go to https://jira.toolserver.org/browse/DBQ and select "Create new issue"; then select "Next>>"
** Please be as detailed as possible about what data you need, in what order, in what format
** If you can, provide the SQL query
* If you are a Toolserver user and are '''willing to run a query''' every now and then, please look at [[jira:DBQ]] and take whatever task you like.
** Before running the query, make sure it's feasible. EXPLAIN the query first.
** Please consider using [[batch job scheduling]] for your query.
** Post the result as a plain file on the Toolserver, or to a wiki page, if that was requested
** Please record the exact query you used for future reference, ideally in a comment to the JIRA ticket.

Note: we now have the [[report tool]] as well; if you expect to need this query more than once, you can request it be added to the tool, where it will be updated automatically.

If you are interested in handling requests for database queries regularly, ask a [[System administrators|root]] to assign you to the DBQ JIRA group.  You will then be notified of any new requests for queries filed in JIRA.  You can also create a JIRA filter (using 'find issues'), to find new queries in this project, and mail them to you periodically, or produce an RSS feed.

The person who runs the database query will add it to the wiki (below) if necessary.

== Past JIRA requests ==
''Note: Only '''the person running the query''' should add it to this list.  If you want to request a new query, file a request [[jira:DBQ|DBQ on JIRA]].''

{{/1}}
{{/5}}
{{/7}}
{{/8}}
{{/9}}
{{/10}}
{{/16}}
{{/24}}
{{/25}}
{{/103}}

== Past non-JIRA requests ==
{{/WantedTemplates cswiki}}

{{/WantedInterwiki parser}}


[[Category:Query service|!]]

<small>This page was moved from [[toolserver:en:Query service]]. It's edit history can be viewed at [[Nova Resource:Tools/Tools/Query service/edithistory]]</small>