Dynamic '

[NOTiFYcouk]

This all works fine when 'hard-coded':

Query<Motorcycle> queryMotorcycle =
        datastore.find(Motorcycle.class)
            .filter(dev.morphia.query.filters.Filters.or(
                dev.morphia.query.filters.Filters.eq("manufacturer", "Aprilia"),
                dev.morphia.query.filters.Filters.eq("manufacturer", "Moto Guzzi")));

I've tried to create 'dynamic' Query/Filters/Filter of 'or' & 'eq' etc. but can't get them to work.

With Hibernate ORM/OGM I created all the queries in:

StringBuilder etc.
...
query = this.mongoDbEntityManager.createQuery(stringBuilderSQL.toString());
List<Motorcycle> motorcycleList = query.getResultList();

Have you any examples available or links you can recommend?

[evanchooly]

What's wrong with the example you gave? What's failing? What problems are you having?

[NOTiFYcouk]

"What's wrong with the example you gave" - It's 'hard-coded'.

What I want to do something like:

   Query<Motorcycle> motorcycleQuery = datastore.find(Motorcycle.class);

   List<Motorcycle> motorcyclesList = motorcycleQuery.iterator().toList();
   motorcyclesList.forEach(motorcycle -> LOGGER.info(">>>>> 2 MotorcyclesEJB = {}", motorcycle));

   Query<Motorcycle> queryMotorcycle =
       datastore.find(Motorcycle.class).disableValidation();


    queryMotorcycle.filter(dev.morphia.query.filters.Filters.or());
        
    if (MotorcycleController.motorcycleManufacturers.length > MotorcyclesEJB.ZERO) {
        for (int x = MotorcyclesEJB.ZERO; x < MotorcycleController.motorcycleManufacturers.length; x++) {
            queryMotorcycle.filter(dev.morphia.query.filters.Filters.eq("manufacturer", MotorcycleController.motorcycleManufacturers[x]));
        }
    }

    List<Motorcycle> motorcycleList = queryMotorcycle.iterator().toList();

    return motorcycleList;

12:22:55,038 INFO  [com.gostophandle.ejb.MotorcyclesEJB] (default task-1) >>>>> EJB 1.5 gqueryMotorcycle = MorphiaQuery[clazz=Motorcycle, query=Document{{$or=[]}}]
12:22:55,038 INFO  [com.gostophandle.ejb.MotorcyclesEJB] (default task-1) >>>>> EJB 1.6 getAllMotorcycles motorcycleManufacturers = Moto Guzzi
12:22:55,045 ERROR [org.jboss.as.ejb3.invocation] (default task-1) WFLYEJB0034: Jakarta Enterprise Beans Invocation failed on component MotorcyclesEJB for method public java.util.List com.gostophandle.ejb.MotorcyclesEJB.getAllMotorcycles(): javax.ejb.EJBException: com.mongodb.MongoQueryException: Query failed with error code 2 with name 'BadValue' and error message '$and/$or/$nor must be a nonempty array' on server localhost:27017

[evanchooly]

What's the issue? what's your code look like?

[NOTiFYcouk]

List<Bson> listManufacturers = new ArrayList();

    if ((MotorcycleController.motorcycleManufacturers != null) && (MotorcycleController.motorcycleManufacturers.length > ZERO)) {
        LOGGER.info(">>>>> EJB 1.1 getAllMotorcycles motorcycleManufacturers = {}", (Object) MotorcycleController.motorcycleManufacturers);
        LOGGER.info(">>>>> EJB 1.2 getAllMotorcycles motorcycleModels = {}", (Object) MotorcycleController.motorcycleModels);
        LOGGER.info(">>>>> EJB 1.3 getAllMotorcycles motorcycleTypes = {}", (Object) MotorcycleController.motorcycleTypes);
        LOGGER.info(">>>>> EJB 1.4 getAllMotorcycles motorcycleManufacturers length = {}", MotorcycleController.motorcycleManufacturers.length);

        if (MotorcycleController.motorcycleManufacturers.length > MotorcyclesEJB.ZERO) {
            for (int x = MotorcyclesEJB.ZERO; x < MotorcycleController.motorcycleManufacturers.length; x++) {
               LOGGER.info(">>>>> EJB 1.5 getAllMotorcycles motorcycleManufacturers = {}", MotorcycleController.motorcycleManufacturers[x]);

                    Bson bson = com.mongodb.client.model.Filters.eq("manufacturer", '"' + MotorcycleController.motorcycleManufacturers[x] + '"');
                    LOGGER.info(">>>>> EJB 1.6 bson = {}", bson);

                    listManufacturers.add(bson);
                    LOGGER.info(">>>>> EJB 1.7 listManufacturers = {}", listManufacturers);
                }
                LOGGER.info(">>>>> EJB 1.8 listManufacturers = {}", listManufacturers.size());
                LOGGER.info(">>>>> EJB 1.9 listManufacturers = {}", listManufacturers.toArray());

                // TODO: Add your filters to a List then pass that list like this: or(list.toArray(new Filter[0]))
                try {
                    queryMotorcycle.filter(dev.morphia.query.filters.Filters.or(listManufacturers.toArray(new Filter[0])));
                } catch (Exception exception) {
                    System.out.println(">>>>> getAllMotorcycles = " + exception);
                }
            }
        }

10:30:01,540 INFO  [com.gostophandle.ejb.MotorcyclesEJB] (default task-1) >>>>> EJB 1.1 getAllMotorcycles motorcycleManufacturers = [Aprilia, Moto Guzzi]
10:30:01,540 INFO  [com.gostophandle.ejb.MotorcyclesEJB] (default task-1) >>>>> EJB 1.2 getAllMotorcycles motorcycleModels = null
10:30:01,540 INFO  [com.gostophandle.ejb.MotorcyclesEJB] (default task-1) >>>>> EJB 1.3 getAllMotorcycles motorcycleTypes = null
10:30:01,540 INFO  [com.gostophandle.ejb.MotorcyclesEJB] (default task-1) >>>>> EJB 1.4 getAllMotorcycles motorcycleManufacturers length = 2
10:30:01,540 INFO  [com.gostophandle.ejb.MotorcyclesEJB] (default task-1) >>>>> EJB 1.5 getAllMotorcycles motorcycleManufacturers = Aprilia
10:30:01,540 INFO  [com.gostophandle.ejb.MotorcyclesEJB] (default task-1) >>>>> EJB 1.6 bson = Filter{fieldName='manufacturer', value="Aprilia"}
10:30:01,540 INFO  [com.gostophandle.ejb.MotorcyclesEJB] (default task-1) >>>>> EJB 1.7 listManufacturers = [Filter{fieldName='manufacturer', value="Aprilia"}]
10:30:01,540 INFO  [com.gostophandle.ejb.MotorcyclesEJB] (default task-1) >>>>> EJB 1.5 getAllMotorcycles motorcycleManufacturers = Moto Guzzi
10:30:01,540 INFO  [com.gostophandle.ejb.MotorcyclesEJB] (default task-1) >>>>> EJB 1.6 bson = Filter{fieldName='manufacturer', value="Moto Guzzi"}
10:30:01,540 INFO  [com.gostophandle.ejb.MotorcyclesEJB] (default task-1) >>>>> EJB 1.7 listManufacturers = [Filter{fieldName='manufacturer', value="Aprilia"}, Filter{fieldName='manufacturer', value="Moto Guzzi"}]
10:30:01,540 INFO  [com.gostophandle.ejb.MotorcyclesEJB] (default task-1) >>>>> EJB 1.8 listManufacturers = 2
10:30:01,540 INFO  [com.gostophandle.ejb.MotorcyclesEJB] (default task-1) >>>>> EJB 1.9 listManufacturers = Filter{fieldName='manufacturer', value="Aprilia"}

10:30:01,541 INFO  [stdout] (default task-1) >>>>> getAllMotorcycles = java.lang.ArrayStoreException: arraycopy: element type mismatch: can not cast one of the elements of java.lang.Object[] to the type of the destination array, dev.morphia.query.filters.Filter

[evanchooly]

listManufacturers should be a List<Filter>. Morphia doesn't deal with Bson types. If you read the javadoc you'll see what the types need to be.

[NOTiFYcouk]

Thanks for that. I now realised I was using "com.mongodb.client.model.Filters.eq" instead of "dev.morphia.query.filters.Filters.eq". Once I changed this to "List listManufacturers = new ArrayList<>()" etc.

It all worked a treat.

List<Filter> listManufacturers = new ArrayList<>();

        if ((MotorcycleController.motorcycleManufacturers != null) && (MotorcycleController.motorcycleManufacturers.length > ZERO)) {
            LOGGER.info(">>>>> EJB 1.1 getAllMotorcycles motorcycleManufacturers = {}", (Object) MotorcycleController.motorcycleManufacturers);
            LOGGER.info(">>>>> EJB 1.2 getAllMotorcycles motorcycleModels = {}", (Object) MotorcycleController.motorcycleModels);
            LOGGER.info(">>>>> EJB 1.3 getAllMotorcycles motorcycleTypes = {}", (Object) MotorcycleController.motorcycleTypes);
            LOGGER.info(">>>>> EJB 1.4 getAllMotorcycles motorcycleManufacturers length = {}", MotorcycleController.motorcycleManufacturers.length);

            if (MotorcycleController.motorcycleManufacturers.length > MotorcyclesEJB.ZERO) {
                for (int x = MotorcyclesEJB.ZERO; x < MotorcycleController.motorcycleManufacturers.length; x++) {
                    LOGGER.info(">>>>> EJB 1.5 getAllMotorcycles motorcycleManufacturers = {}", MotorcycleController.motorcycleManufacturers[x]);

                    listManufacturers.add(dev.morphia.query.filters.Filters.eq("manufacturer", MotorcycleController.motorcycleManufacturers[x]));
                    LOGGER.info(">>>>> EJB 1.7 listManufacturers = {}", listManufacturers);
                }
                LOGGER.info(">>>>> EJB 1.8 listManufacturers = {}", listManufacturers.size());
                LOGGER.info(">>>>> EJB 1.9 listManufacturers = {}", listManufacturers.toArray());

                // TODO: Add your filters to a List then pass that list like this: or(list.toArray(new Filter[0]))
                try {
                    queryMotorcycle.filter(dev.morphia.query.filters.Filters.or(listManufacturers.toArray(new Filter[0])));
                } catch (Exception exception) {
                    System.out.println(">>>>> getAllMotorcycles = " + exception);
                }
            }
        }

[evanchooly]

That's unfortunate naming clash without a decent alternative.