As title,
there are two difference from java or python with appian, one is there is not under_score marks for a list, such as list[0], the a!forEach seems can't apply with number, such as for(i=1,i<100,i++),
also there seems a!save(target:) can only save into one row of value, if I want to update a list, how should I do other than process model, thank you.
Discussion posts and replies are publicly visible
1.) a!forEach can deal pretty well with numbers. I just works differently than a for loop. Can you explain your concrete scenario? (check out the fv! function space. there are fv!Index, fv!item, fv!Islast.....2.) a!save can deal pretty well with arrays. it just depend what you want to archive. sometimes you need a loop function like a!forEach to support you. But in general there a plenty of aaray functions you can use in a a!save to archive manipulation of your array like a!update(), append, insert(), remove(), upadatearray()...What is your concrete scenario?
I am dealing a case that with double tables, from one table get person name and its projectId, the other table has the projectID and it is status_ID, if status_ID equal other than 3 or 4, then i need to change the person's name from the first table, a person can have multiple projectIDs.
give me a example of updatearry and a!update
how do you want to update it? via expression rule in your process? via button or linkaction in a form?
a!update() Function - Appian 21.3
updatearray() Function - Appian 21.3
a!update(data:type!KONE_Development_CSE_TENDER_PHASES_CDT(user:"song"), index:"user", value:"wang"), the data form is not correct, what should i fill in data:? and how should i fill it into database?
how do you divide list to saparate rows save in to database?