Skip to Content
0
Former Member
Jul 30, 2013 at 07:29 PM

Passing Object Names Dynamically in Catalog Query MII 14.0.2

130 Views

Hi all,

I have been trying to see if there is a way to dynamically pass Object Names to the Catalog Query. My goal is to able to at runtime of a transaction pass an Object Name (namespace) in the Catalog as a parameter to run a 'RetrieveProperties' query on it. Such as passing "CatalogConnector.Root.ProductionUnit.EquipmentTag1" as a parameter in the Query.

I see that the BOBJ integration with MII 14.0 seems to have a parameter named 'ObjectName.1-xx' where in BOBJ one can dynamically specify the Object Name one wants to run a query on. That same parameter does not exist in the Catalog Query action block in BLS.

The benefit of having this is we have properties for a particular tag stored at different levels in its namespace, such as ProductionUnit has generic properties applicable to all child tags within that Production Unit so instead of storing it as a property of each tag we store it in a parent namespace group. To extract this currently we are having to climb the namespace and run a GetGroupDetails WS every step, but that is very inefficient compared to being able to after climbing the namespace pass the different parent groups as parameters in a Catalog Query to retrieve all relevant properties in a single query.

Thanks,

Joe