Need Help With a Velocity Script

[Joey_Forcelli1]

Hey All,

I am trying to put together a simple script to populate an image url based upon a integer value.  I essentially want 1 image if the value is greater than 0 and a default image if the value = 0.  I tried using the below script but it did not work (I have replaced the actual URL with place holder text for demonstration purposes only).

Now, if I set the "highest score" equal to XX, the script will work for leads with a highest score field value = XX.

Once I have this part figured out, I will also need to add an OR statement to check if "highest score 2" > 0

Sanford Whiteman​ - Hoping you can help me out.

Thanks in advance.

-JF

[Joey_Forcelli1]

Still trying to troubleshoot this and I am thinking that the field is not being recognized as a integer field.

I set $test = highest score + 1 and the output was [highest score]1. 

[SanfordWhiteman]

#if( $convert.parseNumber($OpportunityList[0].Highest_Score__c) > 0 )

[Joey_Forcelli1]

Thank you Sanford.

To turn this into an OR statement, would the logic need to be:

#if( $convert.parseNumber($OpportunityList.get(0).Highest_Score__c) > 0 || $convert.parseNumber(${OpportunityList.get(0).Highest_Score_2__c}) > 0 )

[SanfordWhiteman]

You don't need the one with curly braces at all.  $convert coerces the string to a number.

[Joey_Forcelli1]

The second part of that statement is a different field I also want to evaluate.  Are you saying to drop the "$convert.parsenumber" piece?

I just tried the following and it did not work:

#if( $convert.parseNumber($OpportunityList.get(0).Highest_Score__c) > 0 || ($OpportunityList.get(0).Highest_Score_2__c) > 0 )

[SanfordWhiteman]

You need to wrap all string vars in $convert.parseNumber(). Sorry if that wasn't clear!

[Joey_Forcelli1]

Sorry dude, very new to velocity scripting.

I just tried the following and again it didn't work:

#if( $convert.parseNumber($OpportunityList.get(0).Highest_Score__c) > 0 || $convert.parseNumber($OpportunityList.get(0).Highest_Score_2__c) > 0 )

Appreciate your help with this.

[SanfordWhiteman · Accepted solution]

Sounds like you're getting empty strings, not just "0" strings. As long as those fields both exist (even if empty) on every Opportunity object, this works for empty strings and numeric values.

#set( $targetOpp = $OpportunityList[0] )
#foreach ( $oppScoreField in ["Highest_Score__c", "Highest_Score_2__c"] )
#if( $targetOpp[$oppScoreField].isEmpty() )
  #set( $targetOpp[$oppScoreField] = 0 )
#else
  #set( $targetOpp[$oppScoreField] = $convert.parseNumber($targetOpp[$oppScoreField]) )
#end
#end
#if( $targetOpp.Highest_Score__c > 0 || $targetOpp.Highest_Score_2__c > 0 )
One or both fields is > 0.
#else
Neither field is > 0.
#end

Note that I use the square brackets [0] syntax as get() is just OOP chaff.

[Joey_Forcelli1]

Regret to say but this didn't work for me either.  Going to go an alternate route and create a Boolean field that gets updated by the 2 fields I need evaluated and run my script off that field.

I still don't understand why #if( $convert.parseNumber($OpportunityList.get(0).Highest_Score__c) > 0 || $convert.parseNumber($OpportunityList.get(0).Highest_Score_2__c) > 0 ) does not work.  The first half of the formula worked perfectly but when I added the pipes and the second half it wasn't returning the correct value.  The lead I tested the script with had highest score = 22 and highest score 2 = 0 and rendered a false output.

Thanks for all your help Sanford.  Thought we had it.