Data retrieval systems and methods

A method for updating data of an issue tracking system, the method comprising:

• cause display, at a user device, of an issue tracking system application, the issue tracking system application including a set of issue objects comprising a respective set of fields;
• receiving a request defining a structured query language query regarding the set of issue objects, the structured query language query comprising a plurality of clauses;
• parsing, by the server system, the plurality of clauses to identify:
• a set of caching type clauses;
• and
• a set of non-caching type clauses non-overlapping with the set of caching type clauses, the set of non-caching type clauses identified based on at least one attribute of a respective non-caching clause included on a non-caching keyword list;
• executing a first stage query based of the set of caching type clauses to obtain a first stage query result from a cached memory;
• executing a second stage query using the first stage query result and one or more of the set of non-caching type clauses to obtain a second stage query result;
• and
• in response to returning the second stage query result, updating display, at the issue tracking system application, the updated display including an updated subset of fields of the set of fields based on the second stage query result.

A method for obtaining issue data from an issue tracking system, the method comprising:

• causing display, at an application of an issue tracking system, a set of issues;
• receiving a request for updated information regarding the set of issues, the request formatted in accordance with a structured query language, the request including a plurality of clauses;
• analyzing the request and identifying, a non-caching type clause from the plurality of clauses;
• identifying, a caching type clause from the plurality of clauses, the caching type clause different from the non-caching type clause;
• executing a first stage query using the caching type clause to obtain a first stage query result from a computer memory;
• executing a second stage query using the non-caching clause on a data store of the issue tracking system to obtain a second stage query result;
• in response to returning the second stage query result, updating display, at the application of the issue tracking system, of the set of issues;
• subsequent to updating display of the set of issues, re-executing the first stage query;
• and
• updating display, at the application of the issue tracking system, of the set of issues.