I am adding a group to a page and I want the group label to have the currently signed in User’s ID, how can I accomplish this? (ideally through Developer Studio)
Solved
How can I dynamically get the user id to show in a group label?
Best answer by asanka1055
Hi
You can change .client and .projection files like below.
E.g:-
.client
@Override
group PricingGroup for SalesPart {
field CUser {
label = "User";
}
}
.projection
@Override
entity SalesPart {
attribute CUser Text {
fetch = "Fnd_Session_API.Get_Fnd_User";
editable = [false];
}}
+20
Hi
+20
BEGIN
INSERT INTO user_audit_log (
table_name, record_key, action_type, modified_by, modified_on
) VALUES (
'CUSTOM_ORDER_TAB', :new.order_id, 'UPDATE', fnd_session_api.get_fnd_user, SYSDATE
);
END;
Hi
For example if I have to expose it to the page’s projection then what does that look like or what does the syntax look like in the client file if I only need to add it there?
+9Hi
You can change .client and .projection files like below.
E.g:-
.client
@Override
group PricingGroup for SalesPart {
field CUser {
label = "User";
}
}
.projection
@Override
entity SalesPart {
attribute CUser Text {
fetch = "Fnd_Session_API.Get_Fnd_User";
editable = [false];
}}
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.