Need help with External Lookup field for DE: custom field

[manu0242]

Need help with External Lookup field, we have a custom field called DE:B Number at project level custom forms. Now I am trying to get a external look up field at issue level custom form for users to map existing DE:B Number which is available at project level Any help would be highly appreciated thanks in advance. 

 

[Sven-iX]

Not clear: Are you trying to just display, on the issue, the value of DE:B Number of the project? If so you can use a calculated field on the issue {project}.{DE:B Number}

[manu0242]

We currently have a 'B Number' captured as a plain text field on our project-level custom form for different projects. We’re hoping to display this 'B Number' on an issue-level custom form as a dropdown option, allowing users to select from all the values entered at the project level.

[manu0242]

I am trying to use API URL as $$HOST/attask/api/v18.0/project/search?status={DE:B Number}&$$QUERY

JSON Path: $.data[*].name

[Sven-iX · Accepted solution]

So DE:B Number is a field - I don't understand why you would equate it with the project status? 

You probably want something like 

 $$HOST/attask/api/v18.0/project/search?DE:B Number_Mod=notblank&DE:B Number_Mod=$$QUERY&fields=DE:B Number

and

JSON Path: $.data[*].['DE:B Number']

This will list all B Number values across all projects, as long as the field has a value. However, you WILL get duplicates. If you want a unique list, use Fusion instead of call to API

[manu0242]

It worked thank you so much 

[Sven-iX]

Yikes, I found a typo

 $$HOST/attask/api/v18.0/project/search?DE:B Number_Mod=notblank&DE:B Number=$$QUERY&fields=DE:B Number

DE:B Number = $$QUERY to filter results based on what user types in ExtLookup field.