Export to Excel in Records working in Tempo but not in Grid

Question

Hi All, 
 I have a Record type configured in a Grid and the Grid i have configured some set of columns which are coming from the Record Type. 
 The Export to excel button works in Tempo. 
 However in the Grid when we configure the Export to Excel button It is throwing an error. 
 It says expression evaluation error at function if parameter 2 line 73 invalid symbol found comma. 
 But when i validate the interface it is working fine. 
 Can someone help me out.

harshav · Accepted Answer

Hi Peter Lewis and i did change my query for a one grid column like this and tried and it worked, but 
 i replaced my contains parameter with search and tried and it worked. But why is contains not working i am not able to figure it out. Any thoughts on this please. 
 a!gridColumn( label: "Org - Position Desc", sortField: 'recordType!{d806002b-c5b8-4f1f-b67e-f5ffa63826a4}s.fields.{orgPosition}orgPosition', value: a!richTextDisplayField( value: { a!richTextItem( text: fv!row['recordType!{d806002b-c5b8-4f1f-b67e-f5ffa63826a4}s.fields.{orgPosition}orgPosition'], color: if(search("orgPosition",fv!row['recordType!{d806002b-c5b8-4f1f-b67e-f5ffa63826a4}s.fields.{updatedFields}updatedFields'])>0, 
 "#FFBF00", "STANDARD" ), 
 style: if(search("orgPosition",fv!row['recordType!{d806002b-c5b8-4f1f-b67e-f5ffa63826a4}s.fields.{updatedFields}updatedFields'])>0, "STRONG", "PLAIN" ) 
 ) } ), width: "NARROW_PLUS" ),

Export to Excel in Records working in Tempo but not in Grid

Top Replies