Support

Home Forums Event Espresso Premium Need to get the upcoming events and exclude all the events from private category

Need to get the upcoming events and exclude all the events from private category

Posted: May 13, 2020 at 2:48 pm


RMK

May 13, 2020 at 2:48 pm

Hi
I need to fetch all the upcoming events from all the categories except 1 named “private” -> ID(574)

here is the code I am using and able to get the upcoming events but unable to filter it from Private category
$events = EEM_Event::instance()->get_all(
array(
‘limit’ => 10,
‘QST_wp_user’ => array(‘in’, array(4)),
‘order_by’ => array( ‘Datetime.DTT_EVT_start’ => ‘ASC’ ),
‘group_by’ => ‘EVT_ID’,
array(
‘Datetime.DTT_EVT_end’ => array( ‘>=’, current_time(‘mysql’) ),
‘status’ => ‘publish’,
)
)
);

Can someone please take a look

Thanks


RMK

May 13, 2020 at 2:49 pm

Hi
I need to fetch all the upcoming events from all the categories except 1 named “private” -> ID(574)

here is the code I am using and able to get the upcoming events but unable to filter it from Private category
$events = EEM_Event::instance()->get_all(
array(
‘limit’ => 10,
‘QST_wp_user’ => array(‘in’, array(4)),
‘order_by’ => array( ‘Datetime.DTT_EVT_start’ => ‘ASC’ ),
‘group_by’ => ‘EVT_ID’,
array(
‘Datetime.DTT_EVT_end’ => array( ‘>=’, current_time(‘mysql’) ),
‘status’ => ‘publish’,
)
)
);

Can someone please take a look

Thanks


Tony

  • Support Staff

May 14, 2020 at 7:45 am

Hi there,

Are you sure that is the correct code you are currently using? It isn’t valid and will throw a fatal error due to this:

'QST_wp_user' => array('in', array(4)),

QST_wp_user is not a valid query param on EEM_Event.

But, to answer your question you would add this to your where conditions:

'Term_Taxonomy.Term.term_id' => array( 'NOT_IN', array(574) )

You must be logged in to reply to this support post. Sign In or Register for an Account

Support forum for Event Espresso 3 and Event Espresso 4.
Documentation for EE3 and EE4
Documentation for Event Espresso 3 Documentation for Event Espresso 4

Status: publish

Updated by  Tony 5 months, 2 weeks ago ago

Topic Tags

Notifications

This topic is: not resolved
Do NOT follow this link or you will be banned from the site!
[gravityform id=80 title=false description=false ajax=false]
<div class='gf_browser_unknown gform_wrapper' id='gform_wrapper_80' ><form method='post' enctype='multipart/form-data' id='gform_80' action='/topic/need-to-get-the-upcoming-events-and-exclude-all-the-events-from-private-category/'> <div class='gform_body'><ul id='gform_fields_80' class='gform_fields top_label form_sublabel_below description_below'><li id='field_80_1' class='gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible' ><label class='gfield_label' for='input_80_1' >First name<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_text'><input name='input_1' id='input_80_1' type='text' value='' class='medium' aria-required="true" aria-invalid="false" /></div></li><li id='field_80_2' class='gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible' ><label class='gfield_label' for='input_80_2' >Email address<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_email'> <input name='input_2' id='input_80_2' type='email' value='' class='medium' aria-required="true" aria-invalid="false" /> </div></li><li id='field_80_3' class='gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible' ><label class='gfield_label' >GDPR Agreement<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_checkbox'><ul class='gfield_checkbox' id='input_80_3'><li class='gchoice_80_3_1'> <input name='input_3.1' type='checkbox' value='I consent to have this website store my submitted information so they can respond to my inquiry.' id='choice_80_3_1' /> <label for='choice_80_3_1' id='label_80_3_1'>I consent to have this website store my submitted information so they can respond to my inquiry.</label> </li></ul></div></li><li id='field_80_4' class='gfield gform_validation_container field_sublabel_below field_description_below gfield_visibility_visible' ><label class='gfield_label' for='input_80_4' >Email</label><div class='ginput_container'><input name='input_4' id='input_80_4' type='text' value='' autocomplete='off'/></div><div class='gfield_description' id='gfield_description_80_4'>This field is for validation purposes and should be left unchanged.</div></li> </ul></div> <div class='gform_footer top_label'> <input type='submit' id='gform_submit_button_80' class='gform_button button' value='Download Now' onclick='if(window["gf_submitting_80"]){return false;} if( !jQuery("#gform_80")[0].checkValidity || jQuery("#gform_80")[0].checkValidity()){window["gf_submitting_80"]=true;} ' onkeypress='if( event.keyCode == 13 ){ if(window["gf_submitting_80"]){return false;} if( !jQuery("#gform_80")[0].checkValidity || jQuery("#gform_80")[0].checkValidity()){window["gf_submitting_80"]=true;} jQuery("#gform_80").trigger("submit",[true]); }' /> <input type='hidden' class='gform_hidden' name='is_submit_80' value='1' /> <input type='hidden' class='gform_hidden' name='gform_submit' value='80' /> <input type='hidden' class='gform_hidden' name='gform_unique_id' value='' /> <input type='hidden' class='gform_hidden' name='state_80' value='WyJbXSIsIjBiNjdjZjkyMDUzOWUxOWY5Y2NiZjIwMzM4YjA1Mjk4Il0=' /> <input type='hidden' class='gform_hidden' name='gform_target_page_number_80' id='gform_target_page_number_80' value='0' /> <input type='hidden' class='gform_hidden' name='gform_source_page_number_80' id='gform_source_page_number_80' value='1' /> <input type='hidden' name='gform_field_values' value='' /> </div> </form> </div><script type='text/javascript'> jQuery(document).bind('gform_post_render', function(event, formId, currentPage){if(formId == 80) {} } );jQuery(document).bind('gform_post_conditional_logic', function(event, formId, fields, isInit){} );</script><script type='text/javascript'> jQuery(document).ready(function(){jQuery(document).trigger('gform_post_render', [80, 1]) } ); </script>
[i]
[i]