Page History
...
Where, 1 denotes the primary organization. (Note that this is done system wide, and cannot be enabled for specific client organizations. Therefore this value must always be 1.
For view joins
During the creation of views, you can configure outer joins to be treated as inner joins when creating View relationships in the database.
Following is the SQL command for this:
Code Block |
---|
INSERT INTO Configuration(IpOrg, ConfigTypeCode, ConfigCode, ConfigData) values(1, 'SYSTEM', 'DISABLEOUTERJOINCHECK', 'TRUE'); |