Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Layout Editor can't add some module block.
#7
Code:
SELECT name FROM vtiger_tab WHERE isentitytype=1 and name NOT IN ('Rss','Recyclebin','Events');

Give:

"Accounts"
"Assets"
"Calendar"
"Campaigns"
"cbCalendar"
"cbMap"
"cbTermConditions"
"cbtranslation"
"cbupdater"
"CobroPago"
"Contacts"
"Documents"
"Emails"
"Faq"
"GlobalVariable"
"HelpDesk"
"InventoryDetails"
"Invoice"
"Leads"
"ModComments"
"PBXManager"
"Potentials"
"PriceBooks"
"Products"
"Project"
"ProjectMilestone"
"ProjectTask"
"PurchaseOrder"
"Quotes"
"SalesOrder"
"ServiceContracts"
"Services"
"SMSNotifier"
"Vendors"
"Webmails"

Code:
from vtiger_relatedlists
left join vtiger_tab on vtiger_relatedlists.related_tabid = vtiger_tab.tabid and vtiger_tab.presence = 0
where vtiger_relatedlists.tabid = 26 order by sequence


give (attach also screenshut):

"83";"26";"4";"get_contacts";"1";"Contacts";"0";"add,select";NULL;"N:N";"4";"Contacts";"0";"6";"Contacts";NULL;NULL;"0";"0";"1";NULL;"Sales"

"84";"26";"7";"get_leads";"2";"Leads";"0";"add,select";NULL;"N:N";"7";"Leads";"0";"4";"Leads";NULL;NULL;"0";"0";"1";NULL;"Sales"
"85";"26";"2";"get_dependents_list";"3";"Potentials";"0";"add";"121";"1:N";"2";"Potentials";"0";"7";"Potentials";NULL;NULL;"0";"0";"1";NULL;"Sales"
"86";"26";"64";"get_activities";"4";"Activities";"0";"add";"821";"1:N";"64";"cbtranslation";"0";"-1";"cbtranslation";NULL;NULL;"1";"0";"1";"0";"Settings"
"88";"26";"6";"get_accounts";"5";"Accounts";"0";"add,select";NULL;"N:N";"6";"Accounts";"0";"5";"Accounts";NULL;NULL;"0";"0";"1";NULL;"Sales"
"123";"26";"42";"get_dependents_list";"6";"CobroPago";"0";"ADD";"586";"1:N";NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL
"177";"26";"26";"get_dependents_list";"7";"Campaigns";"0";"ADD";"849";"1:N";"26";"Campaigns";"0";"-1";"Campaigns";NULL;NULL;"0";"0";"1";NULL;"Marketing"


Relation ID 123 look weird ?!

Thanks


Attached Files Image(s)
   
Reply


Messages In This Thread
RE: Layout Editor can't add some module block. - addady2 - 06-01-2018, 06:03 AM

Forum Jump:


Users browsing this thread: 5 Guest(s)