Advanced search options

  • Resolved geeby

    (@geeby)


    6 years, 12 months ago

    Hi Tobias,
    I have a large table of 400+ rows. I was wondering, is it possible to allow sorting of selected (not all) columns?
    Also, I would like to be able to place a radio button or dropdown above to select a weightclass, rather than the user input it, potentially incorrectly. Is this possible?

    Finally, I’d like to create links to fighter names with an alphabet type option.
    A B C D….Z all in a line. User selects the letter of the surname (primary field) and it either drops them in the middle of the table, where that letter begins, or shows it like search results where only names of that letter are displayed.

    Hope this makes sense.
    Any help would be greatly appreciated. Have spent hours looking into it so far

    The page I need help with: [log in to see the link]

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your question, and sorry for the trouble.

    Yes, this should be possibe. To turn off sorting for certain columns, you could add something like this to the “Custom Commands” text field on the table’s “Edit” screen:

    "columnDefs": [ { "orderable": false, "targets": [ 0, 2 ] } ]

    This would turn off sorting for the first and third column (counting starts with 0).

    For the dropdowns, you could use the TablePress Extension from https://tablepress.org/extensions/datatables-columnfilterwidgets/

    For the ABC search, you can try https://tablepress.org/downloads/extensions/tablepress-datatables-alphabetsearch.zip

    Regards,
    Tobias

    Thread Starter geeby

    (@geeby)

    Hi Tobias,
    Thanks for your reply.
    I got all 3 requests to work separately but had some issues. I would like the ABC search and drop down on the same table, if possible. I can only seem to get one or the other, not together.

    Also, how do I get the ABC search to work off of the 2nd column? I believe it is working off the 1st (which is a photo) so all are shown under ‘none’

    Finally, I van’t work out what changed the font on the table. Any idea how to revert back to the themes font?

    Many thanks!

    p.s This page is down https://tablepress.org/extensions/datatables-alphabetsearch/

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    first the font: This has changed due to copy/pasting. You copied an HTML <pre> element as well. To see that, please switch from the “Visual” to the “Text” editor on the “Edit” screen of your page. Then, remove all the extra HTML around the Shortcode.

    For the features: Indeed, the Alphabet Search works on the first column. Unfortunately, I have no idea how to change that ?? Your best chance might be to copy your name column (so that it is also the first column) but then hide it via CSS, like

    .tablepress-id-123 .column-1 {
  display: none;
}

    For using both Extensions at the same time: Please add

    "dom": "WAlfrtip"

    to the “Custom Commands” textfield on the table’s “Edit” screen. The W and A are the elements that the Extensions add.

    Regards,
    Tobias

    Thread Starter geeby

    (@geeby)

    thanks again, I’m 99% happy now. I cannot work out how to include both these in the custom commands though. Is it possible?
    1) “columnDefs”: [ { “orderable”: false, “targets”: [ 0, 2 ] } ]
    2) “dom”: “WAlfrtip”

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    just combine them with a comma:

    "columnDefs": [ { "orderable": false, "targets": [ 0, 2 ] } ], "dom": "WAlfrtip"

    Regards,
    Tobias

    Thread Starter geeby

    (@geeby)

    thanks so much

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    sure, no problem! ??

    Best wishes,
    Tobias

    P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Advanced search options’ is closed to new replies.