Using the Save and Query Pipeline to “Archive” Deleted Records

re: Using the Save and Query Pipeline to “Archive” Deleted Records

John Luquer — Wed, 02 Jan 2013 09:33:22 GMT

Beth, I think this is a desired (sometimes required) for many LOB apps. Could this functionality not be added as a project option or extention? Moving it to a higher level with a table that includes Table | Field | Mofification Type | Changed By | Original Value | New Value | DateTimeStamp | MachineID and track all changes to any entity (including administration tables) would cut down on the number of tables and code that would be required yes? Not sure if this is possible in Lightswitch.

re: Using the Save and Query Pipeline to “Archive” Deleted Records

An — Fri, 02 Dec 2011 09:23:05 GMT

Hi Beth,

Thank you so much for a useful post. But I have some problem with this, can you help me please?

I have two screen to manage employees. One screen is the list and detail screen for the manager, I want he can see all the employees and their state(Working/Quit); and one search screen for the employees to search, they just can see the employees are working. How can I do that?

re: Using the Save and Query Pipeline to “Archive” Deleted Records

Beth Massi — Tue, 29 Nov 2011 22:05:55 GMT

Hi Jochi,

Rest assured we are hard at work on the next version of LightSwitch. However, we're not disclosing anything about future versions of LightSwitch yet. Stay tuned.

-Beth

re: Using the Save and Query Pipeline to “Archive” Deleted Records

Jochi — Mon, 28 Nov 2011 22:49:26 GMT

I love LightSwitch, like Silverlight, so I'm in doubt.

As LigthSwitch is too dependent on Silverlight:

What's the future of LightSwitch with thouse rumours about SL dead?

Are you thinking in a new version over HTML5 or maybe over WPF?

Could you talk something about this?

re: Using the Save and Query Pipeline to “Archive” Deleted Records

Beth Massi — Tue, 22 Nov 2011 01:19:45 GMT

@kevin -- If you want to also see the deleted records then you would need to create custom queries and use them on the appropriate screens instead of modifying the default Customer query in code.

@anso -- Greetings! Thanks for the link, I'll check it out!

@Ruud - Greetings! Have fun with LightSwitch :-)

re: Using the Save and Query Pipeline to “Archive” Deleted Records

Ruud Jeursen — Mon, 21 Nov 2011 12:03:38 GMT

Thanks very much for this post, Beth, and also greeting from The Netherlands! I used a similar appraoch on my MS Access databases and I'm very pleased to find out that I can use a similar way in LightSwitch !

re: Using the Save and Query Pipeline to “Archive” Deleted Records

anso — Sat, 19 Nov 2011 18:02:45 GMT

Thank you, Beth, once more and greetings from Spain. If you are interested in health-oriented developments, you maybe want this project in which I am a volunteer www.sahanafoundation.org

re: Using the Save and Query Pipeline to “Archive” Deleted Records

kevin bates — Fri, 18 Nov 2011 19:36:48 GMT

For completeness, if we wanted to show the deleted records, for an undelete function, do you simply create a query with isdeleted = true