OroCRM Forums

Covering OroCRM topics, including community updates and company announcements.

Forums Forums OroCRM Filter not working for a Case statement in Datagrid

This topic contains 3 replies, has 3 voices, and was last updated by  golriz.nourani 6 years, 5 months ago.

Starting from March 1, 2020 the forum has been switched to the read-only mode. Please head to StackOverflow for support.

  • Creator
  • #30399


    Hi Team ,

    I have used an Column (timediff) which produces html content in datagrid that is used to show an indicator (Green/Red) in table based on the computed values in the query.We need a functionality that include a filter to filter this indicator.So i have used an extra column (timediffindicator) for this to work which sets a flag based on condition as given below

    So As per my understanding when i filter the timediffindicator for value as 1 , it should display respective columns in timediff with #ff4300 indicators only displayed in table . But this filter is not working & an error is shown in Browser as shown :

    Error during Filter

    Please find the filter not working for the indicators shown below (Ecart Horaire? => timediff Column):

    Screenshot of Indicator & Filter

    Please find the attached Datagrid Code given below:

    Please need some suggestion on how to make filter work for this situation explained above.

    Thanks & Regards,
    Shreyas S

Viewing 3 replies - 1 through 3 (of 3 total)
  • Author
  • #30400

    Yevhen Shyshkin


    Probably, the easiest fix for this issue is to cast your string to integer, i.e.:



    Hi Yevhen,

    Thanks a lot for the help. It solved my issue.

    Thanks & Regards,
    Shreyas S



    I have this problem for other type like string

    filter does not work for this column

    could you help me?

Viewing 3 replies - 1 through 3 (of 3 total)

The forum ‘OroCRM’ is closed to new topics and replies.

Back to top