Index Values Required?

[tjspencer2]

We're on 8.5 MP and I have a user with a question.

When defining an index for an application, if the value is not located, is it okay for an index to be NULL?

I'm thinking ACIF needs to populate a value, and if it doesn't find the value in the specified coordinates then a default must be supplied, correct?

[Justin Derrick]

Correct.  NULL values aren't allowed in CMOD.  (How would you ever find that document?)  You should set a default value, or improve the quality of the data you receive.  (Or remove it as an index if it isn't important enough to have a value every time.)

-JD.

[tjspencer2]

Thanks Justin - those were pretty much my thoughts too.

My user does have other index values that she knows she'll find.

Isn't it also correct that if she doesn't want to apply a default and instead just identify the value as  "Field" that she won't be able to add it to her Folder and search by it?

And that this consequently means she'll only be able to filter/sort by it when she retrieves results in Webi?

Thanks for your help!!

[Justin Derrick]

Isn't it also correct that if she doesn't want to apply a default and instead just identify the value as  "Field" that she won't be able to add it to her Folder and search by it?

I'm not sure what you mean by this.

She can set a default value, and exclude it from the search pane, and only display it in the hitlist, if that's what you're going for...

-JD.