Filter lookup based on the value of another lookup which is Enum

I have to Lookup fields. One where I can select Vehicle type. When I select one vehicle type in the lookup I want the second Lookup to be filtered according to Vehicle type lookup.

The query I have created is as follow but is not working.


select e from fleetmanager$Model e
where e.make.id = :ds$makesDs.id
and (e.vehicleGroup in (:component$fieldGroup.vehicleGroup))

Does someone have and Idea?

Solved.

Use the query as this.


select e from fleetmanager$Model e
where e.make.id = :ds$makesDs.id
and e.vehicleGroup  = :component$vehicleGroup

The lookup will refresh automaticly and show the filtered values.

Hello @kjell1906,

I need help with this same problem, but I don’t know how to solve it, where do I put this query? I need to filter a lookup based on the value of another lookup (countries and cities)