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.
Discy Latest Questions
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.
kilineContributor
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!
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
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
OmairContributor
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
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)
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
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
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