Can I use a Report Prompt for a note entry date with a NOTEXISTS statement? | Community
Skip to main content
C
CatherineKe
Level 5
September 27, 2024
Solved

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

  • September 27, 2024
  • 1 reply
  • 839 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by skyehansen

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.

1 reply

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe ChampionAccepted solution
September 27, 2024

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.

    C
    CatherineKeAuthor
    Level 5
    September 30, 2024

    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
    Community Advisor and Adobe Champion
    skyehansenCommunity Advisor and Adobe Champion
    September 30, 2024

    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/understand-wildcard-filter-variables

    Terms & ConditionsAccessibility statement

    Loading footer...