But if I change the name of the database to something different than, ="User" or in my case = "ActivityEvent" this would not work because the name of the table in the condition is hard coded and not dynamic and will not change according the the new value.

I would like to create a query that gives me the metadata of an Entity without using it's name hard coded.

Thank you!

In that case you can use a query parameter.

I thought about it, but if for example I change the name of the table "user" to "user1", how do I connect the value of the input paramater of @entityname to the new value without changing it manually. 

It will still be hard coded but outside the sql query.

Thank you

Can you explain me what are you trying to accomplish here? 

Are you trying to build a screen where you can search for a specific entity? Do you want to show these fields for every entity that you have?

Instead of hard coding the "User" string to the query parameter, you can just add a variable there and is no longer hard coded. 

I think your best option is through the SSKey attribute. This attribute is unique per table and is the same in all the environments.

You can also take a look at this forge component that can help you achieve what you want.

Hope this helps,

Pedro

Hi Roy,

this sounds like something I did before, the way I read it, you have some view of your entity available (such as the input view of a wrapper action or something) and as part of what you log, you also want to retrieve the metadata of whatever entity your wrapper is for, without explicitly having to hardcode the entity name.

So if that's the case (you have some view, input/local/whatever available of your targeted entity), my solution might work for you.

See attached oml.  It might be slow, so probably not to be used in bulk/critical situations.

So what I'm doing is take any objectified entity view, turn it into xml, and search for the entity name in the xml.

Dorine