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”.
Best answer by Paul McCulloch
View originalI 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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.
