Display combine fields in gridpanel

[Vaishali]

hi,

In the database table I have 3 fields Firstname, Middlename, Lastname.
How can I combined this three fields as Full name and display in gridpanel column(Fullname)?



Vaishali Khatri
Kintu Design PVT LTD.

[NickBin]

I advise you to concatenate fields on the database. This would depend upon the DBMS you are using

Server Side Solution (On Database Server)

SQL Server

SELECT FirstName + ' ' + MiddleName + ' ' + LastName AS FullName FROM ...

Oracle/PostgreSQL

SELECT FirstName || ' ' + MiddleName || ' ' + LastName AS FullName FROM ...

MySQL

SELECT CONCAT(FirstName, ' ', MiddleName, ' ', LastName) AS FullName FROM ...

Client Side Solution (On GridPanel)
Could you please post the markup you are currently using so that a solution could be proposed?

[Vladimir]

Hi,

Please see the following sample (FullName grid's column)
https://examples1.ext.net/#/GridPane...ectDataSource/

[Vaishali]

Thanks
It works now