Patent ID: 9390125
Filing Date: 2016-07-12
CPC Classification: G06F

Claim Text:
1. A method for authoring a database query by modifying a view of results of the database query, the method comprising: generating a query design surface that displays the view of the results of a database query definition, the query design surface comprising a grid displaying rows of database records from at least one database table returned by the database query and columns of fields from the at least one database table returned by the database query; providing at least one user interface control element for modifying the columns of fields of the query design surface, the at least one user interface control element comprising a field list displaying first available fields from a first database table and second available fields from a second database table for adding one or more fields to the view of the results; receiving input via the at least one user interface control element that adds a field to be displayed in the query design surface from the field list of one of the first available fields from the first database table or the second available fields from the second database table, wherein the received input comprises user input dragging the field to be displayed in the query design surface from the field list onto the query design surface; and generating an updated database query definition based on receiving the input that modifies the query design surface to reflect the adding of the field from one of the first database table or the second database table to the fields displayed in query design surface.