you can troubleshoot the workflow using observations to narrow down the location in the workflow where the error comes fromref: Workflow Tooling - Technical Documentation For IFS Cloud
you could use a script task to do this calculation in the workflowSample code:var workset = execution.getVariable("Reference_SchOfWorkEstimateResourceSummary_Set");var myMap = {};for (var i = 0; i < workset.length; i++) {actSeq = workset[i].ActivitySeq;qty = workset[i].Quantity;if (actSeq in myMap ) { myMap[actSeq] = myMap[actSeq] + qty;} else { myMap[actSeq] = qty;}}i attached a sample workflow to show case this.
Scenario 1:Its not possible to use <> with parameters but, You could do something like check the availability of the customer order records and check the result using a gateway and if it does not exist and proceed to do the rest of the taskssample workflow setupgateway condition Scenario 2:Lets Assume that the CustomerNo is 20230810090640 then we could use a filter expression similar to following to get the behaviorPlease note this syntax needs to be entered manually to the filter text box as variable substitution is not supported in the query builder(customer_no = '${CustomerNo}' AND date_entered = to_date('${CustomerNo}','MMDDYYYYHHMISS'))
You could try to use parameters in the READ task to accomplish this Since DateEntered is a date time field you may have to format of the value to match the format “yyyy-mm-dd-hh.mm.ss.00000 00” for the search to work properly
What @Rukmal Fernando said is correct, you should be able to see the values passed into the workflow using the BPA_ASYNC_SYS_TAB.ATTR column.example:You should be able to see data similar to the following in that column!WF_RECEIPTINFOEVENT$LU=ReceiptInfo$NEW:INV_PART_NO=$NEW:RECEIPT_NO=1$NEW:ROWSTATE=Cancelled this should ideally be available to workflow as follows. { "InvPartNo":null, "ReceiptNo":1.0, "ROWSTATE":"Cancelled"}
Hi @kvbe,Few things need to be clarified,so when you set the workflow as async workflow gets triggered ? in the scenario 1 (add receipt from browser), is the workflow set as async? or other timing ? Is the user who is doing the web and mobile app same or atleast have the same permission sets? -You should be able to monitor/view asynchronous workflow runs using the table BPA_ASYNC_SYS_TAB. In here you should be able to see if the job is at least getting submitted Im not sure about the SCANIT application itself. but i suspect the ReceiptInfo table update from app comes as a background job. in such a case workflow needs to set as async to be triggered. From 23r2 on wards we can capture observation of async job executions using start watch option. if you are on a previous version you can use the “ATIR” data in the BPA_ASYNC_SYS_TAB as the input data for troubleshooting (debug) and compare the execution for “IP” status and “DONE”. (For this you need to convert the ATIR data to valid JSON)
In this call API is dealing with clobs, unfortunately as of now workflow does not support clob data type as an input in the API task Blob, Clob, GIS, and File datatypes are not supported currentlyKnown Limitations - Technical Documentation For IFS Cloud
.map() is a ES6 syntax in javascript and that is currently not supported form of syntax in workflowbut you should be able to do the same thing using it in the following way var orderNos = Array.prototype.map.call(CustomerOrderSet_Set, function(order) { return order.OrderNos;}).join(", ");execution.setVariable("OrderNos",orderNos ); Can you give it a try and see
Im not sure about the correct table though but from workflow point of view there is a scenario If the table CRUD operation happen through a background job, such event triggers are not picked up from workflows that trigger using AFTER timing. Can you try setting the workflow Timing to Asynchronous and try again.
workflow does not support $count option yet. You can use a script task for this purpose
Hi @dritter To get the correct value from the event action to the workflow as input you must enable the sourceref attributes in the event action.What is the IFS version you are in? There was an issue with event action trigged like this could pass the information from the first trigger for every following trigger. But it was fixed in the following releases 22R1 SU22, 22R2 SU15, 23R1 SU8, 23R2 SU1.
Currently Timer start event is not supported in IFS workflows. you can see more information here Timer start event in workflow | IFS Community
Is there a possibility can you share screenshots or a sample workflow to get a better idea on the issue?
Not sure about the issue you are facing but at least you should be able to monitor/view asynchronous workflow runs using the table BPA_ASYNC_SYS_TAB. In here you should be able to see if the job is at least getting submitted
The publicly available URL of the mentioned https://docs.ifs.com/techdocs/23r2/040_tailoring/500_business_process_automation/090_industry_specific_configurations/040_supplier_performance_evaluation_kpis/#trigger_workflow_as_a_background_job_for_projection_actions
If i understood correctly you can try to set the projection option to FinishInvoice() action on the ManualSupplierInvoiceAssistantHandling to trigger the BPA after creating a New Manual Supplier Invoice.
There is a similar question around this you can get bit more details about this From that there is a comment about the custom type“custom type” is from the used library. In IFS context, it is not implemented.
There is an issue with the way you are referring the variables you need to use execution.getVariable to get the reverent variable to the code. and since you are using Result variable and the code line seems to be a one liner, no need to declare the js variable using var key word. for eg: alternatively, you can also use execution.setVariable(<variable name>, <value variable>)l to set variables. eg: In the Projection delegate task you need to use expression language syntax to refer the variable eg:
3rd level nested entities are not supported in Workflows. From 23R2 onwards Entity Service APIs can be an alternative approach.
In here InvoiceConsideration is an Enum value, so you need to use the correct key value to get the desired behavior. from the api docs you can get that value and in the workflow designer
B2B gateway is currently not supported by Workflow.
Hi @kamnlk I’ve never done that before so this is very exciting! In said workflow, how do you change the value returned to the form? If you access that projection, I’m assuming it wouldn't be an Update or Call action.. so I’m not sure how you’d achieve that other than just using a javascript script task to update that returned value then just end the workflow? Am I on the right track? Thanks, Bryan Yes, you are on the right track. we can use a script task in the workflow to modify the input variable. (adding this comment for future reference)Glad you got it sorted out
Hi Bryan, You should be able to do this using a workflow. In the workflow configurations, projection action you can listen to SupplierForPurchasePartHandling → PurchasePartSupplier_Default() with process enrichment type with After timing. In the workflow you can set the value for the “Discount” to null to get this behavior. Hi @kamnlk if the timing is set to after, wouldnt this error out no matter what since the mandatory field would be set to null? Are you aware of any IFS functionality that allows for the modification of data on retrieval of fields? I noticed that for customer order lines, when you enter a qty the prices update automatically even though the line hasnt been saved yet. Thanks, Bryan Hi @bdoucette , Not quite, in this case we are not modifying/intercepting the api call that creates the purchase part. we are only changing the api response that populates the default values in the UI (PurchasePartSupplier_Default). Using this approach, we are preventing
@kamnlk are you allowed to update from 0 to null if the field is set as mandatory? What about creating a User interaction WF and once the SFPP is saved, trigger the WF and ask the user for the Discount% → read user’s response and update SFPP? Sorry i missed to reply about the latter part; Yes, using a User interaction WF is another approach for this use case.
yes in this case we are overriding the value of the default() function. we are not changing any value from database, just the client-side prefilled values.the expected output would be like this the projection action configuration used
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
