Problem with Muegge filter.

User ccbacff418

20-11-2006 00:31:02

Hi,





I just tried to use the Muegge filter and IJC gave the following error. Any ideas what's going on?





Thanks.





- Guillermo.





java.lang.RuntimeException: Query failed


at com.im.df.core.impl.DatabaseSchemaManager.queryForIds(DatabaseSchemaManager.java:634)


at com.im.df.core.impl.SimpleDataTreeItem.queryForIds(SimpleDataTreeItem.java:131)


at com.im.df.core.impl.SimpleResultSet.queryForIds(SimpleResultSet.java:177)


at com.im.workbench.ijc.ds.DataTreeSupport$QueryActionListener.run(DataTreeSupport.java:398)


at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:493)


[catch] at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:926)


Caused by: chemaxon.jchem.db.DatabaseSearchException: Error while compiling expression:


(rotatableBondCount() <= 10) && (PSA() <= 140) (mass() <= 450) && (logD('7.4') >= -4) && (logD('7.4') <= 4) && (ringCount() <= 4) && (rotatableBondCount() <= 10) && (donorCount() <= 5) && (acceptorCount() <= 8)


Syntax Error (implicit multiplication not enabled)


at chemaxon.jchem.db.JChemSearch.initChemTermFilter(JChemSearch.java:3114)


at chemaxon.jchem.db.JChemSearch.init(JChemSearch.java:3086)


at chemaxon.jchem.db.JChemSearch.search1(JChemSearch.java:2333)


at chemaxon.jchem.db.JChemSearch.search(JChemSearch.java:2233)


at chemaxon.jchem.db.JChemSearch.access$1200(JChemSearch.java:79)


at chemaxon.jchem.db.JChemSearch$SearchThread.run(JChemSearch.java:428)

User ccbacff418

20-11-2006 00:38:24

I just found out that the problem appears to be the filter selection pop-up window.





If you select 1 filter there is no problem, but if you choose another one the filter parameters are added to the filter-1 parameters and the text in the filter query box becomes red.





You need to select the filter parameters with the cursor, delete them, and then select another filter.





Is this a bug?





Thanks.





- Guillermo.

ChemAxon fa971619eb

20-11-2006 08:28:44

No, that's the way its supposed to work. This allows you to add multiple terms to the expression. But if you do this then you need to ensure that the terms have appropriate separators between them to make the text a valid expression. Typical separators would the the normal maths operatios (+, - *, /) and logical oprators (&&, ||) are obvious examples. The chem terms reference guide gives some good examples.


http://www.chemaxon.com/jchem/doc/user/ChemicalTerms.html





As you noticed, you are notified when an expression is invalid.