Comments (4)
I have discovered the cause of this. It was two fold.
- The omission of $default sort parameter on the DataObject in question
- The mess found in the SortOrder column due to the first issue
Fix was pretty simple. First, correct the SortOrder field in the DataObject table. I used the following query to basically set the SortOrder incrementally in the current order. All anyone else needs to do is alter keywords beginning with "My":
update MyTable target
join
(
select ID, (@rownumber := @rownumber + 1) as rownum
from MyTable
cross join (select @rownumber := 0) r
order by MySortOrder asc
) source on target.id = source.id
set MySortOrder = rownum;
Then, add the default sort to the DataObject so Silverstripe knows what the sort order is:
private static $default_sort = 'MySortOrder';
They do a full dev/build?flush before using the page dragging.
from sortablegridfield.
Sounds like you have a solution then? I'm going to close this if you do, note the examples show to do this.
from sortablegridfield.
Yeah mate. My mistake it seems. Please close it.
from sortablegridfield.
no worries :)
from sortablegridfield.
Related Issues (20)
- Tests required for tables with $table_name declared HOT 2
- No search capabilities when using in ModelAdmin HOT 3
- Move scripting to the new GridField API
- Many Many relationships are broken due to renaming of many_many and many_many_extraFields to manyMany and manyManyExtraFields HOT 5
- mapTableNameAndReturn can't parse namespace+classname into mysql tablename HOT 3
- many_many ss 3.6 GridFieldAddNewMultiClass Column 'SortOrder' in field list is ambiguous HOT 4
- "Adds drag and drop functionality to SilverStripe 3's GridField" HOT 1
- Issue template
- Internal issue while using drag and drop functionality for ManyMany, ManyManyEtraFields in SS4 HOT 12
- User creation in SS CMS HOT 3
- Int to DBInt HOT 6
- spacing and presentation enhancements of gridfield HOT 2
- Drag and Drop sorting for ModelAdmin is not working HOT 6
- Couldn't run query: UPDATE "" SET "SortOrder" = 1 WHERE "" = 1 AND "" = 6 HOT 2
- Update of lang files HOT 1
- Cannot read properties of null (reading 'removeChild')
- Move to tests to GitHub Actions HOT 1
- disableSelection should be avoided. HOT 2
- Feature: Add extension to allow consistency without requiring loading of the GridField
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 sortablegridfield.