Model Condition Enhancement - Condition on something other than field value

  • 1
  • Idea
  • Updated 4 years ago
  • (Edited)
Ok, admittedly this one probably wouldn't be used much but I actually have a specific need for this currently and the solution I've come up with just doesn't scream "obvious to the untrained eye."

Would be great to be able to define a condition on a model that evaluates a dynamic value against something other than a field value.  

Here's my current use case:
I have a page that has 3 models.  On clone, I only want to clone Model #1 & Model #2.  This works perfectly by setting those models to 'yes, if clone parameter is specified in URL'.  However, for Model #3, not only do I not want it cloned but I don't want it populated at all.  My page handles New & Existing records so even if I set Model #3 to clone = 'no', the model contains the records of the id in the url parameter.

Ask:
Add the ability to specify a condition where the "left side" of the operation can be something other than a model field (e.g. Param value).  If this existed, I set Model #3 to "clone=no" and include a condition where "Clone in URL parameter is blank".  This would give me a cloned #1 & #2 and an empty #3.  

Current Workaround
Define a condition on Model #3 evaluating against "Id' field using the URL Parameter "clone" and deactivating condition if parameter doesn't exist.  When "clone" is in URL, this will result in the where clause evaluating "Id = 'clone') which will return no results and an empty model.

Thanks!
Photo of Barry Schnell

Barry Schnell, Champion

  • 18,086 Points 10k badge 2x thumb

Posted 4 years ago

  • 1
Photo of Barry Schnell

Barry Schnell, Champion

  • 18,086 Points 10k badge 2x thumb
Came across another use case for this...

We have models that have multiple record types.  When building a tab page, we only want to display certain objects based on a set of criteria.  Users have access to all the objects so the built in security of SFDC won't filter out records based on authorization.  

To accomplish the goal, we have a condition on the model (e.g. RecordType = TypeXXX).  However, this requires one of two things:

1) Programatically modifying the condition and requerying model on page load
2) Having multiple pages, one for each set of evaluation criteria

If a model condition could be created that allowed the left side to be things like field in another model, url parameter, userinfo, etc. this would allow us to have a single page to serve all purposes and avoid having to write code to accomplish

A very basic example would be Model Conditions that look something like:

1: RecordType = Type1
2: RecordType = Type2
3: FieldInAnotherModel = true

Then the Grouping Logic would be:
1 OR (2 AND 3)

Another approach would be to allow the Grouping Logic to contain the necessary merge syntax. This likely would be more a more technically invasive change but would be pretty cool. For example:

1 OR (2 and $Model.CriteriaModel.data.0.IsAllowed__c = true)

In short, what I'd like the end result to be is something along the lines of the following

SELECT Name
FROM Model
WHERE
(
     (RecordType = Type1)
     OR
     (
         (RecordType = Type2)
         AND
         (true = true) // the left side is the value from OtherModel.Field__c
     )
)

Thanks!