Retrieving Object Name via SQL in BC

(0) Share

Report

Posted on by Community Member

Dear All,

Need assistant on Object name. I am using Jetreport to query BC to build user permission report.

When i query permission table, it will only return Object ID and not Object name.

I had then manage to find the Object name in the table "Application Object Metadata" as follow.

However for Object ID 200XXXX onwards, the data is not stored in this table. Anyone know where is the object 200XXXX being stored? so that i can point and pull the object name?

However 6254.table.png

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Gearoid on at

Like (0)

Report

Hi,

Maybe you can use the "Object Metadata Snapshot" table:

SELECT [Object ID]
,[Name]
FROM [Demo Database BC (18-0)_CU6_W1].[dbo].[Object Metadata Snapshot]
where [Object ID]='2000000111'

Was this reply helpful? Yes No