Few questions

Hi to all,


just few questions:





1) is it possible to copy or move a custom view from a schema to another or from a project to another. Obviously, in this case I would have the same fields between different projects or schemas





2) May I load images into ijc tables?





3) Is it possible to run a query using "group by"?





Thanks in advance,


Pasquale

Quote:

1) is it possible to copy or move a custom view from a schema to another or from a project to another. Obviously, in this case I would have the same fields between different projects or schemas

No this is not currently posible. The problem is that although you know the DBs are identical in IJC all the fields and entities etc. have different IDs in the 2 DB and so there is no current way to tie the form widgets to the fields in the other DB.


Other people have requested this, so we will look for a solution.

Quote:

2) May I load images into ijc tables?

Not currently, but following the 2.0 relese we will be creating a whole load of new field and widget types, including images. Having the image in the DB would be one option, but loading an image into the DB for each row might be painful. We will also support loading of images from URLs (or files) based on an ID that will be part of the URL which may be a more flexible way of doing this.

Quote:

3) Is it possible to run a query using "group by"?

No. We support sorting of data so that if you want the values in the view to be in some order this is easy to do.


GROUP BY is typically for situations when you are generating extra "columns" in the returned data e.g.

Code:

SELECT Company,SUM(Quantity * Price) FROM Sales GROUP BY Company

where SUM(Quantity * Price) is a new result type (it would have to be a new field that appeared by magic and then disappeared when you ran a different query), so is not really appropriate for how IJC currently works.


Were you thinking of GROUP BY in a different context?





Tim

Hello,





I have instant jchem 2.1, and have not found this feature. Has it been implemented yet? If so could you please lead me to the appropriate documentation.





My goal is to load either the image(s) that corresponds to a compound either directly into the db or by url to a folder.





I would be delighted to get this idea off the ground.





And by the way I couldn't be more pleased with your product, this software gives one measly grad student so much power to perform informed chemical screening and analysis!

Glad you are finding IJC useful.


Support for new field types has been discussed on this topic:


http://www.chemaxon.com/forum/ftopic2949.html





Tim