Multiple Metadata filters are not working after version upgradation about llama_index HOT 3 OPEN

The issue you're encountering with the MetadataFilters syntax error after upgrading to llama_index version 0.10.34 seems to stem from how the filter expression is constructed, particularly with the combination of filters and the AND condition. The error message pointing to a syntax error at a specific position in the filter expression suggests that the way the condition is being integrated into the query might not align with the expected format by the underlying search service.

To address this, consider the following steps:

1. Verify the Filter Expression Format: Ensure that the filter expression generated by your code matches the expected format, especially where the AND condition is applied. The format should resemble 'key1 eq 'value1' AND key2 eq 'value2''.

2. Test Filters Individually: To isolate the issue, try applying each MetadataFilter separately. This can help determine if the problem lies with a specific filter or the combination thereof.

3. Review Documentation for Changes: Since you've upgraded to a newer version of llama_index, there might have been changes in how filters and conditions should be constructed. The documentation for the version you're using may have updated examples or guidelines.

4. Analyze the Error Message: The specific mention of a syntax error at position 93 in your filter expression provides a clue. Examine what part of the expression corresponds to this position to identify what might be going wrong.

If these steps do not resolve the issue, it could be beneficial to check for any recent updates or patches to llama_index that address known issues with filter expressions. Additionally, considering the complexity of the error and the specificity of the version changes, engaging with the community or support forums for llama_index might provide further insights or solutions from other users who have encountered similar issues.

To continue the conversation, mention @dosu.

from llama_index.

To address the issue with multiple metadata filters not working after upgrading to llama_index version 0.10.34, follow these steps:

1. Ensure Correct Use of Updated Classes: The MetadataFilter and MetadataFilters classes have seen updates. Make sure you're using these correctly, especially with the introduction of strict type checking and a wider range of operators.

2. Replace Deprecated Features: If you're using ExactMatchFilter, replace it with MetadataFilter as per the new version's guidelines.

3. Update Filter Syntax: Utilize FilterOperator and FilterCondition enums for defining your filters to match the new expressive query capabilities.

4. Leverage New Constructors: Use the from_dict and from_dicts methods for creating filter objects more efficiently if your filters are dynamically generated.

5. Compatibility Check: The new version might have limitations with complex filtering. Ensure your filters are compatible with the version's capabilities.

6. Query Construction: Review any changes in how queries are constructed, particularly with the introduction of the VectorStoreQuerySpec class.

7. Review Documentation: Check the official upgrade notes and documentation for version 0.10.34 for any additional insights on breaking changes or new features.

8. Thorough Testing: After making adjustments, thoroughly test your application to ensure all functionalities, especially metadata filters, work as expected.

By following these steps, you should be able to resolve the syntax error and ensure your metadata filters work correctly with the upgraded version and additional libraries.

To continue the conversation, mention @dosu.

from llama_index.

tried below code as well. But getting same error

metadata_filters = MetadataFilters(
filters=[
MetadataFilter(key="l_65c356b6725083ba39975d56", value="True",operator=FilterOperator.EQ),
MetadataFilter(key="file_guid", value="1234",operator=FilterOperator.EQ),
],
condition= FilterCondition.AND
)

from llama_index.