Create index on user defined fields

[Former Member]

Hi all,

using SAP Business One tools it is possible to add a user defined field and at the same time to create an index on this field by marking the Create Index Checkbox. As a result an index like uidx_U_FieldName is created. This feature seems to be not exposed in the DI-API, am I right?

I'm using SAP Business One 2004A (6.70.189) SP: 00 PL: 30 and corresponding DI-API.

Regards,

Eduard

[rasmuswulff_jensen · Accepted solution]

To do that you need to use the UserKeysMd Object

Update: After you created the field

Message was edited by: Rasmus Jensen

[Former Member]

Thank's,

I know this object, I thought there is a way to avoid this additional work for creating a simple one-field based index.

Regards,

Eduard