Reputation: 47
I have a table named 'content' which has a field named 'created_at'. I am trying to use pageable and specifications in this table.
Specifications works perfectly but i have a problem with pageable. If i use the inherited method from the repository to search the pageable don't recognize the field with underscore and tries to split him. Givin this error:
"No property created found for type Content!"
If i create a method in the repository pageable works but specifications don't. Here is my repository:
@Repository
public interface ContentRepository extends JpaRepository<Content,
String>,JpaSpecificationExecutor<Content> {
@Query(value = "SELECT * FROM content", nativeQuery = true)
public Page<Content> findAll(Specification<Content> specification, Pageable pageable);
}
How can i do both?
Content class:
@Entity
@Table(name = "content")
@Setter
@Getter
public class Content {
@Id
@Column(name = "id")
private String id;
@Column
private String name;
@Column
private String description;
@Column(columnDefinition = "TEXT")
private String content;
@Column(columnDefinition = "TEXT")
private String reference;
@ManyToOne
@JoinColumn(nullable = false)
private User author;
@ManyToOne
@JoinColumn(nullable = true)
private Agenda agenda;
@ManyToOne
@JoinColumn(nullable = false)
private ContentType contenttype;
@Column(columnDefinition = "boolean default true")
private boolean enabled;
@Column(columnDefinition = "boolean default false")
private boolean approved;
@Column
private Date sent_at;
@Column
private Date created_at;
@Column
private Date updated_at;
@Column
private Date deleted_at;
}
Upvotes: 3
Views: 5565