Dynamic content views element order by issue

[Ivan]

Hello

• My goal is to use multiple order criteria at the same time based on different priority rank number each post has and also post date.
• THis goal is based on client requirements
• I have placed the list of order by criteria in a specific order all set to descending.
• However they are not behaving as expected or how one might expect it to work in a normal SQL query.
• If i just have 1 or 2 order by criteria it works fine but any more and it becomes erratic
• I have some proof to demonstrate this erratic behavior

Proof

• The criteria
  • 1. data_solutions_priority (d&s prior)
  • 2. netherlands_priority (nl prior)
  • 3. south_africa_priority (sa prior)
  • 4. post_date
• The results are below (in the spoiler box)
• The conclusion:
  • We can see that "21358" appears before "29468" and yet has a lower "netherlands_priority" this is upside-down seeming

Please help
Thanks

Regards
Ivan Copeland

Spoiler: result

nz prior:
nl prior:
sa prior: 3
d&s prior: 2
id: 21358
post date: 2021-02-05 16:28:46
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21348
post date: 2021-02-04 20:28:46
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21301
post date: 2021-02-04 18:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21261
post date: 2021-02-04 18:27:41
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21341
post date: 2021-02-04 17:28:46
-
nz prior:
nl prior:
sa prior: 3
d&s prior: 3
id: 21303
post date: 2021-02-04 17:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21305
post date: 2021-02-04 17:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21325
post date: 2021-02-04 17:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior: 3
id: 21326
post date: 2021-02-04 17:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21289
post date: 2021-02-04 17:27:44
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21329
post date: 2021-02-04 16:28:46
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21331
post date: 2021-02-04 16:28:46
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21334
post date: 2021-02-04 16:28:46
-
nz prior:
nl prior:
sa prior: 3
d&s prior: 5
id: 21337
post date: 2021-02-04 16:28:46
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21344
post date: 2021-02-04 16:28:46
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21359
post date: 2021-02-04 16:28:46
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21290
post date: 2021-02-04 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior: 5
id: 21294
post date: 2021-02-04 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21298
post date: 2021-02-04 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior: 3
id: 21307
post date: 2021-02-04 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21312
post date: 2021-02-04 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21316
post date: 2021-02-04 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21322
post date: 2021-02-04 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21324
post date: 2021-02-04 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21273
post date: 2021-02-04 16:28:44
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21278
post date: 2021-02-04 16:28:44
-
nz prior:
nl prior:
sa prior: 3
d&s prior: 5
id: 21283
post date: 2021-02-04 16:28:44
-
nz prior:
nl prior:
sa prior: 3
d&s prior: 3
id: 21347
post date: 2021-02-04 15:28:46
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21354
post date: 2021-02-01 16:28:46
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21575
post date: 2021-01-30 11:22:41
-
nz prior:
nl prior:
sa prior: 3
d&s prior: 3
id: 21332
post date: 2021-01-29 16:28:46
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21333
post date: 2021-01-29 16:28:46
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21335
post date: 2021-01-29 16:28:46
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21336
post date: 2021-01-29 16:28:46
-
nz prior:
nl prior:
sa prior: 3
d&s prior: 3
id: 21338
post date: 2021-01-29 16:28:46
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21339
post date: 2021-01-29 16:28:46
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21340
post date: 2021-01-29 16:28:46
-
nz prior:
nl prior:
sa prior: 3
d&s prior: 3
id: 21342
post date: 2021-01-29 16:28:46
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21343
post date: 2021-01-29 16:28:46
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21345
post date: 2021-01-29 16:28:46
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21349
post date: 2021-01-29 16:28:46
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21350
post date: 2021-01-29 16:28:46
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21351
post date: 2021-01-29 16:28:46
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21352
post date: 2021-01-29 16:28:46
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21355
post date: 2021-01-29 16:28:46
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21356
post date: 2021-01-29 16:28:46
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21357
post date: 2021-01-29 16:28:46
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21360
post date: 2021-01-29 16:28:46
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21291
post date: 2021-01-29 16:28:45
-
nz prior: 3
nl prior:
sa prior: 3
d&s prior:
id: 21292
post date: 2021-01-29 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21293
post date: 2021-01-29 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21295
post date: 2021-01-29 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21296
post date: 2021-01-29 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21297
post date: 2021-01-29 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21299
post date: 2021-01-29 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21300
post date: 2021-01-29 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21302
post date: 2021-01-29 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21306
post date: 2021-01-29 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21308
post date: 2021-01-29 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior: 5
id: 21309
post date: 2021-01-29 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21310
post date: 2021-01-29 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21311
post date: 2021-01-29 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21313
post date: 2021-01-29 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21314
post date: 2021-01-29 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21315
post date: 2021-01-29 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21317
post date: 2021-01-29 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior: 5
id: 21318
post date: 2021-01-29 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21319
post date: 2021-01-29 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21320
post date: 2021-01-29 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior: 3
id: 21321
post date: 2021-01-29 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21323
post date: 2021-01-29 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21327
post date: 2021-01-29 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21328
post date: 2021-01-29 16:28:45
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21274
post date: 2021-01-29 16:28:44
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21275
post date: 2021-01-29 16:28:44
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21276
post date: 2021-01-29 16:28:44
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21277
post date: 2021-01-29 16:28:44
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21279
post date: 2021-01-29 16:28:44
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21281
post date: 2021-01-29 16:28:44
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21282
post date: 2021-01-29 16:28:44
-
nz prior:
nl prior:
sa prior: 3
d&s prior: 3
id: 21285
post date: 2021-01-29 16:28:44
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21286
post date: 2021-01-29 16:28:44
-
nz prior:
nl prior:
sa prior: 3
d&s prior: 5
id: 21287
post date: 2021-01-29 16:28:44
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21288
post date: 2021-01-29 16:28:44
-
nz prior:
nl prior: 5
sa prior: 3
d&s prior: 3
id: 29468
post date: 2021-01-25 15:35:15
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21353
post date: 2021-01-20 16:28:46
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21280
post date: 2021-01-04 16:28:44
-
nz prior:
nl prior:
sa prior: 3
d&s prior: 3
id: 21346
post date: 2021-01-01 16:28:46
-
nz prior:
nl prior: 5
sa prior: 3
d&s prior: 3
id: 30318
post date: 2021-01-01 14:32:53
-
nz prior:
nl prior: 5
sa prior: 3
d&s prior: 3
id: 30296
post date: 2021-01-01 14:09:18
-
nz prior:
nl prior: 5
sa prior: 3
d&s prior: 3
id: 30240
post date: 2021-01-01 13:42:25
-
nz prior:
nl prior:
sa prior: 3
d&s prior: 3
id: 3746
post date: 2020-11-02 11:35:33
-
nz prior:
nl prior: 5
sa prior: 3
d&s prior: 3
id: 30345
post date: 2020-03-01 14:54:23
-
nz prior:
nl prior:
sa prior: 3
d&s prior:
id: 21330
post date: 2020-01-29 16:28:46

 

[Ivan]

Some weird glitch im not sure but i fixed it by making sure there was a value for all the fields and none where not assigned (or null or anything). Oh and i only used one country priority at a time