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

Question

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

sivakumarreddy_p · Answer

yaa it's possible,may i know your requirement

tenny · Answer

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 · Answer

it is possible when that relationshiptype is not added in any other item type's relationshiptype

tenny · Answer

please tell me how to do that, thanks.

sivakumarreddy_p · Answer

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 nameRT=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 departmentnProp=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();}

Forum Discussion

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

6 Replies

Recent Discussions

Tech Docs - 'Zoom'

How to populate 'this' properties?

What causes the command bar buttons 'Save' and 'Done' to be greyed out?

Searching against a multi value list data type

Notify User When a Relationship is Added when the Source ItemType and Related ItemType have matching properties