I want to query all items that are on the requisition. I am using the REQ-LINES fields but the query is only pulling the first item of the requisition. How can I get all requisition items to come through?
I think we are talking about the same thing! Here is a screen shot of where I am referring to.
[View:/cfs-file/__key/communityserver-discussions-components-files/57/Doc1.docx:320:240]
When you're attempting to view the Reqs, Are you storing the Information inside the Node (Using an Assign Node between REQ-LINES-Begin and REQ-LINES-END? If you have the connector from Beginning to the EndNode, only 1 record will be saved. You have to build your List by using Assign or MsgBuilder in the Loop.
In the screenshot above I've Highlighted the Start and End Nodes for my Requisition Line query (I'm building this currently for CSF Reuisitions, but it's the same concept for S3)
All the nodes between my beginning and end are validation and message building. I build a list of distributions, for Approval Filtering and build a HTML Table for Inbasket Display.
To get a super basic understanding of the process, create a Req Line query, place a single assign node inside the query, and set the Debug on the Assign node. Then run your flow locally. Check the log as you step through to see how the variables change each time the query loops.