141
Views
6
Comments
Solved
How can i update a several records using a specific static id
Question
Application Type
Reactive

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

2021-10-09 07-57-44
Stefan Weber
 
MVP
Solution

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

BulkDemo.oml
UserImage.jpg
Fernando Lavinas

Hi Stefan!!

Thanks a lot!!!

It's work and was a smart solution.

BR

2020-11-13 07-48-15
Khuong Truong

Hi Fernando,

I believe that the Status entity is not included as dependency.

If so, please include the Status entity via Manage Dependencies.

Regards,

Khuong

UserImage.jpg
Fernando Lavinas

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.


2023-10-21 19-42-11
Tousif Khan
Champion

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

UserImage.jpg
Fernando Lavinas

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.

2021-10-09 07-57-44
Stefan Weber
 
MVP
Solution

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

BulkDemo.oml
UserImage.jpg
Fernando Lavinas

Hi Stefan!!

Thanks a lot!!!

It's work and was a smart solution.

BR

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.