Can I use a Report Prompt for a note entry date with a NOTEXISTS statement?

[CathyKe1]

I have a user report that shows which of my Work users did not enter a note (Note Text) last week. I’d like the time frame to be more flexible, allowing report users to select the time they want to see via a Report Prompt. Is that possible when I’m using NOTEXISTS in the filter for the note entry date?

This is my current text mode in the report Filters:

EXISTS:A:$$EXISTSMOD=NOTEXISTS

EXISTS:A:$$OBJCODE=NOTE

EXISTS:A:entryDate=$$TODAYb-1w

EXISTS:A:entryDate_Mod=between

EXISTS:A:entryDate_Range=$$TODAYe-1w

EXISTS:A:ownerID=FIELD:ID

isActive=true

isActive_Mod=eq

licenseType=T

licenseType_Mod=in

[skyehansen · Accepted solution]

Yes and no. You could introduce more flexibility for example, by putting in 3 or 4 different options like "didn't enter a note last week", "didn't enter a note in the past month", and so on. But each option would be its own separate and complete exists statement.

[CatherineKe]

Thank you so much, @skyehansen. That is exactly what I needed! I have added a couple of custom prompts and they are working as expected.

However, I'm stuck on adding some custom prompts that apply to days. Specifically, I want to know who hasn't entered a note in the last two days. What I'm attempting to use seems to be considering the weekend days. How would I tell it to look at business/weekdays?

For example, since today is Monday I want information regarding the previous two work days, which would be Thursday and Friday. However, this prompt is pulling information for Saturday and Sunday:

---

EXISTS:A:$$OBJCODE=NOTE&&EXISTS:A:entryDate=$$TODAYb-1d&&

EXISTS:A:entryDate_Mod=between&&

EXISTS:A:entryDate_Range=$$TODAYe-2d&&

EXISTS:A:ownerID=FIELD:ID

[skyehansen]

it's likely you might not be able to do this. Take a look at the documentation on wildcards. If it's not in there, it just might not be possible.

https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/report-elements/underst...