Trackcare 2021.2

Please may I know  how to access SQL parameter with string as datatype with NO reference to SQL Table and SQL Column.

Hi Experts,

I have these two clarifications to make:

1. I am struggling to understand the process and method of accessing the SQL table with no reference to SQL parameter or Table but string

This is what I tried: Tired to create ERD diagrams and try to extract Primary and Foreign keys to associate, but I cannot in this case

I would like to do something like this

Select * FROM

SQLUser.SS_User SSU

LEFT JOIN SQLUser.CT_Loc CTL ON CTL.CTLOC_Desc = ?

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. 

Question: How can I join CT_Hospital with CT_Staff.

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.

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, 

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.