Escape Single Quotes in Filter?

  • Resolved gmex1292

    (@gmex1292)


    6 years, 2 months ago

    I have a filter applied to the pbd_list short code, but I can’t seem to figure out how to get results for names that contain a single quote.

    Tried these combinations with no luck:

    [pdb_list filter=”entity_type=thing&company_name=Some Name|company_name=O’Reilly Books”]
    [pdb_list filter=”entity_type=thing&company_name=Some Name|company_name=O\’Reilly Books”]

    This works great:
    [pdb_list filter=”entity_type=thing&company_name=Some Name|company_name=Any Other Name”]

    Any other name with an “OR” clause works, except with names with a single quote.

    What am I doing wrong?

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author xnau webdesign

    (@xnau)

    This normally works fine. Is it possible the apostrophe in the database record is actually a single curly quote?

    Thread Starter gmex1292

    (@gmex1292)

    I have it working now with the single quotes. I think it was actually an ampersand “&” that was causing the problem.

    I’ve tried the filter below and it’s doesn’t work

    [pdb_list filter=”entity_type=thing&company_name=Rusty|company_name=Ward|company_name=Jack \& Jill|company_name=O\’Reilly Books””]

    If I take out the Jack & Jill the query works fine. Sorry for the first wuestion but have the same issue with the AMP?

    Thread Starter gmex1292

    (@gmex1292)

    I think figured it out. If I add one more backslash it now works:

    [pdb_list filter=”entity_type=thing&company_name=Rusty|company_name=Ward|company_name=Jack \\& Jill|company_name=O\’Reilly Books”]

    Plugin Author xnau webdesign

    (@xnau)

    That’s great…thanks for sharing, I think I need to add that to the documentation.

    Thread Starter gmex1292

    (@gmex1292)

    Thank you so much for an excellent plugin and support!

    Thread Starter gmex1292

    (@gmex1292)

    Fixed

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Escape Single Quotes in Filter?’ is closed to new replies.