Modify the search query

This topic contains 3 replies, has 3 voices, and was last updated by  Kor 5 years, 5 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • #457780

    James Gehring
    Expired Member
    Post count: 34

    Is there a way to modify the search query to add in my own where statement based on a couple custom fields?

    I want to have a minimum and maximum field on the listing. I want to modify the query so it finds everything between that min and max.

    example:

    select * from gd_place_details where column_min > min AND column_max < max

    #457803

    Alex Rollin
    Moderator
    Post count: 27815

    Have you tried the options for advance search as shown in the screenshot?

    #457859

    James Gehring
    Expired Member
    Post count: 34

    I don’t see an option like that one. What field would I use to see that? I checked the advanced search and tried every option I could find.

    #457868

    Kor
    Moderator
    Post count: 16516

    Hi James,

    You can refer to this section of the documentation https://wpgeodirectory.com/docs/gd-search/#custom that explains more about this.

    Thanks!

Viewing 4 posts - 1 through 4 (of 4 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket