Developer forum

Forum » CMS - Standard features » Item field of type dropdown list to select item type form entire solution

Item field of type dropdown list to select item type form entire solution

E-mail notifications
Hans Ravnsfjall
Hans Ravnsfjall
Reply
Posted on 21/04/2020 19:55:38

When creating a item field of type of eg dropdown, and wanting to use itemtype to populate the options for the dropdown field,it is - as far as I can see - only possible to select items from one wesite. In my case, i want to be able to select an itemtype that is used across multiple websites. Why is this not possible? Could you please make this possible?

 

Is there another way of doing this?

 

/Hans

 

 

 


Replies

 
Vladimir Shushunov Dynamicweb Employee
Vladimir Shushunov
Posted on 22/04/2020 04:41:19
Reply

Hi Hans,

May be a SQL source will suitable for you, e.g.:

Select all items:

SELECT [Id],[Font] FROM [ItemType_Font]

Get only page items:

SELECT [Id],[Font] FROM [ItemType_Font]
WHERE ID IN (SELECT [PageItemId] FROM [Page] WHERE [PageItemType]='Font')

Get only paragraph items:

SELECT [Id],[Font] FROM [ItemType_Font]
WHERE ID IN (SELECT [ParagraphItemId] FROM [Paragraph] WHERE [ParagraphItemType]='Font')

Note: this way doesn't take page permissions into account

 

Best regards,
Vladimir

 

 

You must be logged in to post in the forum