Low search - searching multiple related children / parents
We would like to search multiple channels and native relationship fields in EE 2.8.1 and low search 4.4.2
Lets assume we have two fields, each from a different channel:
* related_field
* another_ related_field
Our basic search template looks like this:
<h1>Low Search results</h1>
{exp:low_search:results
query="{segment_1}"
require_query="yes"
disable="member_data|category_fields"
orderby="date|edit_date"
sort="desc"
status="not closed"
}
{entry_id} {title} <small style="font-size: 70%; color: grey;">From section {channel}</small><br>
{if low_search_no_results}
<p>No results</p>
{/if}
{/exp:low_search:results}
{exp:low_search:form result_page="/sandbox" status="not closed"}
<input type="hidden" name="child: related_field" value="163691">
<input type="hidden" name="child:another_ related_field" value="163691">
<button type="submit">Go</button>
{/exp:low_search:form}
If we change this to ONLY include one relationship field it works:
{exp:low_search:form result_page="/sandbox" status="not closed"}
<input type="hidden" name="child:catalogue_related_timeline" value="163691">
<button type="submit">Go</button>
{/exp:low_search:form}
Testing each field individually works, returning the results we would expect.
Replies
Paul Cripps 22 Mar 2016 13:31
Here's the templates debug info:
TEMPLATE DEBUGGING
(0.000017 / 10.22MB) - Begin Template Processing -
(0.000056 / 10.22MB) URI: sandbox
(0.000071 / 10.22MB) Path.php Template: /
(0.000087 / 10.22MB) Retrieving Template
(0.000099 / 10.23MB) Parsing Template URI
(0.006459 / 10.34MB) Template Group Found: sandbox
(0.006525 / 10.34MB) Retrieving Template from Database: sandbox/index
(0.007371 / 10.35MB) Template Found
(0.007472 / 10.35MB) Retrieving Template from File
(0.012665 / 10.63MB) Calling Extension Class/Method: Low_seg2cat_ext/template_fetch_template
(0.016616 / 10.76MB) Calling Extension Class/Method: Mo_variables_ext/run
(0.029099 / 10.93MB) Calling Extension Class/Method: Stash_ext/template_fetch_template
(0.029316 / 10.89MB) Template Type: webpage
(0.029349 / 10.89MB) Parsing Site Variables
(0.029707 / 10.90MB) Snippets (Keys): store_stripe_public_key|site_mode|freelancer_version|structure:is:page|structure:is:listing|structure:is:listing:parent|structure:page:entry_id|structure:page:template_id|structure:page:title|structure:page:slug|structure:page:uri|structure:page:url|structure:page:channel|structure:page:channel_short_name|structure:parent:entry_id|structure:parent:title|structure:parent:slug|structure:parent:uri|structure:parent:url|structure:parent:child_ids|structure:parent:channel|structure:parent:channel_short_name|structure:top:entry_id|structure:top:title|structure:top:slug|structure:top:uri|structure:top:url|structure:child_listing:channel_id|structure:child_listing:short_name|structure:freebie:entry_id|structure:child_ids|structure:sibling_ids|structure_1|structure_2|structure_3|structure_4|structure_5|structure_6|structure_7|structure_8|structure_9|structure_10|structure_last_segment|sn_copyright|sn_min_donation_for_benefits|sn_min_donation|sn_required|sn_error_delimiters|sn_valid_member_subscription_groups|sn_valid_member_benefit_groups|sn_date_format|sn_disable|sn_valid_member_pending_groups|sn_pagination|sn_back_to_top|sn_member_discount_value|sn_valid_member_organisation_groups|sn_edit_this|sn_optional|sn_valid_member_upgrade_groups|sn_min_donation_promote_appeals|sn_blog_entry_summary|sn_advanced_search|sn_static_side_panel|sn_content_elements|sn_explore_dropdown|sn_shop_entry_summary|sn_filter_by_mills|sn_total_features|sn_pagination_shop|segment_category_ids|segment_category_ids_piped|segment_1_category_id|segment_1_category_parent_id|segment_1_category_group_id|segment_1_category_name|segment_1_category_description|segment_1_category_image|last_segment_category_id|last_segment_category_parent_id|last_segment_category_group_id|last_segment_category_name|last_segment_category_description|last_segment_category_image|ajax|not_ajax|secure|not_secure|secure_site_url|insecure_site_url|get:child:catalogue_related_timeline|embed:get:child:catalogue_related_timeline|get:child:entry_related_timeline|embed:get:child:entry_related_timeline|get:1|embed:get:1|get_post:child:catalogue_related_timeline|embed:get_post:child:catalogue_related_timeline|get_post:child:entry_related_timeline|embed:get_post:child:entry_related_timeline|get_post:1|embed:get_post:1|post:1|embed:post:1|cookie:local_show_once_welcome|embed:cookie:local_show_once_welcome|cookie:PHPSESSID|embed:cookie:PHPSESSID|cookie:local_stashid|embed:cookie:local_stashid|cookie:exp_show_once_welcome|embed:cookie:exp_show_once_welcome|cookie:_atshc|embed:cookie:_atshc|cookie:__atuvc|embed:cookie:__atuvc|cookie:__atrfs|embed:cookie:__atrfs|cookie:__utma|embed:cookie:__utma|cookie:__utmc|embed:cookie:__utmc|cookie:__utmz|embed:cookie:__utmz|cookie:local_perpage|embed:cookie:local_perpage|cookie:local_last_visit|embed:cookie:local_last_visit|cookie:local_csrf_token|embed:cookie:local_csrf_token|cookie:local_last_activity|embed:cookie:local_last_activity|cookie:local_expiration|embed:cookie:local_expiration|cookie:local_sessionid|embed:cookie:local_sessionid|cookie:local_tracker|embed:cookie:local_tracker|cookie:1|embed:cookie:1|flashdata:1|embed:flashdata:1|last_page_visited|one_page_ago|two_pages_ago|three_pages_ago|four_pages_ago|five_pages_ago|rev_segment_1|rev_segment_2|rev_segment_3|rev_segment_4|rev_segment_5|rev_segment_6|rev_segment_7|rev_segment_8|rev_segment_9|rev_segment_10|rev_segment_11|rev_segment_12|segments_from_1|segments_from_2|segments_from_3|segments_from_4|segments_from_5|segments_from_6|segments_from_7|segments_from_8|segments_from_9|segments_from_10|segments_from_11|segments_from_12|paginated|not_paginated|page_offset|pagination_base_uri|pagination_base_url|archive|daily_archive|monthly_archive|yearly_archive|not_archive|not_daily_archive|not_monthly_archive|not_yearly_archive|categorized|reserved_category_word|server_name|current_url|current_url_encoded|uri_string|uri_string_encoded|query_string|logged_in_member_id|logged_in_group_id|logged_in_group_description|logged_in_group_title|logged_in_username|logged_in_screen_name|logged_in_email|logged_in_ip_address|logged_in_location|logged_in_total_entries|logged_in_total_comments|logged_in_private_messages|logged_in_total_forum_posts|logged_in_total_forum_topics|logged_in_total_forum_replies|logged_in_join_date|logged_in_last_visit|logged_in_last_activity|logged_in_last_entry_date|logged_in_last_comment_date|logged_in_last_forum_post_date|logged_in_timezone|logged_in_time_format|site_id|site_label|site_short_name|last_segment|current_path|current_query_string|is_core
(0.029791 / 10.92MB) Snippets (Values): pk_El7eHKSU3GT7flGOu6K7RCon5CnNy|dev|FALSE||||||||||||||||||||||sandbox|/sandbox/|http://millsarchive.dev/index.php/sandbox/||||||sandbox||||||||||sandbox|© {current_time format="%Y"} The Mills Archive Trust. All rights reserved. Registered Charity in England and Wales #{g_reg_charity_number}|8|1|<span class="required">*</span>|<label class="error"><i class="fa fa-chevron-up"></i>|</label>|18|19|20|21|1|6|7|18|19|20|21|25|%F %d<sup>%S</sup> %Y|categories|category_fields|custom_fields|member_data|pagination|4|24|{paginate} {pagination_links} <ul class="pagination"> {first_page} <li><a href="{pagination_url}" class="page-first">«</a></li> {/first_page} {previous_page} <li><a href="{pagination_url}" class="page-previous">‹</a></li> {/previous_page} {page} <li{if current_page} class="active"{/if}><a href="{pagination_url}" class="page-{pagination_page_number}">{pagination_page_number}</a></li> {/page} {next_page} <li><a href="{pagination_url}" class="page-next">›</a></li> {/next_page} {last_page} <li><a href="{pagination_url}" class="page-last">»</a></li> {/last_page} </ul><!-- / .pagination --> {/pagination_links} {/paginate}|<div class="hidden-print"> <hr> <a href="#Content" class="back_to_top">Back to top <i class="fa fa-chevron-up"></i></a> <hr> </div>|{exp:query sql="SELECT CONCAT(ROUND(percent_discount),'%') AS discount FROM exp_store_discounts WHERE id=1"}{discount}{/exp:query}|19|20|21|{if author_id == logged_in_member_id OR in_group(1)}<a href="{site_url}admin/index.php?S=0&D=cp&C=content_publish&M=entry_form&channel_id={channel_id}&entry_id={entry_id}" id="EditThis" class="btn btn-xs">Edit This</a>{/if}|<span class="optional">(Optional)</span>|5|100|<article class="clearfix"> <h2 class=""><a href="{path='news/entry'}/{entry_id}/{url_title}" class="no_border">{title}</a></h2> <aside class="meta"> <p><span class="meta date">{entry_date format="%F %d<sup>%S</sup> %Y"} by {if blog_guest_author!=''}{blog_guest_author}{if:else}{author}{/if}</span> </p> </aside> <p class="no_links"> {if blog_picture != ""} <a href="{path='news/entry'}/{entry_id}/{url_title}" class="pull-left">{exp:ce_img:single src="{blog_picture}" width="200" crop="no" attributes='class="pull-left" alt="Article Preview Thumbnail" title="{title}" style="margin: 0 20px 20px 0"'}</a> {/if} {blog_summary} </p> <p><a href="{path='news/entry'}/{entry_id}/{url_title}" class="transparent">Read more …</a></p> </article>|<table class="table table-striped table-condensed"> <thead> <tr> <th>Keywords</th> <th>Results</th> </tr> </thead> <tbody> <tr> <td>tow*</td> <td>Items containing a word that starts with “tow”.</td> </tr> <tr> <td>*wer</td> <td>Items containing a word that ends with “wer”.</td> </tr> <tr> <td>*owe*</td> <td>Items containing a word that contains “owe”.</td> </tr> <tr> <td>tower mill</td> <td>Items containing both “tower” and “mill”.</td> </tr> <tr> <td>tower OR mill</td> <td>Items containing either “tower” or “mill” or both.</td> </tr> <tr> <td>tower -mill</td> <td>Items containing “tower” but not “mill”.</td> </tr> <tr> <td>"tower mill"</td> <td>Items containing the exact phrase “tower mill”.</td> </tr> </tbody> </table>|<!-- static_side_panel --> {static_side_panel} <div class="panel panel-default"> {if ssp_title} <div class="panel-heading"> <h2 class="panel-title">{ssp_title}</h2> </div> {/if} <div class="panel-body"> {ssp_body} </div> </div> {/static_side_panel}<!-- /static_side_panel -->|{quote} <div class="quote"> <blockquote>{value}</blockquote> <cite>{author}</cite> </div> {/quote} {picture} <div class="picture pull-{alignment} {image_size}"> {if enlarge OR "{url}"!="" AND "{url}"!="http://"} <a href="{if enlarge}{original}{if:else}{url}{/if}" title="{description}"> {if image_size=="thumb"} <img src="{image}" class="thumb img-responsive" alt="{description}"> {if:elseif image_size=="sized"} <img src="{image}" class="sized img-responsive" alt="{description}"> {if:else} {exp:ce_img:single src="{image}" width="750" crop="no" attributes="class='original img-responsive'"} {/if} </a> {if:else} {if image_size=="thumb"} <img src="{image}" class="thumb img-responsive" alt="{description}"> {if:elseif image_size=="sized"} <img src="{image}" class="sized img-responsive" alt="{description}"> {if:else} {exp:ce_img:single src="{image}" width="750" crop="no" attributes="class='original img-responsive'"} {/if} {/if} {if description}<p class="description clear">{description}</p>{/if} </div> {/picture} {table} <table class="table table-striped table-bordered"> <thead> {thead} <tr>{cells}<th>{value}</th>{/cells}</tr> {/thead} </thead> <tbody> {tbody} <tr>{cells}<td>{value}</td>{/cells}</tr> {/tbody} </tbody> </table> {/table}|<li><a href="/explore/results" id="mills|people|book_library|book_authors|resources|articles" class="explore_collection_trigger">Explore</a></li> <li class="divider divider-muted"></li> <li><a href="{path='explore/archive-catalogue'}">Images & Documents <i class="fa fa-angle-right"></i></a></li> <li class="divider divider-muted"></li> <li class="inset"><a href="{path='explore/mills/results'}" rel="mills" class="explore_collection_trigger">Mills</a></li> <li class="inset"><a href="{path='explore/people/results'}" rel="people" class="explore_collection_trigger">Family History <small>(People)</small></a></li> <li class="inset"><a href="{path='explore/library/books/results'}" rel="book_library" class="explore_collection_trigger">Books</a></li> <li class="inset"><a href="{path='explore/library/authors/results'}" rel="book_authors" class="explore_collection_trigger">Authors</a></li> <li class="inset"><a href="{path='explore/articles/results'}" rel="articles" class="explore_collection_trigger">Features & Articles</a></li> <li class="inset"><a href="{path='explore/resources/results'}" rel="resources" class="explore_collection_trigger">Online Resources</a></li>|<article class="panel panel-default"> <div class="panel-heading"> <h3 class="panel-title {if book_shop_is_new == 'Yes'}new_item_title{/if}"> <a href="{path='shop/product'}/{entry_id}/{url_title}"> {if book_shop_is_new == 'Yes'}<img src="/assets/img/icon_new_item.png" class="new_item">{/if} {exp:word_limit total="7"}{title}{/exp:word_limit}{if "{channel_short_name}"=="book_library"}, {book_authors limit="1"}{title}{/book_authors}, {publication_year}{/if}</a> <span class="pull-right"> {if on_sale} <del>{regular_price}</del> {price} <span class="label label-success">Save {you_save} ({you_save_percent}%)</span> {if:else} {price} {/if} </span> </h3> </div> <div class="panel-body container-fluid"> <div class="row"> <a class="col-xs-3 col-sm-3 col-md-3" href="{path='shop/product'}/{entry_id}/{url_title}"> {if "{channel_short_name}"=="products" OR "{channel_short_name}"=="products_postcards"} {embed="shop/.inc_images_product" entry_id="{entry_id}" width="150"} {if:elseif "{channel_short_name}"=="book_library"} {embed="shop/.inc_images_book" entry_id="{entry_id}" width="150"} {if:elseif "{channel_short_name}"=="catalogue"} {embed="shop/.inc_images_catalogue" entry_id="{entry_id}" width="150"} {/if} </a> <div class="col-xs-9 col-sm-9 col-md-9"> <div class="description"> {if "{channel_short_name}"=="products" OR "{channel_short_name}"=="products_postcards"} {exp:word_limit total="50"} {product_description} {/exp:word_limit} {if:elseif "{channel_short_name}"=="book_library"} {exp:word_limit total="50"} {book_description} {/exp:word_limit} {if:elseif "{channel_short_name}"=="catalogue"} {exp:word_limit total="50"} {catalogue_description} {/exp:word_limit} {/if} </div> {if track_stock AND total_stock <= 0} <span class="btn btn-default pull-right" disabled="disabled">Out of Stock</span> {if:else} {modifiers} {modifier_options} {if option_first} <input type="hidden" name="{modifier_input_name}" value="{option_id}"> {/if} {/modifier_options} {/modifiers} <input type="hidden" id="item_qty" name="item_qty" value="{min_order_qty}"> <input type="submit" name="submit" value="Add to Basket" class="btn btn-default pull-right add_to_basket"> {/if} </div> </div> </div> </article>|<section class="panel panel-default"> <div class="panel-heading"> <h3 class="panel-title">Filter by:</h3> </div> <div class="panel-body filter-by"> {exp:low_search:filters query="{segment_3}"} {if get:search:region OR get:search:mill_district_or_town OR get:category} <h3>Currently filtering by:</h3> <ul> {if get:search:region OR get:search:mill_district_or_town} {if get:search:region} region: {get:search:region} {if:else} mill_district_or_town: {get:search:mill_district_or_town} {/if} {/if} {if get:category} {exp:channel:categories show="{get:category}" style="linear" backspace="2"} <li> <a href="{low_search:url result_page='/explore/mills/results' toggle:category='{category_id}'}" class="check"> <i class="fa fa-check-circle"></i> {category_name} </a> </li> {/exp:channel:categories} <li><a href="/explore/mills/all" class="check selected"><i class="fa fa-minus-circle"></i> Clear all filters</a></li> {/if} </ul> {/if} <h3>Countries:</h3> {exp:gwcode_categories class="ajax-container" show_empty="no" group_id="9" limit="6" orderby="cat_name" parse="inward"} <a href="{low_search:url result_page='/explore/mills/results' toggle:category='{cat_id}'}" {if cat_id IN ({low_search_category})}class="check"{/if}> <i class="fa fa-{if cat_id IN ({low_search_category})}check{if:else}plus{/if}-circle"></i> {cat_name} </a> {if {cat_count} == {results}} <li> <a href="{path='/ajax/get-cats'}/{cat_group_id}/-{results}" class="load"><i class='fa fa-eye'></i> More…</a> </li> {/if} {/exp:gwcode_categories} <h3>Power Sources:</h3> {exp:gwcode_categories class="ajax-container" show_empty="no" group_id="10" orderby="cat_name" parse="inward"} <a href="{low_search:url result_page='/explore/mills/results' toggle:category='{cat_id}'}" {if cat_id IN ({low_search_category})}class="check"{/if}> <i class="fa fa-{if cat_id IN ({low_search_category})}check{if:else}plus{/if}-circle"></i> {cat_name} </a> {/exp:gwcode_categories} <h3>Functions:</h3> {exp:gwcode_categories class="ajax-container" show_empty="no" group_id="12" limit="6" orderby="cat_name" parse="inward"} <a href="{low_search:url result_page='/explore/mills/results' toggle:category='{cat_id}'}" {if cat_id IN ({low_search_category})}class="check"{/if}> <i class="fa fa-{if cat_id IN ({low_search_category})}check{if:else}plus{/if}-circle"></i> {cat_name} </a> {if {cat_count} == {results}} <li> <a href="{path='/ajax/get-cats'}/{cat_group_id}/-{results}" class="load"><i class='fa fa-eye'></i> More…</a> </li> {/if} {/exp:gwcode_categories} <h3>County <a href="{g_historic_counties_link}"><i class="fa fa-info-circle"></i></a>:</h3> {exp:gwcode_categories class="ajax-container" show_empty="no" group_id="8" limit="6" orderby="cat_name" parse="inward"} <a href="{low_search:url result_page='/explore/mills/results' toggle:category='{cat_id}'}" {if cat_id IN ({low_search_category})}class="check"{/if}> <i class="fa fa-{if cat_id IN ({low_search_category})}check{if:else}plus{/if}-circle"></i> {cat_name} </a> {if {cat_count} == {results}} <li> <a href="{path='/ajax/get-cats'}/{cat_group_id}/-{results}" class="load"><i class='fa fa-eye'></i> More…</a> </li> {/if} {/exp:gwcode_categories} <h3>Rivers:</h3> {exp:gwcode_categories class="ajax-container" show_empty="no" group_id="11" limit="6" orderby="cat_name" parse="inward"} <a href="{low_search:url result_page='/explore/mills/results' toggle:category='{cat_id}'}" {if cat_id IN ({low_search_category})}class="check"{/if}> <i class="fa fa-{if cat_id IN ({low_search_category})}check{if:else}plus{/if}-circle"></i> {cat_name} </a> {if {cat_count} == {results}} <li> <a href="{path='/ajax/get-cats'}/{cat_group_id}/-{results}" class="load"><i class='fa fa-eye'></i> More…</a> </li> {/if} {/exp:gwcode_categories} <h3>Types:</h3> {exp:gwcode_categories class="ajax-container" show_empty="no" group_id="7" orderby="cat_name" parse="inward"} <a href="{low_search:url result_page='/explore/mills/results' toggle:category='{cat_id}'}" {if cat_id IN ({low_search_category})}class="check"{/if}> <i class="fa fa-{if cat_id IN ({low_search_category})}check{if:else}plus{/if}-circle"></i> {cat_name} </a> {/exp:gwcode_categories} {/exp:low_search:filters} </div> </section><!-- / .panel -->|{exp:channel:entries channel="features-and-articles" orderby="date" sort="asc" disable="categories|category_fields|member_data|pagination|matrix|playa|store" dynamic="no" status="not closed" search:is_featured="Yes"}{if count == 1}{total_results}{/if}{/exp:channel:entries}|{paginate} <div class="row pagination_outer"> <div class="col-md-12"> {pagination_links} <p class="pagination pages pull-left">{current_page} of {total_pages} pages</p> <ul class="pagination navigation pull-right"> {first_page} <li><a href="{pagination_url}{if query_string}?{query_string}{/if}" class="page-first">«</a></li> {/first_page} {previous_page} <li><a href="{pagination_url}{if query_string}?{query_string}{/if}" class="page-previous">‹</a></li> {/previous_page} {page} <li{if current_page} class="active"{/if}><a href="{pagination_url}{if query_string}?{query_string}{/if}" class="page-{pagination_page_number}">{pagination_page_number}</a></li> {/page} {next_page} <li><a href="{pagination_url}{if query_string}?{query_string}{/if}" class="page-next">›</a></li> {/next_page} {last_page} <li><a href="{pagination_url}{if query_string}?{query_string}{/if}" class="page-last">»</a></li> {/last_page} </ul><!-- / .pagination --> {/pagination_links} </div> </div> {/paginate}|||||||||||||||0|1|0|1|https://millsarchive.dev/|http://millsarchive.dev/|163691|163691|163691|163691|||163691|163691|163691|163691|||||1445265883|1445265883|fc10f1d34e4a227fb712d3b3469ef9c7|fc10f1d34e4a227fb712d3b3469ef9c7|a:2:{s:2:"id";s:40:"0f84b935e16fd172c1c983f6861a49567b0492d9";s:2:"dt";i:1446656734;}|a:2:{s:2:"id";s:40:"0f84b935e16fd172c1c983f6861a49567b0492d9";s:2:"dt";i:1446656734;}|1450214654|1450214654|{}|{}|1|8,0|9,50|10,12|11,4|12|1|8,0|9,50|10,12|11,4|12|ab/|pos/|tot/|rsi/56efcd1f00000000|cfc/|hash/0|rsiq/|fuid/128b4fa7|rxi/|rsc/addressbar|gen/2|csi/|dr/http://millsarchive.dev/explore/mills/great-british-mill-race|ab/|pos/|tot/|rsi/56efcd1f00000000|cfc/|hash/0|rsiq/|fuid/128b4fa7|rxi/|rsc/addressbar|gen/2|csi/|dr/http://millsarchive.dev/explore/mills/great-british-mill-race|87224708.225153031.1445265885.1457561692.1458572201.162|87224708.225153031.1445265885.1457561692.1458572201.162|87224708|87224708|87224708.1445265885.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)|87224708.1445265885.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)|50|50|1458644603|1458644603|5354c1fd5667e568f9309a6891ca7f5da5b299bc|5354c1fd5667e568f9309a6891ca7f5da5b299bc|1458652770|1458652770|1458656370|1458656370|47cbcba6da1db4e0bd70b5f44beeba40ce23a186|47cbcba6da1db4e0bd70b5f44beeba40ce23a186|a:4:{i:0;s:7:"sandbox";i:1;s:5:"index";i:2;s:7:"sandbox";i:3;s:34:"explore/mills/add-mill-information";}|a:4:{i:0;s:7:"sandbox";i:1;s:5:"index";i:2;s:7:"sandbox";i:3;s:34:"explore/mills/add-mill-information";}|||||http://millsarchive.dev/index.php/|http://millsarchive.dev/index.php/|http://millsarchive.dev/index.php/sandbox|http://millsarchive.dev/index.php/explore/mills/add-mill-information|||sandbox||||||||||||sandbox||||||||||||0|1|0|/sandbox|http://millsarchive.dev/index.php/sandbox|0|0|0|0|1|1|1|1|0|category|millsarchive.dev|http://millsarchive.dev/index.php/sandbox|http%3A%2F%2Fmillsarchive.dev%2Findex.php%2Fsandbox|sandbox|sandbox|child:catalogue_related_timeline=163691&child:entry_related_timeline=163691|2191|1||Super Admins|paulcripps|Paul Cripps|paul@ninefour.co.uk|::1||49|0|0|0|0|0|1380275438|1458607345|1458652770|1457697658|1384335842|0|UTC|eu|1|The Mills Archive|default_site|sandbox|sandbox|child%3Acatalogue_related_timeline=163691&child%3Aentry_related_timeline=163691|
(0.030601 / 10.92MB) Parse Date Format String Constants
(0.030622 / 10.92MB) Parse Current Time Variables
(0.030677 / 10.92MB) Parsing Segment, Embed, Layout, and Global Vars Conditionals
(0.037646 / 10.94MB) - Beginning Tag Processing -
(0.037677 / 10.94MB) Parsing Tags in Template
(0.037725 / 10.94MB) Tag: {exp:low_search:results query="sandbox" require_query="yes" disable="member_data|category_fields" orderby="date|edit_date" sort="desc" status="not closed" }
(0.037882 / 10.94MB) Closing Tag Found
(0.037953 / 10.94MB) Tag: {exp:low_search:form result_page="/sandbox" status="not closed"}
(0.038028 / 10.95MB) Closing Tag Found
(0.038072 / 10.95MB) Processing Tags
(0.038116 / 10.95MB) Module Tag: Low_search/results
(0.038142 / 10.95MB) Module Tag: Low_search/form
(0.038160 / 10.95MB) Including Files for Plugins and Modules
(0.043322 / 11.24MB) Files for Plugins and Modules All Included
(0.044023 / 11.27MB) Beginning Final Tag Data Processing
(0.044051 / 11.27MB) Calling Class/Method: Low_search/results
(0.044311 / 11.27MB) -> Class Called: Low_search
(0.053580 / 11.74MB) -> Method Called: results
(0.053660 / 11.75MB) Low Search: Prepping if low_search_no_results conditional
(0.069779 / 12.41MB) Low Search: Applying Low_search_filter_relationships
(0.069833 / 12.41MB) Low Search: Getting channel field info from API
(0.138575 / 16.40MB) Low Search: Filters found no matches, returning no results
(0.138647 / 16.40MB) Returning No Results Content
(0.138746 / 16.40MB) -> Data Returned
(0.138789 / 16.40MB) Calling Class/Method: Low_search/form
(0.138922 / 16.40MB) -> Class Called: Low_search
(0.139176 / 16.40MB) -> Method Called: form
(0.144006 / 16.56MB) -> Data Returned
(0.144128 / 16.53MB) - End Tag Processing -
(0.144487 / 16.54MB) Calling Extension Class/Method: Mo_variables_ext/cleanup
(0.144712 / 16.54MB) Calling Extension Class/Method: Stash_ext/template_post_parse
(0.144750 / 16.54MB) Stash: batch processing queued queries
(0.147995 / 16.67MB) Calling Extension Class/Method: Structure_ext/template_post_parse
(0.148177 / 16.67MB) - End Template Processing -
(0.148193 / 16.67MB) Parse Global Variables
(0.149895 / 16.67MB) Template Parsing Finished
Memory Usage: 17,535,384 bytes
Low 22 Mar 2016 13:39
Can you copy/paste the output of the Output Profiler as well? Specifically, all the queries generated by lsf.relationships.php, which should be mentioned per query.
Paul Cripps 22 Mar 2016 17:33
Sorry Low, here you go:Low Search results
No results
Go
BENCHMARKS
Loading Time: Base Classes 0.0125
Controller Execution Time ( Ee / Index ) 0.2568
Total Execution Time 0.2695
GET DATA
$_GET['child:catalogue_related_timeline'] 163691
$_GET['child:entry_related_timeline'] 163691
MEMORY USAGE
17,622,336 bytes
POST DATA
No POST data exists
URI STRING
sandbox
CLASS/METHOD
ee/index
DATABASE: millsarc_dev_ee QUERIES: 29 (Hide)
0.0014 SELECT *
FROM ('exp_sites')
WHERE 'site_id' = 1
#APP/core/EE_Config.php L:209 EE_Config::site_prefs()
0.0006 SELECT DISTINCT ee.* FROM exp_extensions ee WHERE enabled = 'y' ORDER BY hook, priority ASC, class
#CI/core/Loader.php L:995 EE_Extensions::__construct()
0.0003 SELECT COUNT(*) AS 'numrows'
FROM ('exp_modules')
WHERE 'module_name' = 'Blacklist'
#APP/models/addons_model.php L:260 Addons_model::module_installed()
0.0002 SELECT whitelisted_type, whitelisted_value FROM exp_whitelisted
WHERE whitelisted_value != ''
#APP/libraries/Core.php L:305 EE_Blacklist::_check_blacklist()
0.0003 SELECT blacklisted_type, blacklisted_value FROM exp_blacklisted
#APP/libraries/Core.php L:305 EE_Blacklist::_check_blacklist()
0.0003 SELECT module_id FROM exp_modules WHERE module_name = 'Structure'
#ext.structure.php L:35 Sql_structure::module_is_installed()
0.0002 SELECT var_value, var FROM exp_structure_settings WHERE site_id IN (0,1)
#sql.structure.php L:1344 Sql_structure::get_settings()
0.0002 SELECT entry_id FROM exp_structure_listings WHERE site_id = 1
#sql.structure.php L:1128 Sql_structure::get_listing_entry_ids()
0.0002 SELECT 'member_id', 'admin_sess', 'last_activity', 'fingerprint', 'sess_start'
FROM ('exp_sessions')
WHERE 'session_id' = '81e9be8746541d2b95b54a318ac00ab5709b83a3'
#APP/libraries/Session.php L:729 EE_Session::fetch_session_data()
0.0004 SELECT *
FROM ('exp_members' m, 'exp_member_groups' g)
WHERE 'g'.'site_id' = 1
AND m.group_id = g.group_id
AND 'member_id' = 2191
#APP/libraries/Session.php L:1155 EE_Session::_do_member_query()
0.0002 UPDATE 'exp_sessions' SET 'session_id' = '81e9be8746541d2b95b54a318ac00ab5709b83a3', 'fingerprint' = '2f5757314f007e6527af6b33ed037bc1', 'member_id' = 2191, 'admin_sess' = 1, 'ip_address' = '::1', 'user_agent' = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_2) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.87 Safari/537.36', 'last_activity' = 1458668040, 'sess_start' = '1458667608' WHERE session_id = '81e9be8746541d2b95b54a318ac00ab5709b83a3'
#APP/libraries/Session.php L:193 EE_Session::update_session()
0.0001 DELETE FROM 'exp_sessions'
WHERE 'last_activity' < 1458660840
#APP/libraries/Session.php L:430 EE_Session::delete_old_sessions()
0.0003 SELECT m.email, m.username member_username, m.member_id, d.m_field_id_1 member_title, d.m_field_id_2 member_first_name, d.m_field_id_3 member_middle_name, d.m_field_id_4 member_last_name, d.m_field_id_5 member_address_line_1, d.m_field_id_6 member_address_line_2, d.m_field_id_7 member_address_line_3, d.m_field_id_8 member_town, d.m_field_id_9 member_county, d.m_field_id_10 member_postal_code, d.m_field_id_11 member_country, d.m_field_id_12 member_phone, d.m_field_id_13 member_opt_in_postalmail, d.m_field_id_14 member_opt_in_email, d.m_field_id_15 member_organisation_name, d.m_field_id_16 member_crm_id, d.m_field_id_19 member_last_crm_sync, d.m_field_id_20 member_crm_update_pending, d.m_field_id_21 member_email, d.m_field_id_22 member_crm_memberships, d.m_field_id_23 member_subscribed_with_giftaid, d.m_field_id_24 member_salutation FROM exp_members m, exp_member_data d
WHERE m.member_id = d.member_id
AND m.member_id = 2191
#Sync.php L:30 MillsApp\Cms\Connectors\Eecms\Profile::get()
0.0011 SHOW TABLES FROM 'millsarc_dev_ee'
#CI/database/DB_driver.php L:848 CI_DB_driver::list_tables()
0.0004 select * from 'exp_store_config' where 'site_id' = '1'
#Connection.php L:547 Illuminate\CodeIgniter\CodeIgniterConnection::Illuminate\CodeIgniter\{closure}()
0.0003 SELECT *
FROM ('exp_security_hashes')
WHERE 'session_id' = '81e9be8746541d2b95b54a318ac00ab5709b83a3'
#APP/libraries/csrf/Database.php L:81 Csrf_database::fetch_token()
0.0003 SELECT 'snippet_name', 'snippet_contents'
FROM ('exp_snippets')
WHERE (site_id = 1 OR site_id = 0)
#APP/libraries/Core.php L:382 EE_Core::run_ee()
0.0002 SELECT module_id FROM exp_modules WHERE module_name = 'Structure'
#ext.structure.php L:35 Sql_structure::module_is_installed()
0.0023 SELECT 'route_parsed', 'template_name', 'group_name'
FROM ('exp_templates')
JOIN 'exp_template_routes' ON 'exp_templates'.'template_id' = 'exp_template_routes'.'template_id'
JOIN 'exp_template_groups' ON 'exp_templates'.'group_id' = 'exp_template_groups'.'group_id'
WHERE 'route_parsed' is not null
AND 'exp_templates'.'site_id' = '1'
ORDER BY LENGTH(route_parsed), 'group_name', 'template_name' ASC
#APP/libraries/Template_router.php L:83 EE_Template_Router::set_routes()
0.0003 SELECT 'group_id'
FROM ('exp_template_groups')
WHERE 'group_name' = 'sandbox'
AND 'site_id' = '1'
#APP/libraries/Template.php L:1989 EE_Template::parse_template_uri()
0.0004 SELECT 'exp_templates'.*, 'exp_template_groups'.'group_name'
FROM ('exp_templates')
JOIN 'exp_template_groups' ON 'exp_template_groups'.'group_id' = 'exp_templates'.'group_id'
WHERE 'exp_template_groups'.'site_id' = '1'
AND 'exp_templates'.'template_name' = 'index'
AND 'exp_template_groups'.'group_name' = 'sandbox'
#APP/libraries/Template.php L:2320 EE_Template::fetch_template()
0.0006 SELECT 'cat_url_title', 'cat_id', 'parent_id', 'group_id', 'cat_name', 'cat_description', 'cat_image'
FROM ('exp_categories')
WHERE 'site_id' = '1'
AND 'cat_url_title' IN ('sandbox')
#ext.low_seg2cat.php L:446 Low_seg2cat_ext::_add_vars()
0.0002 SELECT 'module_version', 'module_name'
FROM ('exp_modules')
#APP/libraries/Template.php L:1317 EE_Template::process_tags()
0.0002 SELECT 'settings'
FROM ('exp_extensions')
WHERE 'class' = 'Low_search_ext'
LIMIT 1
#Low_search_settings.php L:130 Low_search_settings::get()
0.0007 SELECT 'field_id', 'field_type', 'field_fmt', 'field_name', 'site_id', 'field_settings'
FROM ('exp_channel_fields')
#APP/libraries/api/Api_channel_fields.php L:150 Api_channel_fields::fetch_custom_channel_fields()
0.0005 SELECT 'parent_id' AS entry_id
FROM ('exp_relationships')
WHERE 'child_id' IN ('163691')
AND 'field_id' = '251'
#lsf.relationships.php L:135 Low_search_filter_relationships::filter()
0.0002 SELECT 'parent_id' AS entry_id
FROM ('exp_relationships')
WHERE 'child_id' IN ('163691')
AND 'parent_id' IN ('152137', '146326', '146300')
AND 'field_id' = '249'
#lsf.relationships.php L:135 Low_search_filter_relationships::filter()
0.0003 SELECT 'variable_name', 'variable_data'
FROM ('exp_global_variables')
WHERE 'site_id' = '1'
#APP/libraries/Template.php L:2989 EE_Template::parse_globals()
0.0002 SELECT action_id, class, method FROM exp_actions WHERE (class= 'Low_search' AND method = 'catch_search')
#APP/libraries/Template.php L:3203 EE_Functions::insert_action_ids()
HTTP HEADERS (Hide)
HTTP_ACCEPT text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
HTTP_USER_AGENT Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_2) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.87 Safari/537.36
HTTP_CONNECTION keep-alive
SERVER_PORT 80
SERVER_NAME millsarchive.dev
REMOTE_ADDR ::1
SERVER_SOFTWARE Apache
HTTP_ACCEPT_LANGUAGE en-US,en;q=0.8,de;q=0.6
SCRIPT_NAME /index.php
REQUEST_METHOD GET
HTTP_HOST
REMOTE_HOST
CONTENT_TYPE
SERVER_PROTOCOL HTTP/1.1
QUERY_STRING child:catalogue_related_timeline=163691&child:entry_related_timeline=163691
HTTP_ACCEPT_ENCODING gzip, deflate, sdch
HTTP_X_FORWARDED_FOR
SESSION DATA (Hide)
username paulcripps
screen_name Paul Cripps
email paul@ninefour.co.uk
url
location
language english
timezone UTC
date_format %j-%n-%y
time_format eu
include_seconds n
group_id 1
access_cp 0
last_visit 1458657549
is_banned
ignore_list Array ( )
member_id 2191
password 9614385eeb8e557edc1dcb1f9369a9806fc7d06842b5daa385045a60b80bfe8452fac956259488ec5e8186341c953c7ceadd76509c41944b8ed5ce088fbb238b
unique_id ab7cd589d6c1468c11496a3b8fbb5c4066038156
authcode
occupation
interests
bday_d 0
bday_m 0
bday_y 0
aol_im
yahoo_im
msn_im
icq
bio
signature
avatar_filename
avatar_width 0
avatar_height 0
photo_filename
photo_width 0
photo_height 0
sig_img_filename
sig_img_width 0
sig_img_height 0
private_messages 0
accept_messages y
last_view_bulletins 0
last_bulletin_date 0
ip_address ::1
join_date 1380275438
last_activity 1458668002
total_entries 49
total_comments 0
total_forum_topics 0
total_forum_posts 0
last_entry_date 1457697658
last_comment_date 1384335842
last_forum_post_date 0
last_email_date 0
in_authorlist n
accept_admin_email y
accept_user_email y
notify_by_default y
notify_of_pm y
display_avatars n
display_signatures n
parse_smileys y
smart_notifications y
cp_theme
profile_theme
forum_theme
tracker
template_size 28
notepad
notepad_size 18
quick_links My Site|http://www.millsarchivetrust.org/|1
quick_tabs Structure|C=addons_modules&M=show_module_cp&module=structure|1 Forms|C=addons_modules&M=show_module_cp&module=freeform|2
show_sidebar n
pmember_id 0
salt J)J"2X[-pu6KvVBn_cnJp64wW%ySD:&?B?B{EAB"0f+R]Gm!1pftHOS":o]Cq@IQqc?C)c_;LaYkJn>D)3Q)A4_8U8?bR=Hc-4Gu72tzltSA%NYB!yF_Gw"N"t49n6}{
site_id 1
group_title Super Admins
group_description
is_locked y
can_view_offline_system y
can_view_online_system y
can_access_cp y
can_access_content y
can_access_publish y
can_access_edit y
can_access_files y
can_access_fieldtypes y
can_access_design y
can_access_addons y
can_access_modules y
can_access_extensions y
can_access_accessories y
can_access_plugins y
can_access_members y
can_access_comm y
can_access_utilities y
can_access_data y
can_access_logs y
can_access_admin y
can_access_sys_prefs y
can_access_content_prefs y
can_access_tools y
can_admin_channels y
can_admin_upload_prefs n
can_admin_design y
can_admin_members y
can_delete_members y
can_admin_mbr_groups y
can_admin_mbr_templates y
can_ban_users y
can_admin_modules y
can_admin_templates y
can_edit_categories y
can_delete_categories y
can_view_other_entries y
can_edit_other_entries y
can_assign_post_authors y
can_delete_self_entries y
can_delete_all_entries y
can_view_other_comments y
can_edit_own_comments y
can_delete_own_comments y
can_edit_all_comments y
can_delete_all_comments y
can_moderate_comments y
can_send_email y
can_send_cached_email y
can_email_member_groups y
can_email_mailinglist y
can_email_from_profile y
can_view_profiles y
can_edit_html_buttons y
can_delete_self y
mbr_delete_notify_emails
can_post_comments y
exclude_from_moderation y
can_search y
search_flood_control 0
can_send_private_messages y
prv_msg_send_limit 20
prv_msg_storage_limit 60
can_attach_in_private_messages y
can_send_bulletins y
include_in_authorlist n
include_in_memberlist n
include_in_mailinglists y
total_forum_replies 0
display_photos n
session_id 81e9be8746541d2b95b54a318ac00ab5709b83a3
fingerprint 2f5757314f007e6527af6b33ed037bc1
admin_sess 1
user_agent Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_2) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.87 Safari/537.36
sess_start 1458667608
member_group 1
CONFIG VARIABLES (Hide)
image_resize_protocol gd2
image_library_path
thumbnail_prefix thumb
word_separator dash
use_category_name y
reserved_category_word category
auto_convert_high_ascii n
new_posts_clear_caches y
auto_assign_cat_parents y
site_404 global/404
save_tmpl_revisions n
max_tmpl_revisions 0
save_tmpl_files y
tmpl_file_basepath /Users/Shared/Sites/millsarchive/development/templates/
strict_urls y
enable_template_routes y
un_min_len 4
pw_min_len 5
allow_member_registration y
allow_member_localization n
req_mbr_activation none
new_member_notification y
mbr_notification_emails liz.bartram@millsarchive.org
require_terms_of_service n
use_membership_captcha n
default_member_group 2
profile_trigger 56f1820825bc9
member_theme default
enable_avatars n
allow_avatar_uploads n
avatar_url /images/avatars/
avatar_path /Users/Shared/Sites/millsarchive/development/images/avatars/
avatar_max_width 100
avatar_max_height 100
avatar_max_kb 50
enable_photos n
photo_url /images/member_photos/
photo_path /Users/Shared/Sites/millsarchive/development/images/member_photos/
photo_max_width 100
photo_max_height 100
photo_max_kb 50
allow_signatures n
sig_maxlength 500
sig_allow_img_hotlink n
sig_allow_img_upload n
sig_img_url /images/signature_attachments/
sig_img_path /Users/Shared/Sites/millsarchive/development/images/signature_attachments/
sig_img_max_width 480
sig_img_max_height 80
sig_img_max_kb 30
prv_msg_upload_path /Users/Shared/Sites/millsarchive/development/images/pm_attachments/
prv_msg_max_attachments 3
prv_msg_attach_maxsize 250
prv_msg_attach_total 100
prv_msg_html_format safe
prv_msg_auto_links y
prv_msg_max_chars 6000
memberlist_order_by screen_name
memberlist_sort_order desc
memberlist_row_limit 50
mailinglist_enabled y
mailinglist_notify y
mailinglist_notify_emails admin@millsarchivetrust.com
encryption_type sha1
site_index index.php
site_name The Mills Archive
site_url http://millsarchive.dev/
theme_folder_url /themes/
webmaster_email admin@millsarchive.org
webmaster_name Mills Archive Trust
weblog_nomenclature weblog
max_caches 150
captcha_url /images/captchas/
captcha_path /Users/Shared/Sites/millsarchive/development/images/captchas/
captcha_font n
captcha_rand y
captcha_require_members y
enable_db_caching n
enable_sql_caching n
force_query_string n
template_debugging y
include_seconds n
cookie_domain millsarchive.dev
cookie_path
allow_username_change y
allow_multi_logins y
password_lockout y
password_lockout_interval 1
require_ip_for_login y
require_ip_for_posting y
allow_multi_emails n
require_secure_passwords n
allow_dictionary_pw y
name_of_dictionary_file
xss_clean_uploads n
redirect_method redirect
deft_lang english
xml_lang en
charset UTF-8
send_headers y
gzip_output y
log_referrers n
max_referrers 0
time_format eu
daylight_savings y
default_site_timezone UTC
mail_protocol mail
smtp_server
smtp_username
smtp_password
email_debug y
email_charset utf-8
email_batchmode n
email_batch_size 5
mail_format plain
word_wrap y
email_console_timelock 5
log_email_console_msgs y
cp_theme default
email_module_captchas y
log_search_terms y
deny_duplicate_data y
redirect_submitted_links y
enable_censoring n
censored_words
censor_replacement
banned_ips
banned_emails
banned_usernames
banned_screen_names
ban_action restrict
ban_message This site is currently unavailable
ban_destination http://www.yahoo.com/
enable_emoticons n
emoticon_path http://www.millsarchivetrust.org/imag...
recount_batch_total 1000
remap_pm_urls n
remap_pm_dest
new_version_check y
publish_tab_behavior hover
sites_tab_behavior hover
enable_throttling n
banish_masked_ips y
max_page_loads 10
time_interval 8
lockout_time 30
banishment_type message
banishment_url
banishment_message You have exceeded the allowed page load frequency.
enable_search_log y
max_logged_searches 500
theme_folder_path /Users/Shared/Sites/millsarchive/development/themes/
is_site_on y
show_profiler y
cp_url http://millsarchive.dev/admin/index.php
charge_webhook_key MfnmdOYVdcI5I08Pf6uQkVLxBwTu1d7C
charge_stripe_account_mode test
charge_stripe_test_credentials_sk ZUGUQlCCaJRIX6GZujRAD5psLQt8yXSm
charge_stripe_test_credentials_pk pk_El7eHKSU3GT7flGOu6K7RCon5CnNy
charge_stripe_live_credentials_sk iSKBAYRgsgfrIzufXmKAnXlhXgj0YWMw
charge_stripe_live_credentials_pk pk_7ZPm4Wu4700Y3z6e5Vdby7cdBlYB6
charge_stripe_currency gbp
charge_force_ssl no
charge_metadata_pass yes
emoticon_url /images/smileys/
smtp_port
date_format %j-%n-%y
cp_session_type c
website_session_type c
charge_email_send_from admin@millsarchive.org
charge_email_send_name Mills Archive Trust
charge_email_send_reply_to
charge_email_send_reply_to_name
third_party_path /Users/Shared/Sites/millsarchive/development/third_party
upload_preferences Array ( [1] => Array ( [name] => Images [server_path] => /Users/Shared/Sites/millsarchive/development/images/uploads/ [url] => http://millsarchive.dev/images/uploads/ ) [2] => Array ( [name] => PDF Documents (Legacy) [server_path] => /Users/Shared/Sites/millsarchive/development/images/uploads/documents/ [url] => http://millsarchive.dev/images/upload... ) [3] => Array ( [name] => Article Images (New) [server_path] => /Users/Shared/Sites/millsarchive/development/files/images/articles/ [url] => http://millsarchive.dev/files/images/... ) [4] => Array ( [name] => Shop Product Images (New) [server_path] => /Users/Shared/Sites/millsarchive/development/files/images/shop/ [url] => http://millsarchive.dev/files/images/... ) [5] => Array ( [name] => Shop Digital Downloads (New) [server_path] => /Users/Shared/Sites/millsarchive/development/downloads/shop/ [url] => http://millsarchive.dev/downloads/shop/ ) [7] => Array ( [name] => Books (New) [server_path] => /Users/Shared/Sites/millsarchive/development/files/images/books/ [url] => http://millsarchive.dev/files/images/... ) [9] => Array ( [name] => Common Images (New) [server_path] => /Users/Shared/Sites/millsarchive/development/files/images/common/ [url] => http://millsarchive.dev/files/images/... ) [10] => Array ( [name] => Mills (New) [server_path] => /Users/Shared/Sites/millsarchive/development/files/images/mills/ [url] => http://millsarchive.dev/files/images/... ) [11] => Array ( [name] => Documents (New) [server_path] => /Users/Shared/Sites/millsarchive/development/files/documents/ [url] => http://millsarchive.dev/files/documents/ ) [12] => Array ( [name] => Assets Photos (Admin Only) [server_path] => /Users/Shared/Sites/millsarchive/development/assets/imgs/photos/ [url] => http://millsarchive.dev/assets/img/ph... ) [13] => Array ( [name] => Family History Uploads [server_path] => /Users/Shared/Sites/millsarchive/development/files/uploads/family-history/ [url] => http://millsarchive.dev/files/uploads... ) [14] => Array ( [name] => Timeline [server_path] => /Users/Shared/Sites/millsarchive/development/files/images/timeline/ [url] => http://millsarchive.dev/files/images/... ) [15] => Array ( [name] => Mills Survey [server_path] => /Users/Shared/Sites/millsarchive/development/files/images/mills-survey/ [url] => http://millsarchive.dev/files/images/... ) )
app_version 281
install_lock
license_number 1869-3824-7938-7827
doc_url http://ellislab.com/expressionengine/...
is_system_on y
allow_extensions y
autosave_interval_seconds 0
protect_javascript n
cookie_prefix local
debug 2
enable_online_user_tracking n
enable_hit_tracking n
enable_entry_view_tracking n
dynamic_tracking_disabling n
minimee Array ( [disable] => yes )
cookie_httponly y
index_page index.php
uri_protocol AUTO
url_suffix
language english
enable_hooks
subclass_prefix EE_
permitted_uri_chars a-z 0-9~%.:_\-
enable_query_strings
directory_trigger D
controller_trigger C
function_trigger M
log_threshold 0
log_path
log_date_format Y-m-d H:i:s
cache_path /Users/Shared/Sites/millsarchive/development//cache
encryption_key Th3M1ll5Arch1v3
global_xss_filtering
csrf_protection
compress_output 1
time_reference local
rewrite_short_tags 1
proxy_ips
template_group global
template index
cookie_secure n
stripe_key MfnmdOYVdcI5I08Pf6uQkVLxBwTu1d7C
crm_credentials Array ( [url] => http://server1.donorstrategy.com:8218... [username] => APIUSER [password] => changeme [dbname] => MillArchiveCopy )
queue_credentials Array ( [token] => gui1G5Z5txidOXh3TDt6dr2YT9E [project_id] => 5304cdd078ce230009000025 [queue] => DevCRM [encryption_key] => 8hUx8g53w60F69f [host] => mq-aws-eu-west-1.iron.io )
global_vars Array ( [store_stripe_public_key] => pk_El7eHKSU3GT7flGOu6K7RCon5CnNy [site_mode] => dev )
site_pages Array ( [1] => Array ( [url] => http://millsarchive.dev/index.php/ [uris] => Array ( [158712] => /research-competition/ [158715] => /research-competition/rules-for-the-mills-archive-research-competition/ [91533] => /explore/ [100978] => /explore/images-and-documents/ [100974] => /explore/mills/ [164867] => /explore/mills/explore-mills-survey/ [100972] => /explore/people/ [100975] => /explore/library/ [91536] => /explore/features-and-articles/ [164232] => /explore/explore-timeline/ [100976] => /explore/resources/ [100980] => /explore/glossary/ [155154] => /explore/historic-counties/ [91507] => /about/ [158100] => /about/aims/ [91511] => /about/the-trust/ [158137] => /about/the-trust/financial-history/ [158101] => /about/the-work-of-the-archive/ [158102] => /about/collections-policy/ [91516] => /about/projects/ [91517] => /about/collaborators/ [91509] => /services/ [91518] => /services/research/ [111615] => /services/research/request/ [91519] => /services/the-library-and-research-centre/ [91521] => /services/high-resolution-images/ [101447] => /services/family-history/ [111598] => /services/family-history/submit-new-information/ [111727] => /services/free-services/ [91510] => /support/ [91522] => /support/donate/ [91548] => /support/donate/thanks/ [101412] => /support/donating-your-collection/ [91527] => /support/friends-of-the-mills-archive/ [101411] => /support/archive-patrons/ [91526] => /support/heritage-partners-and-corporate-friends/ [101409] => /support/heritage-partners-and-corporate-friends/heritage-partners/ [101410] => /support/heritage-partners-and-corporate-friends/corporate-friends/ [91523] => /support/appeals/ [91524] => /support/gifts-in-wills/ [101449] => /support/gifts-in-wills/leaving-us-your-collection/ [101450] => /support/gifts-in-wills/dedicated-bequests-and-lifetime-gifts/ [91525] => /support/trusts-and-foundations/ [164264] => /support/our-fundraising-promise/ [91528] => /support/volunteering/ [111566] => /support/volunteering/the-volunteer-experience/ [164265] => /contact/our-complaints-policy/ [101132] => /shop/ [101131] => /news/ [101135] => /news/archive/ [101133] => /news/submit-topic/ [91508] => /contact/ [101448] => /contact/make-a-general-enquiry/ [101126] => /contact/preparing-for-your-visit/ [158606] => /contact/preparing-for-your-visit/access-to-the-mills-archive-in-watlington-house/ [158723] => /contact/preparing-for-your-visit/book-an-appointment/ [101127] => /contact/ask-a-research-question/ [101128] => /contact/contact-our-family-history-team/ [91530] => /cookie-policy/ [158121] => /terms-and-conditions/ [158903] => /parking/ [165104] => /support/heritage-partners-and-corporate-friends/list-of-heritage-partners-and-corporate-friends/ [165246] => /survey-copyright-statement/ [165338] => /explore/mills/explore-mills-survey/instructions/ ) [templates] => Array ( [] => 79 [91507] => 269 [91508] => 265 [91509] => 268 [91510] => 267 [91511] => 269 [91516] => 269 [91517] => 269 [91518] => 268 [91519] => 268 [91521] => 268 [91522] => 295 [91523] => 294 [91524] => 267 [91525] => 267 [91526] => 267 [91527] => 267 [91528] => 267 [91533] => 270 [91536] => 570 [91548] => 295 [100972] => 322 [100974] => 308 [100975] => 323 [100976] => 456 [100978] => 502 [100980] => 455 [101126] => 265 [101127] => 502 [101128] => 502 [101131] => 680 [101132] => 264 [101133] => 671 [101135] => 674 [101409] => 267 [101410] => 267 [101411] => 267 [101412] => 267 [101447] => 268 [101448] => 587 [101449] => 267 [101450] => 267 [111566] => 267 [111598] => 590 [111615] => 589 [111727] => 268 [155154] => 274 [158100] => 269 [158101] => 269 [158102] => 269 [91530] => 274 [158121] => 274 [158137] => 269 [158606] => 265 [158712] => 274 [158715] => 274 [158723] => 265 [158903] => 274 [164232] => 270 [164264] => 274 [164265] => 274 [164867] => 717 [165104] => 274 [165246] => 274 [165338] => 274 ) [0] => Array ( [url] => http://www.millsarchivetrust.org/inde... ) ) )
site_id 1
site_label The Mills Archive
site_description
site_bootstrap_checksums Array ( [emailed] => Array ( ) [/Users/Shared/Sites/millsarchive/development/index.php] => af44ba191934bb8ca3e9cf56c8f908b5 )
site_short_name default_site
output_charset utf-8
base_url http://millsarchive.dev/
secure_forms y
store_cart_expiry 1440
store_cc_payment_method purchase
store_conversion_tracking_extra
store_currency_code GBP
store_currency_dec_point .
store_currency_decimals 2
store_currency_suffix
store_currency_symbol £
store_currency_thousands_sep ,
store_default_country GB
store_default_order_address shipping_same_as_billing
store_default_shipping_method_id 1
store_default_state
store_dimension_units mm
store_unofficial_payment_gateways 0
store_force_member_login 0
store_from_email shop@millsarchive.org
store_from_name Mills Archive
store_google_analytics_ecommerce 0
store_order_fields Array ( [billing_first_name] => Array ( [member_field] => m_field_id_2 ) [billing_last_name] => Array ( [member_field] => m_field_id_4 ) [billing_address1] => Array ( [member_field] => m_field_id_5 ) [billing_address2] => Array ( [member_field] => m_field_id_6 ) [billing_city] => Array ( [member_field] => m_field_id_8 ) [billing_state] => Array ( [member_field] => m_field_id_9 ) [billing_country] => Array ( [member_field] => m_field_id_11 ) [billing_postcode] => Array ( [member_field] => m_field_id_10 ) [billing_phone] => Array ( [member_field] => m_field_id_12 ) [billing_company] => Array ( [member_field] => m_field_id_15 ) [shipping_first_name] => Array ( [member_field] => m_field_id_2 ) [shipping_last_name] => Array ( [member_field] => m_field_id_4 ) [shipping_address1] => Array ( [member_field] => m_field_id_5 ) [shipping_address2] => Array ( [member_field] => m_field_id_6 ) [shipping_city] => Array ( [member_field] => m_field_id_8 ) [shipping_state] => Array ( [member_field] => m_field_id_9 ) [shipping_country] => Array ( [member_field] => m_field_id_11 ) [shipping_postcode] => Array ( [member_field] => m_field_id_10 ) [shipping_phone] => Array ( [member_field] => m_field_id_12 ) [shipping_company] => Array ( [member_field] => m_field_id_15 ) [order_email] => Array ( [member_field] => ) [order_c
Low 23 Mar 2016 09:32
I can see the queries being generated look good:
and
The combination of the two result in No Results, so that would indicate that there are no entries that have that particular entry selected in both fields.
Are the fields in the same channel?
Paul Cripps 23 Mar 2016 09:41
ok - to clarify - each field is from a different channel - so there would never be entries with both fields.
It need to get all entries where field_id = 251 OR field_id = 249
Is this possible?
Low 23 Mar 2016 10:06
Ah, there's the rub.
No, combining parameters with OR isn't possible without the use of a custom extension or filter.
Parameters are always combined with AND, as per how all parameters across EE work.