Where is the CLM stored in the DB?

[CSI 9.01.01 on-premise]

Where is the Custom Load Method of a Form/Collection stored in the DB? (not the method/SP code, but its link to the form/collection)

Most other Form definition data is found in the Forms DB under tables like FormComponents, ActiveX, FormXYZ... but I cannot find the CLM of a form or collection...?

Find more posts tagged with

Accepted answers

All comments

Legacy Contributor

Formcomponent is just the definition of each elements on a form.

ActiveX is the VB script behind a form.

Their are lots development trainings which can be given to you by the company which installed you CSI.

Legacy Contributor

The CLM is stored in the IDO. It's referenced in the form on the Collections tab under the Definition.

dmitchell

You might have a look at the Variables table in the Forms DB...it might contain what you are looking for.

Legacy Contributor

Technically, it is in the Objects database, though that convention of separate App, Forms, and Objects databases goes away in CSI 10 in favor of a single database approach. However, where you would access it as a end-user is via the IDOs form, by clicking the Methods button (IDO Methods form). That is where IDOs configure IDO Methods to CLM T-SQL Stored Procedures/C# IDO Extension Classes mappings. On a form you would be selecting from this list of IDO Methods to implement the CLM functionality.

Legacy Contributor

Maybe my question wasn't clear: I'm NOT looking for the definition of the method's details (code, params or other contents).

I'm actually looking for the place in the DB where the link between a Form Collection and its CLM are defined.

So when I go into Edit/Design mode in CSI, then go to the Collections tab, and then add a CLM: where is this information stored?

I just checked the Variables table (in Forms DB) and it's not there (unless it has a strange indirect encoding).

dmitchell

So it may be different in 9.01 (we are using 9.00), but it should be stored in the PrimaryDataSource field of the Forms table, but that usually just contains a form variable (usually something like fds_DataSource) that stores the actual value (be it an IDO, CLM, etc) used for the primary data source of the form.

0712131256598360.doc

Legacy Contributor

CLMs are defined in the IDOs form under the Methods tab. They can reference stored procs or Custom Assemblies that are attached to the IDOs.

VISUAL Dashboards and Drill-downs.pdf

Legacy Contributor

Ok so I can actually see it too in some cases:

- in the Forms table there is sometimes a variable like V(fds_DataSource) in the PrimaryDataSource column

- this fds_DataSource form variable contains the whole IDO.CLM(parameters) information (not only the CLM name)

Other forms have an IDO name with brackets (like a constructor call, even though the IDO has no eponymous method), apparently when they do not have a CLM.

This is quite confusing but I think this might be the only answer to my question.

dmitchell

Yeah..it stores multiple pieces of information used to execute the query.

You could probably build a SQL query to find and parse out the information. Something simple like this will get you a listing of forms and their data sources that are using a CLM (as long as the CLM naming convention is being used)

select
f.Name,
f.PrimaryDataSource,
v.Name,
v.Value
from
Forms f
join Variables v on v.FormID = f.ID
where
f.PrimaryDataSource like 'V(%'
and v.Value like '%CLM%'

Copyright © 2025 Infor. All rights reserved.