Expand my Community achievements bar.

SOLVED

HELP with Report - Text Mode for EXISTS

Avatar

Level 7

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...

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

 

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

View solution in original post

4 Replies

Avatar

Correct answer by
Community Advisor

 

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

Avatar

Level 7

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!

Avatar

Community Advisor

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

Avatar

Level 7

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!!!!!!