Databases Reference
In-Depth Information
USER, DU, DU123, DOMESTIC_US
USER, IF, IF123, INTERNATIONAL_FOREIGN
];
Section Application;
LOAD * INLINE [
Flight Type, %FLIGHTTYPE
"Domestic, Foreign Carriers", DOMESTIC_FOREIGN
"Domestic, US Carriers Only", DOMESTIC_US
"International, Foreign Carriers", INTERNATIONAL_FOREIGN
"International, US Carriers Only", INTERNATIONAL_US
];
In this script, we've created the
%FLIGHTTYPE
field. This field exists in both the
section access part of the script as well as in the actual data model, thereby acting
as a bridge field between these two sections. Through association, we can now limit
what a particular user can access within the data model.
Basing an inline table on existing data
One nice feature in the
Inline Data Wizard
dialog
is the
ability to load the contents of an already loaded field by
using
Tools | Document Data
. This can be very useful
when we want to group the values of an existing field.
You may notice that for the
ADMIN
user, we used an asterisk (
*
) instead of a
%FLIGHTTYPE
value. When we use an asterisk, it means that the user gets access
to all values listed in the reduction field. In this case, that means that
ADMIN
gets
access to the
DOMESTIC_FOREIGN
,
DOMESTIC_US
, and
INTERNATIONAL_US
flight types,
but not to the
INTERNATIONAL_FOREIGN
flight type, since that is not listed in the
section access table.
If we want the
ADMIN
user to be able to access the
INTERNATIONAL_FOREIGN
flight
type as well, we will need to add an additional line referencing the
INTERNATIONAL_
FOREIGN
flight type to the section access inline table. Let's do that now:
1.
Create a new line after the line
ADMIN, ADMIN, ADMIN123, *
.
2.
On this new line, enter the following values:
ADMIN, ADMIN, ADMIN123,
INTERNATIONAL_US
.
3.
Go to
File | Save Entire Document
to save the document.
4.
Click on the
Reload
button to reload the script.