Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

    Issue FilterBuilder

    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.


    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>
    Regards
    Chris

    #2
    Can you try this with a more recent nightly? You may have hit a temporary regression.

    Comment

    Working...
    X