on 01-07-2019 3:58 PM
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
User | Count |
---|---|
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.