Hi,
We have created spatial table for annotation as per Bentley Map help document(In XM and V8I both are having same procedure). We have successfully registered with Microstation V8XM but where are when I tried to righister features with GSA in Microstation V8I, it is not showing annotation tables to register.Please find the SQL scripts as attachment.
Could you please help us on how to register annotation spatial table for PBAin microstation v8i.
We have used following versions:
In XM: Micostation 08.09.04.88 and Bentley Map 08.09.04.179
In V8I: Microtsation 08.11.07.171 and Bentley Map 08.11.07.117
See clip below
Greetings,
After reviewing your SQL script, it appears that you may have omitted the primary key definition for the annotation table which would have prevented the table being "discovered" during the "Register Features" process in the Bentley Geospatial Administrator. Attached is a revised version of your SQL script that can be used for comparison.
Regards,
Jeff Bielefeld [Bentley]
Jeff,
Thanks for the response. After applying primary key as suggested by you we are able to register annotation features for PBA successfully.
1) Bentley Map Help document (Working with Oracle->Defining Annotations->Assign Primary Key) confirms us that it will work with composite primary key. Help file example shows primary key is applied for "customers_text_id, customers_ref". Note that it has been working well with microstation V8XM as reported below.
Could you please comment on composite primary for annotations in V8i?. Does it not work in V8i?
2) I have a look up table/domain list (Status_Lkp table) to display to user. As we all know in my Oracle DB, feature table will store domain values instead of domain names unlike display to user (In display user will see domain names). But in my PBA it shows me domain value insted of domain name as per feature table from oracle. My domain list(Status_Lkp table) as follows
Please find the attachments for your review. Help in how to display domain names in PBA instead of domain values.
Veeresh
Veeresh,
First regarding the use of composite primary keys for annotation, you're correct that capability used to work. However when the ability to support arbitrary-depth features in Bentley Map was added for Oracle Spatial persistence, subfeatures were required to have primary keys. Since we only support single-column primary keys on root features, it seemed natural to require a single-column primary key on subfeatures as well. At the same time, the single-column primary key requirement made sense because workspace managed tables in Oracle Workspace Manager require single-column primary keys as well. I hope this helps in explaining the reasoning behind the change.
Next in order to display domain list values rather than lookup keys, you can use PBA expression that contains a VBScript similar to what is shown in the following:
To insert a new PBA VBScript expression, select and right-click on the PBA symbology setting for your annotation and choose "Insert > PBA (VBScript)" as shown in the following:
For your convenience, I've attached a sample SQL script and XFM schema which demonstrates the above. Please let me know if you've further questions regarding this matter.
Jerry it is quite difficult to see anything on your video - QuickTime Viewer doesn't have full screen option - please put here bigger screen size in page for your video.
Artur K,