标志动作定义排序的时候如何根据个别字段中的几位进行...

dr琅琊人

如题，标志动作定义排序的时候如何根据个别字段中的几位进行排序，如下SQL语句
select HX_ProjectApply.*  from HX_ProjectApply HX_ProjectApply  order by left(right(HX_ProjectApply.fContractNo,9),4) + right(HX_ProjectApply.fContractNo,3) asc



用KSQL改写的时候该如何改写 order by 部分？

select HX_ProjectApply.*  from HX_ProjectApply HX_ProjectApply  order by SQL.left(SQL.right(HX_ProjectApply.fContractNo,9),4) + SQL.right(HX_ProjectApply.fContractNo,3) asc 是报错的！！！！

jishuang

KSQL中可以用SQL.调用数据库本地函数实现

dr琅琊人

jishuang 发表于 2017-4-18 16:51
KSQL中可以用SQL.调用数据库本地函数实现

但是上面哪边错了？

jishuang

报错发具体的错误信息啊

dr琅琊人

jishuang 发表于 2017-4-18 17:13
报错发具体的错误信息啊

[ERROR] check error! [com.justep.design.model.ksql.Utils 2017-04-18 17:13:33]
com.justep.design.model.ksql.KSQLException: 未结束的KSQL表达式,当前位置为：960, 当前符号为：(
        at com.justep.design.model.ksql.Utils.check(Unknown Source)
        at com.justep.design.model.ksql.KSQLParser.start(Unknown Source)
        at com.justep.design.model.ksql.KSQLParser.parse(Unknown Source)
        at com.justep.studio.ui.commonpanel.kql.KSQLUtils.string2Obj(Unknown Source)
        at com.justep.studio.ui.commonpanel.kql.KSQLMainDialog.createDialogArea(Unknown Source)
        at org.eclipse.jface.dialogs.Dialog.createContents(Dialog.java:760)
        at org.eclipse.jface.window.Window.create(Window.java:431)
        at org.eclipse.jface.dialogs.Dialog.create(Dialog.java:1089)
        at org.eclipse.jface.window.Window.open(Window.java:790)
        at com.justep.studio.ui.editors.action.ActionParamValueEditorManager.openKSQLDlg(Unknown Source)
        at com.justep.studio.ui.editors.action.ActionParamValueEditorManager.openDlg(Unknown Source)
        at com.justep.studio.ui.editors.action.ActionDetailPanel$22.openDialog(Unknown Source)
        at com.justep.studio.ui.exjface.ComboDialogCellEditor$5.widgetSelected(Unknown Source)
        at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)
        at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
        at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)
        at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4169)
        at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3758)
        at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1053)
        at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
        at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:942)
        at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:86)
        at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:588)
        at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
        at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:543)
        at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
        at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:124)
        at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
        at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
        at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:353)
        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:180)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:629)
        at org.eclipse.equinox.launcher.Main.basicRun(Main.java:584)
        at org.eclipse.equinox.launcher.Main.run(Main.java:1438)



语句如下：
select SQL.newid() as fID,HX_ProjectApply.fContractNo as fContractNo,HX_ProjectApply.fCustomName as fCustomName,HX_ProjectApply.fDuration as fDuration,HX_ProjectApply.fHireDate as fHireDate,HX_ProjectApply.fConHireDate as fConHireDate,SQL.isnull(HX_ProjectApply.fFirstPayment, 0) as fFirstPayment,SQL.isnull(HX_ProjectApply.fContactValue, 0) as fContactValue,SQL.isnull((select  SQL.sum(HX_LendInfo.fLendPrice) as lendprice from HX_LendInfo HX_LendInfo  where HX_LendInfo.fProjectID = HX_ProjectApply), 0) as lendprice,SQL.isnull((select  SQL.sum(HX_YJXJL.fZLFSQ) as zlf from HX_YJXJL HX_YJXJL  where HX_YJXJL.fLXID = HX_ProjectApply), 0) as zlf,SQL.isnull((select  SQL.sum(HX_YJXJL.fZLFSQ) as sqzlf from HX_YJXJL HX_YJXJL  where  HX_YJXJL.fLXID = HX_ProjectApply AND HX_YJXJL.fQC = '1' ), 0) as sqzlf
    from HX_ProjectApply HX_ProjectApply
    where SQL.isnull(HX_ProjectApply.fFlag, '0') = '1' AND SQL.isnull(HX_ProjectApply.fEndFlag, '0') = '0' order by SQL.left(SQL.right(HX_ProjectApply.fContractNo,9),4) + SQL.right(HX_ProjectApply.fContractNo,3) asc

dr琅琊人

jishuang 发表于 2017-4-18 17:13
报错发具体的错误信息啊

我试了下 连简单的两个字段相加的排序都不支持

jishuang

发的错误是设计器的错误吧，设计的错误不用看，设计器可能不支持，看看运行是否正确