Hi Halil, The problem with this sql is that it looks for the licenses attached to a file. ant-1.6.5.jar doesn't contain any licenses - the files inside of ant-1.6.5.jar are the ones that contain licenses. So the query you really want is to list all the licenses inside the jar.
SELECT alr.lic_name, alr.lic_url from agent_lic_meta alm join agent_lic_raw alr on alr.lic_pk=alm.lic_fk join pfile pf on pf.pfile_pk=alm.pfile_fk join uploadtree ut on ut.pfile_fk=pf.pfile_pk where ut.ufile_name like 'ant-1.6.5.jar' and ut.upload_fk=316 and lft>1 and rgt <25; To get the upload_fk, lft, and rgt: select upload_fk, lft, rgt from uploadtree where ufile_name='ant-1.6.5.jar'; agent_lic_*** tables that you are using will only give you the results of the bsam analysis. Combining that with licterms (what we do in the ui) is much more complicated. If you want to see how that is done, look at LicenseGetAll() in ui/common/common-license.php. The good news is all this gets much simpler in fossology v 1.2 but that's still a month or two away. I hope that helps, Bob Gobeille On Feb 8, 2010, at 3:41 PM, Halil Bilda wrote: Hello Bob I will only show the license of an open source component. I can find the os component in main search and view the license. I will now run a sql query. Here I use the following sql query: select alr.lic_name, alr.lic_url from agent_lic_meta alm join agent_lic_raw alr on alr.lic_pk=alm.lic_fk join pfile pf on pf.pfile_pk=alm.pfile_fk join uploadtree ut on ut.pfile_fk=pf.pfile_pk where ut.ufile_name like 'ant-1.6.5.jar' The license will not be displayed. The component is not found. What's wrong? <ATT00001..txt> _______________________________________________ fossology mailing list [email protected] http://fossology.org/mailman/listinfo/fossology
