Hi,
I have a query with 2 sub queries. It's work fine. I made a grid using this query and I can see the data. I want to embed this grid on a dialog and link it, but the dialog does not recognize the columns. With this query I can't make a view because contains a sub query in from clause. what is the solution?
The query is:
SELECT Valoare, Grupa, IdDevizObiect, IdDevizDet, ord, categorii_lucrari_reabilitare_termica.Denumire FROM (
SELECT Valoare, Grupa, IdDevizObiect, IdDevizDet,
CASE
WHEN Grupa = '101' then 1
WHEN Grupa = '100' then 2
WHEN Grupa = '011' then 3
WHEN Grupa = '010' then 4
WHEN Grupa = '001' then 5
END AS ord
FROM (
SELECT
SUM(tdeviz_reabilitari_termice.Valoare_RON_FARA_TVA_3) AS Valoare,
tdeviz_obiect.IdDevizObiect,
tdeviz_obiect.IdDevizDet,
CONCAT(CONCAT(EligibilPentruSpatiiLocuit, NeeligibilPentruSpatiiLocuit),NeeligibilPentruSpatiiAltaDestinatie) AS Grupa
FROM tdeviz_reabilitari_termice
INNER JOIN tdeviz_obiect
ON tdeviz_obiect.IdDevizObiect = tdeviz_reabilitari_termice.IdDevizObiect AND tdeviz_obiect.LogicalDelete = 0
WHERE tdeviz_reabilitari_termice.LogicalDelete = 0
GROUP BY EligibilPentruSpatiiLocuit, NeeligibilPentruSpatiiLocuit, NeeligibilPentruSpatiiAltaDestinatie) AS T1) AS T2
left outer join categorii_lucrari_reabilitare_termica on categorii_lucrari_reabilitare_termica.IdCategorie = T2.ord AND categorii_lucrari_reabilitare_termica.LogicalDelete = 0
ORDER BY ord
Thanks.
I have a query with 2 sub queries. It's work fine. I made a grid using this query and I can see the data. I want to embed this grid on a dialog and link it, but the dialog does not recognize the columns. With this query I can't make a view because contains a sub query in from clause. what is the solution?
The query is:
SELECT Valoare, Grupa, IdDevizObiect, IdDevizDet, ord, categorii_lucrari_reabilitare_termica.Denumire FROM (
SELECT Valoare, Grupa, IdDevizObiect, IdDevizDet,
CASE
WHEN Grupa = '101' then 1
WHEN Grupa = '100' then 2
WHEN Grupa = '011' then 3
WHEN Grupa = '010' then 4
WHEN Grupa = '001' then 5
END AS ord
FROM (
SELECT
SUM(tdeviz_reabilitari_termice.Valoare_RON_FARA_TVA_3) AS Valoare,
tdeviz_obiect.IdDevizObiect,
tdeviz_obiect.IdDevizDet,
CONCAT(CONCAT(EligibilPentruSpatiiLocuit, NeeligibilPentruSpatiiLocuit),NeeligibilPentruSpatiiAltaDestinatie) AS Grupa
FROM tdeviz_reabilitari_termice
INNER JOIN tdeviz_obiect
ON tdeviz_obiect.IdDevizObiect = tdeviz_reabilitari_termice.IdDevizObiect AND tdeviz_obiect.LogicalDelete = 0
WHERE tdeviz_reabilitari_termice.LogicalDelete = 0
GROUP BY EligibilPentruSpatiiLocuit, NeeligibilPentruSpatiiLocuit, NeeligibilPentruSpatiiAltaDestinatie) AS T1) AS T2
left outer join categorii_lucrari_reabilitare_termica on categorii_lucrari_reabilitare_termica.IdCategorie = T2.ord AND categorii_lucrari_reabilitare_termica.LogicalDelete = 0
ORDER BY ord
Thanks.
Comment