|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss SalesLogix legacy development including views, scripts, etc.. View the code of conduct for posting guidelines.
|
|
|
|
Legacy: Grid : dynamically set SQL to Grid
Posted: 15 Nov 07 3:33 AM
|
I want to set grid sql on runtime,
coz i need to group some fields and reterive max field value.
this is modified sql
SELECT distinct A1.PRODUCTID, A1.ACTUALID, A2.SHORTDESCRIPTION A2_SHORTDESCRIPTION,A3.PRICE A3_PRICE
, A3.CURRENCY A3_CURRENCY, A2.LANG A2_LANG
FROM sysdba.PRODUCT A1
INNER JOIN (select productid,max(price)price,currency from sysdba.c_productprice group by productid,currency) A3 ON (A1.PRODUCTID=A3.PRODUCTID)
INNER JOIN sysdba.C_PRODUCT A2 ON (A1.PRODUCTID=A2.PRODUCTID)
WHERE (A2.LANG='e') AND (A3.CURRENCY='chf')
----
this is orginal sql
SELECT DISTINCT A1.PRODUCTID, A1.ACTUALID, A2.SHORTDESCRIPTION A2_SHORTDESCRIPTION, A3.PRICE A3_PRICE
, A3.CURRENCY A3_CURRENCY, A2.LANG A2_LANG
FROM sysdba.PRODUCT A1
INNER JOIN sysdba.C_PRODUCTPRICE A3 ON (A1.PRODUCTID=A3.PRODUCTID)
INNER JOIN sysdba.C_PRODUCT A2 ON (A1.PRODUCTID=A2.PRODUCTID)
WHERE (A2.LANG='e') AND (A3.CURRENCY='chf')
---
i hope somebody help me! |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|