Use data from another ajax call on one column

[walker1234Participant]

Suppose I have a jqxgrid and it s displaying data in the table from Table A.

For eg:
Table A
companyId , companyName

Now, I want to display a third column in the jqxgrid and the column name will be companyAddress. However, this column is not in the Table A so I need to refer to Table B which is following

Table B.
id , companyAddress

In the jqxgrid, I want to have the following columns

companyId, companyName and companyAddress

I can have an Ajax call to get first two columns from Table A. Is it possible to have a separate Ajax call just for the third column which is companyAddress based on the companyId? (where companyId n TableA = id in Table B). I don’t want to join them and combine them as an array or json object but I was wondering if it’s possible to achieve what I asked above?

[adminKeymaster]

Hi walker1234,

You can look at https://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/foreignkeycolumn.htm?fluent. It shows how to bind the grid to a data adapter where one of its fields is data bound to another dataAdapter and gets the data from it.

Best regards,
Peter Stoev

jQWidgets Team
https://www.jqwidgets.com/

[walker1234Participant]

Can you tell me is this type of thing is needed? Or may elaborate on this more?
map: ‘m\\:properties>d\\:EmployeeID’

Do you have a JSFiddle showing the same?

[adminKeymaster]

It is this part: values: { source: employeesAdapter.records, name: ‘EmployeeName’ } }, It tells the dataAdapter that this field will take data from another array, in the case of the example employeesAdapter.

Best regards,
Peter Stoev

jQWidgets Team
https://www.jqwidgets.com/

[Author]

Posts