if(isnull(or(ri!a,ri!b)),{},a!forEach( items:rule!KONE_Development_CSE_TENDER_PHASES_Search_Rule(ri!a), expression:a!localVariables( local!csetenderphases:fv!item, a!forEach( items:rule!KONE_Development_CSE_TENDER_Search_Rule(local!csetenderphases.tenderId), expression: if(local!csetenderphases.tenderId=fv!item.id, if(or(fv!item.statusId="3",fv!item.statusId="4"),{},{ a!update(data:local!csetenderphases,index:"user",value:ri!b) }) ,{}) ) ) ).list.user )
As title, i need transfer all value to be correct form to be saved
thank you all
Discussion posts and replies are publicly visible
What do you actually want to achieve?
What did you try? What was the outcome? What is wrong with it?
The community is not able to help without more details. I try to convince you of this in almost all my replies.
hey sir, how are you today, hope you have a nice day.
The top code is the list i extract from want to save into database put into the value: and in the rule it return with:
However, it always report cannot index {'id',"name",...etc} into list of variant, I doubt I couldn't transfer each of columns into the correct data forms put into value:. How can I transfer? I want to save all list of those value return save into database by using a!writeintodatastoreentity.
I can not follow anymore ... are we talking about a attribute "user" as in the headline, about a missing field "id" as in my last post, or about the code in your initial post?
if it validate that this tenderId != 3 or 4 then we going to assign it a another use which is local!newuser
Yes, I mean any attribute i wish to insert report same error,can't index 'user' of type Text into type List of Variant
or{
}
sorry, not being rude, just this size after paste it, so annoying, sorry sir
Please check my post
https://community.appian.com/discussions/f/new-to-appian/22057/how-can-i-transfer-property-user-of-type-text-into-type-list-of-variant/86362#86362
I didn't get it, I know you can help me sir, it return a list of value of picture I posted.
You are iterating on a list of values. Does this expression return a non-empty list for each of the values?
yes, it do returns non-empty list, at least the id as primary key can't be null return with
OK, but this is just a list of integers. Not a list of data structures having any fields.
This is not?
I am confused. You posted two screenshots. How do the related to each other?
I think that the expression in line 13 of your code does not return a proper list for each value in the outer foreach. Investigate that.
it do returns value, those null are the sample data I put in table, only fill in a few attributes
OK. Whatever. Trying to access fields using dot-notation breaks if that field does not exist. Either make sure that each item has that field or use index() or property() functions.