bizdata设置树形展示的问题，在线等，急

jishuang

把语句发一下看看

chaierkid

jishuang 发表于 2015-3-19 16:03
把语句发一下看看

SELECT tabWBSItem.*,tabItemNotation.fWBSItemID as fWBSItemID,tabItemNotation.fNotationInfo as fNotationInfo,tabItemNotation.fNotationName as fNotationName,tabWBSItemState,tabWBSItemState.sProcessState as sProcessState,tabWBSItemState.sExamineState as sExamineState,tabWBSItemState.sAttentionLevel as sAttentionLevel,tabWBSItemState.sImportDegree as sImportDegree,tabWBSItem as tabWBSItem1,tabWBSItem.version as version,tabWBSItem.fItemName as fItemName,tabWBSItem.fInstruction as fInstruction,tabWBSItem.fMissionPrincipal as fMissionPrincipal,tabWBSItem.fMissionMinitor as fMissionMinitor,tabWBSItem.fExamineState as fExamineState,tabWBSItem.fStartDate as fStartDate,tabWBSItem.festimatedFinishDate as festimatedFinishDate,tabWBSItem.fEndDate as fEndDate,tabWBSItem.fProcessState as fProcessState,tabWBSItem.fProcessInstruction as fProcessInstruction,tabWBSItem.fCreateTime as fCreateTime,tabWBSItem.fEditTime as fEditTime,tabWBSItem.fIsDelete as fIsDelete,tabWBSItem.fIsShow as fIsShow,tabWBSItem.fState as fState,tabWBSItem.fDescription as fDescription,tabWBSItem.fParentNode as fParentNode,tabWBSItem.fChildNode as fChildNode,tabWBSItem.fNodeType as fNodeType,tabWBSItem.fLevel as fLevel,tabWBSItem.fExamineInfo as fExamineInfo,tabWBSItem.fAttentionLevel as fAttentionLevel,tabWBSItem.fImportDegree as fImportDegree,tabWBSItem.fNotationImage as fNotationImage,tabWBSItem.fCreateItemPerson as fCreateItemPerson,tabWBSItem.fUpdateField as fUpdateField,case when fExamineState + fProcessState = 8 then '已完成' when fStartDate is null AND festimatedFinishDate is null then '正常' when :currentDate() > festimatedFinishDate then '已过期' when fStartDate = festimatedFinishDate then '快过期' when ( ( getYear(festimatedFinishDate) - getYear(:currentDate()) ) * 365 + ( getMonth(festimatedFinishDate) - getMonth(:currentDate()) ) * 30 + ( getDay(festimatedFinishDate) - getDay(:currentDate()) ) ) * 1.0 / ( ( getYear(festimatedFinishDate) - getYear(fStartDate) ) * 365 + ( getMonth(festimatedFinishDate) - getMonth(fStartDate) ) * 30 + ( getDay(festimatedFinishDate) - getDay(fStartDate) ) ) <= 0.2 then '快过期' else '正常' end as fImage FROM tabWBSItem tabWBSItem optional join tabItemNotation tabItemNotation on tabItemNotation.fWBSItemID = tabWBSItem optional join tabWBSItemState tabWBSItemState on tabWBSItemState.fWBSItemId = tabWBSItem WHERE ( not tabWBSItem in ('_is_root_8090F41FCAB54BF19E8201CD0258A7D6') ) AND ((tabWBSItem.fIsDelete = 0 and tabWBSItem.fIsShow = 1) AND (fParentNode is null)) ORDER BY fCreateTime ASC

jishuang

如果要过滤的根不是最根级的节点，在root-filter中加上根节点的过滤 is not null看看

chaierkid

jishuang 发表于 2015-3-20 10:46
如果要过滤的根不是最根级的节点，在root-filter中加上根节点的过滤 is not null看看 ...

我就是要过滤跟节点的。。。。

chaierkid

jishuang 发表于 2015-3-20 10:46
如果要过滤的根不是最根级的节点，在root-filter中加上根节点的过滤 is not null看看 ...

我如果不过滤最根级的节点，就会出现下面的情况。。。。
图一是正确的，图二就没有跟项目了，直接从第二级开始显示了。。。。

jishuang

tabWBSItem.level=0这个写到data的filter，不写到root-filter，看看效果

chaierkid

jishuang 发表于 2015-3-20 13:30
tabWBSItem.level=0这个写到data的filter，不写到root-filter，看看效果

那就把其他级别的数据过滤了。。。。

jishuang

chaierkid 发表于 2015-3-20 13:36
那就把其他级别的数据过滤了。。。。

root-filter中的parnet is null的过滤还在过滤的就是根啊

chaierkid

jishuang 发表于 2015-3-20 13:56
root-filter中的parnet is null的过滤还在过滤的就是根啊

我也觉得加上fparentnode is null ，应该就是过滤跟了，但是同样把其他数据过滤了。。。。

chaierkid

jishuang 发表于 2015-3-20 13:56
root-filter中的parnet is null的过滤还在过滤的就是根啊

能远程帮我看一下么？813974450