If you order them by last modified, then expired will not get into the list I think. Will it?

Sergey If you order them by last modified, then expired will not get into the list I think. Will it?

They need to be ordered by a fixed date like creation date. I can't use by last modified because it will mess up the order. :-(

The list also has to include records that never expire and they won't show up if I use sort by last modified.

Added exclude_expirei in module settings.

Konstantin Added exclude_expirei in module settings.

Great!

Does this also mean I can use $view_what = "exclude_expired" as part of a query in a custom module?

Yes

+1

+1

$view_what = "exclude_expired" shows nothing after update :-(

What and where not showing?

Can you check 'exclude_expired' in default cobalt module records, if there work than some issue in your module.

Konstantin Can you check 'exclude_expired' in default cobalt module records, if there work than some issue in your module.

I will do that. But my module was working fine until recently :-(

I didn't make any code changes, so I am really puzzled...

I have checked cobalt module records and it works fine with 'exclude_expired'

I have checked my custom module with $view_what="view_all" settings and it shows records including expired ones.

I have checked my custom module with $view_what="exclude_expired" settings and it shows no records.

I can only advise you it's var_dump sql from model records and look into query, I think than you understand why return nothing.

I can suggest you to turn on debug mode and find SQL query that is produced by API for your module and see what is wrong there. If you cannot find in qery anything, copy it here and I'll have a look.