Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @NamedQuery(name="getHistoryTotalByMonthAndYearAndStatus2", query="SELECT s FROM DocumentDB s WHERE s.creator = :creator AND MONTH(timeSign) = :monthDoc AND YEAR(timeSign) = :yearDoc AND s.status = :status"),
- @NamedQuery(name="getHistoryTotalByDateAndMonthAndYear", query="SELECT s FROM DocumentDB s WHERE s.creator = :creator AND MONTH(timeSign) = :monthDoc AND YEAR(timeSign) = :yearDoc AND DAY(timeSign) = :dateDoc"),
- @NamedQuery(name="getHistoryTotalByDateAndMonthAndYearAndStatus", query="SELECT s FROM DocumentDB s WHERE s.creator = :creator AND MONTH(timeSign) = :monthDoc AND YEAR(timeSign) = :yearDoc AND DAY(timeSign) = :dateDoc AND s.status = :status")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement