Append doesn't seem to work

[avinashsonee]

Hi,

I was trying out QueryTree Advanced Query Builder for a PostgreSQL database. I have added 2 filter conditions to a data table and both the filters seems to work fine. And then I was trying to append these 2 filter nodes using an Append node but I see an error on the Append node.

Append seems to work fine when only either of the Filter nodes are connected to it but fails as soon as both the Filter nodes are connected.

filter2 > select2

filter3 > select3

filter2 > select2 > append2

ERROR!
filter2 > select2 > (append2) < select3 < filter3

The columns are same in both the filters. There is data in each and every cell (row x column) of both the filters.

I tried with enabling and disabling the "Include Non-matched Columns" option of the Append node.

Let me know if you need any more details.

Thanks for building this awesome tool

[d4nt]

@avinashsonee thanks for raising this, and the detailed explanation. I was able to reproduce it and have committed a fix to the develop branch (c9a78c9). Are you able to test it from that branch before I merge it into master?

[avinashsonee]

@d4nt this works. thanks for the quick fix. This can be merged to master although I haven't tested it extensively.

[avinashsonee]

@d4nt I also don't see the scheduled reports to be actually working.
I've configured the settings as per https://github.com/d4software/QueryTree/blob/develop/docs/mail.md
I've tried scheduling a simple report at multiple different times but nothing worked. I didn't receive a mail.
Also the server was always running while checking this. In the server logs too, I didn't see any info about scheduled emails being sent or any kind of error related to that.
Should I raise a separate issue for this?

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.