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
S
Subham Dixit
said
about 2 months 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.
1 Comment
S
Subham Dixit
said
about 2 months ago
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
Christa Helgeson
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.
Hello Christa,
For this use case, you can create a specific BusinessView where you need to put a root filter like this-
or you can also try this below condition-
Please try this and let us know if it works.
Thanks and have a nice day.
Subham Dixit
Hello Christa,
For this use case, you can create a specific BusinessView where you need to put a root filter like this-
or you can also try this below condition-
Please try this and let us know if it works.
Thanks and have a nice day.
-
Extend a model with new entities or attributes
-
Data types in xDM
-
Effective date on entities
-
Search using wild cards
-
Export a model from production and import on a development environment
-
"Allow Delete" vs "Allow Removal" privileges
-
LOV label in Named Query
-
Select location on a map and save coordinates
-
Is there a way to set up a master-detail relationship on browse mode?
-
Choose Either a Stepper or A Workflow Based on The User Privileges
See all 263 topics