I am trying to create a BPM from Erp.CustCnt.Update method directive to apply data to a field in the CustCnt Table, I also want to update the PerCon table so have Inserted an “Invoke BO Method”, using “Update Table by Query”
See layout below.
The query is simple using just the “ttCustCnt” with the criteria of “ShiptoNum” = “” to display the Company, PerconID
The Invoke BO Method is set to use the above Query to update all rows of the PerconUpdateTable.PerCon (“variable”) table with the configured mapopings.
The mappings are all ignore except the field I wish to update, I have the table relationships set to Company = Company and PerConId = PerConId
Where am I going wrong.? Or is what I’m doing impossible?
Good intentions aside, whoever designed this approach with the idea that you could call BO/Methods without Code may indeed be a diabolical and twisted soul who is probably still laughing at the thought of us using it. It does work, but it’s so painful and laborious to use, the time spent building one you could have taught yourself to write code from scratch. Ok, maybe I’m venting a little, but it’s not a fun tool. You’ll need to get a dataset to work with, either by GetByID, Rows, something, setup your variables, datasets, plus any other that may apply etc… I’ve muddled through a couple out of curiosity, but decided to take up cutting myself for a hobby instead. So here’s a working example that i made. Whenever a row is added to a UD table, it looks up a part in part entry (data validation done elsewhere) and updates a checkbox. Simple, but it works and should demonstrate the elements needed… This is for Version 10.1.400.11, should work for any 10.1 point release.
Glenn,
If Rob’s sample wasn’t enough to get you going along, what I have included might help.
I assumed that you were updating the corresponding PerCon record for the CustCnt that is being updated and that triggers the directive.
The Invoke BO Method I used was PerCon.UpdateExt.
In the configured parameters I created a dataset variable (tblPerCon) to be passed to the method. So the bindings looked like this:
a. ds -> tblPerCon
b. Continue processing on… -> false
c. Rollback… -> true
d. errorsOccurred -> ignore
e. -> ignore
I used the Fill Table by Query to fill the tblPerCon variable. The query has ttCustCnt joined to Erp.PerCon on Company and PerConID.
For display fields from my query I selected PerCon_Company and PerCon_PerConID.
In the mapping I populated:
• tblPerCon.Company with PerCon_Company,
• tblPerCon.PerConID with PerCon_PerConID
• tblPerCon.Address3 with a test text entry to demo that the change occurred
• tblPerCon.RowMod with “U”
…Real cute Glenn… LoL (Moderator)
“LMAO
Problem is I’m not a coder so have to resort to the tools I have available.
I managed to do what I needed (have the scares to prove it)
Have attached the BPM that I completed. I’m not sure if you’ll need the UD fields to import.
Thanks for the help though.
Cheers
Glenn”
Older thread, I know but It pertains to what I am trying to do.
In your example: ElementBOCall.bpm,
I see you created a variable ‘Checkbox02’ and set to true, where did you use it?
I would have thought in the Update Table by Query but I didn’t see it in there. Just the rowmod.
lol