GSC - Salesforce SOQL Query Generator Part 1

SOQL Description

SOQL Queries are used to query data from Salesforce.

SELECT fieldList FROM object [WHERE conditionExpression]  [ORDER BY fieldName ASC | DESC ? NULLS FIRST | LAST ? ] LIMIT number_of_rows

The query can be broken into following logical units:

1. Select Clause

2. From Clause

3. Where Clause

4. Order by Clause

5. Limit Clause

We want to build out the wireframes of the UI that enables a user to create a query by simply selecting the appropriate Table, Fields and Comparison operators.

Challenge Description:

This challenge will be an enhancement to existing Salesforce Googlesheet connector. We want to complete following requirements as part of this challenge

1. Install and configure existing Salesforce Googlesheet connector. Deployment guide will be provided in the forums.

2. As per current implementation, user can create/edit a query from following places marked in below image

   

   • ���By clicking on the + sign (Marked as 1), GSC opens a modal window to create a query and allows user to select a query from a predefined set.

   • 

   • Replace “Select query text and dropdown box” with “Create a Query” button and redirect user to new SOQL generator to setup a new query or load from previously created queries. A read only query will be displayed on the screen once, query is generated.

   • 

   • If user wants to edit an individual query, he click on the edit icon (Marked as 2). This will open modal with query details. Display Edit query button, which will open the SOQL Query generator to edit the query if user wants. The query drop-down will be replaced with read-only text.

   • 

3. Fetch all objects from logged-in user’s salesforce org, which are accessible to user. Display them on the “Available Tables” section.

   • Query Objects which satisfy any of the following properties as true, for the current user

     1. Createable

     2. Updateable

     3. Queryable 

   • ���������Query all object fields

   • Query fields details i.e. if field is lookup, get its child-relationship name etc.

  Refer below link for object properties

https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_calls_describesobjects_describesobjectresult.htm

4. Allow users to drag and drop objects to “Selected Table” field.

5. User should be able to select fields from the selected object

   • Allow to select all fields

   • Allow to select individual fields

   • Search fields

6. UI will start building queries as soon as the user starts selecting fields from an object and will display at the top section.

   • Allow user to make manual changes to query.

7. Allow users to perform following operations

   • Save query in the query sheet

   • Execute query to fetch results

   • Load already saved queries

8. Update unit tests included in GSC project based on  the new code written or changes made. Unit tests should cover most if not more than 60% of the core functionality added. Mocking of server requests and responses is permitted

Challenge attachments

1. Salesforce Google sheet connector

   • Code Base

   • Deployment guide

2. UI Wireframes

Sample Queries

Please use below queries to verify your solution

1. SELECT Id, Name, BillingCity FROM Account

2. SELECT Id FROM Contact

3. SELECT Name, (SELECT LastName FROM Contacts) FROM Account

4. SELECT Name, (SELECT lastname FROM Contacts),  (SELECT CreatedBy FROM Notes) FROM Account

5. SELECT Amount, Id, Name, (SELECT Quantity, ListPrice, UnitPrice, PricebookEntry FROM OpportunityLineItems) FROM Opportunity

References

Strictly follow Salesforce Lightning Design System to develop the UI and components.

https://www.lightningdesignsystem.com/design/overview/