EXISTS statement for hour entries with no billing records | Community
Skip to main content
N
NickVa7
Level 9
October 20, 2020
Solved

EXISTS statement for hour entries with no billing records

  • October 20, 2020
  • 2 replies
  • 556 views

Hi WF Community,

I'd like to create a report that uses an EXISTS statement to show me hour entries that aren't associated to a billing record.

I have the following text mode filter so far, but it's not filtering properly and just showing me hour entries without billing records:

EXISTS:A:$$EXISTSMOD=NOTEXISTS

EXISTS:A:$$OBJCODE=BILL

EXISTS:A:ID=ID

project:entryDate=$$TODAYbw

project:entryDate_Mod=between

project:entryDate_Range=$$TODAYew

Does anyone know where I might be off path?

Thanks.

Nick

    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 Doug_Den_Hoed__AtAppStore
    Hi Nick, Since Billing Record ID is on each Hour (that’s what “ties them” together), I think this filter should suffice: billingRecordID_Mod=isblank Regards, Doug

    2 replies

    Doug_Den_Hoed__AtAppStore
    Community Advisor
    Doug_Den_Hoed__AtAppStoreCommunity AdvisorAccepted solution
    Community Advisor
    October 20, 2020
    Hi Nick, Since Billing Record ID is on each Hour (that’s what “ties them” together), I think this filter should suffice: billingRecordID_Mod=isblank Regards, Doug
    N
    NickVa7Author
    Level 9
    October 20, 2020

    Hey Doug!

    Funny enough, that was the first thing I tried, and it didn't work. However, I now know what was missing - some test data, in Sandbox where I was testing, that qualified ;)

    Thanks for pushing me back in the right direction.

    Terms & ConditionsAccessibility statement

    Loading footer...