Sign Up

Hey, Dev!
Are you looking for a forum full of active developers to help you?
So if you want to:
➡️ Get answers for your development issues
➡️ Help others
➡️ Write an article
➡️ Get rewarded for your active participation
Then this place is just for you and it is 100% FREE.

Have an account? Sign In


Have an account? Sign In Now

Sign In

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

Sorry, you do not have a permission to ask a question, You must login to ask question.

Forgot Password?

Need An Account, Sign Up Here
Sign InSign Up

OrclQA.Com

OrclQA.Com Logo OrclQA.Com Logo

OrclQA.Com Navigation

  • Ask Question
  • Write a Tutorial
  • Online Courses
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • Image to Base64
  • PL/SQL Beautifier
  • Ask Question
  • Write a Tutorial
  • Online Courses

Discy Latest Questions

Shimul
Shimul

Shimul

  • 22 Questions
  • 23 Answers
  • 0 Best Answers
  • 145 Points
View Profile
  • 1
ShimulProfessional
Asked: May 15, 2022

I Need barcode Scaner which scans using camera on mobile and transfers it to a page variable.

  • 1

I need barcode scanner plugin on Oracle Apex which scans barcode using camera on mobile ios, android phones and transfers it to a page variable.

apexoracleoracle apex
  • 0
  • 10
  • 0
Answer
ElopezApex
ElopezApex

ElopezApex

  • 1 Question
  • 2 Answers
  • 0 Best Answers
  • 25 Points
View Profile
  • 0
ElopezApexContributor
Asked: May 12, 2022

How to retrieve values without using submit page in a shuttle

  • 0

Hi, I have two Popup LOV, where with a dynamic action "P4_CUSTOMER" refreshes the other Popup LOV "P4_FORMS": Where I filter it as follows "P4_FORMS": select SYW_FORMS.FORM_NAME as FORM_NAME, SYW_FORMS.FORM_ID as FORM_ID from SYW_FORMS SYW_FORMS where CUSTOMER_ID = :P4_CUSTOMER; Cascading List of Values: P4_CUSTOMER In my shuttle I have the following "P4_ROLES": List of Values select SYW_ROLES.ROL_NAME as ROL_NAME, SYW_ROLES.ROL_ID as ROL_ID from SYW_ROLES SYW_ROLES where SYW_ROLES.CUSTOMER_ID = :P4_CUSTOMER Cascading List of Values: P4_CUSTOMER   Source Type: SQL Query (return colon separated value) select SYW_FORMS_ROL.ROL_ID as ROL_ID from SYW_FORMS_ROL SYW_FORMS_ROL WHERE SYW_FORMS_ROL.FORM_ID = :P4_FORMS This is what I have configured in my apex, but I can't get my shuttle to refresh the data without doing a submit page that I run in a dynamic action in "P4_FORMS".   Thanks.    

apexoracle apexquestionshuttle
  • 3
  • 25
  • 0
Answer
kiline
kiline

kiline

  • 1 Question
  • 1 Answer
  • 0 Best Answers
  • 26 Points
View Profile
  • 0
kilineContributor
Asked: May 6, 2022

How to get value of select list in ig

  • 0

Hi, so i have a problem when i try to get value out of interactive grid i get [object Object] in text field. I found out the reason  for that output is because i was trying to get value out of select list column. When i try with any other column type textfield or numberfield it works great and return value correctly. That's the javascript code I am using for retrieving value. if(this.data != null){ if(this.data.selectedRecords[0]!= null){ selectedRecord =  this.data.selectedRecords[0][4]; apex.item( "P34_TEST" ).setValue(selectedRecord); } } Thank you for any help!  

apexigjavascriptselect list
  • 1
  • 37
  • 0
Answer
Awais
Awais

Awais

  • 1 Question
  • 0 Answers
  • 0 Best Answers
  • 25 Points
View Profile
  • 0
AwaisContributor
Asked: April 29, 2022

APEX Cascading List of Values in master detail

  • 0

There is a master form on my page and there is an Editable interactive grid on same page. Can someone tell me that how can I make master table field as parent ( Cascading List of Values) of a column in interactive grid LOV

apex
  • 0
  • 23
  • 0
Answer
Bhavin
Bhavin

Bhavin

  • 6 Questions
  • 14 Answers
  • 0 Best Answers
  • 57 Points
View Profile
  • 0
BhavinProfessional
Asked: April 28, 2022

Oracle Apex - Role Based Custom Authorisation functionality for Apex app

  • 0

Do you have any kind of example/blog/tutorial to implement the custom Role based functionality for the Users (from users table) so particular users can only have an access to certain pages or page component (say Button) based on user role. We can have user role like Super User or Admin, Manager, Clerk and User. Your help and support would be greatly appreciated. Kind Regards, Bhavin Adhvaryu

apexauthorisationcustomrole
  • 0
  • 25
  • 0
Answer
Omair
Omair

Omair

  • 2 Questions
  • 1 Answer
  • 0 Best Answers
  • 31 Points
View Profile
  • 0
OmairContributor
Asked: April 18, 2022

Cascading List of Values in master detail

  • 0

There is a master form on my page and there is an Editable interactive grid on same page. Can someone tell me that how can I make master table field as parent ( Cascading List of Values) of a column in interactive grid LOV Omair Farooq

apex
  • 0
  • 8
  • 0
Answer
Omair
Omair

Omair

  • 2 Questions
  • 1 Answer
  • 0 Best Answers
  • 31 Points
View Profile
  • 0
OmairContributor
Asked: April 18, 2022

Grand Total on page Load when we navigate from report to form

  • 0

I am using this code for grand total function calcordertotal(){ let orderTotal = 0; model.forEach(function(record, index, id) { let total = parseFloat(model.getValue(record, "AMNT")) if (!isNaN(total)) { orderTotal += total; } }); $s('P121_NEW_1', orderTotal); } this code work fine on runtime. when we enter new record on grid. but when we navigate to form from report its not work (not show grand sum in P121_New_1)

apex
  • 3
  • 26
  • 0
Answer
Bheem
Bheem

Bheem

  • 24 Questions
  • 15 Answers
  • 0 Best Answers
  • 175 Points
View Profile
  • 1
BheemProfessional
Asked: March 24, 2022

how to do smart filters like below in Oracle apex

  • 1

How to implement filters like this. for example when i click gear button popup opening below the button.   https://apexapps.oracle.com/pls/apex/apex_pm/r/ideas/home

apex
  • 0
  • 40
  • 0
Answer
AhmedHaroon
AhmedHaroon

AhmedHaroon

  • 26 Questions
  • 25 Answers
  • 0 Best Answers
  • 166 Points
View Profile
  • 2
AhmedHaroonProfessional
Asked: March 24, 2022

Apex Collection: how to have actual column names instead of C001, C002...

  • 2

created a page to allow users to input SQL statement, when user press button, it should Execute this query and another region with Classic Report will display results. on Button a Dynamic Action execute PL/SQL code below: on Click event: begin IF :P17_QUERY IS NOT NULL THEN APEX_COLLECTION.CREATE_COLLECTION_FROM_QUERY ( p_collection_name => 'MYCOLLECTION', p_query => :P17_QUERY, p_truncate_if_exists => 'YES' ); end if; end; Item to Submit: P17_QUERY second Action refreshes CR region and CR region is based on: SELECT * FROM APEX_COLLECTIONS WHERE COLLECTION_NAME = 'MYCOLLECTION'; resulted columns are not limited to the query results and column headers are C001, C002, C003 etc. a) how i can limit the columns to the SQL statement contained and b) how to change header to the actual column names please help with sample/example. regards

apexcollection
  • 5
  • 69
  • 0
Answer
AhmedHaroon
AhmedHaroon

AhmedHaroon

  • 26 Questions
  • 25 Answers
  • 0 Best Answers
  • 166 Points
View Profile
  • 0
AhmedHaroonProfessional
Asked: March 9, 2022

IG: sum of multiple columns SAL and COMM - how to?

  • 0

hi Vinish created a page, region is IG using EMP table, below code is working fine to calculate sum of SAL column. what if i have to aggregate multiple columns like SAL & COMM both. how i can do it? note: have copied below code from another app as i dont know JS (function($) { function update(model) { var total_amt = model.getFieldKey("SAL") , totalAmt = 0; model.forEach(function(record, index, id) { var totalamt = parseFloat(record[total_amt]), meta = model.getRecordMetadata(id); if (!isNaN(totalamt) && !meta.deleted && !meta.agg) { totalAmt += totalamt; } }); $s("P10_TOTAL", totalAmt); } $(function() { $("#emp").on("interactivegridviewmodelcreate", function(event, ui) { var sid, model = ui.model; if ( ui.viewId === "grid" ) { sid = model.subscribe( { onChange: function(type, change) { console.log(">> model changed ", type, change); if ( type === "set" ) { // dont bother to recalculate if other columns change if (change.field === "SAL" ) { update( model ); } } else if (type !== "move" && type !== "metaChange") { update( model ); } }, } ); update( model ); model.fetchAll(function() {}); } }); }); })(apex.jQuery); regards

apexdynamic sumig
  • 0
  • 29
  • 0
Answer
Old Questions

Sidebar

Ask Question
Write a Tutorial

Recent Blog Posts

  • Vinish

    What is Oracle ERP?

  • Vinish

    The Benefits of Unit Testing

  • Vinish

    Java OOPS Concepts MCQ Quiz

  • Vinish

    What is the Best Database to Use?

  • Vinish

    Sending Query Strings in Post Requests in C#

Explore

  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • Image to Base64
  • PL/SQL Beautifier

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
© 2021 OrclQA.Com. All Rights Reserved.
Privacy Policy - About Us