AnsweredAssumed Answered

Set Properties with Cache Lookup

Question asked by on Nov 14, 2017
Latest reply on Jan 6, 2018 by mmorthala189353

This is my first time using a Document Cache Lookup, and I am having some difficulty.  I have a Set Properties shape configured in a similar manner to the Set Properties example found here: Document Cache Best Practices and Common Scenarios 


I have a Cache of Project Group names and WBS1 Codes. 


Coming into the branch shape, we already have Dynamic Doc Property "ProjectGroup" set to 'ORCA T1T2 Cap'. 


Node 1 is supposed to search the ProjectGroup Cache by name and set dynamic document property WBS1 = 'OC'   The lookup works - it finds 'OC' but fails to set WBS1 = 'OC.' 


Later, in Node 4, it checks if WBS1 = 'OC' but fails because WBS1 is empty. 


Here is Node 1 log - it finds OC, but sets it back into Parameter 1, not the WBS1.

Here is Node 4 - Parameter 1 should be 'OC' but is empty.

Node 4


I want WBS1 to be set as the value 'OC' being returned from the Cache Lookup, but it isn't.



Here is the Cache Lookup.  The UI isn't so friendly here, but, here's a summary:

  • The Cached documents have several elements, including Name and WBS1.  
  • The Index is built on the Name property
  • The parameter is a dynamic document property (ProjectGroup) whose value matches a name
  • The output parameter is the WBS1 element of the cached ProjectGroups


Please help!