Hi there,
My predecessor (Hi Tash!) set up several custom tables to display to some usergroups as system tables. These system tables were at one point, to my knowledge, in both our Live and Test clients. Now, I have noticed that they are missing from our Test db for all usergroups, even though they are still assigned in Security and still exist in the db.
I began trying to figure out why this was and found some forum posts explaining that custom system tables should be named with the prefix LTR. The system tables that I have noticed missing from Test begin with LT or LTX.
Could this be because of the naming convention? Does the copy from Live to Test run UP_POPULATE_REFTABLES_TABLE?
thanks,
frannie
Hi Frances,
Did you find a fix for this? I'm experiencing the same issue and oddly enough the table also disappeared from Security.
Thanks,
Janelle
I've resigned myself to the naming limitation, and use "LTR_X_" for naming cross tables that I want to appear in the Systems Tables.
Hi Janelle -
Yes, confirming what Gawain and earlier Paul said - I realized the reason they had disappeared from the application was because they were not prefaced with LTR. Similar to Gawain, we changed them to "LTRX_" to avoid this problem and now they are back.
(Of course if you rename tables make sure you know what-all depends on them!)
Best,
Frannie