If I have a pkey-intger (for e.g. bug-20) how do I find associated project name? Can someone please help?
I believe "project" table does have an entry for pkey and with associated pname, I need to get rid of integer value
I assume pkey is the project key? If that is the case, you can query from the project table.
select * from project where pkey = '<PKEY_HERE>';
Use the database susbtring function to extract the pkey from pkey-integer e.g. for MySQL - http://dev.mysql.com/doc/refman/5.5/en/string-functions.html#function_substring-index
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.