|
Mongo сортировка
#39591285
Ссылка:
Ссылка на сообщение:
Ссылка с названием темы:
Ссылка на профиль пользователя:
|
Участник
Откуда: Минск
Сообщения: 2 100
|
|
Подскажите, как отсортировать по дате
1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15.
Jan 25, 2018 7:59:05 PM com.dsmsm.mqtt.dse.communication.handlers.MqttSubscribeCallback messageArrived
19:59:05.273 [MQTT Call: 1iukvzjzygd45] ERROR com.server.services.MqttMessageProcessor - ERROR process message
java.lang.IllegalArgumentException: Given sort contained an Order for date with ignore case! MongoDB does not support sorting ignoreing case currently!
at org.springframework.data.mongodb.core.query.Query.with(Query.java:180) ~[spring-data-mongodb-1.10.9.RELEASE.jar:?]
at com.server.services.mongo.MongoServiceImpl.findListEnity(MongoServiceImpl.java:222) ~[classes/:?]
at com.server.services.mongo.MongoServiceImpl.findWithLimit(MongoServiceImpl.java:189) ~[classes/:?]
at com.server.services.mongo.MongoServiceImpl.findWithoutLimit(MongoServiceImpl.java:195) ~[classes/:?]
at com.server.services.mongo.event.EventMongoServiceImpl.getLastNoSyncEvent(EventMongoServiceImpl.java:228) ~[classes/:?]
at com.server.services.MqttMessageProcessor.updateEvents(MqttMessageProcessor.java:269) ~[classes/:?]
at com.server.services.MqttMessageProcessor.process(MqttMessageProcessor.java:138) [classes/:?]
at com.dsmsm.mqtt.dse.communication.handlers.MqttSubscribeCallback.messageArrived(MqttSubscribeCallback.java:30) [classes/:?]
at org.eclipse.paho.client.mqttv3.internal.CommsCallback.deliverMessage(CommsCallback.java:477) [org.eclipse.paho.client.mqttv3-1.1.1.jar:?]
at org.eclipse.paho.client.mqttv3.internal.CommsCallback.handleMessage(CommsCallback.java:380) [org.eclipse.paho.client.mqttv3-1.1.1.jar:?]
at org.eclipse.paho.client.mqttv3.internal.CommsCallback.run(CommsCallback.java:184) [org.eclipse.paho.client.mqttv3-1.1.1.jar:?]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_161]
1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. 32. 33. 34. 35.
@Override
public List<T> findWithoutLimit(String fiqlQuery, int size, String fieldName, Direction direction) {
Sort sort = new Sort(new Order(Direction.ASC, fieldName).ignoreCase());
return findWithLimit(fiqlQuery, size, sort);
}
@Override
public List<T> findWithoutLimit(String fiqlQuery) {
return findWithoutLimit(fiqlQuery, null);
}
@Override
public List<T> findWithoutLimit(String fiqlQuery, Sort sort) {
return findListEnity(fiqlQuery, -1, sort);
}
@Override
public List<T> findWithoutLimit(String fiqlQuery, String fieldName, Direction direction) {
Sort sort = new Sort(direction, fieldName);
return findWithoutLimit(fiqlQuery, sort);
}
private List<T> findListEnity(String fiqlQuery, int size, Sort sort) {
Query query = getSearchQuery(fiqlQuery);
if (size != -1) {
int sizeShow = (size > 0) ? size : DEFAULT_SIZE;
query.limit(sizeShow);
}
if (sort != null) {
query.with(sort);
}
List<T> rows = mongoOperations.find(query, genericType);
return rows;
}
|
|
|