Searching for a List of items

User 7b0ee04e66

04-08-2009 11:11:02

Hello


We are trying to search for a list of Notebooks in a local Instant JChem database. The list comes from an external source (e.g. Excel) and we need to know if these notebooks exist.


It is possible to run an 'OR' query for a few, but this is not very practical if the list is bigger than 5 or 10.


We have tried to search for LNB in List and copy our list in the text area, but this does not work.


Can you suggest an alternative way to do this?


Thanks


Catherine

ChemAxon 3b366b17e5

04-08-2009 15:25:30

Yes, it's possible. You need to use Query BuilderĀ  window to create query with or operator. Query Builder windows can be opened from Window->Query Builder main menu. The operator can be changed from popup menu of query builder.


Petr

ChemAxon fa971619eb

04-08-2009 16:29:28

We do plan to extend the list management feature to allow it to handle lists from fields other than the ID field, but currently this is not possible,