seems I almost there, the problem I found is that the value i supposed to be saved for a!query is not the standard form. What should be the correct one?
a!save(target:ri!userrole.USER_ID, value:cast(type!Integer, a!queryEntity( entity:cons!KONE_Development_userrole_Constant, fetchTotalCount:true, query:a!query( selection: a!querySelection( columns: { a!queryColumn( field: "USER_ID" ) } ), filter:a!queryFilter( field:"NAME",operator:"=", value:ri!userinputsheet.kone_user_name, applyWhen:not(isnull(ri!userinputsheet.KONE_user_name)) ), pagingInfo:a!pagingInfo( startIndex: 1, batchSize: 50 ) ) ).data.USER_ID) ),
Discussion posts and replies are publicly visible
I think i have to trim the bracket
In general I would say you should avoid having a queryEntity inside a saveInto. If the query fails or does not retrieve the results you expect (since you are using a batchSize of 50 for it), you will be saving the wrong values into USER_ID without a good way to debug it.
i have if judgement if the value is null but i didn't put it in here
Then how i am able to configure the username match to its userid?
target:ri!userrole.USER_ID, value:a!forEach( items:rule!KONE_Development_Username_UserId(), expression:if(fv!item.username=ri!userinputsheet.KONE_user_name, fv!item.userid,{}) )
I did both way but neither is work
Why are you doing this in this spot, exactly? And how (and when) does the value of `ri!userinputsheet.kone_user_name` get set?
what do you mean, I did in the rule input
a!forEach( items:rule!KONE_Development_Username_UserId(), expression:if(fv!item.NAME=ri!userinputsheet.KONE_user_name, a!save(target:ri!userrole.USER_ID,value:fv!item.USER_ID),{} ) ), rule as: a!queryEntity( entity: cons!KONE_Development_userrole_Constant, query: a!query( pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 50, ), aggregation:a!queryAggregation( aggregationcolumns:{ a!queryAggregationColumn(field:"NAME",alias:"username",isGrouping:true), a!queryAggregationColumn(field:"USER_ID",alias:"userid",isGrouping:true), } ) ), ).data
But not working either.
Your query is attempting to look up the user ID of the database entry(s) matching `ri!userinputsheet.kone_user_name`. I'm trying to discern what your use case is exactly, and that includes how the value of this is initialized.
I solved this already, I have another question not sure whether you have been faced before, Whenever i want to update the row value of database, i enlist them out in editable grid, however, if i want just update one column of value but have to resave others column of value again, or just this column value get updated, others column all change to be null.