How to have two custom fields of the same database row?

[Sascha Ziemann]

I have install nFeed and was able to create a custom field, which gets read by an SQL select query from the database. It works fine even with auto complete.

Now I would like to have another read only custom field, which displays anoter column of the same row. But I do not understand how to use an issue attribute in the SQL query.

How do I have to define such a read only field? Can anybody give me an example for the SQL query?

[Nicolas Simon · Accepted solution]

Hello Sascha,

Maybe this tutorial will help you -> https://valiantys.atlassian.net/wiki/spaces/NFEED512X/pages/99942710/Display+related+data+with+read-only+fields

Nicolas

[Sascha Ziemann]

Thanks this helps. There seems to be also an alternative way:

select "LAN-MAC" from "DeliveryItem" where "SerialNbr" = '$issue.customfield_10117'