Geller
Stony Creek COnsulting, LLC
Hi,
I discovered it was easy enough to update the fabrik_elements table, params column, to set the "inc_in_adv_search":1, string to "inc_in_adv_search":0, and this is how the params value looked before the change. Reason I include this is I found after changing the string, the element was not included in the Advanced Search which was great as I did this for all but the elements showing in the list so a user would not get overwhelmed by the number of selections.
{"rollover":"","comment":"","sub_default_value":"","sub_default_label":"","element_before_label":1,"allow_frontend_addtocheckbox":0,"database_join_display_type":"dropdown","joinType":"simple","join_conn_id":-1,"date_table_format":"Y-m-d","date_form_format":"Y-m-d H:i:s","date_showtime":0,"date_time_format":"H:i","date_defaulttotoday":1,"date_firstday":0,"multiple":0,"allow_frontend_addtodropdown":0,"password":0,"maxlength":255,"text_format":"text","integer_length":6,"decimal_length":2,"guess_linktype":0,"disable":0,"readonly":0,"ul_max_file_size":16000,"ul_email_file":0,"ul_file_increment":0,"upload_allow_folderselect":1,"fu_fancy_upload":0,"upload_delete_image":1,"make_link":0,"fu_show_image_in_table":0,"image_library":"gd2","make_thumbnail":0,"imagepath":"\/","selectImage_root_folder":"\/","image_front_end_select":0,"show_image_in_table":0,"image_float":"none","link_target":"_self","radio_element_before_label":0,"options_per_row":4,"ck_options_per_row":4,"allow_frontend_addtoradio":0,"use_wysiwyg":0,"my_table_data":"id","update_on_edit":0,"view_access":1,"show_in_rss_feed":0,"show_label_in_rss_feed":0,"icon_folder":-1,"use_as_row_class":0,"filter_access":1,"full_words_only":0,"inc_in_adv_search":0,"sum_on":0,"sum_access":0,"avg_on":0,"avg_access":0,"median_on":0,"median_access":0,"count_on":0,"count_access":0}
When I took the same approach to the params string "include_in_list_query":"0", since I use only ten of the close to 300 elements in this List I needed to speed up the queries as they are very slow, and huge when dumped in a debug as so many elements are needlessly being included. I then noticed this params string is only in several elements I had manually set this from the default of Yes or 1 to No or 0. Then I noticed in the above the string was not there. I changed the value to No or 0 using Fabril and now this is the table cell's params value for the same element:
{"bootstrap_class":"input-medium","width":"40","height":"6","textarea_showlabel":"1","textarea_placeholder":"","use_wysiwyg":"0","wysiwyg_extra_buttons":"1","textarea-showmax":"0","textarea-maxlength":"255","textarea_limit_type":"char","textarea-tagify":"0","textarea_tagifyurl":"","textarea-truncate-where":"0","textarea-truncate-html":"0","textarea-truncate":"0","textarea-hover":"1","textarea_hover_location":"top","show_in_rss_feed":"0","show_label_in_rss_feed":"0","use_as_rss_enclosure":"0","rollover":"","tipseval":"0","tiplocation":"top-left","labelindetails":"0","labelinlist":"0","comment":"","edit_access":"1","edit_access_user":"","view_access":"1","view_access_user":"","list_view_access":"1","encrypt":"0","store_in_db":"1","can_order":"0","alt_list_heading":"","custom_link":"","custom_link_target":"","custom_link_indetails":"1","use_as_row_class":"0","include_in_list_query":"0","always_render":"0","icon_hovertext":"1","icon_file":"","icon_subdir":"","filter_length":"20","filter_access":"1","full_words_only":"0","filter_required":"0","filter_build_method":"0","filter_groupby":"text","inc_in_adv_search":"0","filter_class":"input-medium","filter_responsive_class":"","tablecss_header_class":"","tablecss_header":"","tablecss_cell_class":"","tablecss_cell":"","sum_on":"0","sum_label":"Sum","sum_access":"1","sum_split":"","avg_on":"0","avg_label":"Average","avg_access":"1","avg_round":"0","avg_split":"","median_on":"0","median_label":"Median","median_access":"1","median_split":"","count_on":"0","count_label":"Count","count_condition":"","count_access":"1","count_split":"","custom_calc_on":"0","custom_calc_label":"Custom","custom_calc_query":"","custom_calc_access":"1","custom_calc_split":"","custom_calc_php":"","validations":[]}
It appears the use of the Fabrik component to update a default of Yes to No for the element added many other strings to the params string, including the missing "include_in_list_query":"0", string. If the string was included by default in the original params for the element as "include_in_list_query":"1", (which keeps it working the way it does now) would allow changing it as easily as I did to change the "inc_in_adv_search":1, string in params to "inc_in_adv_search":0, it would alleviate what appears to be having to manually submit close to 300 elements to add the string to params and change it to 0.
My question is: Is there any way to add the "inc_in_adv_search":1, string to params and have Fabrik recognize it as being disabled. My assumption is it has to have the same format as the second params value above. Or is there an easier way to do this as I am sure the params must vary somewhat by element.
Sincerely
Stony Creek Consulting, LLC
Joseph J. Geller
I discovered it was easy enough to update the fabrik_elements table, params column, to set the "inc_in_adv_search":1, string to "inc_in_adv_search":0, and this is how the params value looked before the change. Reason I include this is I found after changing the string, the element was not included in the Advanced Search which was great as I did this for all but the elements showing in the list so a user would not get overwhelmed by the number of selections.
{"rollover":"","comment":"","sub_default_value":"","sub_default_label":"","element_before_label":1,"allow_frontend_addtocheckbox":0,"database_join_display_type":"dropdown","joinType":"simple","join_conn_id":-1,"date_table_format":"Y-m-d","date_form_format":"Y-m-d H:i:s","date_showtime":0,"date_time_format":"H:i","date_defaulttotoday":1,"date_firstday":0,"multiple":0,"allow_frontend_addtodropdown":0,"password":0,"maxlength":255,"text_format":"text","integer_length":6,"decimal_length":2,"guess_linktype":0,"disable":0,"readonly":0,"ul_max_file_size":16000,"ul_email_file":0,"ul_file_increment":0,"upload_allow_folderselect":1,"fu_fancy_upload":0,"upload_delete_image":1,"make_link":0,"fu_show_image_in_table":0,"image_library":"gd2","make_thumbnail":0,"imagepath":"\/","selectImage_root_folder":"\/","image_front_end_select":0,"show_image_in_table":0,"image_float":"none","link_target":"_self","radio_element_before_label":0,"options_per_row":4,"ck_options_per_row":4,"allow_frontend_addtoradio":0,"use_wysiwyg":0,"my_table_data":"id","update_on_edit":0,"view_access":1,"show_in_rss_feed":0,"show_label_in_rss_feed":0,"icon_folder":-1,"use_as_row_class":0,"filter_access":1,"full_words_only":0,"inc_in_adv_search":0,"sum_on":0,"sum_access":0,"avg_on":0,"avg_access":0,"median_on":0,"median_access":0,"count_on":0,"count_access":0}
When I took the same approach to the params string "include_in_list_query":"0", since I use only ten of the close to 300 elements in this List I needed to speed up the queries as they are very slow, and huge when dumped in a debug as so many elements are needlessly being included. I then noticed this params string is only in several elements I had manually set this from the default of Yes or 1 to No or 0. Then I noticed in the above the string was not there. I changed the value to No or 0 using Fabril and now this is the table cell's params value for the same element:
{"bootstrap_class":"input-medium","width":"40","height":"6","textarea_showlabel":"1","textarea_placeholder":"","use_wysiwyg":"0","wysiwyg_extra_buttons":"1","textarea-showmax":"0","textarea-maxlength":"255","textarea_limit_type":"char","textarea-tagify":"0","textarea_tagifyurl":"","textarea-truncate-where":"0","textarea-truncate-html":"0","textarea-truncate":"0","textarea-hover":"1","textarea_hover_location":"top","show_in_rss_feed":"0","show_label_in_rss_feed":"0","use_as_rss_enclosure":"0","rollover":"","tipseval":"0","tiplocation":"top-left","labelindetails":"0","labelinlist":"0","comment":"","edit_access":"1","edit_access_user":"","view_access":"1","view_access_user":"","list_view_access":"1","encrypt":"0","store_in_db":"1","can_order":"0","alt_list_heading":"","custom_link":"","custom_link_target":"","custom_link_indetails":"1","use_as_row_class":"0","include_in_list_query":"0","always_render":"0","icon_hovertext":"1","icon_file":"","icon_subdir":"","filter_length":"20","filter_access":"1","full_words_only":"0","filter_required":"0","filter_build_method":"0","filter_groupby":"text","inc_in_adv_search":"0","filter_class":"input-medium","filter_responsive_class":"","tablecss_header_class":"","tablecss_header":"","tablecss_cell_class":"","tablecss_cell":"","sum_on":"0","sum_label":"Sum","sum_access":"1","sum_split":"","avg_on":"0","avg_label":"Average","avg_access":"1","avg_round":"0","avg_split":"","median_on":"0","median_label":"Median","median_access":"1","median_split":"","count_on":"0","count_label":"Count","count_condition":"","count_access":"1","count_split":"","custom_calc_on":"0","custom_calc_label":"Custom","custom_calc_query":"","custom_calc_access":"1","custom_calc_split":"","custom_calc_php":"","validations":[]}
It appears the use of the Fabrik component to update a default of Yes to No for the element added many other strings to the params string, including the missing "include_in_list_query":"0", string. If the string was included by default in the original params for the element as "include_in_list_query":"1", (which keeps it working the way it does now) would allow changing it as easily as I did to change the "inc_in_adv_search":1, string in params to "inc_in_adv_search":0, it would alleviate what appears to be having to manually submit close to 300 elements to add the string to params and change it to 0.
My question is: Is there any way to add the "inc_in_adv_search":1, string to params and have Fabrik recognize it as being disabled. My assumption is it has to have the same format as the second params value above. Or is there an easier way to do this as I am sure the params must vary somewhat by element.
Sincerely
Stony Creek Consulting, LLC
Joseph J. Geller