Welcome to jBASE's new documentation site! Many answers to your questions can be found by searching the Knowledgebase or viewing the jBASE Documentation. We also have a Google Group for peer discussion about jBASE. If you are unable to find the information you are looking for, jBASE Support will be glad to assist in resolving your technical problems. Enjoy and please provide comments and feedback .

How can we help you?

PN5_60895

Description

Support sub-valued fields in a secondary index


Previous Release Behavior

If a data field was indexed, and that field had sub-values then the index would include multiple sub-values.

In the example below, where ] is a value mark and \ is a sub-value mark, we would have the following index keys created:

  • CHELSEA
  • FOREST\DERBY
  • CITY
  • UNITED\LIVERPOOL\EVERTON


CHELSEA]FOREST\DERBY]CITY]UNITED\LIVERPOOL\EVERTON


Current Release Behavior

Sub-values are now automatically treated in the same way as multi-values, and an index key is generated for each sub-value within a multi-value.

In the above example, we would now have the following index keys:

  • CHELSEA
  • FOREST
  • DERBY
  • CITY
  • UNITED
  • LIVERPOOL
  • EVERTON


Notes

There are no options in create-index for this enhancement, it just occurs automatically.

Was this article helpful?