<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:drewjensen.inbox@gmail.com" title="Drew Jensen <drewjensen.inbox@gmail.com>"> <span class="fn">Drew Jensen</span></a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - ReportBuilder does not know aliases for Firebird views"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=118233">bug 118233</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>drewjensen.inbox@gmail.com
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - ReportBuilder does not know aliases for Firebird views"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=118233#c4">Comment # 4</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - ReportBuilder does not know aliases for Firebird views"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=118233">bug 118233</a>
from <span class="vcard"><a class="email" href="mailto:drewjensen.inbox@gmail.com" title="Drew Jensen <drewjensen.inbox@gmail.com>"> <span class="fn">Drew Jensen</span></a>
</span></b>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=142941" name="attach_142941" title="screen shot showing issue">attachment 142941</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=142941&action=edit" title="screen shot showing issue">[details]</a></span>
screen shot showing issue
Got it:
Two QueryDefinitions; MitgliederVerbandExcelvorlage and Abfrage1.
MitgliederVerbandExcelvorlage uses table MitgliederVerband
Abfrage1 uses MitgliederVerbandExcelvorlage and creates one alias, VereinID
Report is based on Abfrage1 and in the set filter dialog references
Abfrage1.VereinID
But the filter SQL snippet references "MitgliederVerbandExcelvorlage"."Verien"
instead of ( "Abfrage1"."VereinID" = '0' )
As far as I can tell it doesn't change the result set (didn't after I added
some records and ran the report with both variations), but it seems it should
the later and the not the former.
Put it all in pictures(why not? ;) see attachment</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>