Collaboration with other software
About model and data exchange with 3rd party solutions: Revit, Solibri, dRofus, Bluebeam, structural analysis solutions, and IFC, BCF and DXF/DWG-based exchange, etc.

query for retrieving parameters of objects table

Anonymous
Not applicable
Hi,

i wanna query the parameters value and parameters variable name from parameters _of_ objects table.

I cud manage to get it work using the querys as below
select xx.parameters.type,xx.parameters.value,xx.parameters.name from Flat(objects,parameters) as xx where xx.parameters.variable_name='easy_ID' and id='59E19E78-BE54-4D09-8CCC-91A35009DAE8'

Now what i wanna do is instead of using id='59E19E78-BE54-4D09-8CCC-91A35009DAE8', i need to query from other table as
select lb.object_id from objects as ob,labels as lb where ob.id=lb.object_id

when i execute this query alone,it works fine, but i dont know how to insert this query in where clause....... can any1 please help me in this regard????

Thank u
0 REPLIES 0