[Resolved] Only display posts from users whose email matches an email field
This support ticket is created 8 years, 4 months ago. There's a good chance that you are reading advice that it now obsolete.
This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.
Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.
No supporters are available to work today on Toolset forum. Feel free to create tickets and we will handle it as soon as we are online. Thank you for your understanding.
I have a type called 'Leads'. Within this type I have an email field called 'Assigned to', and another field called 'Job reference or reason'.
I now want to create a view which only shows Leads where the 'assigned to' field matches the current users email address. I would also like to only display the leads for this user if the 'job reference or reason' field is null.
Then you should check with [wpv-current-user info="email"] value with your custom field value. Could you please try to use Views conditional statement:
For example:
[wpv-conditional if="( $(wpcf-email) eq '[wpv-current-user info='email']' )"]
Whatever you want to display conditionally
[/wpv-conditional]
I have got it to work, however the bullet points for items in the view which are not being shown are still being displayed. Any idea how to remove those?
Okay, I can hide the bullet points, but it is still 'displaying' the empty records. So If I change the number of records per page to 3, then I get a second page with nothing but empty records on it.
It's not so much that I want to hide the bullet points as I don't want it to 'see' the empty records.
Which part of the page? I have enclosed a shot of the Loop Output and filters sections. Is that what you want?
I've also attached a shot of the output on the page. I have changed the pagination to be 3 per page, and as you can see it is bringing up the pagination controls, even though there are only 2 fields displayed. It was doing this even when I removed the bullet points with CSS.
I think its better that you send me access details and link of the page where you have added your 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 would additionally need your permission to de- and re-activate Plugins and the Theme, and to change configurations on the site. This is also a reason the backup is really important. If you agree to this, please use the form fields I have enabled below to provide temporary access details (wp-admin and FTP).
I have set the next reply to private which means only you and I have access to it.
I am displaying the view on the home page of top1.gammawebsolutions.co.za.
I didn't use the conditional for user emails as I thought it would be easier to debug without that as then you would need to create your own records. Instead I am just using the other conditional I want to use for this view, to only show records where the 'job reference or reason' field is null.
That would be this view:
hidden link
As you can see, I have set the number of items per page to be three. There are only 3 records which have a 'job reference or reason' field equal to null, and yet it is showing a second (empty) page.
I've added following code to your functions.php file that is used to get fields with empty values for custom field 'wpcf-job-reference-or-reason'.
add_filter( 'posts_where' , 'posts_where' );
function posts_where( $where ) {
global $wpdb;
global $WP_Views;
if($WP_Views->current_view == 149){
$where .= " And $wpdb->posts.ID NOT IN (SELECT post_id FROM $wpdb->postmeta
WHERE ($wpdb->postmeta.post_id = $wpdb->posts.ID)
AND meta_key = 'wpcf-job-reference-or-reason'
)";
}
return $where;
}
