This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, Deferred deletion is great, but how may on select records marked deleted using LS? Also, how may one purge deleted records and all their associated items? Thanks again, Kavan |
|
|
Hi Kavan, To include deleted items in a query then you just need to set "IncludeDeleted" on your query object. E.g. Query q = new Query() There is no provision for purging records marked as deleted at this stage but we will look at adding this to the backlog. Hope that helps, John-Daniel |
|
|
Is there any news regarding Purge deleted option? Haris |
|
|
Hi Haris, We have not yet added this provision, and I have to admit it is a fairly low priority because we tend to think of purging deleted objects as a database maintenance function, similar to archiving, rather than a domain modelling function, and therefore more likely to be carried out in accordance with the organisation's retention policies by DBAs or using scheduled jobs, rather than from the application layer. Is it a priority for you to be able to drive this stuff from the app layer? If so could you say a bit more about the requirement e.g. blanket purge, retain last x days, purge by query, etc.? Thanks! |
|
|
"we tend to think of purging deleted objects as a database maintenance function" That is good for companies who have DBA's but what about those of us who are writing for the end user that has no knowlege of a database. All I want to provide the End User with is a recycle bin they can recover from or empty(purge) |
|
|
Nevermind I guess I put my foot in my mouth. 10 seconds after the post I realized the solution to y problem. I will just create a second property called purge. Then let my users mark delete items for purge. Then when they save I can run a stored procedure to delete all items marked purge and DeletedOn is not Null. Thanks for Stored Procedure support. |
|
|
I guess I didnt realize "Non-query stored procedures are not supported" |
|
|
I have a linked up procedure that is a "Non query" linked up and working fine using the Calculate function of Mindscape.Lightspeed : ProcedureQuery qry = new ProcedureQuery("STP_ImportProcedure_Run", Instance.Calculate(qry)
YMMV
Cheers Paul |
|
|
MiddleTommy, we can look at adding support for non-query sprocs (it's on the wishlist), or for the time being you could just have your sproc return a dummy scalar (e.g. 1 for success, 0 for failure, or the number of rows deleted, or something like that) and use the Calculate method. |
|