Connection between Session Parameter and Query Subject

[satish217_1990]

There is an existing Framework Manager model which has Session Parameter configured for Data Source. When we change the Parameter, the data source is automatically getting changed in the existing Query Subjects. As far as I have seen I couldn't find any link between the Query Subject and Session Parameter. Any idea where the link would have been provided?

[MFGF]

There is an existing Framework Manager model which has Session Parameter configured for Data Source. When we change the Parameter, the data source is automatically getting changed in the existing Query Subjects. As far as I have seen I couldn't find any link between the Query Subject and Session Parameter. Any idea where the link would have been provided?

Have you looked at the SQL in one of the underlying data source query subjects? Does it reference the session parameter?

MF.

[satish217_1990]

Have you looked at the SQL in one of the underlying data source query subjects? Does it reference the session parameter?

MF.

Yes. I checked the Query subject present in Database layer. There is no reference to the session parameter.

[MFGF]

Yes. I checked the Query subject present in Database layer. There is no reference to the session parameter.

Have you checked in the properties of the data source in FM? It might be used in the Content Manager Data Source property?

MF.

[AnalyticsWithJay]

If the session parameter is not referenced in the SQL (referencing in SQL isn't a good practice, by the way), then it's likely in the data source connection properties.

Expand 'Data Sources' in FM, select the data source in question and look at the Catalog, Schema and Content Manager Data Source properties. They might have macros referencing the parameter.