Report doesnt see fields from nuSQL(after JOIN)

[Ricu]

Hi,
My report cant see the fields when I try to add them from nuSQL.
I think its a problem with the JOIN, because if i try to take the data from just one table it works fine.
When I JOIN other tables, the report becomes empty.
I saw other users had this problem, but I couldnt find a solution for me.

Thanks!

[kev1n]

Hi,

You might get around this by creating a temporary table:
https://wiki.nubuilder.cloud/index.php/Reports#Table

[Ricu]

with a procedure?
(so is a problem with nubuilder... in older version it worked perfectly )

[Ricu]

OK, i tried with a procedure, i copied the code from sql builder from my form where it works.
Same thing. The report cant see no fields
Can u help me?

[kev1n]

Yes, with a procedure.

My report cant see the fields when I try to add them from nuSQL.

Can you provide more details? Where do you not see the fields?

[Ricu]

in the report designer, when i try to add new fields.
to be more clear, if my code is:

SELECT * my_table
it works perfect

but when i added the JOINs it doesnt work.

[kev1n]

I created a simple SQL with a JOIN:

sql.png

and I'm still able to select the fields. Or do you mean something else?

designer.png

[Ricu]

This is what i mean.
But i found the problem... it seems u shouldnt have 2 columns with the same name in different tables... i modified one of them and now it works fine.
Thanks!

[kev1n]

This also applies to the Browse SQL. I usually do a SELECT * FROM (....) as a workaround.