Welcome, Guest
You have to register before you can post on our site.

Username
  

Password
  





Search Forums

(Advanced Search)

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.

Print this item

  What is 'This record has deleted product/service lines. Please edit and fix according
Posted by: Guido1982 - 07-17-2018, 11:42 AM - Forum: Administrator Support - Replies (2)

I'm getting this message: 'This record has deleted product/service lines. Please edit and fix accordingly' in a salesorder. It seems okay, but what's the trigger for this?

Print this item

  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?

Print this item

  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?

Print this item

  Sent email only changes made for other user
Posted by: rslemer - 07-13-2018, 12:37 PM - Forum: Administrator Support - No Replies

Sent email only changes made thru other user

I wish change a default workflow to send a new email with opportunity detail is changed only for another user.

Today even owner change any detail system send a email, I think in this case not necessary

I tried include a new test if modified by last user = assigned to for do that, but not working.

See image

Doubt : this test verify any user or only if admin changed ?



Attached Files Thumbnail(s)
   
Print this item

  [solved] Problem with inline editting
Posted by: rslemer - 07-12-2018, 06:15 PM - Forum: Administrator Support - Replies (2)

After upgrade system exhibited "Copy" instead  "Edit" for editing inline.

Why?



Attached Files Thumbnail(s)
   
Print this item

  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?

Print this item

  [solved] System shows a error message
Posted by: rslemer - 07-11-2018, 04:43 PM - Forum: Administrator Support - Replies (3)

When I try created a new workflow, system shows


Warning: session_name(): Cannot change session name when session is active in /usr/share/coreBOS/corebos-master/include/utils/Session.php on line 49

Warning: count(): Parameter must be an array or an object that implements Countable in /usr/share/coreBOS/corebos-master/include/database/PearDatabase.php on line 487



Attached Files Thumbnail(s)
   
Print this item

  session timeout
Posted by: LorenzoGreco - 07-11-2018, 02:57 PM - Forum: Administrator Support - Replies (4)

Hi All
is there a way to increase session timeout?
I don't like to login so often during a day.
bye
Lorenzo

Print this item

  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?

Print this item