Form和Web 界面查找字段-优快云博客

本文链接：https://blog.youkuaiyun.com/zhangzhongjie/article/details/84098223

本文将指导您如何在数据库界面中查找特定字段，并通过SQL语句获取所需数据。包括如何确认视图或表，使用应用程序密码访问，以及在Web界面上通过视图或页面详情找到字段名。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.在此界面点击历史记录，报错，说明此字段在此界面为非基表字段。

[img]http://dl.iteye.com/upload/attachment/604085/df362fb5-8aa0-3622-a4cd-e9d0e90eb353.jpg[/img]

2.原始成本在账簿界面可以查询到

[img]http://dl.iteye.com/upload/attachment/604087/c654b881-bd6a-3e0a-b8c4-281a80d2f57a.jpg[/img]

3.点击历史记录

[img]http://dl.iteye.com/upload/attachment/604089/6ce38f02-3f82-3a61-8b1c-b813df71556f.jpg[/img]

4.确定是哪个视图或者哪个表

[img]http://dl.iteye.com/upload/attachment/604091/37162707-fcf0-389b-9902-d76467efcd4a.jpg[/img]

5.鼠标点击相应的列，点击查看

[img]http://dl.iteye.com/upload/attachment/604093/010293f3-41e9-3d51-adf4-3288b40bb735.jpg[/img]

6.输入apps密码

[img]http://dl.iteye.com/upload/attachment/604095/90669f3b-dde5-33d6-a07a-44aa9b7a63a6.jpg[/img]

7.取出字段名称

[img]http://dl.iteye.com/upload/attachment/604097/2c24a23d-d124-339f-bc5d-4fddeb814af3.jpg[/img]

8.sql 如下：

select fb.original_cost,fb.* from fa_books_v fb

9.要查具体的表，则打开视图 fa_books_v 即可

l Web 界面上查找字段
1. 先确定要找的字段，这里我以‘人员’字段为例。

[img]http://dl.iteye.com/upload/attachment/604099/4ebd185e-cac6-388b-943b-c58270da064a.jpg[/img]

2. 点击左下脚的 ‘关于此页’，后点击‘全部展开’

[img]http://dl.iteye.com/upload/attachment/604101/2d68daa7-bf7e-35f7-b897-49bcafc3059a.jpg[/img]

3. 找到 ‘人员’

[img]http://dl.iteye.com/upload/attachment/604103/295a252a-e4b5-3fb8-bacc-49b51a1ff9c8.jpg[/img]

4. 点击 ‘TeamHighlightsVO’ 后面 ResourceName 代表是这个列

[img]http://dl.iteye.com/upload/attachment/604105/45a0b3f7-0291-3b8a-bf07-162bc2e3b8cd.jpg[/img]

5.则已经找到对应的sql。