limiting results sets in JC_COMPARE

ChemAxon 60ee1f1328

25-05-2006 10:42:53

Hello,





Could you please indicate which query I should use in the options of JC_COMPARE in order to limit my results set to x. I think I tried "select cd_id from tab where rownum < x" and this gave an error message indicating this was not a valid option...





Thanks,


Daniel.

ChemAxon aa7c50abf8

26-05-2006 07:50:39

Please, consult the documentation for the filterQuery option of jc_compare (http://www.chemaxon.com/jchem/doc/guide/cartridge/cartapi.html#jc_compare).





Peter

ChemAxon 9c0afc9aaf

26-05-2006 08:07:32

You should also take a look at the "maxHitCount" option at the same location, maybe that's what you really need (depending on what you want to achieve).





Szilard

ChemAxon 60ee1f1328

26-05-2006 08:12:34

Hi Guys,





I think the maxHitCount option is what I need...I have read the jc_compare documentation and tried select cd_id from tab where rownum < x but it didn not appear to accept that and so thanks for pointing out this option.





Daniel.