In which database table can I find the Current Project Id ?

[support for vo]

I want to do a SQL request to retrieve the CurrentProjectId.

[Alexey Matveev]

Hello,

What do you mean CurrentProjectId? Id is always the same for the whole life of a project. Do you want to get the CurrentProjectKey?

Anyway all this info is in the project table.

[Grigory Salnikov]

I can confirm it. It's the first column:

[Alexey Matveev]

What do you mean by Id? And how do you want to use it?

[support for vo]

Hi,

Thanks for your reply. But what I need is the Id of the Current Project which is this one :

[Grigory Salnikov]

It's the same here. You just need to look for the project "Sentinel" in the "project" table and find its id. As @Alexey Matveev has already said, there's no such thing as "CurrentProjectId", but you can always find the ID of the current project.

[support for vo]

Sorry, but it doesn't answer my problem. I know what you explain.

But I want to make a generic request for the Current Project. I don't know which is the Current Project. In my example it is "Sentinel", but if the user select another Project, the "Current Project" will change.

It is the same problem as when you use the function "project = currentProject() " in any filter (after installing the plugin). With this function you can make generic filter to use in an unique Board for example.

[Grigory Salnikov]

Ok, I see. 

You have a limited number of projects, right? You can create all the pairs "Project - ID" and take the matching value without any SQL queries. 

Where do you plan to use this value, anyway?

[support for vo]

It is to use for example in the SQL field of a "List" type field of the PROFIELD plugin, which is connected to an external Source (as another JIRA database). But anyway, to display the CURRENT PROJECT or the RECENT PROJECTS lists ... the project(s) ID must be stored somewhere in the JIRA database isn't it ?

[Grigory Salnikov]

Not necessarily. 

I tend to think that such information may as well be stored in users' cookies. 

[support for vo]

AH OK ! In this case there is no solution for me with SQL .. I will have to do differently. Thanks a lot for all your answers.

[Grigory Salnikov]

You're welcome. Sorry you haven't found the answer.