SQL in Display logic, possible?

Developers
2012-03-13
2013-03-08
  • Alfredo Celeste
    Alfredo Celeste
    2012-03-13

    Hi friends! :

    is possible use SQL code in Display Logic?

     
  • karsten-thiemann
    karsten-thiemann
    2012-03-14

    Hi,

    as far as I know it is not possible to use it directly. But you can try to define a virtual column to have the result of your SQL query in the context and use the virtual column in your display logic.
    This approach will have some disatvantages:
    - virtual columns are updated only after a save of the record
    - you might have to show the virtual column in the tab to have it in the context (not sure about that - I think a workarround here would be to add the column to the tab with a display logic of 2=1 to hide it)

    Hope that helps. Best regards, Karsten

     
  • Alfredo Celeste
    Alfredo Celeste
    2012-03-14

    thanks you!