Advanced searching of relational data via a mobile device

A computer program product comprising computer readable program code for searching of relational data stored in an on-demand database system by a user of a mobile communications device, the program code to be executed by one or more processors when retrieved from a non-transitory machine-readable medium, the program code including instructions to:

• receive, by the database system, information about searchable tables containing a plurality of fields information, the searchable tables being identified using a metadata API, wherein at least one of the plurality of fields has a relationship to a corresponding object, the metadata API providing information about the schema information of the plurality of fields and the relationship of the at least one of the plurality of fields to the corresponding object;
• provide, by the database system, information to the mobile communications device to cause to generate a first view of relational data based on i) at least one of the plurality of fields of at least one of the searchable tables, and ii) the relationship between the at least one of the plurality of fields and its corresponding object;
• receive, by the database system, a set of inputs from the user for searching the relational data based on the relationship between the at least one of the plurality of fields to its corresponding object presented in the first view;
• create, by the database system, a query definition that is defined by the received set of relational data search inputs from the user when all of the set of relational data search inputs is received and associating the query definition with an icon;
• store, by the database system, the created query definition;
• and
• cause, in response to receiving a selection of the icon by the user, the database system to apply the stored query definition and the metadata API to retrieve the relational data, and search the relational data at a later time by reusing the stored query definition without additional input from the user or database system.

A system for advanced searching of relational data in an on-demand database system by a user of a mobile communications device, the system comprising:

• one or more hardware processors;
• and
• a non-transitory computer readable medium storing a plurality of instructions, which when executed, cause the one or more processors to:
• receive, by the database system, information about searchable tables containing a plurality of fields information, the searchable tables being identified using a metadata API, wherein at least one of the plurality of fields has a relationship to a corresponding object, the metadata API providing information about the schema information of the plurality of fields and the relationship of the at least one of the plurality of fields to the corresponding object;
• provide, by the database system, information to the mobile communications device to cause to generate a first view of relational data based on i) at least one of the plurality of fields of at least one of the searchable tables, and ii) the relationship between the at least one of the plurality of fields and its corresponding object;
• receive, by the database system, a set of inputs from the user for searching the relational data based on the relationship between the at least one of the plurality of fields to its corresponding object presented in the first view;
• create, by the database system, a query definition that is defined by received set of relational data search inputs from the user when all of the set of relational data search inputs is received and associating the query definition with an icon;
• store, by the database system, the created query definition;
• and
• cause, in response to receiving a selection of the icon by the user, the database system to apply the stored query definition and the metadata API to retrieve the relational data, and search the relational data at a later time by reusing the stored query definition without additional input from the user or database system.