Announcement

Collapse
No announcement yet.

Index on additional fields in many-to-many link

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Index on additional fields in many-to-many link

    How to add index on additional field in many-to-many link? For example on field "role" in account-to-contact link?

    I try add Index: true to additionalColumns in link description. Nothing happens.
    Code:
        "links": {
            "accounts": {
                "additionalColumns": {
                    "role": {
                        "index":true
                    }
                }
            },
    ​
    Last edited by dimyy; 08-29-2022, 07:34 AM.

  • #2
    This should work I believe:

    PHP Code:

        
    "links": {
            
    "accounts": {
                
    "additionalColumns": {
                    
    "role": {
                        
    "type""varchar"
                    
    }
                },
                
    "indexes": {
                    
    "role": {
                        
    "columns": ["role"]
                    }
                }
            }
        }
    ​ 

    Comment

    Working...
    X