HELP with Report - Text Mode for EXISTS

[TegwynSt]

Hello Community!

I have reports that use "EXISTS" in text mode but I can't figure out how to "merge" them or find documentation on how to.

Here's what I have:

EXISTS:a:$$EXISTSMOD=EXISTS
EXISTS:a:$$OBJCODE=DOCFDR
EXISTS:a:documents:ID=FIELD:ID
EXISTS:a:name=Final Videos

and then another report for this:

EXISTS:a:$$EXISTSMOD=EXISTS
EXISTS:a:$$OBJCODE=DOCFDR
EXISTS:a:documents:ID=FIELD:ID
EXISTS:a:name=Final Files

can they be in same report? I have a few other final folders named something else so I'd like to add them all...

[RandyRoberts · Accepted solution]

EXISTS:a:$$EXISTSMOD=EXISTS
EXISTS:a:$$OBJCODE=DOCFDR
EXISTS:a:documents:ID=FIELD:ID
EXISTS:a:name=Final Videos	Final Files

Put a tab character between the "Final Videos" and "Final Files"!!!!

TIP: if this solved your problem, I invite you to consider marking it as a Correct Answer to help others who might also find it of use.
If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/mysocalledideas

[TegwynSt]

Thank you so much @RandyRoberts !!! worked like a charm - I was worried when the tab spacing started shrinking 4 deep lol.

If you know how I could just ask for any folder that contains the word "final" that would be even better but I will take this!

Love getting text mode help here!

[RandyRoberts]

Try this:

EXISTS:a:$$EXISTSMOD=EXISTS
EXISTS:a:$$OBJCODE=DOCFLD
EXISTS:a:documentID=FIELD:ID
EXISTS:a:folder:name=The Name Of Your Doc Folder Here
EXISTS:a:folder:name_Mod=eq

or you could replace the last line if you don't know the exact name of the folder

EXISTS:a:folder:name_Mod=cicontains

[TegwynSt]

PERFECT!!! using the alternate last line worked - and this is so much better because I wasn't sure if there were some one off folders that had "final".

THANK YOU!!!!!!