Help with Search_indexing.conf
HI,
in the object search mask I have to add the possibility to search also for some metadata of the entities, both in direct relationships with the entities and in relation to the occurrences so the path will be:
# ------------------------------------
ca_entities = {
tables = {
entities = [ca_objects_x_entities],
occurrences = [ca_objects_x_occurrences, ca_occurrences, ca_entities_x_occurrences]
},
fields = {
entity_id = { DONT_INCLUDE_IN_SEARCH_FORM },
type_id = { STORE },
idno = { STORE, DONT_TOKENIZE, INDEX_AS_IDNO, BOOST = 100 },
_count = { },
_ca_attribute_intest_author = {},
_ca_attribute_autv = {}
}
},
the metadata I want to add in search are intest_autor and autv.
My problem is that if I add _metadata as a special key it works, but the indexing takes 10 days which is unacceptable for a production system and in any case I index more than I need; but if I add with syntax "_ca_attribute_"element_code", in the interface I see the searchable fields that have disappeared so I suppose something went wrong...
If instead I use the syntax without underscores I get a php error:
[20-May-2023 04:06:55 America/New_York] PHP Fatal error: Uncaught DatabaseException: Unknown column 't2.ca_attribute_intest_autor' in 'field list' in /data/www/html/cola/app/lib/Db/ mysqli.php:316
what is the correct syntax to use?
can you help me please?
Comments
google translate changed the metadata name, the correct one is: intest_autor and autv
fields = {
entity_id = { DONT_INCLUDE_IN_SEARCH_FORM },
type_id = { STORE },
idno = { STORE, DONT_TOKENIZE, INDEX_AS_IDNO, BOOST = 100 },
_count = { },
_ca_attribute_intest_autor = {},
_ca_attribute_autv = {}
}
I also tried with access points but it didn't work...
#antonio access point
ent_intest_author = {
fields = [ca_entities.intest_autor],
options = { }
},
ent_autv = {
fields = [ca_entities.autv],
options = { }
}
#antonio access point
hi,
providence 1.7.16
I upload search_indexing.conf, I don't see metadata intest_autor and autv as searchable fields in objects search forms,
if I use _metadata works, if I declare the metadata no.
Can you help me?
thanks