AnsweredAssumed Answered

Hierarchical portlet problem

Question asked by pmarzec on Jun 6, 2017
Latest reply on Jun 13, 2017 by YoannD

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
Perhaps it is gently twisted, but when you start, I hope you understand what I mean

Attachments

Outcomes