+sub _before_save_invalidate_requirement_spec_version {
+ my ($self, %params) = @_;
+
+ return 1 if !$self->requirement_spec_id || $self->requirement_spec->working_copy_id;
+
+ my %changed_columns = map { $_ => 1 } (Rose::DB::Object::Helpers::dirty_columns($self));
+
+ $self->requirement_spec->invalidate_version
+ if !Rose::DB::Object::Util::is_in_db($self) || any { $changed_columns{$_} } qw(title text position output_position);
+
+ return 1;
+}
+
+sub _before_delete_invalidate_requirement_spec_version {
+ my ($self, %params) = @_;
+
+ $self->requirement_spec->invalidate_version if $self->requirement_spec_id;
+
+ return 1;
+}
+
+sub pictures_sorted {
+ my ($self, @args) = @_;
+
+ croak "Not a writer" if @args;
+
+ return [ sort { $a->position <=> $b->position } $self->pictures ];
+}
+
+sub content_excerpt {
+ my ($self) = @_;
+
+ return Common::truncate($self->text_as_stripped_html // '', at => 200);
+}
+