Welcome, Guest |
You have to register before you can post on our site.
|
Online Users |
There are currently 4 online users. » 0 Member(s) | 1 Guest(s) Bing, Google, Yandex
|
Latest Threads |
Finetuning the way you se...
Forum: coreBOS Development
Last Post: alexandy40d
12-06-2024, 07:38 AM
» Replies: 4
» Views: 8,134
|
MariaDB Version
Forum: Administrator Support
Last Post: joebordes
11-01-2024, 11:49 AM
» Replies: 1
» Views: 613
|
Product Catalog / parts c...
Forum: Modules/Extension Support
Last Post: joebordes
09-15-2024, 09:40 AM
» Replies: 1
» Views: 1,106
|
Challenges and Best Pract...
Forum: coreBOS Development
Last Post: wishforbes
08-30-2024, 04:21 PM
» Replies: 0
» Views: 717
|
PRODUCTS IN ACCOUNTS BY O...
Forum: User Support
Last Post: jonathanmoore858
08-03-2024, 04:14 PM
» Replies: 4
» Views: 2,755
|
Zapier | Integration
Forum: Modules/Extension Support
Last Post: bernardgbailey
07-29-2024, 11:45 PM
» Replies: 7
» Views: 9,841
|
Versión PHP recomendada
Forum: International
Last Post: joebordes
07-04-2024, 05:42 PM
» Replies: 7
» Views: 3,318
|
Could Someone Give me Adv...
Forum: Open Discussions
Last Post: joebordes
06-27-2024, 08:32 AM
» Replies: 1
» Views: 1,696
|
RESTRICTED FILE
Forum: Administrator Support
Last Post: inspectorflint
06-22-2024, 08:08 AM
» Replies: 7
» Views: 5,651
|
GENDOC imágenes
Forum: Open Discussions
Last Post: joebordes
06-02-2024, 05:11 PM
» Replies: 4
» Views: 2,018
|
|
|
Extending the email wftask merge tags |
Posted by: Guido1982 - 08-03-2020, 03:01 PM - Forum: coreBOS Development
- Replies (3)
|
|
I want to create some functionality: when a comment is placed, we send e-mails to the person mentioned in the comment. In that e-mail, I'd like to show the rest of the conversation. To that end I'd like to extend the existing workflow merge tags to accomodate a new tag that gets and prints the conversation that preceeded this comment. How would I start extending this functionality?
|
|
|
Use 'onlyonmymodule' in manifest.xml? |
Posted by: Guido1982 - 07-28-2020, 07:12 AM - Forum: coreBOS Development
- Replies (5)
|
|
In the manifest file, we have the option to add customlinks (which will become business actions), but can we also specify the 'Only on my module' option? And if yes, how? Something like this?
PHP Code: <customlink> <linktype>DETAILVIEWWIDGET</linktype> <linklabel>InventoryDetailsBlock</linklabel> <linkurl><![CDATA[block://InventoryDetailsBlock:modules/WorkAssignment/InventoryDetailsBlock.php]]></linkurl> <linkicon><![CDATA[]]></linkicon> <sequence>0</sequence> <handler_path><![CDATA[]]></handler_path> <handler_class><![CDATA[]]></handler_class> <handler><![CDATA[]]></handler> <onlyonmymodule>1</onlyonmymodule> </customlink>
|
|
|
Background of the financial fields |
Posted by: Guido1982 - 07-26-2020, 12:38 PM - Forum: coreBOS Development
- Replies (8)
|
|
Since I'm working on a module that will introduce a new inventorydetails block and will also implement the now 'standard' financial fields that live on the stock inventory modules. I will use the master-detail businessmap definition as described in the wiki, but to be able to do so I would like to know the purpose, unit (%, currency or just no.) and exact formula for each of the following fields: - pl_gross_total
- pl_dto_line
- pl_dto_global
- pl_dto_total
- pl_net_total
- pl_sh_total
- pl_sh_tax
- pl_adjustment
- pl_grand_total
- sum_nettotal
I will later specify this in a readme that we could also feed back into the wiki
|
|
|
notDuplicate validation not respected on lead conversion |
Posted by: radu - 07-10-2020, 05:22 AM - Forum: Administrator Support
- Replies (1)
|
|
I noticed if i have a validation rule with notDuplicate on the Accounts, it is not respected if the account is created during a Lead conversion. So if the accounts does not permit duplicates on phone field for example, it is not respected if i convert a lead that passes an existing phone number in the account and the new organization gets created with a phone that already exists.
|
|
|
-Solved- Workflow execution when saved by another workflow |
Posted by: radu - 07-08-2020, 06:26 AM - Forum: User Support
- Replies (4)
|
|
The workflows are triggered when a record is saved most of the time. However, if the triggered workflow modifies(and saves) a field on a related module and another workflow is supposed to execute when something is saved in that module, the second workflow is not triggered, because it was 'indirectly' saved i suppose.
Is there a method to trigger workflows when a previous workflow was the one that 'provoked' the triggers instead of the user? To obtain a sort of cascading effect.
I remember i saw something like that in documentation examples but i can't find anything.
Thanks
|
|
|
Mail Converter text encoding |
Posted by: addady2 - 07-01-2020, 02:03 PM - Forum: Administrator Support
- Replies (3)
|
|
Hi,
Some of the incoming emails are not encode well, The text appear as: ... ???????? ???????? ....
Those email are in windows-1255 encoding.
There is a sample of typical email header:
Code: Subject: =?windows-1255?B?4/TpIPHs6ffk?=
Content-Type: text/plain; charset="windows-1255"
It seems that Corebos ignore this encoding.
How can I add it to the Mail coverter?
Thanks
|
|
|
Workflow function aggregation error |
Posted by: radu - 06-26-2020, 07:11 AM - Forum: Administrator Support
- Replies (5)
|
|
I noticed when i have a condition in the aggregation function the whole function fails. For example i have the following function:
Code: aggregation('count','SalesOrder','pl_grand_total','[sostatus,e,Approved,or],[sostatus,e,Delivered,or]')
which should count the sales orders that have the status 'Approved' or 'Delivered'. If I remove the condition from the expression, the function retunrs the correct count number of existing SO's but if i put any condition it craps out and return empty. This exact expression is in use on a older install and it works fine.
The log inspection reveals some clues. Here is what the query and result looks like on a new install:
query select count(vtiger_salesorder.pl_grand_total) as aggop from vtiger_salesorder inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_salesorder.salesorderid left outer join vtiger_quotes on vtiger_quotes.quoteid=vtiger_salesorder.quoteid left outer join vtiger_account on vtiger_account.accountid=vtiger_salesorder.accountid left outer join vtiger_potential on vtiger_potential.potentialid=vtiger_salesorder.potentialid left join vtiger_groups on vtiger_groups.groupid=vtiger_crmentity.smownerid left join vtiger_users on vtiger_users.id=vtiger_crmentity.smownerid where vtiger_crmentity.deleted=0 and vtiger_potential.potentialid = 25326 ORDER BY vtiger_crmentity.createdtime DESC and (vtiger_crmentity.deleted=0 AND ( vtiger_salesorder.sostatus IN (
select translation_key
from vtiger_cbtranslation
where locale="en_us" and forpicklist="SalesOrder::sostatus" and i18n = 'Approved') OR vtiger_salesorder.sostatus = 'Approved') or ( vtiger_salesorder.sostatus IN (
select translation_key
from vtiger_cbtranslation
where locale="en_us" and forpicklist="SalesOrder::sostatus" and i18n = 'Delivered') OR vtiger_salesorder.sostatus = 'Delivered') AND vtiger_salesorder.salesorderid > 0)
and it fails with:
Code: DB DB >ADODB error Query Failed:select count(vtiger_salesorder.pl_grand_total) as aggop from vtiger_salesorder inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_salesorder.salesorderid left outer join vtiger_quotes on vtiger_quotes.quoteid=vtiger_salesorder.quoteid left outer join vtiger_account on vtiger_account.accountid=vtiger_salesorder.accountid left outer join vtiger_potential on vtiger_potential.potentialid=vtiger_salesorder.potentialid left join vtiger_groups on vtiger_groups.groupid=vtiger_crmentity.smownerid left join vtiger_users on vtiger_users.id=vtiger_crmentity.smownerid where vtiger_crmentity.deleted=0 and vtiger_potential.potentialid = 25326 ORDER BY vtiger_crmentity.createdtime DESC and (vtiger_crmentity.deleted=0 AND ( vtiger_salesorder.sostatus IN (
select translation_key
from vtiger_cbtranslation
where locale="en_us" and forpicklist="SalesOrder::sostatus" and i18n = 'Approved') OR vtiger_salesorder.sostatus = 'Approved') or ( vtiger_salesorder.sostatus IN (
select translation_key
from vtiger_cbtranslation
where locale="en_us" and forpicklist="SalesOrder::sostatus" and i18n = 'Delivered') OR vtiger_salesorder.sostatus = 'Delivered') AND vtiger_salesorder.salesorderid > 0)::->[1064]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and (vtiger_crmentity.deleted=0 AND ( vtiger_salesorder.sostatus IN (
se' at line 1
And this is how the query looks on the older system where is working ok:
Code: select count(vtiger_salesorder.pl_grand_total) as aggop from vtiger_salesorder inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_salesorder.salesorderid left outer join vtiger_quotes on vtiger_quotes.quoteid=vtiger_salesorder.quoteid left outer join vtiger_account on vtiger_account.accountid=vtiger_salesorder.accountid left outer join vtiger_potential on vtiger_potential.potentialid=vtiger_salesorder.potentialid left join vtiger_groups on vtiger_groups.groupid=vtiger_crmentity.smownerid left join vtiger_users on vtiger_users.id=vtiger_crmentity.smownerid where vtiger_crmentity.deleted=0 and vtiger_potential.potentialid = 519508 and (vtiger_crmentity.deleted=0 AND ( vtiger_salesorder.sostatus IN (
select translation_key
from vtiger_cbtranslation
where locale="en_us" and forpicklist="SalesOrder::sostatus" and i18n = 'Approved') OR vtiger_salesorder.sostatus = 'Approved') or ( vtiger_salesorder.sostatus IN (
select translation_key
from vtiger_cbtranslation
where locale="en_us" and forpicklist="SalesOrder::sostatus" and i18n = 'Delivered') OR vtiger_salesorder.sostatus = 'Delivered') AND vtiger_salesorder.salesorderid > 0)
I have marked with red the difference between the two which is ORDER BY vtiger_crmentity.createdtime DESC and
.
The failed query gives syntax errors when launched in the sql engine. However if I remove the red part which does not used to be present before, the engine executes the query just fine. I am not well versed in sql but from my point of view, that select query has logic with or without the 'red addition'. The syntax itself, i tried to count the parentheses and other symbols to see if i can spot any obvious mistake(with my limited knowledge of the language), i could not find any but the engine will not execute if that 'sorting/order' is present. If i remove it and launch that query in the engine, it runs ok.
Maybe someone can get a clue about what is going on. Could be something with my own install.
|
|
|
|