Table widget Notes Column

[rajavinoth]

Hi,
     
   Is it possible to get task notes from status_log table?

@GET(sthpw/note['timestamp', 'is on',@GET(.timestamp)]['search_code','is',@GET(sthpw/task.search_code)].note)

Expression error: do_query error: SELECT "sthpw"."public"."note".* FROM "sthpw"."public"."note" WHERE "note"."timestamp" >= '2019-12-11' AND "note"."timestamp" < '2019-12-12' AND "note"."search_code" is '3D/ANI' AND "note"."search_type" = 'sthpw/status_log' AND "note"."search_code" in ('STATUS_LOG703330') ORDER BY "timestamp" desc

This is the view inherit from status log
   

Need to display notes of the task based on the date added.

[Celton McGrath]

Hi Rajavinoth,

Can you try this definition for your expression column?

<element name="notes" title="Notes" edit="false" color="false">
<display widget="expression">
<expression>@GET(sthpw/task.parent.sthpw/note['timestamp', 'is on',@GET(.timestamp)].note)</expression>
<return>list</return>
</display>
</element>

I think your expression is failing because you are using the 'is' operator:
['search_code','is',@GET(sthpw/task.search_code)

The 'is on' operator for timestamp is correct.

Hope this helps,

Celton

[rajavinoth]

Thanks Working for me