By using Elementorforum.com’s services you agree to our Cookies Use and Data Transfer outside the EU.
We and our partners operate globally and use cookies, including for analytics, personalisation, ads and Newsletters.

  • Join the Best Unofficial Elementor Support forum

    Provide or get advice on everything Elementor and Wordpress, ask questions, gain confirmation or just become apart of a friendly, like minded community who love Wordpress and Elementor


    Join us!
elementor official

Dynamic content views element order by issue

Ivan

Ivan

New Member
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

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
 
elementor official
Last edited:
Ivan

Ivan

New Member
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
 
elementor official

Latest posts

Latest Products

Other Elementor Resources

elementor official
elementor official
Top