Create Filter to show records created today : xDM

Start a new topic

Create Filter to show records created today

Christa Helgeson

started a topic 8 days ago

I would like to create a Collection filter that only displays records created today and by me. How do I do this? I assume it will need to be a SemQL filter, but not getting that to work.

1 Comment

Subham Dixit

said 8 days ago

Hello Christa,

For this use case, you can create a specific BusinessView where you need to put a root filter like this-

CreationDate = CURRENT_DATE() and Creator = :V_USERNAME

or you can also try this below condition-

CreationDate = CURRENT_DATE() and Creator = :V_USER_FIRSTNAME || :V_USER_LASTNAME

Please try this and let us know if it works.

Thanks and have a nice day.