Why does it not work while using the nn, nutnull or isnotnull?

[alansun2]

My rsql is like this:
status=='ACTIVE';region!='';filespacePrefix!='';workflowExtInfo=nn=
but workflowExtInfo=nn= does not work, and the param workflowExtInfo is a map.

And I use the postgresql.

[perplexhub]

Hi @alansun2, could you share your model class? Thanks.

[alansun2]

helloe @perplexhub My model like this:
DriveCluster:

@Entity
@Table(name = "drive_cluster", schema = "drive")
@SQLDelete(sql = "UPDATE drive.drive_cluster SET deleted = TRUE WHERE id = ?")
@SQLRestriction(value = "deleted = false")
public class DriveCluster extends DomainObject implements Serializable {

    private String studio;

    private String studioId;

    private String name;

    @Type(JsonType.class)
    @Column(name = "cities", columnDefinition = "jsonb")
    private List<Object> cities;

    private String vendor;

    @Size(max = 255)
    @NotNull
    @Column(name = "user_group_prefix", nullable = false)
    private String userGroupPrefix;

    @Enumerated(value = EnumType.STRING)
    @Column(name = "status", nullable = false)
    private ClusterStatusEnum status = ClusterStatusEnum.DETACHED;

    @Size(max = 255)
    @Column(name = "region")
    private String region;

    @Column(name = "workflow_ext_info")
    @JdbcTypeCode(SqlTypes.JSON)
    private Map<String, Object> workflowExtInfo;

    @Size(max = 32)
    @Column(name = "filespace_prefix")
    private String filespacePrefix;

ClusterStatusEnum:

public enum ClusterStatusEnum {

    ACTIVE, IN_PROVISION, ERROR, DETACHED
}

[alansun2]

@perplexhub hello