Expand my Community achievements bar.

Project name "starts with" filter

Avatar

Level 2
Can someone tell me if there is a way to filter project names by "starts with". Text mode? Cynthia Lee American Equity
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

4 Replies

Avatar

Level 10
Hi Cynthia, Yes, you can use the "Contains" parameter. Vic Alejandro, PMP, CSM | IT | Sr. Technical Project Manager Denver Water | t: (303-628-7262) | c: (303-319-6473) "http://www.denverwater.org/"> http://www.denverwater.org INTEGRITY | VISION | PASSION | EXCELLENCE | RESPECT

Avatar

Level 2
We currently use that today, but because many of our projects start with "AE" we also get other projects that have these letters in the name. Cynthia Lee American Equity

Avatar

Level 8
This is an old thread, but wanted to document the solution I just figured out. In my case, I wanted to filter on any projects where the value in a Department Number custom field starts with 020. This is the filter code I used, and I put a % at the end of 020 for the wildcard: DE:Department Number=020% DE:Department Number_Mod=cilike Adina Pierce Cisco

Avatar

Level 10
Very nice, Adina. Workfront uses Oracle under the hood as its database, and % is Oracles wildcard character. Oracle also uses _ as a single character wildcard, which (if it works similarly within Workfront) might be useful for searching for patterns. For those interested in other special Oracle search characters and techniques, refer to "https://docs.oracle.com/cd/F49540_01/DOC/inter.815/a67843/cqspcl.htm">https://docs.oracle.com/cd/F49540_01/DOC/inter.815/a67843/cqspcl.htm Regards, Doug