DNNCommunity / DNN.FormAndList

Design your own table complete with field types, validation and custom user permissions.
MIT License
28 stars 20 forks source link

Save DNN Page link #112

Closed maduranga001 closed 4 days ago

maduranga001 commented 4 days ago

DNN 9.13.4 FNL 6.5.8

I use URL field to select existing DNN pages. But it saved the tab ID. How can I save the page link to the database UserDefinedData table? I need to get this and show it back via an SQL to display in a chart. So I need it to save as the URL.

How can I do this? Please, can you help?

Thank you!

valadas commented 4 days ago

You could do a join on the TabId and the TabPath from the Tabs table potentially and then you can get the portal alias too by using the portalId of that tab and the PortalAliases table...