Forum Discussion

Ideator I

7 years ago

How can I hide some columns in relationship grid base on the some rule of parent item type

I need to hide some columns in relationship grid base on the some rules of parent item type when form on populated. Is it possible?

SivaKumarReddy_P

Ideator I

6 years ago

yaa it's possible,may i know your requirement

Ideator I

6 years ago

I have a property department in parent item type,I would like to hide some columns in relationship grid depends on department property when the form on populated event.

SivaKumarReddy_P
Ideator I
6 years ago
it is possible when that relationshiptype is not added in any other item type's relationshiptype
- tenny
  Ideator I
  6 years ago
  please tell me how to do that, thanks.
  - SivaKumarReddy_P
    Ideator I
    6 years ago
    Hi tenny,
    
    Hope this is useful.
    
    var inn=new Innovator();
    var cType=document.thisItem.getType();
    
    var iType=inn.newItem("ItemType","get");
    iType.setAttribute("where","[ItemType].name='"+cType+"'");
    iType=iType.apply();
    
    var RT=inn.newItem("RelationshipType","get");
    RT.setAttribute("where","[RelationshipType].source_id='"+iType.getID()+"' and [relationshiptype].name=''");//relationship type name
    RT=RT.apply();
    var relId=RT.getProperty("related_id");
    
    var nProp=inn.newItem("Property","get");
    nProp.setAttribute("where","[Property].source_id='"+relid+"' and [property].name='property name'");//say department
    nProp=nProp.apply();
    
    if(document.thisItem.getProperty("say department")==="")//give your dept name
    {
    nProp.setAction("edit");
    nProp.setProperty("is_hidden2","1");
    nProp=nProp.apply();
    }
    else{
    nProp.setAction("edit");
    nProp.setProperty("is_hidden2","0");
    nProp=nProp.apply();
    aras.clearClientMetadataCache();
    }