<div dir="ltr"><div class="gmail_default"><font face="arial, helvetica, sans-serif">A visit to <a href="https://www.google.co.uk/search?q=dbix+select+distinct">https://www.google.co.uk/search?q=dbix+select+distinct</a> should answer your question:</font><br></div><div class="gmail_default"><font face="arial, helvetica, sans-serif"><br></font></div><div class="gmail_default"><font face="arial, helvetica, sans-serif">DBIx::Class::Manual::Cookbook (first result here) says:<br></font></div><div class="gmail_default"><font face="arial, helvetica, sans-serif"><br></font></div><div class="gmail_default"><font face="arial, helvetica, sans-serif"><div class="gmail_default">SELECT DISTINCT with multiple columns</div><div class="gmail_default">...</div><div class="gmail_default"> my $rs = $schema->resultset('Artist')->search(</div><div class="gmail_default"> {},</div><div class="gmail_default"> {</div><div class="gmail_default"> columns => [ qw/artist_id name rank/ ],</div><div class="gmail_default"> distinct => 1</div><div class="gmail_default"> }</div><div class="gmail_default"> );</div><div>...</div><div><br></div><div>It *is* a little hard to find, I guess, since the word "distinct" does not appear in DBIx::Class::Manual::Features, and the explanation of *distinct* in DBIx::Class::ResultSet only mentions `GROUP BY`.</div><div><br></div><div>You can generate the functional form by writing e.g. { ..., columns => [ { distinct => ... } ] };</div><div><br></div></font></div></div><div class="gmail_extra"><br><div class="gmail_quote">On 8 March 2018 at 06:52, Andreas Dafferner <span dir="ltr"><<a href="mailto:andreas.dafferner@adw.uni-heidelberg.de" target="_blank">andreas.dafferner@adw.uni-heidelberg.de</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I'm quite new to DBIx and cannot find out what is the DBIx way for<br>
<br>
select distinct left (col, (length(col) - 9)) from table order by col<br>
<br>
???<br>
<br>
Thank you for any help<br>
<br>
Andreas<br>
<br>
______________________________<wbr>_________________<br>
List: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class" rel="noreferrer" target="_blank">http://lists.scsys.co.uk/cgi-b<wbr>in/mailman/listinfo/dbix-class</a><br>
IRC: <a href="http://irc.perl.org#dbix-class" rel="noreferrer" target="_blank">irc.perl.org#dbix-class</a><br>
SVN: <a href="http://dev.catalyst.perl.org/repos/bast/DBIx-Class/" rel="noreferrer" target="_blank">http://dev.catalyst.perl.org/r<wbr>epos/bast/DBIx-Class/</a><br>
Searchable Archive: <a href="http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk" rel="noreferrer" target="_blank">http://www.grokbase.com/group/<wbr>dbix-class@lists.scsys.co.uk</a><br>
</blockquote></div><br></div>