I want to add some linked field (from Process Table) on specsheet. I know I have to modify the AT_View ( in this case AT_INST) in order to add these fields. But there are fields mismatch between the AT_INST view from the specsheet module and the one found in Project Administrator > Select Project > Expand Database > AT_Views > AT_INST ( or the one found in Project.mdb). The one in the specsheet module contains fields from Process or Pipe_run Table (like PSZ, POPP, POPT) but not the one found in Project Administrator (see image).
Where can I modify this AT_INST query used by the specsheet module ?
Thank you,
Eric
Eric,
The differences you are seeing is caused by the way the Datasheet Module's coding structure formats that "Available Fields List". It shows all fields in the Doc_Reg table (this is for Datasheet related data only), next depending on what datasheet your using (built per tag_type) will depend on its Tag Register table next shown. In this instance it's tag_type is AT_INST so the Tag Register table will be the INSTR table. Next will be the AT_View linked to the Tag_Type for this Datasheet which is AT_INST. To stop duplication the coding will remove available fields that are already shown in the INSTR or DOC_REG table or Vice Versa. Next come the Project tables data and the finally I believe the Project.ini values.
How to add new fields to link a cell to?
You will need to add the new fields to the AT_INST view in Project Administrator. These new fields will be available in the AT_INST view "Available Fields List" in the DataSheet's module.
I hope this answers your questions. If not please reply back and we can continue our discussions.
Brandon Moberg
Hi Brandon,
Thank you for the detailed explanation. I tried to modify the AT_INST view in Project Administrator, but like I said, the fields there doesn't correspond to the one found in the Datasheet Module. I've check every table in the Fields Tab ( Inst_a, Tag_reg, Instr_d, Instr_e) but I cannot found the field like Psz or Popp that are on the Datasheet Module. It seems that there a mismatch, I should found table like Process or Pipe_Run ( on the left side where they show table).
Regards,
Hi Eric,
There is an existing post that you might already read. communities.bentley.com/.../how-do-i-add-custom-fields-in-the-datasheet-field-list.aspx
From this post:
DOC_REG: All Tags will have this option to pull the Document Information.INSTR: This is the Tag Register table for Instruments. All others will show TAG_REG.View [AT_INST]: This is the AT_ System Query that works with the AT_INST Tag_Type. This will be different for each Tag_Type.STREAM: This is shown for all Tag_Type Datasheets. It allows the user to add any related Stream information.PROJECT.INI: This allows the user to add any values that are stored in the Project.ini such as Client Information, Project Descriptions, etc.This is all hard-coded and added on the fly via core code. This cannot be modified.Regards,Artiom
Did the post from Artiom above help resolve the problem? If not possibly we can setup a meeting to further discuss your issue.
I already read this post from the Wiki. Yes, I think we can setup a meeting to discuss this point.