###################################################################################### Building a Configurable Filter that Ignores Records Based on User-selected Cutoff Date ###################################################################################### Here we'll take a slightly more advanced scenario and walk through it. **************** Desired Behavior **************** * A User can apply a condition to an incoming date field where that field is evaluated and if it fails our test, the record is ignored. * The test will be comparing the record's date in the field to a cutoff/threshold date that has been configured by the User. * A User should be able to apply this condition to any incoming date field, and (if desired) more than one date field on the same record. * The cutoff dates are configured per-mapping, so if multiple fields should be inspected they can have different cutoff dates. ******************** Solution Walkthrough ******************** To satisfy these expectations we'll want to create a :ref:`custom Filter ` that implements both :doc:`/filter-interfaces/transformation-filter` and :doc:`/filter-interfaces/configurable-per-mapping-filter`. Our configuration needs are pretty simple (just a date picker), so we'll use the :doc:`/extension-concepts/configuration-structure` pattern for handling configurations. Class Declaration ================= We start out with our class declaration and implementing both of our interfaces. .. literalinclude:: /code/IgnoreOldRecordsFilter.cls :language: java :lineno-match: :lines: -5 .. warning:: Make sure you declare your class as **global**, otherwise Valence won't be able to see it and use it! Configuration Setup =================== Since we opted for :doc:`a configuration structure `, we'll be returning **null** from getMappingConfigurationLightningComponent(). The shape we return from getMappingConfigurationStructure() will be used by Valence to build a UI on our behalf and show it to the User. We are going to use the "date" flavor of `lightning:input`_ by setting the "type" attribute on that base component so that our User gets a nice, friendly date picker. Valence will save the User-selected date to the database for us, and we'll be given the value back later when we need it. .. _lightning:input: https://developer.salesforce.com/docs/component-library/bundle/lightning:input/specification .. literalinclude:: /code/IgnoreOldRecordsFilter.cls :language: java :lineno-match: :lines: 7-19 .. tip:: We don't have to set "componentType" on the **cutoff** field because lightning:input is the default component type. Configuration Explanation ========================= We always want to give the User useful information about what they've done and what they can expect. Valence uses explainMappingConfiguration() to give us an opportunity to interpret a configuration and break it down in plain language for the User. .. literalinclude:: /code/IgnoreOldRecordsFilter.cls :language: java :lineno-match: :lines: 21-28 Configuration Class =================== For convenience and cleanliness it's a good idea to create a simple inner Apex class to hold your configuration structure. Valence serializes configuration values from the form the User filled out into a JSON object whose keys are the **name** values you specified in your configuration schema. In our case we defined a single field called **cutoff** that we expect to find a serialized Date value inside. .. literalinclude:: /code/IgnoreOldRecordsFilter.cls :language: java :lineno-match: :lines: 70-75 Restricting Filter Usage ======================== Some Filters only make sense in specific scenarios, for example RelationshipFilter (the built-in Valence Filter that handles populating Master-Detail and Lookup fields) only makes sense for records flowing into Salesforce, not outbound. For this cutoff Filter we are building, we aren't going to restrict it to only certain Links. All Links can use it. .. literalinclude:: /code/IgnoreOldRecordsFilter.cls :language: java :lineno-match: :lines: 30-32 Processing Records ================== Finally, we get into the core purpose of our Filter: ignoring old records. Let's walk through our process() method. 1. Set up a Map we will use to line up the names of the record fields we're going to inspect with the configured cutoff date for each field. .. literalinclude:: /code/IgnoreOldRecordsFilter.cls :language: java :lineno-match: :lines: 34-36 2. Iterate through the :doc:`/classes/mapping` instances we are given as part of the :doc:`/classes/link-context`. Remember that Valence is clever here and will inject serialized User configurations from the database into mapping.configuration properties wherever the User has set up a configuration. 3. We collect the **cutoff** Date values from a deserialized Configuration instance for any populated configurations. .. literalinclude:: /code/IgnoreOldRecordsFilter.cls :language: java :lineno-match: :lines: 41-48 4. Now that we've assembled our Map, if it's empty we can stop processing. .. literalinclude:: /code/IgnoreOldRecordsFilter.cls :language: java :lineno-match: :lines: 50-52 5. Now we iterate through the incoming :doc:`/classes/record-in-flight` instances. .. literalinclude:: /code/IgnoreOldRecordsFilter.cls :language: java :lineno-match: :lines: 58 6. For each field we need to check, inspect that field's value for this record. .. literalinclude:: /code/IgnoreOldRecordsFilter.cls :language: java :lineno-match: :lines: 59-60 7. Compare the field value to our cutoff date for this field. If older than the cutoff, mark this record as :ref:`ignored`. .. literalinclude:: /code/IgnoreOldRecordsFilter.cls :language: java :lineno-match: :lines: 61-64 .. hint:: You can see in the code for this example scenario we are assuming that all dates are being transmitted as Long values, i.e. milliseconds since Epoch. This is a simplification and you may not be able to make this same assumption in your real-world scenario! ****************** Full Solution Code ****************** Here is the complete solution code that we walked through above. .. literalinclude:: /code/IgnoreOldRecordsFilter.cls :language: java :lineno-match: