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
Process Automation (IPA) - General Discussions
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.
Quick Links
All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Popular Tags
Infor Lawson Human Resources Group - Discussion
Infor Lawson Technology Group - Discussion
General Discussions
VISUAL - Enterprise General Discussions
Infor Lawson Supply Chain Management - Discussion
Process Automation (IPA) - General Discussions
Pegasus - Partner General Discussions
Infor Lawson Supply Chain Group - Discussion
Infor Lawson Financials Group - Discussion
Infor EPM Discussions