Database constraint to only include empty values

0
Hi, I would need to have a data grid only list all “Asset” entities having the “Owner account” attribute empty. I tried adding a database constrain saying OwerAccount equals and leaving the value field empty, but this does not work ….it actually introduced some weird behavior…  maybe due to empty string vs. null value (?). How do I configure a data grid database constraint to include only objects having a field empty or null? Br, Tom
asked
1 answers
2

Hey Tom,

 

Have you tried [owner = empty] (as an Xpath, not a constraint). Leaving it empty might not work, or set it in an Xpath instead of using the contraints?

 

Regards

Mark

answered