Ciao a tutti,

mi aiutate a capire come devo fare per impostare la query per filtrare tutti gli Items che contengono il valore 'News' nel campo ItemComponent.alias? Questo è un estratto dell'array restituito dalla query:

Codice PHP:
[1] => Array
        (
            [
Item] => Array
                (
                    [
title] => FAQ
                
)

            [
ItemType] => Array
                (
                    [
id] => 3
                    
[active] => 1
                    
[ItemComponentsItemType] => Array
                        (
                            [
0] => Array
                                (
                                    [
id] => 5
                                    
[item_component_id] => 8
                                    
[item_type_id] => 3
                                    
[ItemComponent] => Array
                                        (
                                            [
id] => 8
                                            
[title] => TemplateBox
                                            
[active] => 1
                                        
)

                                )

                            [
1] => Array
                                (
                                    [
id] => 16
                                    
[item_component_id] => 1
                                    
[item_type_id] => 3
                                    
[ItemComponent] => Array
                                        (
                                            [
id] => 1
                                            
[title] => News
                                            
[active] => 1
                                        
)

                                )

                        )

                )

        )