MintJoomlaMintJoomla

Import of select field (SQL query)

Question Question | Reviewed Reviewed | Cobalt 8 | Hits: 831 | Comments: 1 | Bookmarked: 0 | Followers: 8

danielbidala VIP
Total posts: 153
30 Aug 2017 11:09

When a select or multiple select field is set to SQL (the dropdown options populated by SQL query) it stores an additional ID in the record_values table. Can we import that ID? If not, how does it work if I only import the value. What will happen when I open the record for editing?

Last Modified: 22 Sep 2017

Quote

Sergey
Total posts: 13,748
22 Sep 2017 10:57

danielbidala What will happen when I open the record for editing?

If in the field parameters you do not enable SQL then you will see thoe values. But if you enable SQL, most probably you will not see anything.

Import of such a dependable reference tables are complaicated.

Best way is to import IDs as they are, eneable SQL and make sure that IDs in source and destination sites tables does match.

Powered by Cobalt

Login (copy)