Dot walking in data table widget

[Venkat122]

Hi All,

I want to display value from a custom field created in task table in it's approval record. so, i used OOTB "Data table" widget and selected table as "sysapproval_approver" but i can't find a way to add dot walked fields to the fields array (document_id.u_detailed_info). Is there any way to add dot walked field values in "Data table" widget.

Thanks and regards

Swamy

[Community Alums]

I think you'd have to clone the widget, and then modify the HTML to specifically refer to this. I would consider cloning the widget, naming the clone something specific to this particular use, and then adding a section to the server code that specifically queries the record in the document_id field, returns a bunch of information about the record, and assigns it to your data object, for example.

Then, you insert code into the view that is bound to these parameters of the data object.

This would be a little inflexible for other uses, but I think it's the best way to attain the functionality you're looking for; as far as I know, dot-walking in the list of columns to display is not supported.

[Venkat122]

Hi Andrew,

Thank you !!

it will be helpful if you can provide the sample code snippet.

Thanks and regards

Giri

[Venkat122]

Thank you all,

I am able to fetch data by adding below line in server side script

  record.requested for = gr.document_id.requested_for.getDisplayValue();

  record.sys_id = gr.getValue('sys_id');

  data.list.push(record);

[Anais Geisen]

Glad you succeed with the script