Is there a way to make a Dynamic list property to be based on information that we currently have in a customer database? What I'm trying to accomplish is displaying certain data from the customers database based on what the editor sets on the page and to elminate problems that editors fill in the wrong values I would like the Dynamic list data to be based on information from the database.
Table1: Persons | Columns: Id, Name
Table2: PersonInformation | Columns with different information.
What I want to accomplish i so that the Dynamic list data i based on values in Table1: Persons and then the page list the information for that person based on the id-value set in the Dynamic list.
Is there a solution for this?
You can do that with a custom property and/or dynamic content. Let the user select the person/persons in a dropdown or checkboxlist and then perform whatever logic you need to render the corresponding list.
You could use page providers to pull the information into the EPiServer page tree. Editors can then select a page that represents the customer and use the information in the page provider page to display. Obviously depending on the number of customers you will need to structure the tree appropriately.
My basic thought was to create a custom property. Though I was hoping that there could be a simpler way, perhaps by using attributes on a class that just returned a collection with (string, string) items to be used the same way as you would set in the config.