DesignWall

You’re welcome, my friend. =))

Hi there,

Thanks for writing in. We’re so happy that you have resolved the issue yourself. 😀

If you encounter any problem with the DW Question & Answer, please get back to us. We’re here to assist you.

Cheers.

Hi Prafulla Kumar Sahu,

Thanks buddy. We do really appreciate your help.

If there is any more issue with the DW Question & Answer, please do not hesitate to get back to us. It encourages us a lot.

Hi Prafulla Kumar Sahu,

Thank you for getting in touch with us. Please try this code below here

add_filter( 'dwqa_prepare_archive_posts', 'dwqa_refilter_question' );
function dwqa_refilter_question( $args ) {
 if ( isset( $_GET['filter'] ) && $_GET['filter'] == 'my-answer' ) {
  $user_id = get_current_user_id();

  $answer_args = array(
   'post_type' => 'dwqa-answer',
   'posts_per_page' => 5,
   'no_found_rows' => true,
   'update_post_term_cache' => false,
   'update_post_meta_cache' => false,
   'orderby' => 'date',
   'order' => 'DESC',
   'fields' => 'ids',
   'meta_key' => '_question',
   'author' => get_current_user_id()
  );

  add_filter( 'posts_where', 'dwqa_answer_post_where' );
  add_filter( 'posts_clauses', 'dwqa_answer_posts_clauses' );
  add_filter( 'posts_distinct', 'dwqa_answer_post_distinct' );
  $questions = new WP_Query( $answer_args );
  remove_filter( 'posts_where', 'dwqa_answer_post_where' );
  remove_filter( 'posts_clauses', 'dwqa_answer_posts_clauses' );
  remove_filter( 'posts_distinct', 'dwqa_answer_post_distinct' );

  if ( $questions->have_posts() ) {
   $args['post__in'] = $questions->posts;
  }
 }

 return $args;
}

function dwqa_answer_post_join( $join ) {
 global $wpdb;
 if ( isset( $_GET['filter'] ) && $_GET['filter'] == 'my-answer' ) {
  $join .= 'JOIN {$wpdb->postmeta} ON {$wpdb->posts}.ID = {$wpdb->postmeta}.post_id ';
 }
}

function dwqa_answer_post_where( $where ) {
 global $wpdb;
 if ( isset( $_GET['filter'] ) && $_GET['filter'] == 'my-answer' ) {
  $user_id = get_current_user_id();
  $where .= " AND {$wpdb->postmeta}.meta_key = '_question' ";
 }

 return $where;
}

function dwqa_answer_posts_clauses( $clauses ) {
 global $wpdb;
 $clauses['fields'] = $wpdb->postmeta . '.meta_value';

 return $clauses;
}

function dwqa_answer_post_distinct( $distinct ) {
 return "DISTINCT";
}

Hello Prafulla Kumar Sahu,

Thanks for noticing us. We will implement this feature in the upcoming version of DW Q&A.

However, until then you can only use dwqa_prepare_archive_posts filter to change the arguments.

Hi guys,

How’s everything? Does DW Question & Answer work fine on your site?
If you encounter any problem, please do not hesitate to get back to us. We’re here to help you.

Hi Kashifkiduniya,

How’s everything? Does DW Question & Answer look good on your site?
If you encounter any problem, please do not hesitate to get back to us. We’re here to help you.

Hi Prafulla Kumar Sahu,

Please read these lines below as our assistance:

You can go to wp-content/themes/<your-theme-folder> and add this code in to functions.php

add_filter( 'dwqa_prepare_archive_posts', 'dwqa_refilter_question' );
function dwqa_refilter_question( $args ) {
 // change 0 to page id you had place other archive page contain shortcode [dwqa-list-questions]
 if ( is_page( 0 ) ) {
  $answer_args = array(
   'post_type' => 'dwqa-answer',
   'posts_per_page' => 5,
   'post_status' => 'publish',
   'fields' => 'ids',
   'no_found_rows' => true,
   'update_post_term_cache' => false,
   'update_post_meta_cache' => false,
   'author' => get_current_user_id(),
   'orderby' => 'date'
  );

  // this will return array with 5 answer's ids
  $answers = get_posts( $answer_args );
  $question_lists = array();

  foreach( $answers as $answer_id ) {
   $question_lists[] = get_post_meta( $answer_id, '_question', true );
  }

  $args['post__in'] = $question_lists;
 }

 return $args;
}

If you encounter any problem, please do not hesitate to get back to us. We’re here to help you.