Duration issue on 9.0.0.

[Russ]

Hey guys, I have this field as an 'Expression' in the report:


GREATER_THANTIMESTAMPDIFF_MINUTEdateStart, dateEnd), 1)

GREATER_THAN':'(TIMESTAMPDIFF_MINUTE':'(dateStart, dateEnd), 1)

Idea was to capture all calls with duration more than 1 minute, and it was working for a year or so, after the update it's not catching calls

[Russ]

Hey guys, I have this field as an 'Expression' in the report:


GREATER_THAN':'(TIMESTAMPDIFF_MINUTE':'(dateStart, dateEnd), 1)

Idea was to capture all calls with duration more than 1 minute, and it was working for a year or so, after the update it's not catching calls

Had to use quotation marks to get rid of emojis ':' in reality is just :

[yuri]

Works fine for me.

[victor]

Paste your code in

[HTML][/HTML]

or in

[CODE][/CODE]

In addition, you can send a screenshot of your Report settings.

[Russ]

GREATER_THAN:(TIMESTAMPDIFF_MINUTE:(dateStart, dateEnd), 1)

[Russ]

here is the screenshot of a report, victor, ty

[Russ]

it works, issue is somewhere else, I am sorry, thank you

[Russ]

The issue is that parent is not assigned anymore by the system, I guess.

it's empty, please guide me through changes

[Russ]

The issue is that parent is not assigned anymore by the system, I guess.

it's empty, please guide me through changes

victor

[Russ]

normal behavior, or expected one is to have a parent=to lead or contact, as of now, there is no 'parent' while you can see on screenshot it's related to a lead

[victor]

It is difficult to say, the required steps for reproduce, but it seems that initially the Call was made, but the Lead was not created. Then the Lead was created manually (for example, through the Bottom Panels (screenshot 1) or through the workflow, but not during the Call and the Lead was created via the pop-up. This is one of the main possible reasons, because the Lead and Call entities (Contact and Call similarly) have two common but different system Relationships between them.

- And in the example of the test Call, if I manually add a Contact via the Bottom Panels, it will not appear in the Parent of this Call (screenshot 2).
- And if I add this Contact to the Parent of the test Call, it will also not appear in the Bottom Panels (screenshot 3).

You may be able to investigate in Administration > Action History who and when performed certain actions with a specific Call.

[Russ]

Lead was added hours before the call.

Pre 9.0 and voip 2.0 it was assigning no problem, any way to fix it?

[victor]

Russ,

Please write the steps to reproduce your problem and I will later reproduce them on both EspoCRM 9.0.2 + VoIP 2.0.2 and EspoCRM 8.4.2 + VoIP 1.30.0.