www.qxorm.com • View topic - How to fetch the data has been soft deleted？

Page 1 of 1

How to fetch the data has been soft deleted？

Posted: Tue Feb 28, 2017 7:17 am

by behtgod

Such as title.
I want fetch all deleted data,but the fetch_by_query function filtered out the soft deleted data automaticly.
Are there any solutions?

Re: How to fetch the data has been soft deleted？

Posted: Tue Feb 28, 2017 9:29 am

by qxorm

Hello,

You could try to add a condition to your SQL query to fetch your soft deleted items, something like :

Code: Select all: ... (SQL query generated by qx::dao::fetch QxOrm function) + OR my_delete_column = '1'