Hello !!
I would like to update the status of all selected records of a screen according to the chosen status of the static entity.
When I assign the id of the static entity to the attribute of the current list (FK Status), the variable does not appear as an option, only the records of the static entity.
Thank you!!
Image Caption
Hi Fernando,
attached is a quick sample on how to bulk update a status for selected items in a list. The Task_SetStatusBulk takes a list of Task Identifiers as input along with a new Status Identfier. An advanced SQL Statements performs the bulk update in a single statement.
Hope that helps,
Stefan
Hi Stefan!!
Thanks a lot!!!
It's work and was a smart solution.
BR
I believe that the Status entity is not included as dependency.
If so, please include the Status entity via Manage Dependencies.
Regards,
Khuong
Hi Khuong!
Thanks.
It is included.
I created a local variable to save the dropdown value (Status list), id, which is a record of the static entity, called Status.
The screen displays the records of the Backlog entity that has an attribute that is FK Status.
What I want to do is that when choosing the Backlog records, through the checkbox and selecting the Status in the dropdown, all the selected records must be updated with the selected status.
However, when trying to assign the value of Dropdown.status that was saved in the local variable to the attribute of the Backlog, FK of Status, i can't because the options that appear are only the records of the status static entity. I imagined that the local variable could appear so that it could be assigned to FK.
Hello
you can create a loop and select the filtered list(those records that are checked) On a loop cycle assign a variable and define the status what you have selected to the list in which you have a Fk, after that use your entity action create or update,
I hope this helps
Best Regards
Tousif khan
Thanks for your attention.
i can't assign the StatusId from dropdown to my FK. In the box of formulas only labels(Status) are show instead of the local variable.