Searching for "query to return entity fields "

Searching for "query to return entity fields "

I'd like to display all the field names in an entity (table) on a screen. The SQL command I used in SQL2008 management studio works fine, but I'm not sure how to put it in the advance SQL action as it doesn't like the "INFORMATION_SCHEMA.COLUMNS". Here's my SQL command:


if there's a better way to do this I'd like to know. Eventually the names will be used to populate checkboxes, but that's down the road.
Randy -

You don't need an advanced query, add a reference to the Entity_Attr Entity in System in your eSpace and that will let you get the list of columns in each Entity. The Entity entity in System has the information about the Entities.

Hi Randy, 

are you trying to do an advanced Filter builder to your application, so users can choose the attributes to search of any table? If so, take a look at this component