How to create a dynamicLogic for Opportunity age ??

[Nishan Perera]

Hi,

I want a field which is to show age of a particular opportunity with dynamic logic. opportunity age field read only and should update automatically ?? how it can be done ?

any help ??

[Maximus]

Hi,
If you are talking about auto-counting of the age field, you can use scheduled workflow with a report.

[Nishan Perera]

Hi,
If you are talking about auto-counting of the age field, you can use scheduled workflow with a report.

I tried that, But it change the data modify date and the user. is it possible to do without update those data ?

[Maximus]

As far as I know there is no such an ability.

[yuri]

Create a notStorable field and define SQL in "select" in entityDefs. Example here: https://forum.espocrm.com/forum/deve...storable-bools

You need something like this:

"ageDays": {
    "type": "int",
    "notStorable": true,
    "readOnly": true,
    "select": "DATEDIFF(NOW(), created_at)",
    "orderBy": "DATEDIFF(NOW(), created_at) {direction}"
}

[Nishan Perera]

Create a notStorable field and define SQL in "select" in entityDefs. Example here: https://forum.espocrm.com/forum/deve...storable-bools

You need something like this:

"ageDays": {
"type": "int",
"notStorable": true,
"readOnly": true,
"select": "DATEDIFF(NOW(), created_at)",
"orderBy": "DATEDIFF(NOW(), created_at) {direction}"
}

Thank you for the code yuri. without entering table name i'm getting "Internal server error 500".

For me this worked

custom\Espo\Custom\Resources\metadata\entityDefs\O pportunity.json

{
    "fields": {
        "oppAge": {
            "type": "int",
            "notStorable": true,
            "select": "DATEDIFF(NOW(), opportunity.created_at)",
            "orderBy": "DATEDIFF(NOW(), opportunity.created_at) {direction}",
            "readOnly": true,
            "isCustom": true
        }
    }
}

Thank you for the support .!

[Nishan Perera]

Hi yuri,

I need some support on opportunity age calculation which is now working perfectly. Thing is I want to stop the age calculation if stage change to closed won or closed lost.

Is this possible to achieve ? Let me know.

[Nishan Perera]

Hi Maximus , Could you also advice me on above which is "stop the age calculation if stage change to closed won or closed lost."

[Maximus]

Hi,
Sorry, can't help here. It is out of my skills.

[Nishan Perera]

yuri could you please help me on this. appreciate your support.

[Nishan Perera]

yuri could you please help me on this. appreciate your support.

yuri Can you support me on this ?

[Nishan Perera]

Is there anyone can help me on this ?