custom database index does not included into update set

[antonbabanov]

Hello,

I have custom table with fields f1, f2

I have to prevent duplicates in table among all records (duplicates of full pair values, not among f1/f2 fields separately)

I creates Database Index for pair (f1, f2)

Looks good, but now I cannot see this index into my Update Set.

Does such behavior is correct? If yes how can I move my custom table index from development instance to production instance?

[paramveer]

Hi Anton,

You can not capture indexing in an update set. You need to do it manually in prod instance.

Thanks,

Param

[antonbabanov]

Thank you for your response!

I need approach witch can be distributed via Update Set (I have no access for production instance)

I think about Business Rule, but sometimes it execution can be avoided (updates via scripts for example).

Can I performs other approach for such checking?

[martinpriestley]

This feature was introduced within the Helsinki release

Please refer to the following documentation:

https://docs.servicenow.com/bundle/helsinki-release-notes/page/release-notes/servicenow-platform/r_U...