We have created an ETM Channel where we are creating new Items. To create an Item we need to provide Section-Department. Everything works fine until we try to provide NULL Department for Section Department.
Example: Section-Department “ABC-” already exist in Database. But when we are trying to fetch it from ETM it returns all the Section Departments that has Section as “ABC”.
I have never been able to search on a null value on the ETM, however there is a possible workaround.
In my trials, I tend to find that the search lists are in id order and the ‘unknown-’ record is first. If this is the same for you then you could use something similar to the screen shot below.
assyst doesn’t usually store null values - instead it uses a record with id 0. You can find these records by doing a short code search for the special value EMPTY_RECORD (without quotes):
Alternatively you can explicitly identify the 0 record for the Department as an expression:
Thank you so much for helping :)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.