Find "Blank" field in all field

klinspatrick

Hi,

Can Nav 4.0 search any field that is "Blank" or no input by users?

I tried in searching in Change Log, to find " " in fields New Value and Old Value. But it can't search anything.

It's good for trace any field in a table that users are ignoring and forgetting to input values.



Patrick

Savatage

Search the forum for "Mandatory fields" to find how to solve your problem

klinspatrick

thanks! Not Sleep yet?>

klinspatrick

Hi, Savatage,

There are 2819 search out for the term of "Mandatory fields", can you tell me more? Thanks.

Patrick

todro

klinspatrick wrote:

Hi, Savatage,

There are 2819 search out for the term of "Mandatory fields", can you tell me more? Thanks.

Patrick

if you use the option "Search all terms" you will get 47

anniqa

is text you can filter on the fields with the condition ". Since NAV doesn't accept NULL-values it substitues those with an empty string

klinspatrick

thanks, everyone.