Show and not show deleted items

Classic Servoy
1

Hi
I have a question with deleted items.

I have a integer field for show or not show items, 0 is show and 1 is not show
If I use filter when open my applicatión and I find a invoice from delete client, I can´t find it because this client is not show.
Is the same with articles, suppliers, etc…

What is the best option for show and not show deleted items?.

Thanks

Servoy 5.2.6
PostgreSql

2

You can use a tableFilter for that.

For an admin, you can make a feature to delete that tableFilter, to restore ‘deleted’ records

3

JuanMartin:
Hi
I have a question with deleted items.

I have a integer field for show or not show items, 0 is show and 1 is not show
If I use filter when open my applicatión and I find a invoice from delete client, I can´t find it because this client is not show.
Is the same with articles, suppliers, etc…

What is the best option for show and not show deleted items?.

Thanks

Servoy 5.2.6
PostgreSql

Hi Juan, am I right if I understand that you do not delete records but mark it as show/not show with a field?

If that is your situation, you could add a onUpdate trigger for the customer table that checks the value for the deleted flag (or show/no show flag) and mark the related records with the same value. Of course you must have the flag in all the related tables and then use a filter, as I guess you are doing.

Of course only do the mark/unmark as deleted if the flag field has changed.

I hope this helps.