<div>To fetch the value you need to call $obj-&gt;get_column(&#39;decrypted_field_name&#39;),</div>
<div>not $obj-&gt;decrypted_field_name. See docs for info on how&nbsp;get $obj-&gt;decrypted_field_name working too.<br><br>&nbsp;</div>
<div><span class="gmail_quote">2007/5/7, Oleg Pronin &lt;<a href="mailto:syber.rus@gmail.com">syber.rus@gmail.com</a>&gt;:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>For this to be done automatically, </div>
<div>in your result source Employee:</div>
<div>&nbsp;</div>
<div>__PACKAGE__-&gt;resultset_attributes({</div><span class="q">
<div>&nbsp;&nbsp;&nbsp;&nbsp; +select =&gt; [ \&quot;AES_DECRYPT(field_name,&#39;password&#39;)&quot; ],<br>&nbsp;&nbsp;&nbsp;&nbsp; +as&nbsp;&nbsp;&nbsp;&nbsp; =&gt; [qw/ decrypted_field_name /],<br>});</div></span></blockquote></div>