|
| | | StrataFrame VIP
Group: StrataFrame Users
Last Login: 10/10/2008 7:28:14 PM
Posts: 1,280, Visits: 3,259 |
| I just tried to create a view in the DDT based on a Union query. The view looks something like this:
Select Distinct
us_pk
,pm_id
,pm_key
,up_action
From SFSUserPermissionInfo
Union
Select Distinct
us_pk
,pm_id
,pm_key
,up_action
From SFSUserRolePermissionInfo
When I save it, it reports the following as the columns:
Column Table
----------------- --------------------------------------
pm_pk SFSPermissions
pm_pk SFSPermissions
pm_key SFSPermissions
pm_Key SFSPermissions
up_Action SFSUsersXPermissions
rp_Action SFSUsersXRoles
Distinct| us_pk SFSUserPermissionInfo| || Union
Distinct| us_pk SFSUserPermissionInfo| || Union
I deployed it and built a BO off of it and all seems to work, but the columns/tables are weird. I'm assuming that there are no significant ramifications of this, but I'd like to be sure all is OK. |
| |
| | | 
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Today @ 4:52:53 AM
Posts: 4,586, Visits: 4,571 |
| | I am sure that it is fine. The view is deployed through SMO and at times the columns can be rearranged under certain circumstances. You should be fine. |
| |
|
|