infor.com
concierge
infor u
developer portal
Posts
Categories
Groups
Hubs
Developer
Healthcare
Hospitality
Public Sector
CloudSuites
Aerospace & Defense (LN)
Automotive (LN)
Chemicals (M3)
Corporate (FSM/HRT)
Distribution (Sx.e/CSD)
Distribution Enterprise (M3)
Engineering & Construction (LN)
Fashion (M3)
Food & Beverage (M3)
Healthcare (FSM/HRT)
Industrial (Syteline/CSI)
Industrial Enterprise (LN)
Manufacturing (M3)
Public Sector (FSM/HRT)
Solutions
Supply Chain Management (SCM)
Human Capital Management (HCM)
Events
Groups
Your Groups
User Groups
Migrated Forums
FSM/HCM/S3 - Infor Lawson 10.x
HCM/S3 - Learning and Development
HCM/S3 - Global HR
HCM/S3 - Talent Acquisition
HR Service Delivery
Human Capital Management (HCM) - EMEA
Infor Configuration Management for Service Industries
Lawson - Business Intelligence
Lawson - Financials
Lawson - Human Resources
Lawson - Supply Chain
Lawson - Supply Chain Management
Lawson - Technology
MSCM on Landmark
About
Community News
Email Community Support
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
CPQ: Ask a Colleague
FAQs, How-To, and Best Practices
Idea
Infor OS Portal
UI Design
CPQ: Tips and Tricks
Infor Homepages
Widget Development
Infor EPM Migration
Infor Ming.le