Sql to find custom fileds

Distef01

Hello to all.

How can i find witch sql custom fields assigned to project when only specific issue type selected ?

For example. For any new issues of PRJ1 no custom fields required.

For any new issues of PRJ2 if Task type defined then Filed1 custom filed required otherwise none.

 

 

 

Nic Brough -Adaptavist-

That is not a simple question.  Your SQL will need to read the field contexts, screen schemes and field configurations to work out what might be available on create (and, obviously, the screens could be different for edit.  Oh, and the workflow, you'll need to check workflow screens)

Then for the "fields required" bit, you will have already read the field configuration, but you'll need to check the workflow for any "field is mandatory" conditions or validators.

Are you sure you want to do this with SQL?  As it's the worst possible approach...