Comments (5)
Opening another issue is fine. I prefer that to having a single issue expand and evolve over time.
I can't re-create the problem. Sorting + Pagination is working as expected on my little test system. So it's not broken at the very basic level.
There could very easily still be something missing in my code, though. Some condition I didn't consider. If you can't figure out where the problem is, you can send me code examples (whatever you think is pertinent) and I'll see if I can figure it out.
from cakephp-3-oracle.
hmm, thanks. Not sure on this, does your pagination example you tested contain any relationship/foreign key?
My table has a belongsTo/hasMany relationship so it's pulling a foreign key from another table/model.
So there's an INNER JOIN in the generated SQL both when page loads and when I click on a column to sort. Just that after clicking on column header to sort the ORDER BY not added into the SQL.
That's only thing I can think of now, but I honestly havent had a lot of time to look into it today. Will try to debug more and let you know, but may be a week before as I'm out of town next week.
Thanks!
from cakephp-3-oracle.
Ah, no I didn't test with relationships. I'll try that in a bit, but maybe you missed the "sortWhitelist" pagination thing:
http://book.cakephp.org/3.0/en/controllers/components/pagination.html#control-which-fields-used-for-ordering
Important quote on that page: "This option is required when you want to sort on any associated data"
from cakephp-3-oracle.
Yep, pretty sure that's your problem. Sorting on related table data works properly for me, but only when using the sortWhitelist as described in that link.
from cakephp-3-oracle.
ah, yes you may be right... i don't think I did add sortWhitelist. away from computer now but will double check and post back when have access to my code. thanks again
from cakephp-3-oracle.
Related Issues (14)
- Oracle datasource for CakePHP 3.x HOT 10
- Paginate with oracle HOT 10
- Unsupported operand types HOT 15
- ID not returned from REST API HOT 2
- Erro to connect, PDODriverTrait and Oracle HOT 3
- error in getConnection, setConnection, getValues HOT 1
- Sequence of execution HOT 20
- Driver could not be found HOT 2
- Only get 1 result buts many expected HOT 1
- Unable to get table description from database HOT 12
- Question about synonym HOT 4
- ORA-00972: identifier is too long HOT 5
- Cannot describe <table> It has 0 columns. HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from cakephp-3-oracle.