Binding dropdown using macro

It expects IEnumerable. Helps says: Macro expression (without macro brackets). The result of the expression should be an enumerable object whose items will be used to fill the list. For example: CurrentUser.PurchasedProducts.DisplayNames.

Try: TopicsInfoProvider.GetTopics().Columns("TopicsID", "TopicName").AsEnumerable() or TopicsInfoProvider.GetTopics().Columns("TopicName").AsEnumerable()

Dont forget to import linq namespace.

If this doesnt work you may switch to List of Options and try to macro directly there:

{%TopicsInfoProvider.GetTopics().Columns("TopicsID", "TopicName").AsEnumerable()
.Select(t => t.TopicID.ToString() + ";" + t.TopicName + "\n" )|(identity)GlobalAdministrator%} and it works.

P.S. Is there a reason why you dont want to simply query your Topic table?

      

HI, Thanks for your response.

TopicsInfoProvider.GetTopics().Columns("TopicsID", "TopicName").AsEnumerable() or TopicsInfoProvider.GetTopics().Columns("TopicName").AsEnumerable()

Both are not working. It is displaying TopicName along with the Object name. Like Material.TopicInfo(material.topics)-"Name of the Topic"

Am I missing something?

I am not querying directly, since I need to display only those topics which are part of some other object or table and in that table topic ids are present as comma separated.

Thanks.

I guess this is how ToString works. Did you try the second suggestion?

Remove Columns, i.e. your macro should do just return TopicsInfoProvider.GetTopics().AsEnumerable()

Switch Data source to List of Options and try 2nd macro directly there:

{% TopicsMacro.Transform("{#TopicsID#};{#TopicName#}\n")|(identity)GlobalAdministrator%}