Welcome, Guest |
You have to register before you can post on our site.
|
Forum Statistics |
» Members: 539,605
» Latest member: bowlarm1
» Forum threads: 1,745
» Forum posts: 9,084
Full Statistics
|
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,142
|
MariaDB Version
Forum: Administrator Support
Last Post: joebordes
11-01-2024, 11:49 AM
» Replies: 1
» Views: 637
|
Product Catalog / parts c...
Forum: Modules/Extension Support
Last Post: joebordes
09-15-2024, 09:40 AM
» Replies: 1
» Views: 1,110
|
Challenges and Best Pract...
Forum: coreBOS Development
Last Post: wishforbes
08-30-2024, 04:21 PM
» Replies: 0
» Views: 722
|
PRODUCTS IN ACCOUNTS BY O...
Forum: User Support
Last Post: jonathanmoore858
08-03-2024, 04:14 PM
» Replies: 4
» Views: 2,772
|
Zapier | Integration
Forum: Modules/Extension Support
Last Post: bernardgbailey
07-29-2024, 11:45 PM
» Replies: 7
» Views: 9,853
|
Versión PHP recomendada
Forum: International
Last Post: joebordes
07-04-2024, 05:42 PM
» Replies: 7
» Views: 3,336
|
Could Someone Give me Adv...
Forum: Open Discussions
Last Post: joebordes
06-27-2024, 08:32 AM
» Replies: 1
» Views: 1,708
|
RESTRICTED FILE
Forum: Administrator Support
Last Post: inspectorflint
06-22-2024, 08:08 AM
» Replies: 7
» Views: 5,675
|
GENDOC imágenes
Forum: Open Discussions
Last Post: joebordes
06-02-2024, 05:11 PM
» Replies: 4
» Views: 2,041
|
|
|
Have there been changes that affect the SalesOrder's duedate field? |
Posted by: Guido1982 - 07-17-2018, 12:15 PM - Forum: coreBOS Development
- Replies (7)
|
|
My Schedular module gives you the opportunity to set certain fieldvalues on a related record whenever you delete a Schedular record: (https://github.com/Luke1982/newSchedular...sOrder.php). As you can see in this example I used it to clear out a related SalesOrder's duedate when a Schedular record is deleted.
In my local installation I'm testing a an upgrade from an old coreBOS version and I've noticed the duedate does not clear out. Upon further investigation I saw that in fact, the clearing did happen, but was immediately reversed (I could see that in the 'View history' widget). I turned on the debug log and saw that a query was happening after the Schedular-launched query that in fact reversed the duedate setting. The Schedular query that cleared the duedate was also visible, but as I said, that happened first, then the duedate was reversed by yet another query.
In the current installation, this doesn't happen and I haven't changed anything to the Schedular module. Have there been any changes, maybe in the aftersave event handling or system-workflows that could cause this? I can't asses from the log entries what part of the application is doing this.
UPDATE
I found out what was happenning. Apparently, I created a workflow in the Schedular module with a custom task. That task did NOT function in the 'old' installation, at least not as expected. In the new installation, that task suddenly started to function. Since I use the regular save method to update the related record (intentionally, to trigger workflows), the task fired and reset the SalesOrder duedate.
UPDATE 2
Well, the workflow WAS functioning in the 'old' installation, since it was meant to update the SalesOrder's duedate when the Schedular record's date changed. Somehow, that workflow never did that when the Schedular record was deleted, or maybe the order in which workflows and afersave event fire was changed, not sure about that. Anyway, the workflow task now ALWAYS updates the SalesOrder, so I'll add a check that checks the Schedular record for 'deleted' before it updates the SalesOrder record.
UPDATE 3
I can't alter my workflow task to do what I want, which is: update the salesorder duedate only if the Schedular record is NOT deleted. I tried an INNER JOIN on the vtiger_crmentity table WHERE 'deleted' on vtiger_crmentity was 0, but apparantly, the workflow is fired before the crmentity table is updated with the deletion of the Schedular record. I tried installing an 'on delete' workflow task for the Schedular record, but that will only allow me to update fields on the Schedular record, since the SalesOrder is related through an M:M relation, not a M:1.
UPDATE 4
I solved this by:- Setting a REQUEST variable that indicates deletion of the schedular record in my beforerecorddelete event
- Using that REQUEST variable to asses whether I should launch the workflow task to the salesorder or not.
|
|
|
Simple workflow task condition error |
Posted by: Guido1982 - 07-16-2018, 02:23 PM - Forum: Administrator Support
- Replies (8)
|
|
I have a very simple workflow. It sends an e-mail when a certain checkbox (custom field) is set to true (has changed to - true: boolean). I've got 20 workflow tasks like these but this one doesn't work for some reason. When I remove the condition (the workflow runs on every save) and edit a record the e-mail gets sent. When I add the condition, it doesn't. The field is a custom field and the label is quite long. It had a question mark in the label that I removed, but that didn't do the trick. Any ideas what this simple thing could be?
|
|
|
Can we aggregate in report columns? |
Posted by: Guido1982 - 07-16-2018, 10:14 AM - Forum: Administrator Support
- Replies (2)
|
|
I see we have a lot of new functionality in repots, which is very cool. One use case I have for this is: When you report salesorders, a lot of times you want to know if a salesorder has been completely invoiced (if you invoice salesorders in multiple invoices of course). Would it be possible to sum the total amount of invoice subtotals related to that salesorder on-the-fly during the generation of the report and display it as a normal cell? Or would it be more wise to create a field in salesorders that aggregates the invoices through a workflow and just use that on the report?
|
|
|
error a la hora de guardar datos |
Posted by: construmet4 - 07-12-2018, 12:59 PM - Forum: User Support
- Replies (10)
|
|
Buenos días:
Hoy de golpe me ha salido este error, sin modificar nada
Fatal error: Call to a member function FetchRow() on boolean in /home/xxxx/public_html/corebos/include/database/PearDatabase.php on line 668
Alguna idea de lo que puede ser?
|
|
|
Update field through workflow ONLY when no related records are present |
Posted by: Guido1982 - 07-11-2018, 09:27 AM - Forum: coreBOS Development
- Replies (2)
|
|
I have a use case where I hope I can use a workflow in stead of coding:
I want to update the field 'dateinservice' in Assets. I have a custom module called 'ServiceJob' that is related to Assets through a M:M relation. Now I want to do the following:
When an asset is saved, a workflow should check if only one ServiceJob is related. If so, the 'dateinservice' field should be filled with a field from that related ServiceJob record. If the no. or related ServiceJob records is 0 or greater than 1, it should do nothing. Do we have a workflow expression function that counts related records, or one that could be 'abused' to do so?
|
|
|
|