Skip to content

Instantly share code, notes, and snippets.

View joebordes's full-sized avatar

Joe Bordes joebordes

View GitHub Profile
@joebordes
joebordes / BusinessQuestion.csv
Created May 14, 2020 21:53
react table corebos question
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 2.
"Name Text","Question No","Type","Status","SQL Query","Collection","Module","Page Size","Assigned To","Created By","Created Time","Modified Time","Columns","Condition","Description","Order by Column","Group by Column","Type Properties","Main Table Alias","Unique ID Field","Materialized View Cron","Map Id","Materialized View Workflow","Conditions in Filter Format","CRM Entity Alias","Update View when Related Changes","Related Module List","Unique Identifier"
"Contacts in Spain","cbQ-0000007","Table","Active","0","","Contacts","10.00","admin","admin","2020-04-19 16:16:52","2020-04-19 16:18:26","[{""fieldname"":""firstname"",""operation"":""is"",""value"":""firstname"",""valuetype"":""fieldname"",""joincondition"":""custom"",""groupid"":0,""groupjoin"":""firstname""},{""fieldname"":""lastname"",""operation"":""is"",""value"":""lastname"",""valuetype"":""fieldname"",""joincondition"":""custom"",""groupid"":0,""groupjoin"":""lastname""}]","[{""fieldname"":""mailingcountry"",""operation"":""is"",""value"":""Spain""
@joebordes
joebordes / BusinessQuestion.csv
Created May 15, 2020 00:29
react chartjs corebos question
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 2.
"Name Text","Question No","Type","Status","SQL Query","Collection","Module","Page Size","Assigned To","Created By","Created Time","Modified Time","Columns","Condition","Description","Order by Column","Group by Column","Type Properties","Main Table Alias","Unique ID Field","Materialized View Cron","Map Id","Materialized View Workflow","Conditions in Filter Format","CRM Entity Alias","Update View when Related Changes","Related Module List","Unique Identifier"
"Contacts per Country","cbQ-0000008","Pie","Active","0","","Contacts","10.00","admin","admin","2020-04-19 16:27:14","2020-05-14 22:20:39","[{""fieldname"":""mailingcountry"",""operation"":""is"",""value"":""mailingcountry"",""valuetype"":""fieldname"",""joincondition"":""custom"",""groupid"":0,""groupjoin"":""mailingcountry""},{""fieldname"":""countres"",""operation"":""is"",""value"":""count(contact_no)"",""valuetype"":""expression"",""joincondition"":""count"",""groupid"":0,""groupjoin"":""contact_no""}]","[{""fieldname"":""mailingcountry"",""operation""
@joebordes
joebordes / index.js
Created May 16, 2020 18:04
call Business Action from javascript
getGraph = () => {
mermaid.initialize({ startOnLoad: true, securityLevel: 'loose', });
cbconn.doLogin('admin', 'admin', true)
.then(()=> {
//cbconn.doInvoke('executeBusinessAction', { businessactionid: '47086', 'context':JSON.stringify({'ID':'13x47084', 'MODE':''}) }, 'GET')
//cbconn.doInvoke('executeBusinessAction', { businessactionid: '47087', 'context':JSON.stringify({'ID':'13x47084', 'MODE':''}) }, 'GET')
cbconn.doInvoke('PushAlongFlow', { pflowid: '47069', 'contextid': '13x47089'}, 'GET')
.then(data => {
// let graph = data.substr(data.indexOf('graph'));
// graph = graph.substr(0, graph.indexOf('</div>'));
@joebordes
joebordes / ListViewBusiness_Actions.csv
Created August 28, 2022 00:33
List View Action Business Actions
Link Type Link Label Link Url Link Icon Sequence Handler Path Only On My Module Handler Class Module List Handler Assigned To Active Action Role For all users Business Rule Business Actions No Created By Created Time Modified Time Description Unique Identifier
LISTVIEWACTION show message module=Utilities&action=UtilitiesAjax&file=showMsgWidget&msg=ListViewAction&level=success 0.00 0 Accounts admin 1 1 bact-0000139 admin 2022-08-24 21:28:57 2022-08-24 21:41:56 b830de7a53ef16889c72d1f2859f285f47554f78
LISTVIEWACTION show iframe block://showHTMLBlock:modules/Utilities/showHTMLBlock.php:op=iframe&height=400px&ex=http%3A%2F%2Fcorebos.org%3Fifcrmid%3D%24RECORD%24%26ifmodule%3D%24MODULE%24 0.00 0 Accounts admin 1 1 bact-0000140 admin 2022-08-24 21:29:25 2022-08-24 21:33:54 b888766f19f6101fb643aac161648137897ded43