Start a new topic
Discussions xDM xDM - Model and Application Design
Answered

Create Filter to show records created today

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.

Best Answer

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.

1 Comment
Answer

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.

Login to post a comment
More topics in xDM - Model and Application Design
See all 274 topics
Help Desk Software by Freshdesk