Hi,
In my hbm file, I have a property:

<property
name="abcd"
type="java.lang.String"
update="false"
insert="false"
formula="(select ug.ts_name from ts_map um join ts_groups ug on ug.ts_id = um.ts_group_id where um.ts_delete = false)"
lazy="true"
not-null="false"
/>


The where clause in my formula ... i need to set it to the boolean value false. Do I use quotes around it? Single? Double?

Should it be:

formula="(select .... where um.ts_delete = 'false')"

or

formula="(select .... where um.ts_delete = "false")"

or no quotes?

formula="(select .... where um.ts_delete = false)"

just use
formula="(select ug.ts_name from ts_map um join ts_groups ug on ug.ts_id = um.ts_group_id where um.ts_delete = 'Y')"