在保存的“记录浏览器项目"搜索中找到表和字段 [英] Find the tables and fields in a saved search for Records Browser Item
问题描述
The issue we are having is trying to map/relate the fields with different tables from result of saved search created on Records Browser Item(http://www.netsuite.com/help/helpcen...cord/item.html).
我们有一个包含许多模块的零售库存管理系统.因此，将我们的专栏与NetSuite相关联的尝试已经进行了一段时间，没有任何结论.
We have a retail inventory management system with many modules. So the attempt relating our columns to NetSuite has been going on for a while without any conclusion.
我们正在尝试的方法是在调试器上运行SuiteScript并查看数据集.那些数据量相对较少的公司，我们是成功的.由于限制为10,000行，我们被困在返回1Mil的Item上.记录.当我们添加所有搜索列时，搜索将返回此数据量.添加/删除单个列的过程非常严格，仅使用一列就会返回10,000行以上的问题.因此变得不可能获取数据并完成映射过程.
The approach we are trying is to run SuiteScript on the debugger and view the dataset. We were successful those with relatively little volume of data. As the limit is 10,000 rows, we are stuck with Search on Item that returns 1Mil. records. The search returns this volume of data when we add all the search columns. The problem the process of add/removing individual columns is rigorous and just with one column it returns more than 10,000 rows. So it becomes impossible to fetch the data and complete the mapping process.
所以我想知道是否有什么方法只能看到保存的搜索的架构及其关系?
So I would like to know if there is any way we can only see the schema and their relationships for a saved search?
谢谢.
推荐答案
在SuiteScript 1.0中，这可以通过计划的脚本来实现，该脚本从保存的搜索中创建多个CSV文件( SuiteAnswers文章33496 )和管理限制( SuiteAnswers文章23406 ).如果将文件设置为无需登录即可使用"，则应该能够在没有凭据的情况下通过HTTP GET请求检索CSV.但是，这将使知道URL的任何人都可以看到数据，这是您必须考虑的安全问题.
In SuiteScript 1.0, this can be achieved by a scheduled script that creates multiple CSV files from a saved search (SuiteAnswers article 36206). You'll have to get around the search limit (SuiteAnswers article 33496) AND the governance limit (SuiteAnswers article 23406). If you make the file Available Without Login, you should be able to retrieve the CSV with an HTTP GET request without credentials. However, that will make the data potentially viewable by anyone who knows the URL--a security concern that you will have to consider.
在SuiteScript 2.0中，这可能可以通过Map/Reduce脚本来实现( SuiteAnswers文章43795 ).这可能是优化脚本的更好方法，但我自己尚未在SuiteScript 2.0中对其进行测试.
In SuiteScript 2.0, this can probably be achieved with a Map/Reduce script (SuiteAnswers article 43795). This may be a better way to optimize the script, but I have not tested it myself in SuiteScript 2.0.
这篇关于在保存的“记录浏览器项目"搜索中找到表和字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
