<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /></head><body style='font-size: 10pt; font-family: Verdana,Geneva,sans-serif'>
<p>Hi,</p>
<p>What expression did you use?</p>
<p>Here are some ideas what you could do:</p>
<ul>
<li>get_feature() / get_feature_by_id() and attribute() - here you need some logic how to retrieve the related feature from the other layer</li>
<li>relation_aggregate() - allows you to have more than one match in the other layer and create aggregates</li>
<li>joins on layer properties - for 1:1 joins - needs to be done on layer properties</li>
</ul>
<p>If you clarify more specifically what you want to do, we can more easily help.</p>
<p>Also, if you have your expressions to share that you tried, it would help.</p>
<p>Greetings,</p>
<p>Andreas</p>
<p id="reply-intro">On 2019-06-26 09:06, Ville Koivisto wrote:</p>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0">
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0"><!-- html ignored --> <!-- head ignored --> <!-- meta ignored --> <!-- meta ignored --></blockquote>
</blockquote>
<style type="text/css">
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:8.5in 11.0in;
margin:70.85pt 56.7pt 70.85pt 56.7pt;}
div.WordSection1
{page:WordSection1;}</style>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0">
<div class="WordSection1">
<p class="MsoNormal"><strong><span>Hi list, <!-- o ignored --></span></strong></p>
<p class="MsoNormal"><span><!-- o ignored --> </span></p>
<p class="MsoNormal"><span>I’m trying to add several texts to my layout and configure their contents by an expression. The problem is that the fields that expression dialog offers me under <em>fields and values </em>are from one certain layer and I need them from another one. I’m struggling to find a way to fetch fields from two other layers participating in the layout. <!-- o ignored --></span></p>
<p class="MsoNormal"><span><!-- o ignored --> </span></p>
<p class="MsoNormal"><span>If I try to use their fields in an expression I get: <!-- o ignored --></span></p>
<p class="MsoNormal"><em><span>Eval error: Column “Field” not found<!-- o ignored --></span></em></p>
<p class="MsoNormal"><em><span><!-- o ignored --> </span></em></p>
<p class="MsoNormal"><span>How to solve this? Thank you for your attention. <!-- o ignored --></span></p>
<p class="MsoNormal"><span><!-- o ignored --> </span></p>
<p class="MsoNormal"><strong><span>Best regards,<!-- o ignored --></span></strong></p>
<p class="MsoNormal"><span>Ville Koivisto<!-- o ignored --></span></p>
<p class="MsoNormal"><span><!-- o ignored --> </span></p>
<p class="MsoNormal"><span><!-- o ignored --> </span></p>
<p class="MsoNormal"><span><!-- o ignored --> </span></p>
</div>
<!-- html ignored --><br />
<div class="pre" style="margin: 0; padding: 0; font-family: monospace">_______________________________________________<br />Qgis-user mailing list<br /><a href="mailto:Qgis-user@lists.osgeo.org" rel="noreferrer">Qgis-user@lists.osgeo.org</a><br />List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank" rel="noopener noreferrer">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br />Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank" rel="noopener noreferrer">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></div>
</blockquote>
<p><br /></p>
</body></html>