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 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 comprising at least an expression using a polymorphic relationship and a database query language clause to narrow results;
adding, with the one or more processors, an expression to at least one database query language clause 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; and
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.
2. The method of claim 1 wherein the database query is for a multitenant database.
3. The method of claim 1 wherein the expression selects different fields form a target of a polymorphic reference based on target type.
4. The method of claim 3 wherein the query is processed as a plurality of batches.
5. The method of claim 1 wherein the remote electronic device comprises a mobile computing device.
6. The method of claim 1 wherein the polymorphic relationship is determined based on input received via a user interface.
7. 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 comprising at least an expression using a polymorphic relationship and a database query language clause to narrow results;
add, with the one or more processors, an expression to at least one database query language clause 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; and
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.
8. The non-transitory computer-readable medium of claim 7 wherein the database query is for a multitenant database.
9. The non-transitory computer-readable medium of claim 7 wherein the expression selects different fields form a target of a polymorphic reference based on target type.
10. The non-transitory computer-readable medium of claim 7 wherein the query is processed as a plurality of batches.
11. The non-transitory computer-readable medium of claim 7 wherein the remote electronic device comprises a mobile computing device.
12. The non-transitory computer-readable medium of claim 7 wherein the polymorphic relationship is determined based on input received via a user interface.
13. 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 a request that has at least a database query comprising at least an expression using a polymorphic relationship and a database query language clause to narrow results, to add an expression to at least one database query language clause 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 by running the query against a portion of a set of data in the database, and to transmit a result for the database query, where the result is defined by at least the polymorphic relationship, to a remote electronic device.
14. The system of claim 13 wherein the database query is for a multitenant database.
15. The system of claim 13 wherein the expression selects different fields form a target of a polymorphic reference based on target type.
16. The system of claim 13 wherein the query is processed as a plurality of batches.
17. The system of claim 13 wherein the remote electronic device comprises a mobile computing device.
18. The system of claim 13 wherein the polymorphic relationship is determined based on input received via a user interface.