How to use a global condition in all queries of panache

[guoxunbo]

I have some objects. such as code like this

@MappedSuperclass
public class MyEntity extends PanacheEntity {
    @Column(name="OBJECT_RRN")
    @Id
    protected Long objectRrn;

    @Column(name="ACTIVE_FLAG")
    protected String activeFlag;

    @Column(name="ORG_RRN")
    @TenantId
    protected Long orgRrn;

    public Long getObjectRrn() {
        return objectRrn;
    }

    public void setObjectRrn(Long objectRrn) {
        this.objectRrn = objectRrn;
    }

    public String getActiveFlag() {
        return activeFlag;
    }

    public void setActiveFlag(String activeFlag) {
        this.activeFlag = activeFlag;
    }

    public Long getOrgRrn() {
        return orgRrn;
    }

    public void setOrgRrn(Long orgRrn) {
        this.orgRrn = orgRrn;
    }
}

@Entity
@Table(name="BASE_MESSAGE")
public class BaseMessage extends MyEntity {

    private String keyId;

    private String message;

    private String messageZh;

    private String messageRes;

    //    @CacheResult(cacheName="BaseMessage")
    public static BaseMessage findByKeyId(/*@CacheKey*/  String keyId) {
        return find("keyId", keyId).<BaseMessage>singleResultOptional().orElse(null);
    }

    public String getKeyId() {
        return keyId;
    }

    public void setKeyId(String keyId) {
        this.keyId = keyId;
    }

    public String getMessage() {
        return message;
    }

    public void setMessage(String message) {
        this.message = message;
    }

    public String getMessageZh() {
        return messageZh;
    }

    public void setMessageZh(String messageZh) {
        this.messageZh = messageZh;
    }

    public String getMessageRes() {
        return messageRes;
    }

    public void setMessageRes(String messageRes) {
        this.messageRes = messageRes;
    }
}

But I want add contion like "activeFlag = 'Y' and (org_rrn = 0 org org_rrn = :orgRrn)" condition on all who extends MyEntity.
What can I do this on panache?

[luca-bassoricci]

I don't this this is a Panache responsibility, but you can use Hibernate filters.
Also check https://thorben-janssen.com/hibernate-filter/.

[guoxunbo]

If use filter. it should point to use filter with any query.
So I want to definition a global condition that can be used in any query with who extends MyEntity.