infor.com
concierge
infor u
developer portal
Home
Groups
Process Automation (IPA) Community
PFI to IPA query string was not convertible for WFMSGDTL
mbozenik
Converting PFI flows to IPA flows. More specifically PFI WFMSGDTL query nodes to IPA PFIMESSAGE query nodes. The issue are landmark queries nodes that call wfmsgdtl. They are now in pfimessage/s$pfime. I've been trying to come up with the proper transaction string, but I can't seem to get rid of the query string was not convertible error.
PFI:
PROD=LOGAN
&FILE=WFMSGDTL
&FIELD=MESSAGE;MESSAGE-APPEND;MESSAGEHDR.CREATED-BY;MESSAGEHDR.ATTACH-BY
&SELECT=WORKUNIT=
&OUT=CSV&DELIM=~
IPA:
_dataArea="lawprod"
& _module="pfi"
& _objectName="PfiMessage"
& _actionName="Find"
& _actionOperator="NONE"
& _actionType="MultipleRecordQuery"
& _runAsUser=""
& _authenticatedUser=""
& _pageSize="30"
& _relationName="PfiActorRel"
& _setName="SymbolicKey"
& _asOfDate=""
& _effectiveDate=""
& PfiWorkunit=""
& PfiMessage & AttachByName & Message
--First is it safe to 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.
Find more posts tagged with
Comments
mbozenik
I was able to get it to work by deleting and re-adding the nodes. It appears s$pfime is part of the pfimessage implicitly.
Important Links
Community Hubs
Discussion Forums
Groups
Community News
Popular Tags
ION Connect
ION API Gateway
ION Workflow
Syteline Development
CPQ Discussion Ask a Colleague
Infor Data Fabric
Infor Document Management (IDM)
LN Development
API Usage
FAQs, How-To, and Best Practices