Challenge Summary
Welcome to the Salesforce SOQL Query Generator Application Wireframe Challenge.
The objective of this Challenge is to create the HTML wireframe to generate SOQL Query that will developed in Salesforce application in next development based on guidelines stated on challenge details below
You’re encouraged to use Axure or Balsamiq Wireframe Development Application for this challenge
Round 1
Initial Salesforce SOQL Query Generator Application Wireframe
Round 2
Final Salesforce SOQL Query Generator Application Wireframe with updated Checkpoint Submission Feedback.
IMPORTANT!
- You submission format need to be clickable wireframe.
- For this wireframe challenge, you need focus how application works for Desktop Screen Size only.
- Your wireframe need to be able to drill down all interactions and flow.
- Click flow need to created as details as possible to let us understand your proposed solution
Wireframe Requirements:
A SOQL Query is a used to query data from Salesforce application.
The queries can be broken into these parts:
1. Select Clause
2. From Clause
3. Where Clause
4. Order by Clause
5. Limit Clause
We want to build a UI that allows the user the create a query by simply selecting the Table, Fields and comparison operators.
Anatomy of a Query:
SELECT fieldList FROM objectType [WHERE conditionExpression] [ORDER BY fieldName ASC | DESC ? NULLS FIRST | LAST ? ] LIMIT number_of_rows
SOQL Query Feature Notes:
- The UI should enable the user to construct “Select”, “From”, “Where”, “Order by” and “Limit” parts
- The UI should show the Query as it is being generated in an editable text box.
- Think about modern form feature to let user quickly insert and select the query field
- The User should be able to create nested queries, example:
“SELECT Name, (SELECT LastName FROM Contacts) FROM Account”
- The UI should be simple and intuitive.
- Your wireframe solution is possible to build for Web Development using Html, css, javascript, jquery, bootstrap
- The UI should be concise and should fit in a popup/modal window.
- Put actions button to run the query in page
- Show us how the Query Result table generated
- Need ability to save the custom selected query. How the list show up? What happens if user click the saved query?
- Show us notes to explains your proposed solution.
Sample Queries:
- SELECT Id, Name, BillingCity FROM Account
- SELECT Id FROM Contact WHERE Name like 'A%' AND MailingCity='California'
- SELECT Id, Name FROM Account ORDER BY Name DESC NULLS LAST
- SELECT Id, Name FROM Account WHERE industry = 'media' LIMIT 125
- SELECT Id, Name FROM Account WHERE industry = 'media' ORDER BY BillingPostalCode ASC NULLS last LIMIT 125
- SELECT Name, (SELECT LastName FROM Contacts) FROM Account
- SELECT Name, (SELECT LastName FROM Contacts) FROM Account
- SELECT Name, (SELECT lastname FROM Contacts WHERE CreatedBy = 'x') FROM Account WHERE industry = 'media'
- SELECT Name, (SELECT CreatedBy FROM Notes) FROM Account
- SELECT Amount, Id, Name, (SELECT Quantity, ListPrice, UnitPrice, PricebookEntry FROM OpportunityLineItems) FROM
- SELECT Id, Name, (SELECT Id, FirstName, LastName FROM Contacts) FROM Account WHERE Name like 'Acme%’
Target Audience
- SOQL Query Generator Customers
Judging Criteria
- User Experience of Salesforce SOQL Query Generator Application Wireframe Challenge
- Completeness and accuracy of the wireframe as defined in the spec requirements.
- How well your wireframes provide a consistent user flow.
- Possible to build as responsive web solution?
Submission & Source Files
Preview Image
Please create your preview image as one (1) 1024x1024px JPG or PNG file in RGB color mode at 72dpi and place a screenshot of your submission within it.
Submission File
Wireframes should be built in Axure or Balsamiq. The resulting files are not critical in this Challenge. The most important point is that all the content is listed and the pages are linked together to show page flow.
Keep your source files out from this submission folder.
Source Files
All original source files of the submitted ideas. If you would like to submit notes please include notes.txt file.
Final Fixes
As part of the final fixes phase you may be asked to modify content or user click paths.
Please read the challenge specification carefully and watch the forums for any questions or feedback concerning this challenge. It is important that you monitor any updates provided by the client or Studio Admins in the forums. Please post any questions you might have for the client in the forums.