如何在GScript中用换行编写清晰的搜索条件公式?
在GScript中换行编写搜索条件的实现方法
完全可以通过换行拆分长搜索条件来提升代码可读性,以下是两种常用实现方式:
方法1:字符串拼接(兼容所有GAS运行环境)
通过+运算符将拆分后的字符串片段拼接,每个条件单独占一行:
function myDeleteSharingPublicLinks() { var files = DriveApp.searchFiles( 'visibility = "anyoneCanFind" ' + 'OR visibility = "anyoneWithLink" ' + 'OR visibility = "domainCanFind" ' + 'OR visibility = "domainWithLink"' ); while (files.hasNext()) { var file = files.next(); file.setSharing(DriveApp.Access.PRIVATE, DriveApp.Permission.NONE); } }
方法2:ES6模板字符串(更简洁)
Google Apps Script已支持ES6语法,使用反引号(`)包裹字符串,可直接换行编写,无需手动拼接:
function myDeleteSharingPublicLinks() { var files = DriveApp.searchFiles(` visibility = "anyoneCanFind" OR visibility = "anyoneWithLink" OR visibility = "domainCanFind" OR visibility = "domainWithLink" `); while (files.hasNext()) { var file = files.next(); file.setSharing(DriveApp.Access.PRIVATE, DriveApp.Permission.NONE); } }
注意:模板字符串中的换行和缩进会被保留,但Drive的搜索API会忽略多余的空白字符,不影响搜索逻辑。
内容的提问来源于stack exchange,提问作者J. Doe
相关产品推荐
相关产品推荐

