Challenge Overview
We launched our previous challenge to modify the base design of Pipeline Page .We launched another challenge last week and we have enhanced our code to support multiple default filter selection based on url parameter .This challenge is to play with Jquery datatable library and enable filter by Blank/Empty feature in our Pipeline Table.
Requirements specification:
1) Filter by Blank Based on URL parameter
If current page url contains parameter having no value/blank value page should be loaded with filter by blank values .
Datatype : Picklist
Example: assume current page url is →
https://c.cs18.visual.force.com/apex/pipeline?header=MA+Pipeline&Channel=&Type_1=Web&Type_2=Walk+In
This page loads as below screen
In url Channel is Blank but it’s filtered with All values.This need to be fixed as when we have any parameter having blank value in url then record should be filtered by blank values not all values.All should be default when no parameter exist in url.
Expected screen for this will be:
*See channel is blank for these 2 records.
Datatype : Text
If url contain a text Type Column and that holds empty value we should add a space → ‘ ‘ in search box and filter by blank values as per screenshot below:
See Account ID is empty in url parameter so accountid column should filter with empty vslues.
Datatype Date
Add a checkbox ‘Filter Blank’[Store this label is Custom Label] in Datepicker filter below ‘This month’.If url parameter contains blank like ‘Created= ‘ then check that checkbox and filter those record where created is empty.
2)Filter with Blank based on user action.
How it should work for Different Datatype?
1) Text : If we type space/blank in search it should filter all those data where that column holds blank/empty value.Currently it shows all values.As datatable.js search for ‘all’ when you search by empty.
Picklist : add a value ‘None’ in Picklist and if None is selected filter by empty.
Date: there should a checkbox as explained earlier.if that is checked then filter by empty dates.
[*For any other type use creative idea to filter by blank.It should filter for all datatype where blank can exist.]
How to Start:
1)Install unmanaged package in a fresh Dev org.
2)Give pipeline access in User record.
Create Records as Per below screenshot.
1)MA Pipeline
2)New Sales
Final Submission Guidelines
1) Include your source and package.xml.
2) Include a video showing your solution in action. If English is your second language feel free to annotate your video rather than narrate it. A video walk-through of your code is nice but not required.
3) Provide detailed documentation of your solution. Include installation and setup instructions.
4) Also you may choose to provide the login and password to your dev org. This is not required but will only help you in the judging if you omit something in your package the and judges have difficulty installing. If you do this you should also install Ray Dehler’s “Enable All Trusted IP ranges” so we don’t have to ask your for the activation code.
5) Your solution should works in all popular browsers like IE,Chrome,Firefox,Safari etc.