HI all,Our company has just purchased a solution called Clarity (a task / time management suite) and I've been selection (I am so lucky) to be the "Custom Reports Guy" for the project.I've received documentation from Clarity and they use something called NSQL. Is that a sybase product? I've had a hard time finding much on the Web'The website www.nsql.com is the following helpfull text..."nsql.com nsql.com any information please contact info@nsql.comtesting by stephenCool?"Anyone got any experience with this -- could point me to a good resource?Here's some sample NSQL syntax....SELECT @select:dim:user_def:implied:TimeSheet:ts.PRID:ts_PRID@, @select:dim_prop:user_def:implied:TimeSheet:ts.PRTIMEPERIODID:ts_PRTIMEPERIODID@, @select:dim_prop:user_def:implied:TimeSheet:ts.PRRESOURCEID:ts_PRRESOURCEID@, @select:dim_prop:user_def:implied:TimeSheet:ts.PRSTATUS:ts_PRSTATUS@, @select:dim_prop:user_def:implied:TimeSheet:tsstatus.name:tsstatus@, @select:dim_prop:user_def:implied:TimeSheet:ts.PRVERSION:ts_PRVERSION@, @select:dim_prop:user_def:implied:TimeSheet:ts.PRSUBMITTEDBY:ts_PRSUBMITTEDBY@, @select:dim_prop:user_def:implied:TimeSheet:submit.full_name:SubmittedBy@, @select:dim_prop:user_def:implied:TimeSheet:ts.PRAPPROVEDBY:ts_PRAPPROVEDBY@, @select:dim_prop:user_def:implied:TimeSheet:approv.full_name:ApprovedBy@, @select:dim_prop:user_def:implied:TimeSheet:ts.PRISADJUSTMENT:ts_PRISADJUSTMENT@, @select:dim_prop:user_def:implied:TimeSheet:ts.PRADJUSTEDID:ts_PRADJUSTEDID@, @select:dim_prop:user_def:implied:TimeSheet:ts.PRMODBY:ts_PRMODBY@, @select:dim_prop:user_def:implied:TimeSheet:ts.PRMODTIME:ts_PRMODTIME@, @select:dim_prop:user_def:implied:TimeSheet:ts.POSTED_TIME:ts_POSTED_TIME@, @select:dim_prop:user_def:implied:TimeSheet:tp.prid:tp_prid@, @select:dim_prop:user_def:implied:TimeSheet:tp.prstart:tp_prstart@, @select:dim_prop:user_def:implied:TimeSheet:tp.prfinish - 1:tp_prfinishLessOne@, @select:dim_prop:user_def:implied:TimeSheet:entry.te_practsumsum / 3600:entry_te_practsumsum@, @select:dim_prop:user_def:implied:TimeSheet:sres.id:sres_id@, @select:dim_prop:user_def:implied:TimeSheet:sres.full_name:sres_full_name@, @select:dim_prop:user_def:implied:TimeSheet:presdept.departcode:dept_departcode@, @select:dim_prop:user_def:implied:TimeSheet:presdept.shortdesc:dept_shortdesc@, @select:dim_prop:user_def:implied:TimeSheet:rman.id:rman_id@, @select:dim_prop:user_def:implied:TimeSheet:rman.full_name:rman_full_name@FROM prtimesheet ts INNER JOIN cmn_lookups_v tsstatus ON ts.prstatus = tsstatus.lookup_enum INNER JOIN prtimeperiod tp ON ts.prtimeperiodid = tp.prid INNER JOIN (SELECT te.prtimesheetid te_prtimesheetid, SUM(te.practsum) te_practsumsum FROM prtimeentry te GROUP BY prtimesheetid) entry ON ts.prid = entry.te_prtimesheetid INNER JOIN srm_resources sres ON ts.prresourceid = sres.id LEFT JOIN srm_resources rman ON sres.manager_id = rman.user_id LEFT JOIN (SELECT pres.id pres_id, dept.departcode departcode, dept.shortdesc shortdesc FROM pac_mnt_resources pres LEFT JOIN departments dept ON pres.departcode = dept.departcode) presdept ON sres.id = presdept.pres_id LEFT JOIN srm_resources submit ON ts.PRSUBMITTEDBY = submit.user_id LEFT JOIN srm_resources approv
-------------Charlie
Anyone got experience with NSQL?
Posted - 2008-08-08 : 11:01:37
