Error ADD DASHLET

[gcipolletti]

Ho creato un report solo di righe e colonne, senza grafico.
Quando provo ad importarlo nel modulo dashBoard come add dashlet mi da il seguente errore:

Error executing query Query Failed:SELECT FROM quotes INNER JOIN team_memberships team_memberships ON quotes.team_id = team_memberships.team_id AND team_memberships.user_id = 'c1113c0b-c8b0-8efc-dbaa-47c806e86139' AND team_memberships.deleted=0 INNER JOIN quotes_accounts l0_l ON quotes.id=l0_l.quote_id AND l0_l.deleted=0 AND l0_l.account_role='Bill To' INNER JOIN accounts l0 ON l0.id=l0_l.account_id AND l0.deleted=0 INNER JOIN team_memberships team_membershipsl0 ON l0.team_id = team_membershipsl0.team_id AND team_membershipsl0.user_id = 'c1113c0b-c8b0-8efc-dbaa-47c806e86139' AND team_membershipsl0.deleted=0 LEFT JOIN quotes_cstm quotes_cstm ON quotes.id = quotes_cstm.id_c WHERE (quotes.original_po_date>='2008-01-01 00:00:00' AND quotes.original_po_date<='2008-12-31 23:59:59' AND quotes_cstm.redatta_da_c LIKE 'Alessia Verticchio%' AND quotes_cstm.quote_type_cstm_c='Order' ) AND quotes.deleted=0 ::MySQL error 1064:

Qualcuno sa aiutarmi?

Grazie in anticipo

[DragonflyMaster]

Ho creato un report solo di righe e colonne, senza grafico.
Quando provo ad importarlo nel modulo dashBoard come add dashlet mi da il seguente errore:

Error executing query Query Failed:SELECT FROM quotes INNER JOIN team_memberships team_memberships ON quotes.team_id = team_memberships.team_id AND team_memberships.user_id = 'c1113c0b-c8b0-8efc-dbaa-47c806e86139' AND team_memberships.deleted=0 INNER JOIN quotes_accounts l0_l ON quotes.id=l0_l.quote_id AND l0_l.deleted=0 AND l0_l.account_role='Bill To' INNER JOIN accounts l0 ON l0.id=l0_l.account_id AND l0.deleted=0 INNER JOIN team_memberships team_membershipsl0 ON l0.team_id = team_membershipsl0.team_id AND team_membershipsl0.user_id = 'c1113c0b-c8b0-8efc-dbaa-47c806e86139' AND team_membershipsl0.deleted=0 LEFT JOIN quotes_cstm quotes_cstm ON quotes.id = quotes_cstm.id_c WHERE (quotes.original_po_date>='2008-01-01 00:00:00' AND quotes.original_po_date<='2008-12-31 23:59:59' AND quotes_cstm.redatta_da_c LIKE 'Alessia Verticchio%' AND quotes_cstm.quote_type_cstm_c='Order' ) AND quotes.deleted=0 ::MySQL error 1064:

Qualcuno sa aiutarmi?

Grazie in anticipo

Ciao,
pare che ci sia un errore nella query SQL.
Prova a sostituire la query con questa:

SELECT FROM quotes
	   INNER JOIN team_memberships team_memberships
					   ON quotes.team_id = team_memberships.team_id
	   INNER JOIN quotes_accounts l0_l
					   ON quotes.id=l0_l.quote_id
	   INNER JOIN accounts l0
					   ON l0.id=l0_l.account_id
	   INNER JOIN team_memberships team_membershipsl0
					   ON l0.team_id = team_membershipsl0.team_id
	   LEFT JOIN quotes_cstm quotes_cstm
					   ON quotes.id = quotes_cstm.id_c
	   WHERE (quotes.original_po_date>='2008-01-01 00:00:00'
	   AND quotes.original_po_date<='2008-12-31 23:59:59'
	   AND quotes_cstm.redatta_da_c LIKE 'Alessia Verticchio%'
	   AND quotes_cstm.quote_type_cstm_c='Order')
	   AND quotes.deleted=0
	   AND team_memberships.user_id = 'c1113c0b-c8b0-8efc-dbaa-47c806e86139'
	   AND team_memberships.deleted=0
	   AND l0_l.deleted=0
	   AND l0_l.account_role='Bill To'
	   AND l0.deleted=0
	   AND team_membershipsl0.user_id = 'c1113c0b-c8b0-8efc-dbaa-47c806e86139'
	   AND team_membershipsl0.deleted=0

Fammi sapere se così funziona!

[gcipolletti]

Ciao!
Grazie per il consiglio......ma avrei un piccolo problema a metterlo in pratica
Come si fa a modificare la query?

[DragonflyMaster]

Ciao!
Grazie per il consiglio......ma avrei un piccolo problema a metterlo in pratica
Come si fa a modificare la query?

Mi spiace, ma io uso Sugar 5.0.0b CE, che non ha il modulo reports, quindi non ti saprei dire con esattezza dove puoi andare a modificare la query.
Di sicuro so che la query SQL che hai postato andava in errore.