I could not come up with a better way to title this post as I’m not really sure what I’m doing So, here’s the deal, I want to display a table view from the i18n_messages table exactly like the I18N files does when you open it in developer. Simple enough to show the message_key and message_value where message_language IS NULL, but when trying to show the message_value in the ‘default’ column when the locale is different I am not able to get the data pulled in correctly.
I have created a relation i18n_messages_to_i18n_messages where the From is based off of a global var that holds the language with the operation equal to message_language but I get errors. When adding message_key = message_key I get into a loop that causes me to have to kill the Servoy Developer task and restart. If I use message_id=message_id it does not error, but returns no data in the Locale column.
Basically, I’m just trying to reproduce the I18N form in developer but in a solution (well kinda but not completely). Any ideas?
CFDaddy:
I have created a relation i18n_messages_to_i18n_messages where the From is based off of a global var that holds the language with the operation equal to message_language but I get errors. When adding message_key = message_key I get into a loop that causes me to have to kill the Servoy Developer task and restart. If I use message_id=message_id it does not error, but returns no data in the Locale column.
What version of Servoy is this?
Also it sounds odd that Servoy would get into a loop when you use a relation with a global (I do that all the time). It’s a straight global relation?