getting all paths from db with color