cancel
Showing results for 
Search instead for 
Did you mean: 

DQL - Bulk input of search paths

Phil_Rosier
Level 4

Hi,

I have a report which searches a list of paths for certain types of files such as vmdk, for example.

FROM dfspath
GET absname
IF extension = 'vmdk'
AND (substri(dfspath.absname, '<search path1>')=1 
OR substri(dfspath.absname, '<search path2>')=1)

Is there a way to read in the list of search paths from a CSV file rather than hard-coding them into the report. I tried using the IN FILE expression but this looks for a exact match of the pathnames whereas we are search for files below these paths.

Alternatively, does DQL support wild characters such as '*' or '%'

Any advice is much appreciated as always.

Phil

 

 

 

 

 

 

1 REPLY 1

Rishi_Thaper
Level 4
Employee

Hi Phil,

This would require multiple DQL queries and SQL post-processing. In case you are using 5.0, post-processing can be utilized from UI. Otherwise, you would need to write the SQL query outside DI.

Regarding wild characters, DQL doesn't support these but provide match / matchi functions for regular expressions.

Regards,

Rishi