knireis

I understand now, search is only enabled for another field so it wont find it with the search i did

thanks for the support

How ddo I get rid of the AND?

The docs say to use pipe symbol for OR

in the above i searched in the filterd list for ‘jan’ , there are a few items presented but not the record which has ‘LidvanVerdienste” selected

then i searched for ‘krikke’ , no results but there should have been one because ‘krikke’ has “Erelid” selected

I did the logging, but no clue where to look for in it:


PDb_List_Query::_restore_query_session getting session: list_query-1 got: Array
(
? [0] =>
? [where_clauses] => Array
?? (
????[status] => Array
????? (
?????? [0] => PDb_List_Query_Filter Object
????????(
????????? [fieldname:PDb_List_Query_Filter:private] => status
????????? [sql:PDb_List_Query_Filter:private] => p.status LIKE "%Erelid%"
????????? [or_statement:PDb_List_Query_Filter:private] => 1
????????? [term] => Erelid
????????? [index:PDb_List_Query_Filter:private] => 0
????????? [background:PDb_List_Query_Filter:private] => 1
????????? [like_term] =>
????????? [is_regex] =>
????????? [or_parenthesized:PDb_List_Query_Filter:private] => 1
????????)

?????? [1] => PDb_List_Query_Filter Object
????????(
????????? [fieldname:PDb_List_Query_Filter:private] => status
????????? [sql:PDb_List_Query_Filter:private] => p.status LIKE "%LidvanVerdienste%"
????????? [or_statement:PDb_List_Query_Filter:private] => 1
????????? [term] => LidvanVerdienste
????????? [index:PDb_List_Query_Filter:private] => 1
????????? [background:PDb_List_Query_Filter:private] => 1
????????? [like_term] =>
????????? [is_regex] =>
????????? [or_parenthesized:PDb_List_Query_Filter:private] => 1
????????)

?????? [2] => PDb_List_Query_Filter Object
????????(
????????? [fieldname:PDb_List_Query_Filter:private] => status
????????? [sql:PDb_List_Query_Filter:private] => p.status LIKE "%Lid%"
????????? [or_statement:PDb_List_Query_Filter:private] =>
????????? [term] => Lid
????????? [index:PDb_List_Query_Filter:private] => 2
????????? [background:PDb_List_Query_Filter:private] => 1
????????? [like_term] =>
????????? [is_regex] =>
????????? [or_parenthesized:PDb_List_Query_Filter:private] => 1
????????)

????? )

????[geb_datum] => Array
????? (
?????? [0] => PDb_List_Query_Filter Object
????????(
????????? [fieldname:PDb_List_Query_Filter:private] => geb_datum
????????? [sql:PDb_List_Query_Filter:private] => p.geb_datum LIKE "%jan%"
????????? [or_statement:PDb_List_Query_Filter:private] => 1
????????? [term] => jan
????????? [index:PDb_List_Query_Filter:private] => 3
????????? [background:PDb_List_Query_Filter:private] =>
????????? [like_term] =>
????????? [is_regex] =>
????????? [or_parenthesized:PDb_List_Query_Filter:private] => 1
????????)

????? )

?? )

? [sort] => Array
?? (
????[geb_datum] => Array
????? (
?????? [field] => geb_datum
?????? [ascdesc] => ASC
????? )

?? )

? [clause_count] => 4
? [is_search] => 1
)
[11/06/24 6:00pm UTC]PDb_List::_setup_iteration list query: SELECT p.id, p.first_name, p.last_name, p.geb_datum, p.address, p.zip, p.city FROM wp_participants_database p WHERE (p.status LIKE "%Erelid%" OR p.status LIKE "%LidvanVerdienste%" OR p.status LIKE "%Lid%") AND (p.geb_datum LIKE "%jan%") ORDER BY p.geb_datum ASC[11/06/24 6:00pm UTC]Cannot modify header information - headers already sentin /home/hhkhil8456/domains/hhkhillegom.nl/public_html/wp-content/plugins/litespeed-cache/src/optimize.cls.php on line 657[11/06/24 6:00pm UTC]PDb_List_Query::_restore_query_session getting session: list_query-1 got: Array
(
? [0] =>
? [where_clauses] => Array
?? (
????[status] => Array
????? (
?????? [0] => PDb_List_Query_Filter Object
????????(
????????? [fieldname:PDb_List_Query_Filter:private] => status
????????? [sql:PDb_List_Query_Filter:private] => p.status LIKE "%Erelid%"
????????? [or_statement:PDb_List_Query_Filter:private] => 1
????????? [term] => Erelid
????????? [index:PDb_List_Query_Filter:private] => 0
????????? [background:PDb_List_Query_Filter:private] => 1
????????? [like_term] =>
????????? [is_regex] =>
????????? [or_parenthesized:PDb_List_Query_Filter:private] => 1
????????)

?????? [1] => PDb_List_Query_Filter Object
????????(
????????? [fieldname:PDb_List_Query_Filter:private] => status
????????? [sql:PDb_List_Query_Filter:private] => p.status LIKE "%LidvanVerdienste%"
????????? [or_statement:PDb_List_Query_Filter:private] => 1
????????? [term] => LidvanVerdienste
????????? [index:PDb_List_Query_Filter:private] => 1
????????? [background:PDb_List_Query_Filter:private] => 1
????????? [like_term] =>
????????? [is_regex] =>
????????? [or_parenthesized:PDb_List_Query_Filter:private] => 1
????????)

?????? [2] => PDb_List_Query_Filter Object
????????(
????????? [fieldname:PDb_List_Query_Filter:private] => status
????????? [sql:PDb_List_Query_Filter:private] => p.status LIKE "%Lid%"
????????? [or_statement:PDb_List_Query_Filter:private] =>
????????? [term] => Lid
????????? [index:PDb_List_Query_Filter:private] => 2
????????? [background:PDb_List_Query_Filter:private] => 1
????????? [like_term] =>
????????? [is_regex] =>
????????? [or_parenthesized:PDb_List_Query_Filter:private] => 1
????????)

????? )

????[geb_datum] => Array
????? (
?????? [0] => PDb_List_Query_Filter Object
????????(
????????? [fieldname:PDb_List_Query_Filter:private] => geb_datum
????????? [sql:PDb_List_Query_Filter:private] => p.geb_datum LIKE "%krikke%"
????????? [or_statement:PDb_List_Query_Filter:private] => 1
????????? [term] => krikke
????????? [index:PDb_List_Query_Filter:private] => 3
????????? [background:PDb_List_Query_Filter:private] =>
????????? [like_term] =>
????????? [is_regex] =>
????????? [or_parenthesized:PDb_List_Query_Filter:private] => 1
????????)

????? )

?? )

? [sort] => Array
?? (
????[geb_datum] => Array
????? (
?????? [field] => geb_datum
?????? [ascdesc] => ASC
????? )

?? )

? [clause_count] => 4
? [is_search] => 1
)
[11/06/24 6:00pm UTC]PDb_List::_setup_iteration list query: SELECT p.id, p.first_name, p.last_name, p.geb_datum, p.address, p.zip, p.city FROM wp_participants_database p WHERE (p.status LIKE "%Erelid%" OR p.status LIKE "%LidvanVerdienste%" OR p.status LIKE "%Lid%") AND (p.geb_datum LIKE "%krikke%") ORDER BY p.geb_datum ASC

thanks, i changed the shortcode to filter=”status~Lid|status~Erelid|status~LidvanVerdienste”

however it does not show all records i would expect

I looked in the database with phpmyadmin and here are 2 records of the status field


a:1:{i:0;s:16:"LidvanVerdienste";}

a:1:{i:0;s:3:"Lid";}

the records with “Lid” are included, but with status “LidvanVerdienste” and “Erelid” are not.
How can i get these records included in the filter?

I changed strict date setting to ‘on’ . And now i get output. But us in english so i can not use that.

I switched to the string combine field type and now i get the output in localized language. So i can use that for a search field.

Hi, thanks for your efforts to help, but i can not get this to work.

So i gave up on the idea of the dynamic list. If i can filter on birthday month that should be at least something to work with.

So i set up a datecalculation field and entered [birthday]=[?day_month] in the template field. “birthday” is the name of the datefield.
However when i create a shortcode to display a list with names and the datecalculation field, the datecalculation field remains empty.

Sorry, i have not been able to figure out what to do with this code. I changed ‘birthday’ in the name of the databasefield i use ‘geboortedatum’ , then i copied the code in codesnippets plugin to see what happens. But it immediately gave a critical error on my site. With phpmyadmin i removed the snippet again.

Can you explain how to use the code you provided?

Same issue here, i started to receive spam. Both free and pro version.

I think there was an update a few days ago, which might have broken some of the functionality.

Same here.

I work with price increase and lost some money today…. (i know i should have checked better)

• This reply was modified 2 years, 10 months ago by knireis.

Perfect! Thanks

Yes of course, https://staging.mr-nishikigoi.com/checkout/

you can add a product to the cart even if the price is hidden

Maybe last question.
I managed to filter all members born in june.
Now is it possible to sort them only based on the date, not the year?

Got it, thanks

can you be a bit more detailed please?
Do i need to setup a new field and define it as stringcombine field?