Hi Syed, Thanks for the answer. Can you let me know, when it is properly fixed?
Greetings, Gert ________________________________________ From: Syed Haider [[email protected]] Sent: Thursday, February 09, 2012 1:18 AM To: Gert Hulselmans Cc: [email protected] Subject: Re: [BioMart Users] Problems with boolean fields in Mart Configurator (release-0_8-candidate_7) Hi Gert, Clearly the only combination that seemed to be working is singleSelect. I was hoping that logs would have the SQL statement itself logged in - but thats not the case. In short, the query compilation is perhaps the one which needs to be fixed for this case. I guess safest route for you right now is to use singleSelect. Best, Syed On 08/02/2012 09:44, Gert Hulselmans wrote: > Hi Syed, > > Order of the queries: > > 1. Simplerepeat: type boolean ==> select 'Only' > - Dropdown values are set to "false" and "true" (filled in by update > button) > - "Error has occurred" > 2. Simplerepeat: type boolean ==> select 'Excluded' > - Dropdown values are set to "false" and "true" (filled in by update > button) > - "Error has occurred" > 3. Microsatellite: type boolean ==> select 'Only' > - Dropdown values are set to "0" and "1" (changed manually) > - "Error has occurred" > 4. Microsatellite: type boolean ==> select 'Excluded' > - Dropdown values are set to "0" and "1" (changed manually) > - "Error has occurred" > 5. Segmentational duplication : type SingleSelect ==> select '1' > - Dropdown values are set to "0" and "1" (changed manually) > - Correct results > 6. Segmentational duplication : type SingleSelect ==> select '0' > - Dropdown values are set to "0" and "1" (changed manually) > - Correct results > 7. Segmentational duplication : type SingleSelect ==> select 'true' > - Dropdown values are set to "false" and "true" (filled in by update > button) > - Wrong results (only results with Segmental duplication = 0 are shown) > 8. Segmentational duplication : type SingleSelect ==> select 'true' > - Dropdown values are set to "false" and "true" (filled in by update > button) > - "Correct" results (only results with Segmental duplication = 0 are shown) > > > Here is the relevant part of the log: > > 2012-02-03T09:27:09+0100 INFO [445882584@qtp-1468206791-3:Log.java:165]: > Incoming XML query:<!DOCTYPE Query><Query client="biomartclient" > processor="TSVX" limit="1000" header="1"><Dataset name="cancerlcbmut" > config="snvs_config"><Filter name="snvs__simplerepeat_101" > value="only"/><Attribute name="snvs__chr_101"/><Attribute > name="snvs__startpos_101"/><Attribute > name="snvs__simplerepeat_101"/><Attribute > name="snvs__microsat_101"/><Attribute > name="snvs__segdup_101"/></Dataset></Query> > 2012-02-03T09:27:09+0100 INFO [445882584@qtp-1468206791-3:Log.java:165]: > Query = > {"dataset":"cancerlcbmut","attributes":["snvs__chr_101","snvs__startpos_101","snvs__simplerepeat_101","snvs__microsat_101","snvs__segdup_101"],"filters":["snvs__simplerepeat_101: > only"]} > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an > error in your SQL syntax; check the manual that corresponds to your > MySQL server version for the right syntax to use near ''NOT NULL'' at > line 1 > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > > at java.lang.reflect.Constructor.newInstance(Constructor.java:525) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) > at com.mysql.jdbc.Util.getInstance(Util.java:382) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626) > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119) > > at > com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281) > at org.biomart.queryEngine.SubQuery.executeDatabaseQuery(SubQuery.java:795) > at org.biomart.queryEngine.SubQuery.executeQuery(SubQuery.java:757) > at > org.biomart.queryEngine.QueryRunnerThread.recurseSubQueries(QueryRunnerThread.java:171) > > at > org.biomart.queryEngine.QueryRunnerThread.call(QueryRunnerThread.java:73) > at > org.biomart.queryEngine.QueryRunnerThread.call(QueryRunnerThread.java:37) > at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) > at java.util.concurrent.FutureTask.run(FutureTask.java:166) > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) > at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) > at java.util.concurrent.FutureTask.run(FutureTask.java:166) > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) > at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) > at java.util.concurrent.FutureTask.run(FutureTask.java:166) > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) > > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) > > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) > > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) > > at java.lang.Thread.run(Thread.java:722) > 2012-02-03T09:27:09+0100 INFO [445882584@qtp-1468206791-3:Log.java:165]: > Total query time is 226 ms > 2012-02-03T09:30:56+0100 INFO > [1870285440@qtp-1468206791-4:Log.java:165]: Incoming XML query:<!DOCTYPE > Query><Query client="biomartclient" processor="TSVX" limit="1000" > header="1"><Dataset name="cancerlcbmut" config="snvs_config"><Filter > name="snvs__simplerepeat_101" value="excluded"/><Attribute > name="snvs__chr_101"/><Attribute name="snvs__startpos_101"/><Attribute > name="snvs__simplerepeat_101"/><Attribute > name="snvs__microsat_101"/><Attribute > name="snvs__segdup_101"/></Dataset></Query> > 2012-02-03T09:30:56+0100 INFO > [1870285440@qtp-1468206791-4:Log.java:165]: Query = > {"dataset":"cancerlcbmut","attributes":["snvs__chr_101","snvs__startpos_101","snvs__simplerepeat_101","snvs__microsat_101","snvs__segdup_101"],"filters":["snvs__simplerepeat_101: > excluded"]} > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an > error in your SQL syntax; check the manual that corresponds to your > MySQL server version for the right syntax to use near ''NULL'' at line 1 > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > > at java.lang.reflect.Constructor.newInstance(Constructor.java:525) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) > at com.mysql.jdbc.Util.getInstance(Util.java:382) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626) > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119) > > at > com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281) > at org.biomart.queryEngine.SubQuery.executeDatabaseQuery(SubQuery.java:795) > at org.biomart.queryEngine.SubQuery.executeQuery(SubQuery.java:757) > at > org.biomart.queryEngine.QueryRunnerThread.recurseSubQueries(QueryRunnerThread.java:171) > > at > org.biomart.queryEngine.QueryRunnerThread.call(QueryRunnerThread.java:73) > at > org.biomart.queryEngine.QueryRunnerThread.call(QueryRunnerThread.java:37) > at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) > at java.util.concurrent.FutureTask.run(FutureTask.java:166) > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) > at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) > at java.util.concurrent.FutureTask.run(FutureTask.java:166) > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) > at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) > at java.util.concurrent.FutureTask.run(FutureTask.java:166) > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) > > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) > > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) > > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) > > at java.lang.Thread.run(Thread.java:722) > 2012-02-03T09:30:56+0100 INFO > [1870285440@qtp-1468206791-4:Log.java:165]: Total query time is 12 ms > > > 2012-02-03T09:32:41+0100 INFO > [1870285440@qtp-1468206791-4:Log.java:165]: Incoming XML query:<!DOCTYPE > Query><Query client="biomartclient" processor="TSVX" limit="1000" > header="1"><Dataset name="cancerlcbmut" config="snvs_config"><Filter > name="snvs__microsat_101" value="only"/><Attribute > name="snvs__chr_101"/><Attribute name="snvs__startpos_101"/><Attribute > name="snvs__simplerepeat_101"/><Attribute > name="snvs__microsat_101"/><Attribute > name="snvs__segdup_101"/></Dataset></Query> > 2012-02-03T09:32:41+0100 INFO > [1870285440@qtp-1468206791-4:Log.java:165]: Query = > {"dataset":"cancerlcbmut","attributes":["snvs__chr_101","snvs__startpos_101","snvs__simplerepeat_101","snvs__microsat_101","snvs__segdup_101"],"filters":["snvs__microsat_101: > only"]} > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an > error in your SQL syntax; check the manual that corresponds to your > MySQL server version for the right syntax to use near ''NOT NULL'' at > line 1 > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > > at java.lang.reflect.Constructor.newInstance(Constructor.java:525) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) > at com.mysql.jdbc.Util.getInstance(Util.java:382) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626) > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119) > > at > com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281) > at org.biomart.queryEngine.SubQuery.executeDatabaseQuery(SubQuery.java:795) > at org.biomart.queryEngine.SubQuery.executeQuery(SubQuery.java:757) > at > org.biomart.queryEngine.QueryRunnerThread.recurseSubQueries(QueryRunnerThread.java:171) > > at > org.biomart.queryEngine.QueryRunnerThread.call(QueryRunnerThread.java:73) > at > org.biomart.queryEngine.QueryRunnerThread.call(QueryRunnerThread.java:37) > at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) > at java.util.concurrent.FutureTask.run(FutureTask.java:166) > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) > at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) > at java.util.concurrent.FutureTask.run(FutureTask.java:166) > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) > at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) > at java.util.concurrent.FutureTask.run(FutureTask.java:166) > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) > > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) > > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) > > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) > > at java.lang.Thread.run(Thread.java:722) > 2012-02-03T09:32:41+0100 INFO > [1870285440@qtp-1468206791-4:Log.java:165]: Total query time is 12 ms > 2012-02-03T09:36:30+0100 INFO > [1870285440@qtp-1468206791-4:Log.java:165]: Incoming XML query:<!DOCTYPE > Query><Query client="biomartclient" processor="TSVX" limit="1000" > header="1"><Dataset name="cancerlcbmut" config="snvs_config"><Filter > name="snvs__microsat_101" value="excluded"/><Attribute > name="snvs__chr_101"/><Attribute name="snvs__startpos_101"/><Attribute > name="snvs__simplerepeat_101"/><Attribute > name="snvs__microsat_101"/><Attribute > name="snvs__segdup_101"/></Dataset></Query> > 2012-02-03T09:36:30+0100 INFO > [1870285440@qtp-1468206791-4:Log.java:165]: Query = > {"dataset":"cancerlcbmut","attributes":["snvs__chr_101","snvs__startpos_101","snvs__simplerepeat_101","snvs__microsat_101","snvs__segdup_101"],"filters":["snvs__microsat_101: > excluded"]} > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an > error in your SQL syntax; check the manual that corresponds to your > MySQL server version for the right syntax to use near ''NULL'' at line 1 > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > > at java.lang.reflect.Constructor.newInstance(Constructor.java:525) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) > at com.mysql.jdbc.Util.getInstance(Util.java:382) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626) > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119) > > at > com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281) > at org.biomart.queryEngine.SubQuery.executeDatabaseQuery(SubQuery.java:795) > at org.biomart.queryEngine.SubQuery.executeQuery(SubQuery.java:757) > at > org.biomart.queryEngine.QueryRunnerThread.recurseSubQueries(QueryRunnerThread.java:171) > > at > org.biomart.queryEngine.QueryRunnerThread.call(QueryRunnerThread.java:73) > at > org.biomart.queryEngine.QueryRunnerThread.call(QueryRunnerThread.java:37) > at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) > at java.util.concurrent.FutureTask.run(FutureTask.java:166) > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) > at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) > at java.util.concurrent.FutureTask.run(FutureTask.java:166) > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) > at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) > at java.util.concurrent.FutureTask.run(FutureTask.java:166) > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) > > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) > > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) > > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) > > at java.lang.Thread.run(Thread.java:722) > 2012-02-03T09:36:30+0100 INFO > [1870285440@qtp-1468206791-4:Log.java:165]: Total query time is 12 ms > > > 2012-02-03T09:36:51+0100 INFO > [1870285440@qtp-1468206791-4:Log.java:165]: Incoming XML query:<!DOCTYPE > Query><Query client="biomartclient" processor="TSVX" limit="1000" > header="1"><Dataset name="cancerlcbmut" config="snvs_config"><Filter > name="snvs__segdup_101" value="1"/><Attribute > name="snvs__chr_101"/><Attribute name="snvs__startpos_101"/><Attribute > name="snvs__simplerepeat_101"/><Attribute > name="snvs__microsat_101"/><Attribute > name="snvs__segdup_101"/></Dataset></Query> > 2012-02-03T09:36:51+0100 INFO > [1870285440@qtp-1468206791-4:Log.java:165]: Query = > {"dataset":"cancerlcbmut","attributes":["snvs__chr_101","snvs__startpos_101","snvs__simplerepeat_101","snvs__microsat_101","snvs__segdup_101"],"filters":["snvs__segdup_101: > 1"]} > 2012-02-03T09:36:51+0100 INFO > [1870285440@qtp-1468206791-4:Log.java:165]: Total query time is 235 ms > 2012-02-03T09:37:10+0100 INFO > [1870285440@qtp-1468206791-4:Log.java:165]: Incoming XML query:<!DOCTYPE > Query><Query client="biomartclient" processor="TSVX" limit="1000" > header="1"><Dataset name="cancerlcbmut" config="snvs_config"><Filter > name="snvs__segdup_101" value="0"/><Attribute > name="snvs__chr_101"/><Attribute name="snvs__startpos_101"/><Attribute > name="snvs__simplerepeat_101"/><Attribute > name="snvs__microsat_101"/><Attribute > name="snvs__segdup_101"/></Dataset></Query> > 2012-02-03T09:37:10+0100 INFO > [1870285440@qtp-1468206791-4:Log.java:165]: Query = > {"dataset":"cancerlcbmut","attributes":["snvs__chr_101","snvs__startpos_101","snvs__simplerepeat_101","snvs__microsat_101","snvs__segdup_101"],"filters":["snvs__segdup_101: > 0"]} > 2012-02-03T09:37:10+0100 INFO > [1870285440@qtp-1468206791-4:Log.java:165]: Total query time is 237 ms > > > 2012-02-03T09:54:14+0100 INFO > [1478626955@qtp-1468206791-8:Log.java:165]: Incoming XML query:<!DOCTYPE > Query><Query client="biomartclient" processor="TSVX" limit="1000" > header="1"><Dataset name="cancerlcbmut" config="snvs_config"><Filter > name="snvs__segdup_101" value="true"/><Attribute > name="snvs__chr_101"/><Attribute name="snvs__startpos_101"/><Attribute > name="snvs__simplerepeat_101"/><Attribute > name="snvs__microsat_101"/><Attribute > name="snvs__segdup_101"/></Dataset></Query> > 2012-02-03T09:54:14+0100 INFO > [1478626955@qtp-1468206791-8:Log.java:165]: Query = > {"dataset":"cancerlcbmut","attributes":["snvs__chr_101","snvs__startpos_101","snvs__simplerepeat_101","snvs__microsat_101","snvs__segdup_101"],"filters":["snvs__segdup_101: > true"]} > 2012-02-03T09:54:14+0100 INFO > [1478626955@qtp-1468206791-8:Log.java:165]: Total query time is 662 ms > 2012-02-03T09:55:32+0100 INFO > [1478626955@qtp-1468206791-8:Log.java:165]: Incoming XML query:<!DOCTYPE > Query><Query client="biomartclient" processor="TSVX" limit="1000" > header="1"><Dataset name="cancerlcbmut" config="snvs_config"><Filter > name="snvs__segdup_101" value="false"/><Attribute > name="snvs__chr_101"/><Attribute name="snvs__startpos_101"/><Attribute > name="snvs__simplerepeat_101"/><Attribute > name="snvs__microsat_101"/><Attribute > name="snvs__segdup_101"/></Dataset></Query> > 2012-02-03T09:55:32+0100 INFO > [1478626955@qtp-1468206791-8:Log.java:165]: Query = > {"dataset":"cancerlcbmut","attributes":["snvs__chr_101","snvs__startpos_101","snvs__simplerepeat_101","snvs__microsat_101","snvs__segdup_101"],"filters":["snvs__segdup_101: > false"]} > 2012-02-03T09:55:32+0100 INFO > [1478626955@qtp-1468206791-8:Log.java:165]: Total query time is 239 ms > > > On 02/01/2012 10:06 PM, Syed Haider wrote: >> Gert, >> >> For the settings whereby you get the incorrect results from the >> webinterface, what do the logs suggest >> (biomart-java/dist/logs/stdouterr*) ? >> >> You can see the query in the logs and please post here. >> >> thanks >> Syed >> >> >> On 01/02/2012 16:35, Arek Kasprzyk wrote: >>> Hi Gert, >>> have you tried 'rc6'? (this is the last version officially released). >>> Are >>> you experiencing the same problem there? >>> >>> a >>> >>> >>> On Wed, Feb 1, 2012 at 11:17 AM, Gert Hulselmans< >>> [email protected]> wrote: >>> >>>> Hi, >>>> >>>> I am trying to use Mart Configurator of BioMart >>>> (release-0_8-candidate_7) >>>> with my custom table. >>>> >>>> I have some fields with boolean data (stored as TINYINT(1)): >>>> - false is stored as 0 >>>> - true is stored as 1 >>>> >>>> When I give such a field a boolean type in Mart Configurator, I get: >>>> >>>> "Error has occurred" >>>> >>>> when I select one of the options (Only or Excluded) and press "Go" in >>>> the webinterface. >>>> >>>> When looking at the "Dropdown list" in Mart Configurator, I see: >>>> - false >>>> - true >>>> >>>> Changing those values to 0 and 1 respectively, doesn't help (same >>>> error). >>>> >>>> If I change the fileds with the boolean data to singleSelect or >>>> multiSelect type in Mart Configurator >>>> and select 'true' or 'false', both return only columns with '0' for >>>> that >>>> field. >>>> >>>> When changing 'false' -> '0' and 'true' -> '1' in the "Dropdown list", >>>> selecting '0' or '1' return >>>> the right columns. >>>> >>>> >>>> Is this a bug or am I doing something wrong? >>>> >>>> >>>> Another question. >>>> Where can I find documentation about all property fields in Mart >>>> Configurator? >>>> The PDF manual doesn't cover them all. >>>> >>>> Is it possible to specify in Mart Configurator which checkboxes for the >>>> attributes section >>>> of the webinterface should be checked by default in the webinterface? >>>> >>>> >>>> Greetings, >>>> Gert Hulselmans >>>> ______________________________**_________________ >>>> Users mailing list >>>> [email protected] >>>> https://lists.biomart.org/**mailman/listinfo/users<https://lists.biomart.org/mailman/listinfo/users> >>>> >>>> >>> >>> >>> _______________________________________________ >>> Users mailing list >>> [email protected] >>> https://lists.biomart.org/mailman/listinfo/users > > _______________________________________________ > Users mailing list > [email protected] > https://lists.biomart.org/mailman/listinfo/users _______________________________________________ Users mailing list [email protected] https://lists.biomart.org/mailman/listinfo/users
