Reporting Wildcards


Reporting Wildcards

I would greatly appreciate any help you can give me with this topic:


We have in our keys multiple dimensions, for example 

First 3 digits: function

4th Digit: grade

5th Digit: Cost Category

6th-8th Digit: Project

9th-10th Digit: Location


The question is whether there are wildcards that would allow us to report on specific grades or even projects without having to do Excel data dumps to isolate the different dimensions.


For example, I'd like to find all the keys that have a 3 in the 4th digit.  In Excel I would be able to look that up as ???3*, or ???3??????.


Thank you for your responses!

2 Replies
Community Support Expert
Community Support Expert

Hi @balmasa 


To assist you further, would you please confirm the PowerSchool product you are referring to?



Jyotishka B.
Community Moderator

Remember to give Kudos to suggestions that help you!
If another user helps solve your issue, please select Accept As Solution on their post so others can see the solution, too!


Thank you very much!  I got the answer to my question and it was for BusinessPlus, CDD reports.


The wildcard to use for searching for specific characters within a key, but every other character in every other place is:  underscore _  so to find the 3 in my example above, you'd have to type 3 underscores and a 3, followed by an asterisk *  that is, you'd have: ___3* as the solution for my question above.


Thank you!