[Closed] Custom query filter to View

[Author]

Posts

[kelvinL-2]

Dear Sir/Madam,

Is it possible to have my custom query filter to a View? I want to query the name list with post__in, I have a custom field to store the post id.

From page, I add below shortcode to call the View

[wpv-view name="my-name-list" wpvrelatedto="[get_vfmember_id u="[wpv-user field='ID']"]"]

I return the get_vfmemeber_id by below function

function func_get_vfmember_id($atts) {
	$args = [
		'post_type' => 'vfmember',
		'posts_per_page' => 1,
		'author' => $atts['u'],
	];
	$query = new WP_Query($args);
	
	if($query->have_posts()): 
		$query->the_post();
	    $mentor_id = get_the_ID();
	endif; 
	wp_reset_postdata();
    return $mentor_id;
}
add_shortcode('get_vfmember_id', 'func_get_vfmember_id');

I will rewrite my code to get one more $mentor_id and then return to View, but I have no idea how I can query the filter with more than one id for parameter wpvrelatedto like
[wpv-view name="my-name-list" wpvrelatedto="23,45"] then it can query the name list related to both parent id 23 and 45.

[Minesh]

Hello. Thank you for contacting the Toolset support.

To use the custom shortcode "get_vfmember_id " as attribute of view's shortcode attribute you will have to register the custom shortcode.

To do this, go to the Toolset -> Settings page, click the Front-end Content tab and add your shortcode name "get_vfmember_id" in the Third-party shortcode arguments section.

If your shortcode does not paresed then you will have to use different method. Can you please share what that shortcode return value and what exactly you want to pass. You may share admin access details and problem URL where you added the view.

*** Please make a FULL BACKUP of your database and website.***
I would also eventually need to request temporary access (WP-Admin and FTP) to your site. Preferably to a test site where the problem has been replicated if possible in order to be of better help and check if some configurations might need to be changed.

I have set the next reply to private which means only you and I have access to it.

[Minesh]

As I understand, basically what you want is, you want to get the related posts of post relationship "VFMembers Name Lists" from the following post:
=> hidden link

And another ID that is available with the custom field "Spouse ID" and you want to fetch the related posts from the ID available with the custom field "Spouse ID" and display it - correct? If yes: but what is the condition based that we find the following post:
- hidden link

Do you want to find the author of the post equal to current loggedin user from the VFMembers post type and based on that found post we should get the "Spouse ID" and display the related post of both found post?

[kelvinL-2]

Dear Minesh,

Reply your question as below:

If yes: but what is the condition based that we find the following post:
- <em><u>hidden link</u></em>

Login user will visit the page hidden link to view the mantee list and also I want to let the user can view his or her spouse's mantee list

To display the spouse's mantee list by shortcode

[wpv-view name="my-mantees" view_display="layout" cached="off" mentorid="[get_spouse_id u="[wpv-user field="ID"]"]" ]

I don't want to show all mantees in separated view, can I combine them by query?

As both VFMember posts are belong to different login user, my shortcode [wpv-view name="my-name-list" wpvrelatedto="[get_vfmember_id u="[wpv-user field='ID']"]"] will pass the VFMember ID and shortcode [wpv-view name="my-mantees" view_display="layout" cached="off" mentorid="[get_spouse_id u="[wpv-user field="ID"]"]" ] will get the spouse id in script.

[Minesh]

Login user will visit the page hidden link to view the mantee list and also I want to let the user can view his or her spouse's mantee list
==>
I would like to know, Using what frontend user login access I should visit the above link so that I can see the results?

I have set the next reply to private which means only you and I have access to it.