Відео

Thanks for your compliment and interest.😊

There are a couple of ways to solve it. I believe there is customer_id connecting the 2 tables 'customer_invoice' and 'customer'. When you select customer, you should pass the parameter customer_id to pxx_customer_id (pxx is page number) in the invoice page. Assume in your invoice page there are some items from the customer table such as customer_name, customer_email, customer_location etc. First, you should have the page item pxx_customer_id, pxx_customer_name, pxx_customer_email, pxx_customer_location etc. Then go to the page item property pane, 'Default', 'Type' :SQL Query（return single value) , write SQL statement: 'select customer_name from customer where customer_id=:pxx_customer_id'. Similarly, this way is also appliable for other items like customer_email, customer_location etc. This is one way, hope it can help you. Thank you for you interested my channel.

Thanks for watching!

Thank you for your advice, I hope you will see a brand-new me in my next video😊

Thank you for you advice, I will do that if I am available😊, I appreciate you like my video and topic.

@@weililiu2119 great!

Card or class report region is different from the template component type about the checkbox selection. I will do that in my future video. Thank you😊

Can you send me a screenshot to my email cherryliu362@gmail.com? Thank you

It’s free

I will check it

Thank you Lady

Because 'Redirect to Page in this Application' doesn't request and pass the parameter to the server, and in page 12, I used dynamic action to get the value of original salary, current salary which are in the client side, not in server. Session is only stored in the server side, so we should submit the page to get the new session value. Hope it is helpful for your future developing. Thank you for asking.

@@weililiu2119 Thank you Weili

1). You can use V_USERNAME, V_PASSWORD as arguments instead of P9999_USERNAME, P9999_PASSWORD in the function DUP2_VALIDATE_USER_PASSWORD like below: create or replace FUNCTION dup2_validate_user_password ( V_USERNAME IN VARCHAR2, V_PASSWORD IN VARCHAR2) RETURN BOOLEAN IS l_password VARCHAR2(1000):=' '; l_stored_password VARCHAR2(1000):=' '; l_count NUMBER:=0; ... END; Then you can call the function DUP2_VALIDATE_USER_PASSWORD( :P9999_USERNAME, :P9999_PASSWORD) in your application. 2) In the function , declare variable, I add default value because you used sql like 'select ... into ...' Hope it can help you. Thank you for asking.

You can go to the button Behavior setting: Behavior: Action: Redirect to URL Target: apex.oracle.com/pls/apex/f?p=132071 (This is the app which you want to redirect） Hope it can help you.

Please check your email

I think the code should modify a little. It should use ‘parseFloat’ to ensure the number has 2 decimals. Thank for your question.

Thank you for your reply

Can we validate row level entry in IG and restrict the add row process

@@PMNDEV ua-cam.com/video/50TNO9DdMhk/v-deo.htmlsi=WfHN3Za5hn13sg4b

Thankyou for this but I want control on add row or validation on add row...means new add will not perform if previous row's column is empty ....like that check the validation on click add row button ​@@weililiu2119

I will see and try. Thanks

I’ll prepare for it

Glad it helped!

Yes. I will post a new video about this. I'd like to know if you have business requirement about this? Usually we sum columns in one report. Thank you for your question

@@weililiu2119 Thank you for replying , i will explain .For eg: i have 2 Interactive grid A and B .Interactive grid A have “salary” column and interactive grid B have “increment column” ,i need to take the sum of these 2 columns and show in interactive grid B as "total" column. how can i achieve this ?

@@BinuKP-m3q Thank you for your explanation. I'd like to know you just sum the 2 columns without modifying(just reading) rather than sum the 2 columns when the 2 columns change? Usually what we do, get the salary cell value when IG row is selected to the page item and put the page item as hidden, then when I select one row in the report B, sum the page item and 'increment column' value to the column 'Total'.

I modified the function request_rest_password in package MTL_AUTH_PKG, APEX_UTIL.PREPARE_URL ( p_url IN VARCHAR2, p_url_charset IN VARCHAR2 default null, p_checksum_type IN VARCHAR2 default null, p_triggering_element IN VARCHAR2 default 'this') RETURN VARCHAR2; P_checksum_type: Null or any of the following six values, SESSION or 3, PRIVATE_BOOKMARK or 2, or PUBLIC_BOOKMARK or 1. I added the session in URL and changed p_checksum_type from 1 to 2 If p_checksum_type=2, then we can use this value when you want to generate a private link that will only be available to you. It’s associated with the currently authenticated user. /****************** before zero session for pubilc user *****************/ l_url := apex_util.prepare_url(p_url => c_hostname||'f?p='||v('APP_ID')||':31:0::::P31_USER_ID,P31_VC:' || l_id || ',' || l_verification_code, p_checksum_type => 1); /*****************modify: session for the authenticated user ***********/ l_url := apex_util.prepare_url(p_url => c_hostname||'f?p='||v('APP_ID')||':31:'||v('APP_SESSION')||'::::P31_USER_ID,P31_VC:' || l_id || ',' || l_verification_code, p_checksum_type => 2);

I will try it. Thank for asking

Please take a look: ua-cam.com/video/dzY8iLedmZU/v-deo.html

I will consider and do it. Thanks for your question.

I will consider it. Thanks for your question.

好的，我会考虑，谢谢

Thank you🙂

Have sent it. Please check your email. Thank you for your interest

@@weililiu2119 Please check your email

It seemed that I didn’t receive your email. My email:cherryliu362@gmail.com

Respond via email. Please your email. Thank you for interest.

Send me email and contact:cherryliu362@gmail.com

@@weililiu2119 I sent a email for you to ask about your video badge list.

@@weililiu2119 Please add it in description or in comment section.

I will. Thanks.

Please take a look my new video ua-cam.com/video/FhFpSSvR-_Q/v-deo.html Thank you

Thanks @@weililiu2119, in the meantime, I managed to get the information.

But I would like to do the same for a page with multiple Interactive GRIDs. But it is not possible to do the same as IRs. Only one IG can be put in the "Request" area. I think it is a bug.