You are not logged in.
Announcement
Unanswered posts
|
Pages: 1

Hello,
I would like clean data container for one entity.
In datacontainer view, i can search data from entity and physically delete a data selection, but juste for 10 items it takes time and it's not very useful.
There is not anyway to clean all in one time?
Regards
Offline
Hi David,
There's a magic way :-)
You can create a Stored Procedure in your studio that takes care of that.
Just create a new SP in your studio and paste this code:
for $e in //p/%0
where $e/../../c = "%1"
return try{
xlib:delete-member(concat("/%1/%0/%1.%0.",$e/../../i))
}catch($err){
element error { $err }
},xlib:commit()
If you try to execute it, it will ask you for the two parameters I've included, %0 is the Entity Name and %1 is the Data Container name.
Offline

Thank you Vgalopin.
I tried, it works.
Regards
Offline
Pages: 1