The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.

The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.

Date of Patent:
May. 24, 2022

Filed:

Apr. 17, 2020
Applicant:

Salesforce.com, Inc., San Francisco, CA (US);

Inventor:

Rohitashva Mathur, Walnut Creek, CA (US);

Assignee:

salesforce.com, inc., San Francisco, CA (US);

Attorneys:
Primary Examiner:
Int. Cl.
CPC ...
G06F 16/2452 (2019.01); G06F 16/2455 (2019.01); G06F 16/22 (2019.01); G06F 16/242 (2019.01);
U.S. Cl.
CPC ...
G06F 16/24524 (2019.01); G06F 16/221 (2019.01); G06F 16/242 (2019.01); G06F 16/2455 (2019.01);
Abstract

A query to retrieve database values for a first subset of table columns in a database table is determined. Runtime column selection variables are set up to identify the first subset of table columns for data retrieval, and are dynamically bound to a prepared query statement with single-column query statements joined by interstitial union operators. Each single-column query statement in the prepared query statement specifies a single-column query directed to a corresponding table column with a corresponding predicate to be bound at runtime dynamically with a corresponding portion of the one or more runtime column selection variables. The predicate is evaluated to be true or false in dependence on whether the corresponding table column is in the first subset of table columns. The prepared query statement is executed to retrieve database values for the first subset of table columns in the database table.


Find Patent Forward Citations

Loading…