Systems, methods and techniques for polymorphic queries
First Claim
Patent Images
1. A method for polymorphic selection of data from a database storing data on at least one memory device and managed by one or more hardware processors, the method comprising:
- receiving, with the one or more processors, a request that has at least a database query compatible with salesforce object query language (SOQL), wherein the database query comprises at least an expression using a polymorphic relationship and a SELECT clause;
adding, with the one or more processors, a TYPEOF expression to the SELECT clause to function as a case expression to allow specification of fields of a related parent object that are to be selected based on the polymorphic relationship;
processing the request utilizing the polymorphic relationship, with the one or more processors, by running the query against a portion of a set of data in the database;
transmitting, with the one or more processors, a result for the database query, where the result is defined by at least the polymorphic relationship, to a remote electronic device.
1 Assignment
0 Petitions
Accused Products
Abstract
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.
-
Citations
19 Claims
-
1. A method for polymorphic selection of data from a database storing data on at least one memory device and managed by one or more hardware processors, the method comprising:
-
receiving, with the one or more processors, a request that has at least a database query compatible with salesforce object query language (SOQL), wherein the database query comprises at least an expression using a polymorphic relationship and a SELECT clause; adding, with the one or more processors, a TYPEOF expression to the SELECT clause to function as a case expression to allow specification of fields of a related parent object that are to be selected based on the polymorphic relationship; processing the request utilizing the polymorphic relationship, with the one or more processors, by running the query against a portion of a set of data in the database; transmitting, with the one or more processors, a result for the database query, where the result is defined by at least the polymorphic relationship, to a remote electronic device. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. An article comprising a non-transitory computer-readable medium having instructions for polymorphic selection of data from a database storing data on at least one memory device and managed by one or more hardware processors that, when executed by one or more processors, cause the one or more processors to:
-
receive, with the one or more processors, a request that has at least a database query compatible with salesforce object query language (SOQL), wherein the database query comprises at least an expression using a polymorphic relationship and a SELECT clause; add, with the one or more processors, a TYPEOF expression to the SELECT clause to function as a case expression to allow specification of fields of a related parent object that are to be selected based on the polymorphic relationship; process the request utilizing the polymorphic relationship, with the one or more processors, by running the query against a portion of a set of data in the database; transmit, with the one or more processors, a result for the database query, where the result is defined by at least the polymorphic relationship, to a remote electronic device. - View Dependent Claims (8, 9, 10, 11)
-
-
12. An apparatus for polymorphic selection of data from a database storing data on at least one memory device and managed by one or more hardware processors, the apparatus comprising:
-
means for receiving, with the one or more processors, a request that has at least a database query compatible with salesforce object query language (SOQL), wherein the database query comprises at least an expression using a polymorphic relationship and a SELECT clause; means for adding, with the one or more processors, a TYPEOF expression to the SELECT clause to function as a case expression to allow specification of fields of a related parent object that are to be selected based on the polymorphic relationship; means for processing the request utilizing the polymorphic relationship, with the one or more processors, by running the query against a portion of a set of data in the database; means for transmitting, with the one or more processors, a result for the database query, where the result is defined by at least the polymorphic relationship, to a remote electronic device. - View Dependent Claims (13, 14, 15)
-
-
16. A system comprising:
-
one or more user systems; one or more server systems communicatively coupled with the one or more user systems, the server system to receive, with the one or more processors, a request that has at least a database query compatible with salesforce object query language (SOQL), wherein the database query comprises at least an expression using a polymorphic relationship and a SELECT clause, to add, with the one or more processors, a TYPEOF expression to the SELECT clause to function as a case expression to allow specification of fields of a related parent object that are to be selected based on the polymorphic relationship, to process the request utilizing the polymorphic relationship, with the one or more processors, by running the query against a portion of a set of data in the database, to transmit, with the one or more processors, a result for the database query, where the result is defined by at least the polymorphic relationship, to a remote electronic device. - View Dependent Claims (17, 18, 19)
-
Specification