FlexibleSearch WITH INDEX : cannot find (visible) type for alias

[former_member734158]

Hello,

Please we need to force the use of an DB Index in our FlexibleSearch, Unfortunatly it doesn't work where the FlexibleSearch is incubated like the example :

 select sum(o1.somePrice) from {Object1 as o1}
 where {o1.someInfo} in
 ({{
 select {o2.someInfo} from
 {Object2 AS o2
    JOIN Object3 AS o3 with(index(o3_first_index))  ON {o2.o3pk}={o3.pk} 
  }
 }})

Error :

 Message d'exception: cannot find (visible) type for alias o3 within [o3 with(index(o3_first_index)):Object3]

We don't want to change the "IN" condition with a "JOIN"

We just need to know if there is a way to tell to the query parser, that "with(index(o3_first_index))" has to be ignored and not take it as part of the Alias

Thank you in advance

[former_member761026]

I've done this before but using MySql, the right syntax would be something like this:

Select * from {CustomType} use index (IndexId) where ...