create view for log and fix bugs