User bio
404 bio not found
Member since Dec 9, 2015
Alexander has not published any posts yet.

I have many data mapped like this and Caché usually uses the indices.

To get Caché to use mapped indices you have different options:

  1. Use appropriate data types.
  2. It looks like the collation of your indexed data is "exact". So please use one of these options  (or a combination of them) if the data type is %String:
    1. Property bbb as %String(COLLATION="EXACT");
    2. select * from loggpro.Indextest where %EXACT(bbb)=123

If all of your indexed data of type %String is collated "exact", it is usefull to subclass the %String datatype and set the COLLATION parameter there. Use the new datatype instead of %String afterwards.

Good luck!

Alex Riemer

Certifications & Credly badges:
Alexander has no Certifications & Credly badges yet.
Global Masters badges:
Alexander has no Global Masters badges yet.
Alexander has no followers yet.
Alexander has not followed anybody yet.