In the basic filter of a lookup configuration on an SFM, I'm successful filtering based on a lookup field like this:
Location - equals - value - SVMX.CURRENTRECORD.SVMXC__Site__c
But if I try to filter based on a picklist field, it breaks and I get the 'loading' cursor that lasts forever when I click on the lookup on the SFM. An example:
SomeValue - equals - value - SVMX.CURRENTRECORD.PickListField__c
Is it possible to use CURRENTRECORD with a Picklist? Or is the CURRENTRECORD literal only supposed to work with Lookup fields? Bonus if you can provide documentation
Thanks!
-Andy
Yes, it is possible to use SVMX.CURRENTRECORD in a lookup configuration's basic filter with a picklist field. For this to work, please ensure the following:
- PickListField__c is the API Name of a field which exists in the SFM transaction's target object (header or child), and does not refer to a field in the looked up object itself. For example, if the basic filter is being defined for the Part field (Product lookup field) in Work Detail object, PickListField__c field should exist in Work Detail object.
- PickListField__c must be included in the SFM transaction's page layout.
The example used in online help section on basic filters shows SVMX.CURRENTRECORD with a date field. Same example is mentioned in the section on SFM Literals.
Regards,
Meenakshi.
Hi Andrew,
SVMX.CURRENTRECORD.<FieldAPIName>: This is not a picklist literal. This literal is only available in for Lookup Pre-filter Criteria, Value Mappings, and Field Mappings. This cannot be used to apply Mapping for “Create New Record” type SFMs. This literal is not supported for Advanced Lookup Filters, Advanced Data Validation, SFM Expressions, or Source Object Updates.
Here is some more helpful documentation on Literals. I also uploaded this document to the documentation section here is the link: Literals and Linked Process Docs.docx
Literals:
This literal is not supported for Advanced Lookup Filters, Advanced Data Validation, SFM Expressions, or Source Object Updates.
This literal is not supported for Advanced Lookup Filters, Advanced Data Validation, SFM Expressions, or Source Object Updates.
Note: This is the one often used when defining Linked Process value mappings.
Thanks,
Mike
literals reference documents supportedliterals sfm sfm mappings picklists lookupfilters lookupfields sfm transactionsfm trasaction designersfm configuration
Yes, it is possible to use SVMX.CURRENTRECORD in a lookup configuration's basic filter with a picklist field. For this to work, please ensure the following:
- PickListField__c is the API Name of a field which exists in the SFM transaction's target object (header or child), and does not refer to a field in the looked up object itself. For example, if the basic filter is being defined for the Part field (Product lookup field) in Work Detail object, PickListField__c field should exist in Work Detail object.
- PickListField__c must be included in the SFM transaction's page layout.
The example used in online help section on basic filters shows SVMX.CURRENTRECORD with a date field. Same example is mentioned in the section on SFM Literals.
Regards,
Meenakshi.
Thanks Meenakshi S,
That's exactly the way I've it setup, but it wasn't working. No time to revisit now, but if I get a chance I will see if I can get it to work and report back. Have you actually used this literal to match two Picklist fields in a basic filter before, or do you just know it's possible?
Thanks!
-Andy
Yes, I have checked and seen it working, as recently as in Spr 15 SP release. And, if the API Name of the field specified after the prefix SVMX.CURRENTRECORD. is not correct or if that field is not included in the page layout, I have seen the issue you have described (loading cursor shown forever).
Regards,
Meenakshi.
Great answer, thank you for the quick and thorough responses!
-Andy