Database view filter for 'is not empty'

[Saranya K]

Hi all,

we need to add the filter condition in database view to filter out the empty value from model field.

we created database view using the several table we added the condition in software discovery model table when model field is not empty but it is not working as excepted.

can anyone help me on this.

Thanks

[Brad Bowman · Accepted solution]

Are you certain that 'model' is the correct field name on the dsw table? If you can't get it to work due to the number of tables, you can always look into a before Query Business Rule on the table to filter out the blank models.