Using %IGNOREINDICES helped!

Thank you all :)

I tried using between but got the same result.

My property definition is as below:

Property Active As %Integer [ Calculated, Private, SqlComputeCode = { Set {Active}='$D(^ADZDICT("OS80",1,{HospitalCode},1,{LocationCode},"ACT"))
}, SqlComputed ];

I have a method:

Method ActiveGet() As %Integer
{
 Q '$D(^ADZDICT("OS80",1,..HospitalCode,1,..LocationCode,"ACT"))
}

Let me add some more details here.

I have a class where I have a private property "Active"

I also tried a simple query "Select Active from classname" and it does not print any data for this property in the result

Also using it in WHERE clause does not return any data.

Thank you! Can you please explain providing an example, that would really help!