Systems, methods and techniques for polymorphic queries

摘要

Techniques for providing polymorphic query requests. A request is received that has at least a database query. The database query comprises at least an expression using a polymorphic relationship. The request is processed utilizing the polymorphic relationship. A user-readable result is provided for the query where the result is defined by at least the polymorphic relationship.

主权项

1. A method for polymorphic selection of data, the method comprising:
receiving a request, via a graphical user interface and with hardware computing device to provide database search functionality, wherein a database object having a target object type has been selected via the graphical user interface and the request comprises at least a database query, wherein the database query comprises at least an expression using a polymorphic relationship corresponding to the target object type, wherein the database query is for a multitenant database; processing, with the hardware computing device, the request utilizing the polymorphic relationship by at least, automatically and without user interaction, selecting relevant set of one or more fields corresponding to the polymorphic reference based on a runtime type of the polymorphic reference, wherein the polymorphic relationship is specified by the expression that within a clause that allows the request to specify fields of a related parent object that are to be selected based on the type of the parent object; and providing, with the hardware computing device, a user-readable result on the graphical user interface for the query where the result is defined by at least the polymorphic relationship.