dhruvpsaru/tis_spock.md

## tis_spock.md

      
    Raw
  

              tis_spock.md
            
          
    insert  into field_mapping ("altKeys" , "dbKey" , "fieldKey" , "fieldType" , label , "templateId" , visibility , "communityId" )
						values(['w.tisNewField1'], ['pretrialreportdate_date_32f53a6c'], 'w_tisNewField', 'STRING', 'Workkard Tis field1', [0], 'public', 396);

alter table workkards add column "w_tisNewField1" string;

spock.custom_field_refresh
{
   "org_id": 396
}