Filter only by onr coulmn (serial number)

  • Resolved sinaydavid

    (@sinaydavid)


    7 years, 9 months ago

    Hello
    I using your great plugin(!!)
    i need to show the user results based on only one filter value(the product serial number).
    I have installed the database-invert-filter and passed my page slug name on line 22 like you
    said and on the shourtcode i am passing like so:

    ‘[table id=1/]
    [table_filter id=1 filter_columns=1 /]’

    what am i missing?
    please advise 🙂
    thanks!
    David

    https://wordpress.org/plugins/tablepress/

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    7 years, 9 months ago

    Hi David,

    thanks for your question, and sorry for the trouble.

    With the DataTables Inverted Filtering Extension, [table id=1/] is the correct Shortcode. The other one is for different Extensions.

    What exactly is not working? Can you please post a link to the page with the table where this problem happens, so that I can take a direct look? Thanks!

    Regards,
    Tobias

    Thread Starter sinaydavid

    (@sinaydavid)

    7 years, 9 months ago

    Hi! no trouble 🙂
    Thanks for the fast replay!
    here is the link:
    http://b-d-v.co.il/%D7%9E%D7%97%D7%99%D7%A8%D7%95%D7%9F/
    i am trying to allow the user to find records based on ONLY one filter, the Product iD filter.
    in the link its called in hebrew מק״ט
    i don’t want the users to search by product name or price or any other column but the productID.
    plus i would like to show them results only after they have the right productid not before and not something smiler. is that possible with your plugin?
    For Exp. try to find the following product id : JC2D3172 in the search box.
    thanks
    David

    Plugin Author TobiasBg

    (@tobiasbg)

    7 years, 9 months ago

    Hi David,

    you can then prevent filtering in the other columns, with this “Custom Command” on the “Edit” screen:

    "columnDefs": [ { "searchable": false, "targets": [ 1, 2, 3, 4 ] } ]

    This turns of searching the second through fifth column (counting starts with 0 in the code).

    Regards,
    Tobias

    Thread Starter sinaydavid

    (@sinaydavid)

    7 years, 9 months ago

    that works great!!
    thank!
    any idea with the secound issue?
    i would like to show them results only after they have the RIGHT productid (whole number) not before and not something smiler. is that possible with your plugin?
    thanks again!
    David

    Plugin Author TobiasBg

    (@tobiasbg)

    7 years, 9 months ago

    Hi David,

    sorry, I’m not aware of a direct solution for that 🙁
    You could maybe try and modify the JS code in the DataTables Inverted Filtering Extension and add another check for the length of the search term.

    Also note that there is no absolute protection. If a user turns off JavaScript in his browser or uses “View Source” he will be able to see the full table.

    Regards,
    Tobias

    Thread Starter sinaydavid

    (@sinaydavid)

    7 years, 9 months ago

    Hi Tobias
    Thanks for all the help and the great plugin!
    David

    Plugin Author TobiasBg

    (@tobiasbg)

    7 years, 9 months ago

    Hi,

    no problem, you are very welcome! 🙂 Good to hear that this helped!

    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 ‘Filter only by onr coulmn (serial number)’ is closed to new replies.

Tags