Hi Experts

I am trying to pull the code tables Information and this code table has linked code table not exactly obviously joined by SQL tables or columns. This is confusing me. Please can you clarify how to link these two tables.

I will be generic to ensure, any privacy is protected

CT_Hospital has CT_Staff linked in.

When CT_Hospital has data, for that relevant hospital code, CT_Staff can be clicked and data entered.

When I see in the Components - > Items I do not see any SQL table or SQL column common between CT_Hospital and CT_Staff.

0 1
1 240

Hi Experts,

SQL access,

In the component window, I see that some of the fields have no reference to SQL, for example: The active flag.

how to know all the active elements, when getdate()>= DateTo or between time between From and To does not work in SQL, I see some existing code, with reference to CAST, please can you provide more details? Thanks a lot.

0 1
1 220

Dear Experts,

I have to pull out a report of certain code tables and this is my first script and I need to write many.

1. If I have to refer to the table, seeing the reference in the components with reference to SQL table and column,

can I use Select < What I need from the table>

Inner join with reference table?

I tried, I used the code table reference in the components, but I am getting errors,

0 3
1 206

Hi InterSystems Architects,

Please may I know the relationship between

1. Menus, Workflows, Workflow Items, Components, Code Tables, etc

Detailed relationship diagrams, how each element in each of the above are related to another.

2. When I extracted the data. I see ID number, but they aren't unique or related. I wanted to build a relationship between them myself in the absence of documents but I am missing the critical unique primary key of each and how they are referred in another table.

0 3
1 140