“Invalid index: Cannot index property ’’identifier’’ of type String into type List of Variant

Question

Expression evaluation error [evaluation ID = H0IAIER6] 
 in rule 'apac_getidentifiersforexcelreport' 
 (called by rules 'apac_sgp_importrqstlogrptdisplay' > 'apac_sgp_reportsdashboard'): &ldquo;Invalid index: Cannot index property &rsquo;&rsquo;identifier&rsquo;&rsquo; of type String into type List of Variant 
 
 Can someone guide where to proceed with this defect ? 
 
 this errro comes in reports

Mike Schmitt · Answer

Usually this would mean you're trying to directly reference a property (in this case named "identifier") of a local variable you expect to be loaded with a CDT/dictionary containing that property, but in some cases apparently does not contain that (this can result i.e. when a query returns empty). I don't have any way of making more specific suggestions since you haven't posted any of the code from your rule ' apac_getidentifiersforexcelreport ' or told us what it contains, but the first thing you should check for is a place where you're calling i.e. "local!myVariable.identifier", and instead use the property() function to try to access the property in a failsafe manner, i.e. "property(local!myVariable, "identifier", null())"

Mike Schmitt · Answer

Much as in the original post here, the error message you're seeing there indicates that the result of your rule call for rule!RGRACSLBL_QE_getLabelChangeCountryByFilters() , with the parameters you listed, is returning an empty set , and you're trying to directly index the property named "id_int" into it. This would work if the rule (when executed against those parameters) returned a dictionary including a member named "id_int" -- but if you directly check the rule itself, i believe you will find it does not. 
 If you want to handle the case of the rule returning nothing, without producing this pink error, then correct use of the property() function should help you. I don't know what you tried already and found not to work, but the following *will* work assuming other things are configured as normal: 
 property(
 rule!RGRACSLBL_QE_getLabelChangeCountryByFilters(
 requestId: 10365,
 country: "Germany"
 ),
 "id_int",
 null()
)

GopalK · Answer

Hi mla , Please use property() or index() function to resolve this issue. Its always advisable to use index or property fucntion when you are indexing into any datasubset. See example code below, 
 property(
 property(
 rule!EDD_GetPendingListOfApprover(status_code: "F3"),
 "data",
 {}
 ),
 "businessGroup",
 ""
)

mla · Answer

thanks

sureshkumarm2211 · Answer

use index() function to compare the value

“Invalid index: Cannot index property ’’identifier’’ of type String into type List of Variant

Top Replies