search

frappe / insights

Open source analytics / business intelligence tool (BI)
https://frappe.io/insights
GNU Affero General Public License v3.0
408 stars 200 forks source link

Table not shown using Inner Join #129

Closed pinxaolives closed 1 year ago

pinxaolives commented 1 year ago

Description of the issue

Problem using inner joins. The SQL statement is:

SELECT t0.* FROM tabEscala TSO AS t0 INNER JOIN tabEscala De Jong Gierveld AS t1 ON t0.owner = t1.owner LIMIT 500

Left table is shown but the right table is not…

image

Context information (for bug reports)

Output of bench version Version 14

Steps to reproduce the issue

Expected result

Stacktrace / full error message No errors shown

Additional information OS: Ubuntu Edge

Frappe install method:

Frappe Cloud

nextchamp-saqib commented 1 year ago

This is a known issue. Ref. https://github.com/frappe/insights/issues/118#issuecomment-1554735565

The issue is with the SQL itself and not with the application

nextchamp-saqib commented 1 year ago

Currently it is the expected behavior so closing the issue