i have created a Database View for t
for time card and time worked.
for task and case. it is working .
what changes do i need to do for this?
1 ACCEPTED SOLUTION
You can always manually filter the List view or Report where the Parent -> State is not one of Closed, Resolved, Cancelled. To have the Database View ALWAYS exclude these, just create a Business Rule that looks like this:
Where Table = u_test1 in your case. The Script on the Advanced tab looks like this:
(function executeRule(current, previous /*null when async*/) {
current.addEncodedQuery('tt_parent.stateNOT IN3,6,7');
})(current, previous);
