Column Sql Value in Grid View
136 views
Skip to first unread message
Niraj Joshi
Oct 26, 2021, 2:21:41 AM10/26/21
to iDempiere
Hello,
I have created a virtual column which is working fine. But the result in grid view is not being shown
How can preview the value in grid view ?
Column sql, result, grid View result are attached below
Ricardo Alexsander Santana
Oct 26, 2021, 4:33:29 AM10/26/21
to idem...@googlegroups.com
Hi,
Virtual UI Columns does not work in grid mode. You have to convert to a Virtual DB Column.
Here you can find an example:
--
You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/eab9efe5-6a35-4dca-a831-601aca8a7062n%40googlegroups.com.
Niraj Joshi
Oct 26, 2021, 5:18:52 AM10/26/21
to iDempiere
As you can see in the attachment above , I think i created it to be as Virtual UI column but the grid view doesnot has any value/
Diego Ruiz
Oct 26, 2021, 6:14:17 AM10/26/21
to iDempiere
Hi,
From the documentation wiki:
"Grid usage: columns are calculated with the context when the record
is activated. The dependant context values are set only when you select a
row.
"
As Ricardo said if you need to see the information in Grid mode you have to create a Virtual DB Column instead, with its corresponding trade-off performance-wise.
You can check out this video to see how Virtual DB Columns work and are configured:
Best Regards,
Diego Ruiz
Niraj Joshi
Oct 27, 2021, 2:26:35 AM10/27/21
to iDempiere
Thanks for your reply.
I have viewed the video you mentioned but what I am trying to achieve is a bit different in case.
The video uses two different tables to create a column SQL, but in my case, I have a single table
I have a date field 'biddate' from which a column 'duedays' is supposed to be calculated from the current date.
so I used column SQL to achieve it. The result seems to be fine in normal view but the grid view value seems to be empty.
is there any other method to implement it?
I have viewed the video you mentioned but what I am trying to achieve is a bit different in case.
The video uses two different tables to create a column SQL, but in my case, I have a single table
I have a date field 'biddate' from which a column 'duedays' is supposed to be calculated from the current date.
so I used column SQL to achieve it. The result seems to be fine in normal view but the grid view value seems to be empty.
is there any other method to implement it?
Reply all
Reply to author
Forward
0 new messages