Indexes in Cache Objects

Question

Question

Jenna Poindexter · Apr 15, 2018

#Indexing #Object Data Model #Caché

Hi-

I have the following objects

Class A

Property P1 As B

Property P2 As %String

Property P3 As %String

Class B

Property P1 As %String

Can I create an index in Class A based on P1.P1. Basically I want an index of class A by property P1 in class B

I tried creating the following but got a compile error

Index I1 On P1.P1

Thanks

Discussion (2)1

Log in or sign up to continue

Eduard Lebedyuk · Apr 15, 2018

You can create computed property and index it.

Class A {

Property P1 As B;

Property P1P1 As %String [ SqlComputeCode = {set {*} = ##class(B).P1GetStored({P1})}, SqlComputed, SqlComputeOnChange = (%%INSERT, %%UPDATE) ];

Index I1 On P1P1;

}

1 0

score 0 · Answer 1 · 2018-04-16T15:08:30-04:00

Diones Forteski · Apr 16, 2018

hello

Use only
Index I1 On P1

0 0