Hi guys, i tried to make a portlet, simply to project dashboard, with one more level - "audit" trail for any task ( i want to show type of change, old value, new value). Everything is clear, portlet work, everything is right. Problem happens when i want to filter data by date of "create" of change (created_date from cmn_audits). When i filter, i see some for ex. projects/tasks which i can expand, but they dont have any value (which is good, because where clause work). How can i build my sql clause to delete that problem ?
Perhaps it is gently twisted, but when you look at ma sql, I hope you understand what I mean