Skip Navigation

[Resolved] View query will not return proper results

This thread is resolved. Here is a description of the problem and solution.

Problem:

I have set up my view with a query using the constant "Alaska" for field Province/state. No results are returned.

Solution:

There are two custom fields with the same name "Province/state", but you are using wrong one in the view's filter, so it conducts the problem, you need to find and select the correct custom field "Province/state"

Relevant Documentation:

This support ticket is created 4 years, 3 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.

Sun Mon Tue Wed Thu Fri Sat
- 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 -
- 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 -

Supporter timezone: Asia/Hong_Kong (GMT+08:00)

This topic contains 2 replies, has 2 voices.

Last updated by ericE-4 4 years, 3 months ago.

Assisted by: Luo Yang.

Author
Posts
#1789669
Screen Shot 2020-09-24 at 3.31.54 PM.png
Screen Shot 2020-09-24 at 3.31.10 PM.png

I am trying to show a view that displays all "Lodge" post types that have the field Province/state equal to Alaska. There are dozens of them. I've attached a screenshot of one of the lodges in Alaska showing the value for field Province/state.

I have set up my view with a query using the constant "Alaska" for field Province/state. No results are returned.

If I query other fields it works fine.

Link to a page where the issue can be seen: hidden link

#1790031

Hello,

There are two custom fields with the same name "Province/state", but you are using wrong one in the view's filter, so it conducts the problem.

I have done below modifications in your website:
Edit post view:
hidden link
In section "Query Filter", change the filter to the "Province/state" field from field group "Main fields", please test again, check if it is fixed. thanks

#1790987

I thought for sure I chose the field from the Main group. Perhaps the UI could label the group that the currently selected field is from.