Announcements
1,703
I have been struggling trying to create a view on a custom entity with the following criteria
‘Submission_Status’ = ACCEPTED , EXTRACTED, REJECTED PROCESSING, SUBMITTED
WHERE ‘Submitted_date’ = TODAY()
Or Submission_Status’ = UNSUBMITTED
(There is no ‘Submitted_date’ )
Or Submission_Status = APPROVAL
(There is no ‘Submitted_date’ )
Is this possible and if so what grouping should I use
*This post is locked for comments
you need to AND
‘Submission_Status’ = ACCEPTED , EXTRACTED, REJECTED PROCESSING, SUBMITTED
WHERE ‘Submitted_date’ = TODAY()
Then or condition for
Submission_Status’ = UNSUBMITTED
Submission_Status = APPROVAL
and Complete OR for all three conditions.
so your conditions will look like in advanced find
Submission_Status’ = UNSUBMITTED
OR
Submission_Status = APPROVAL
OR
Submission_Status’ = ACCEPTED , EXTRACTED, REJECTED PROCESSING, SUBMITTED
AND
‘Submitted_date’ = TODAY()
To do grouping you need to select condition and add group.. group is shown on the top ribbon
Pete,
Try this format
Hope this helps!
#1
Mohamed Amine Mahmoudi
83
Super User 2025 Season 1
#2
Community Member
54
#3
dkrishna
6
Share
Report
All responses (
Answers (
