jQWidgets Forums

jQuery UI Widgets Forums Grid Filters on Mapped columns

This topic contains 1 reply, has 1 voice, and was last updated by  bjpetal 7 years, 7 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • Filters on Mapped columns #97543

    bjpetal
    Participant

    I am using a few local data sources as basically “lookup” sources. When retrieving my json for my main grid, I retrieve integer IDs, and then map them to descriptions/names from my lookup sources. This works great, because I don’t have to send those long descriptions “over the wire”, and can just map the ids.

    The problem I am running into with these is filtering with an initial filter. I am using a filterrow, and the column in question is a checkedlist. There are two problems:

    #1 – The filter is initially applied correctly, but the item is not checked in the filterrow dropDownList. This happens where the column is mapped or not. Not a dealbreaker, but would be nice to know if there is a resolution.

    #2 – When I try to change the filter on this column, my initial filter stays, and I can’t filter correctly. In the example, try to change the filter to “Select All”. Nothing happens. If you select a different item, it will show nothing as it seems to be chaining the filters with AND. This only happens with a mapped column.

    Is there a different way I should be setting up or applying the filter here?

    https://jsfiddle.net/UbK74/1386/

    Filters on Mapped columns #97579

    bjpetal
    Participant

    Figured it out – You have to apply the filter by the description/name, and on the description/name column. Not by the numeric ID. Both issues resolved.

    https://jsfiddle.net/UbK74/1387/

    Thanks!

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.