bamaer opened a new issue, #8629: URL: https://github.com/apache/hop/issues/8629
### What needs to happen? PgVector search turns every filter into column = ?. When a row's filter field is null or empty, the query binds NULL or "", matches nothing, and returns zero results without any warning. Optional filters, such as a category a user may leave blank, can't be expressed today. Proposed: * PgVector search: add a per-filter "Skip if empty" option (skip_if_empty, default N, so existing pipelines are unchanged). When it's set, that filter is left out of the WHERE clause for rows where its value is null or empty. The option is per filter so that required filters, such as a tenant or access-control column, always apply and can't widen a search. * Docs, Language Model Chat and AI Provider: document that when an AI Provider is set, its settings override the transform's inline settings: model type, base URL, API key, CHAT model, timeout and temperature. Inline values are only used as fallbacks when a provider field is empty. Also correct the AI Provider page, which says the transform can override the model; that is true for the embedding transforms, but not for Language Model Chat. ### Issue Priority Priority: 2 ### Issue Component Component: Transforms, Component: Documentation -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
