+- TACTIC Open Source (http://forum.southpawtech.com)
+-- Forum: TACTIC Open Source (http://forum.southpawtech.com/forumdisplay.php?fid=3)
+--- Forum: TACTIC Discussion (http://forum.southpawtech.com/forumdisplay.php?fid=4)
+--- Thread: Table widget Notes Column (/showthread.php?tid=53)
Table widget Notes Column - rajavinoth - 12-11-2019
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
[attachment=31]
Need to display notes of the task based on the date added.
RE: Table widget Notes Column - Celton McGrath - 12-11-2019
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
RE: Table widget Notes Column - rajavinoth - 12-11-2019
Thanks Working for me
