I have the problem with the following FilterBuilder, that the sortField and the picklListCriteria settings are ignored. And the type ahead functionality of the SelectItem is missing.
Im noticed the issues in the nighly build 2010-November-07 - PowerEdition.
Regards
Chris
Im noticed the issues in the nighly build 2010-November-07 - PowerEdition.
Code:
filterBuilder.setTopOperatorAppearance(TopOperatorAppearance.NONE); filterBuilder.setShowSubClauseButton(false); filterBuilder.setDataSource(new SkillsetManagerFilterBuilderDS(49)); filterBuilder.setAllowEmpty(true); filterBuilder.setDisabled(true);
Code:
public SkillsetManagerFilterBuilderDS(String systemId) { DataSourceField skill skill.setName(Consts.F_SKILL); skill.setValidOperators(OperatorId.AND, OperatorId.OR, OperatorId.NOT, OperatorId.ICONTAINS, OperatorId.INOT_CONTAINS); skill.setLength(50); skill.setType(FieldType.TEXT); SelectItem skillSelectItem = new StyledSelectItem(); DataSource ds = DataSource.get(Consts.DS_SKM_FILTER_SKILL); skillSelectItem.setOptionDataSource(ds); skillSelectItem.setDisplayField(Consts.F_FULL_NAME); skillSelectItem.setValueField(Consts.F_FULL_NAME); skillSelectItem.setWidth("*"); skillSelectItem.setPickListWidth(250); skillSelectItem.setPickListCriteria(new Criteria( GeneratedFieldConsts.F_SK_SYM_ID, systemId)); skillSelectItem.setSortField(Consts.F_FULL_NAME); skill.setEditorType(skillSelectItem);
Code:
<DataSource ID="skm_filter_skill" serverType="sql" tableName="sdm$vi_web_skill" qualifyColumnNames="false" cacheAllData="true" cacheMaxAge="1800"> <fields> <field name="full_name" title="" type="text" required="false" primaryKey="true"></field> <field name="sk_sym_id" title="" type="integer" required="true"></field> </fields> <operationBindings> <operationBinding operationType="fetch" customValueFields="full_name, sk_sym_id" customCriteriaFields="full_name, sk_sym_id"> <tableClause>(select sk_name|| nvl2(skl_number,' - '||skl_number|| ' / ' || skl_name,'') as full_name, sk_id, sk_number,sk_name,sk_sym_id, skl_number, skl_name, sk_valid_from, sk_valid_to from sdm$vi_web_skill left join sdm$vi_web_skill_level_allowe on sk_id = sla_sk_id left join sdm$vi_web_skill_level on sla_skl_id = skl_id)</tableClause> <whereClause>trunc(sysdate) between sk_valid_from and sk_valid_to and ($defaultWhereClause)</whereClause> </operationBinding> </operationBindings> </DataSource>
Chris
Comment