SQL Queries - CAST Knowledge Base - Queries on objects - How to retrieve bookmark points

Purpose

This page provides queries to retrieve bookmark points which is used in Dynamic Link Manager for bookmarking.

Applicable in CAST Version

Details

Get OBJECT ID of “Calling Name”

Run this query to get OBJECT ID (<calling_name_object_ID>) of “Calling Name”)

SELECT * 
FROM   keys 
       INNER JOIN objfulnam 
               ON idobj = idkey 
WHERE  keynam LIKE '<calling_name_object>' 
ORDER  BY fullname;

Get OBJECT ID of “Called Name”

Run this query to get OBJECT ID (<called_name_object_ID>) of “Called Name”)

SELECT * 
FROM   keys 
       INNER JOIN objfulnam 
               ON idobj = idkey 
WHERE  keynam LIKE '<called_name_object>' 
ORDER  BY fullname;

Get BOOKMARK ID of “Calling Name” and “Called Name”

use the OBJECT ID <calling_name_object_ID> and <called_name_object_ID> from above 2 queries respectively to get the <BOOKMARK_ID>

SELECT * 
FROM   acc 
WHERE  idclr = <calling_name_object_id> 
AND    idcle = <called_name_object_id>

Get BOOKMARK POINTS using BOOKMARK ID

use the <BOOKMARK_ID> from previous query result to get the BOOKMARK POINTS

SELECT * 
FROM   acc 
WHERE  idclr = <calling_name_object_id> 
AND    idcle = <called_name_object_id>
 
SELECT info1 AS start_row_point, 
       info2 AS start_column_point, 
       info3 AS end_row_point, 
       info4 AS end_column_point 
FROM   accbook 
WHERE  idacc = <IDACC from previous acc query>

This resulting bookmark points will highlight the “Calling Name” in code viewer where

• (START_ROW_POINT, START_COLUMN POINT) indicates where bookmark /highlighting of “Calling Name” Starts
• (END_ROW_POINT, END_COLUMN_POINT) indicates where bookmark /highlighting of “Calling Name” Ends

Notes / Comments

Related Pages