SELECT I.* FROM ISSUE I INNER JOIN NOTE N ON N.ISSUE=I.ID WHERE UPPER(N.TEXT) LIKE UPPER('%@FIND%')
Admin console
If we create a database as shown in quick start we get in c:\Program Files\MyTracker\Admin console\server.ini
Such lines:
[Servers]
myprojectname=FB;;c:\Program Files\MyTracker\myprojectname.fdb;sysdba;dzesE2MeBOnolYNZFeVvoA==
If you use a database server in network you should use such a database connection string:
myprojectname=FB;;computername:c:\Program Files\MyTracker\myprojectname.fdb;sysdba;dzesE2MeBOnolYNZFeVvoA==
Of course if you work local on the database server machine you could also use localhost as computername