Wildcard support for file name in reporting
Answered
I would like to be able to specify a wildcard character as part of a file name in the User and File Report. We receive files that include a date stamp as part of the name, and I'd like to be able to search the non-date part.
For example, If I specify "AFile*.txt", the report should return both "AFile2019-03-17.txt" and "AFile2019-03-18.txt".
-
Hello, Marty.
Thanks for the feedback and taking the time to submit a request.
As a small team with a large product roadmap, we have to pick new feature based on the value they'll add to the most users possible.
With feature requests posted to the community, we will gauge demand for this request.
While waiting for your request to gather the support of our community, we suggest browsing the other request and showing support for requests that you find valuable as well.
0 -
Marty.
Was doing some research on your request. You also may receive a support ticket with the same information.
Depending on the database that you are using, you could use a few wildcards in your text searches.
For example, for many DB searches you can use % as a wildcard. We actually prepend and append % onto anything that's typed into the file path search box and user name search box in the report generation tool in many cases.
You could try something like this to get what he's looking for (this is database-dependent):
afile%.txt
The above assumes SQL Server or LocalDB.0 -
Hi,
Thanks for the responses! We're using SQL LocalDB and it seems like % works fine. I'm guessing you're just passing the argument through to a LIKE condition in a dynamic query, so all the operators (https://docs.microsoft.com/en-us/sql/t-sql/language-elements/like-transact-sql?view=sql-server-2017) should work as well.
I don't see a way to close my request, but you've definitely answered it.
Cheers!
Marty Nickel
0 -
No problem Marty. Glad we could help.
0
Please sign in to leave a comment.
Comments
4 comments