We are using barcode in our labels that contain the Catalog Number data. Sometimes we need uptade some data in a non-sequence set of records, thus it´s necesary save a record set with these data.
The barcode reader can insert a list of these records in the field "catalog number" of a query, for example: ANL 000093, ANL 001204, ANL 000066, ANL 000168, ANL 000569 .... , and with operator "IN" we can get the specific records.
However, this process just works in a english version of Specify, using the portuguese version we get an error (see below) in the Handled Exception window, I supposed that in the stack_trace the word "Em" should be remains "IN".
Is it possible to fix these bug in the next versions?
Is there another way to search a especific list of data using other operator (LIKE, CONTAIN ...) and some wildcard (* " ; ...)?
Thanks very much!
ERROR:
class_name: edu.ku.brc.specify.tasks.subpane.qb.QueryBldrPane
comments:
stack_trace:
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: Em near line 1, column 130 [select co0.collectionObjectId, co0.catalogNumber from edu.ku.brc.specify.datamodel.CollectionObject co0 where co0.catalogNumber Em ('ANL 000071', 'ANL 000062') AND (co0.collectionMemberId = 393216)]
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:31)
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:24)
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:59)
at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:258)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:157)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
at org.hibernate.engine.query.HQLQueryPlan.
at org.hibernate.engine.query.HQLQueryPlan.
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)
at edu.ku.brc.specify.dbsupport.HibernateDataProviderSession$HibernateQuery.
at edu.ku.brc.specify.dbsupport.HibernateDataProviderSession.createQuery(HibernateDataProviderSession.java:582)
at edu.ku.brc.specify.tasks.subpane.qb.QueryBldrPane.checkHQL(QueryBldrPane.java:1558)
at edu.ku.brc.specify.tasks.subpane.qb.QueryBldrPane.buildHQL(QueryBldrPane.java:1540)
at edu.ku.brc.specify.tasks.subpane.qb.QueryBldrPane.doSearch(QueryBldrPane.java:1740)
at edu.ku.brc.specify.tasks.subpane.qb.QueryBldrPane.doSearch(QueryBldrPane.java:932)
at edu.ku.brc.specify.tasks.subpane.qb.QueryBldrPane$5.actionPerformed(QueryBldrPane.java:637)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
task_name: Query
title:
id: 76f1157d-cd48-7f7b-0ec7-0b6e75f0418f--13225ee9fa0
os_name: Windows XP
os_version: 5.1
java_version: 1.6.0_23
java_vendor: Sun Microsystems Inc.
max_memory: 778502144
used_memory: 630170000
user_name: crsantos
ip: 10.XXXXXXX
app_version: 6.3.05
collection: XXXX
discipline: IXXXXX
division: CXXXXXXX
institution: MuXXX
Collection_number: null
Discipline_number: null
Division_number: null
Institution_number: null