opened
m3rlin94
username_0
I'm submitting a,
[x] bug report
[ ] feature request
[ ] support request 

**Current behavior**
In DataTable component, even though a custom onSort function is provided, datatable still considers the default sorting mechanism. This is a problem because it conflicts with SQL alpha-numeric ordering mechanism.

Example: 
apple1, apple2, apple11 will be ordered as follows:

Primereact -> apple1, apple2, apple11
PostgreSQL -> apple1, apple11, apple2

This cause inconsistencies within the application

**Expected behavior**
 I expect that the default sorting will not be considered and only the provided sort will be considered. 

**Minimal reproduction of the problem with instructions**
<!--
If the current behavior is a bug or you can illustrate your feature request better with an example, 
please provide the *STEPS TO REPRODUCE* and if possible a *MINIMAL DEMO* of the problem via
https://codesandbox.io or similar (you can use this template as a starting point: https://codesandbox.io/s/qjx332qq4).
-->

**Please tell us about your environment:**
<!-- Operating system, IDE, package manager, HTTP server, ... -->
OS: MacOS Catalina
Package Manager: Yarn
IDE: VS Code

* **React version:**
16.9.0

* **PrimeReact version:**
3.1.8

* **Browser:** [all | Chrome XX | Firefox XX | IE XX | Safari XX | Mobile Chrome XX | Android X.X Web Browser | iOS XX Safari | iOS XX UIWebView | iOS XX WKWebView ]
all
 
* **Language:** [all | TypeScript X.X | ES6/7 | ES5]
all
DataTable sorting interrupts the custom onSort
issue
created
mertsincan
username_1
Unfortunately, I couldn't replicate this issue. Could you please attach a codesandbox link for us to replicate?

Also, please see this code;
```
if(this.columnSortable && this.columnSortFunction) { // call custom sort function
            value = this.columnSortFunction({
                field: this.getSortField(),
                order: this.getSortOrder()
            });
        }
        else {
```
comment
created
m3rlin94
username_0
@username_1 Thank you for your reply. Could you please check the following sandbox?

[https://codesandbox.io/s/primereact-test-0wr15?fontsize=14&hidenavigation=1&theme=dark](url)
comment
closed
mertsincan
username_1
issue
created
mertsincan
username_1
{columns.map(col => (
            <Column
              key={col.field}
              field={col.field}
              header={col.header}
              sortable
              sortFunction={this.setFullState}
            />
          ))}
        </DataTable>
      </div>
    );
  }
}
```
comment