Project lcommon key between Jira and BigPicture

[Shahid Mohammad]

The table Project holds the Projects information as it is stored in Jira. As such it has an ID, PNAME, PKEY.

In Bigpicture when you create an entry as a Project you could name it anything and then under its configuration in the BP you link this BP project entry to the Jira Project (under task scope def).

Ideally we should name the project name in BP same as Jira but this could be different.

The project information inside BP is stored in the table AO_0456E7_BOX

I can link the two tables only with Pname and Name. but in case BP Project name is different it wont work. can any one tell me the key to match ?

[Nic Brough -Adaptavist-]

It's a long and complicated thing to try to explain.  The best answer I can give you is to stop reading the database - it's not built for reporting, it's a total mess, and you're far better off using the REST API to ask questions of your Jira.