We have several Process Flows with DME calls to workflow tables. When they are converted to IPA, the majority of these nodes not converted at all or partially converted if there were references to other tables. All the calls accessing WFWORKUNIT converted to PfiWorkunit; however any references to WFVARIABLE fields did not convert. All the calls accessing WFMSGDTL did not convert at all. Is there a KB or documentation to help with trying to find the equivalent tables and relationships?
Thank you, Tim!
I've run into the same issue. I'm curious if you got the transaction script to work? Did you join s$pfime to get to message? Did you use the build wizard or did you just change the script manually? I've tried both and still get: query string was not convertible error. I can't seem to clear it.
This was the old PFI query PROD=LOGAN &FILE=WFMSGDTL &FIELD=MESSAGE;MESSAGE-APPEND;MESSAGEHDR.CREATED-BY;MESSAGEHDR.ATTACH-BY &SELECT=WORKUNIT=t> &OUT=CSV&DELIM=~
I tried this using the build button: _dataArea="lawprod" & _module="pfi" & _objectName="PfiMessage" & _actionName="Find" & _actionOperator="NONE" & _actionType="MultipleRecordQuery" & _runAsUser="" & _authenticatedUser="" & _pageSize="30" & _relationName="PfiActorRel" & _setName="SymbolicKey" & _asOfDate="" & _effectiveDate="" & PfiWorkunit="kUnit>" & PfiMessage & AttachByName & Message --I assume that Message is really joining pfimessage and s$pfime and returning s$pfime.message? Or do I need to change this landmark query to a sql query and join the tables.