Create a propertyFilter from entity computed column

Support
#1

Having the entity

public class Domain extends StandardEntity {
    @NotBlank
    @InstanceName
    @Column(name = "NAME", nullable = false)
    private String name;

    @NotNull
    @Column(name = "EXPIRATION_DATE", nullable = false)
    private LocalDate expirationDate;

    @JmixProperty
    @DependsOnProperties({"expirationDate"})
    public Boolean getExpired() {
        return expirationDate.isBefore(LocalDate.now());
    }

    @JmixProperty
    @DependsOnProperties({"expirationDate"})
    public Integer getExpirationDays() {
        return (int) DAYS.between(LocalDate.now(), expirationDate);
    }
}

i create a propertyFilter in the view for the @JmixProperty expired. The filter is displayed but with no effect in the datagrid. The properties are displayed correctly in dataGrid.

i have also tried with @Transient field in entity

@Transient
@JmixProperty
private Integer expirationDays;

@Transient
@JmixProperty
private Boolean expired;

@PostLoad
public void postLoad() {
    LocalDate now = LocalDate.now();
    this.expirationDays = (int) DAYS.between(now, expirationDate);
    this.expired = expirationDate.isBefore(now);
}

Am i missing something?

i use jmix 2.5.1

#2

Hello!

Transient properties can not be filtered as they are not presented in SQL. The @DependsOnProperties annotation only enabling sorting transient property in DataGrid by property defined in the annotation.