Advertisement
Guest User

Untitled

a guest
Feb 25th, 2020
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. $cvid = SELECT cvid FROM vtiger_customview WHERE viewname = 'All' AND entitytype = 'Payments'
  2. $lastIndex = SELECT columnindex FROM vtiger_cvcolumnlist WHERE cvid = 157 ORDER BY columnindex DESC LIMIT 1
  3.  
  4. INSERT INTO vtiger_cvcolumnlist (cvid, columnindex, columnname) VALUES ($cvid, $lastIndex + 1, 'vtiger_payments:operation_type:operation_type:Payments_Operation_Type:V')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement