I have a view with an exposed filter for biblio keywords. When I enter a keyword autocomplete works correctly but then my query is still saying that kid = 0.
Is the /biblio/autocomplete/biblio_keywords supposed to bring back an id and a name and not just the keyword twice?
This is what it brings back at the moment: { "test": "test", "test2": "test2" } or have I missed out a setting somewhere!?
This is my query when I'm just entering a keyword, if I change it to the id of a keyword it works. but I don't know how to get that information into the query! There's no keyword id field in my list of fields only 'All Keywords'
SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node_data_field_biblio_image.field_biblio_image_fid AS node_data_field_biblio_image_field_biblio_image_fid, node_data_field_biblio_image.field_biblio_image_list AS node_data_field_biblio_image_field_biblio_image_list, node_data_field_biblio_image.field_biblio_image_data AS node_data_field_biblio_image_field_biblio_image_data, node.type AS node_type, node.vid AS node_vid, biblio_type AS biblio_tid, biblio.biblio_custom1 AS biblio_biblio_custom1, biblio.biblio_publisher AS biblio_biblio_publisher, biblio.biblio_abst_e AS biblio_biblio_abst_e, biblio.biblio_custom3 AS biblio_biblio_custom3, biblio.biblio_date AS biblio_biblio_date, biblio.biblio_lang AS biblio_biblio_lang, biblio.biblio_custom2 AS biblio_biblio_custom2, biblio_types.name AS biblio_types_name, biblio_keyword.kid AS biblio_keyword_kid, biblio.vid AS biblio_vid, biblio.biblio_year AS biblio_biblio_year, node_data_field_biblio_image.field_language_pub_value AS node_data_field_biblio_image_field_language_pub_value, node.nid AS node_nid FROM node node INNER JOIN biblio_keyword biblio_keyword ON node.vid = biblio_keyword.vid LEFT JOIN content_type_biblio node_data_field_biblio_image ON node.vid = node_data_field_biblio_image.vid INNER JOIN biblio biblio ON node.vid = biblio.vid LEFT JOIN biblio_types biblio_types ON biblio.biblio_type = biblio_types.tid WHERE (node.status <> 0) AND (node.type in ('biblio')) AND (biblio_keyword.kid = 0) GROUP BY nid ORDER BY node_nid DESC
Comments
Comment #1
apricot13 commentedok so I'm now looking at moving the keywords out of biblio and into a taxonomy I selected a taxonomy to use and it didn't import any keywords? is that correct? from all the other topics I've read (I must have read the lot!) they all seem to import the biblio keywords into the taxonomy. I even tried the suggestion to untick the content type and that didn't work either!
I then need to bring these keywords back in the view so that the exposed filter will work when I try to search for keywords. I'm willing to accept even a text box at this point!
Comment #2
rjerome commentedSorry, I've been busy on another project the last few weeks but I will be focusing all my time on biblio in the coming weeks so I should be able to resolve this soon.
Ron.
Comment #3
apricot13 commentedI understand! A nudge in any direction would be really handy, even if it comes to nothing! :)
I shall keep going through past posts in the mean time!
Comment #4
liam morlandThis version is no longer maintained. If this issue is still relevant to the Drupal 7 version, please re-open and provide details.