20
Views
3
Comments
Export and import process entity source to target environment
Question

I would like to update data in both the Process and Activity tables. In the Process table, I can use the Create or Update event, but in the Activity table, I only have the option to retrieve data. How can I update records in the Activity table?

The purpose of this is to migrate a process from one environment to another (e.g., from the development environment to a non-production environment) while maintaining the same process stage. For instance, if a process is running midway in development, I need it to be in the same stage in the non-production environment. I attached image for your reference .



ProcessTable.png
activitytable.png
2021-09-06 15-09-53
Dorine Boudry
 
MVP

Hi @Moovesh S ,

the reason is that this entity has Exposed as readonly set to Yes.

this means that in all their wisdom, the developers of the System module think it is not a good idea to allow consumers to just update it.  

So what does expose as read only mean ? In an OutSystems application, several things are blocked based on this boolean.  

  • As you already said, the entity actions are not available
  • but it is also not possible to write an sql update explicitly naming the entity

There are ways (other than the 2 things mentioned above) to update an entity exposed as readonly from another module.  I'll not elaborate, as I don't want to promote this.  But if you are curious, just look around in forge components and you might learn a thing or two.

But the more obvious, if you are on-prem, is just doing this job in the database directly.

Dorine

2022-12-30 07-28-09
Navneet Garg

@Dorine Boudry is right. but we can create service or server action in producer module where we can check roles and permission before updating the entity and can access that in consumer module.

@Dorine Boudry correct me if this is wrong.

2021-09-06 15-09-53
Dorine Boudry
 
MVP

we are talking about the system module here, so no acces to add actions

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