Dear community, I am interested to see if anyone has any experience or examples of executing Powershell commands from a custom menu? i.e. to perform any sort of O/S function , open explorer , etc? You can use something like below."C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe" "ipconfig"Everything is explained in the technical documentation.External Program Custom Menu Sample (ifs.com)Regards,
Has anyone managed to request or create an overview screen for the Approved Supplier List? We’ve created a lobby metric and would like to navigate to the ASL from it. The problem is that the data exists on a line level while the ASL is a form view. Navigating to it attempts to open the header, which does not contain the line level information. That in turn creates an error message for missing fields. An overview would contain both, but the screen doesn't exist. Hi @Cirrostratus ,You create create a table window type custom page and navigate to it. Custom Pages (ifs.com)Regards,
I äm trying to create a new lobby for Project Hour and Cost Analysis hence I have created the below sql query but I am finding it difficult to have a sub-total for every group of the same activity I wrote the following SQL query select distinct a.activity_description, a.resource_id as resource_id, b.resource_group_desc, a.qty_used as qty_used, a.qty_planned as qty_planned, a.project_cost, a.percent_used from IFSAPP.activity_resource_proj a JOIN IFSAPP.activity_resource_proj_sum b ON a.resource_id = b.resource_id AND a.project_id = '&Project_ID' ORDER BY activity_description Below is what I am gettting: I need a sub_total for Activity named 'DETAILED DESIGN’ as well as sub_total for '’ÍNSTALLATION SAFETY STUDIES'’ Hi @DAVIDO ,I think best solution would be to go for an IAL and use it in the lobby.You can get the total for each activity that way. Hope you are familiar with IALs.Regards,
Hi @hhy38 ,You are trying to insert a record to History tab when materials and operations are updated in Shop order.Therefore you can trigger event on below tables.SHOP_ORDER_OPERATIONSHOP_MATERIAL_ALLOC_TAB. Regards,
Thank you for your reply! Dumb question but can custom pages be created for existing IFS logical units? No but you can create a custom logical unit with fields (read only) to get data from Approved Supplier List related views.
Hi @MWitczak .Is there a way to limit the display on this overview to items with object_type ‘Activity%’? Yes but you will have to put the custom tab in activity level which means inside the Activity tab. Is there a way to default the information on this tab to the results of a custom search or something?It is not possible to set up a custom search on a tab.Regards,
Hi Nadeesha, thanks for your suggestions.. I did a work around and added LINE_NO as Source_Key_Name for the MenuItem1 and did not add this Qucik report parameter for MenuItem2 By this way.. when the Parameter ISNULL() I can Suppress the Summary field. Passing Static value won’t work as we expected.. so instead I passed some field name which would always have an value and use ISNULL() to suppress the Summary field on the report. Now that i think about it we could have a custom field (persistent) with the TRUE value and use it here. But thanks for letting me know. I have tried only the other way around. Kind Regards,
Hi, I created a Custom Field in the LU IncomingInvoice which returns the Coordinator Name based on the PO Reference. But there could be multiple PO References separated with a semicolon. When that is the case IFS returns no value. Is it possible to solve this issue, so that IFS returns multiple values when there are multiple PO References. Please see the screenshots below. Arguments: v.company, v.po_ref_number Select Statement: SELECT t.cf$_coordinator_name FROM Purchase_Order_cfv t WHERE t.company = :COMPANY AND t.order_no =:PO_REF_NUMBER Kind regards, Simon Hi @BZNSIMON ,You have to break all the PO in REF_NUMBER and then get relevant coordinators and then concatenate them.There could be simple changes. But this is the way. Try belowSELECT LISTAGG(t.cf$_coordinator_name, ',') FROM Purchase_Order_cfv t WHERE t.company = :COMPANY AND t.order_no IN (SELECT trim(regexp_substr('PO123,PO456', '[^,]+', 1, LEVEL))FROM dualCONNECT BY LEVEL <= regexp_count('PO123,PO456', ',')+1)Regard
Hi @EntNadeeL When I try your suggestion, I receive an Error Message. Please see the screenshot below. This is the data I used for the statement, can you see what is wrong: Arguments: v.company, v.po_ref_number Select Statement: SELECT LISTAGG(t.cf$_coordinator_name, ',') FROM Purchase_Order_cfv t WHERE t.company = :COMPANY AND t.order_no IN (SELECT trim(regexp_substr('PO123,PO456', '[^,]+', 1, LEVEL)) FROM dual CONNECT BY LEVEL <= regexp_count('PO123,PO456', ',')+1) Hi @EntNadeeL ,I didnt expect you to put the same code I sent. Because you have to replace the string with po_ref_number parameter like below. SELECT LISTAGG(t.cf$_coordinator_name, ',') FROM Purchase_Order_cfv t WHERE t.company = :COMPANY AND t.order_no IN (SELECT trim(regexp_substr(:po_ref_number, '[^,]+', 1, LEVEL))FROM dualCONNECT BY LEVEL <= regexp_count(:po_ref_number, ',')+1)
Hi @EntNadeeL I am sorry, i misunderstood. I tried it and received the following error message; Ah yes that was my bad.. with the keyword LISTADD there are few other thingsSELECT LISTAGG(t.cf$_coordinator_name, ',') WITHIN GROUP (ORDER BY t.cf$_coordinator_name) "Coordinator_list" FROM Purchase_Order_cfv t WHERE t.company = :COMPANY AND t.order_no IN (SELECT trim(regexp_substr(:po_ref_number, '[^,]+', 1, LEVEL))FROM dualCONNECT BY LEVEL <= regexp_count(:po_ref_number, ',')+1)
I am getting this error on a custom event when I try to post a background job using a Deferred Call. “Too many declarations of 'Deferred_Call' match this call” The Action Details of the event are below DECLARErowkey_attr_ VARCHAR2(32000) := '&NEW:ROWKEY';wo_no_attr_ VARCHAR2(32000) := NULL; app_amt_attr_ varchar2(2000):='&NEW:CF$_APPLICATION_AMOUNT';invoice_attr_ varchar2(2000):='&NEW:CF$_INVOICE_NO';po_attr_ varchar2(2000):='&NEW:CF$_PO_NUMBER';params_ VARCHAR2(32000) ;job_id_ VARCHAR2(32000) ;BEGINSELECT WO_NO INTO wo_no_attr_ FROM ACTIVE_SEPARATE_OVERVIEW WHERE OBJKEY=rowkey_attr_ ;client_sys.Clear_Attr(params_);client_sys.Add_To_Attr('wo_no_', wo_no_attr_ , params_);client_sys.Add_To_Attr('app_amt', app_amt_attr_ , params_);client_sys.Add_To_Attr('inv_no', invoice_attr_ , params_);client_sys.Add_To_Attr('po_no', po_attr_ , params_); transaction_sys.Deferred_Call(job_id_, 'EPS_TECH_UTIL_API.UPDATE_ACTIVE_WORK_ORDER_BKUP','ATTRIBUTE', params_,'Update the Work Ord
Hi @EntNadeeL , I managed to publish the custom field with the statement you provided, but I did not get the desired result. The field displays the Coordinator Name when there is one Purchase Order as reference, but it displays nothing when there are multiple Purchase Orders as reference. Please see the screenshot below. Do you know what is wrong? I assume it’s because PO reference is delimited by semicolon. We have used the comma in our select query. This could be the reason. Check the part in bold letters.SELECT LISTAGG(t.cf$_coordinator_name, ',') WITHIN GROUP (ORDER BY t.cf$_coordinator_name) "Coordinator_list" FROM Purchase_Order_cfv t WHERE t.company = :COMPANY AND t.order_no IN (SELECT trim(regexp_substr(:po_ref_number, '[^;]+', 1, LEVEL))FROM dualCONNECT BY LEVEL <= regexp_count(:po_ref_number, ',')+1)try and let me know.
Hi @EntNadeeL I also changed the comma is the last line to a semicolon and then I got the desired result! I aslo changed it in the first line, because now the results are separated with a semicolon instead of a comma. Many thanks for your help!! SELECT LISTAGG(t.cf$_coordinator_name, ';') WITHIN GROUP (ORDER BY t.cf$_coordinator_name) "Coordinator_list" FROM Purchase_Order_cfv t WHERE t.company = :COMPANY AND t.order_no IN (SELECT trim(regexp_substr(:po_ref_number, '[^;]+', 1, LEVEL)) FROM dual CONNECT BY LEVEL <= regexp_count(:po_ref_number, ';')+1) Good to hear that this got successful.
Hi @NerakYak ,When you install oracle you need to install it in Administrator option and should install oracle client 32 bit in order to work with Crystal Reports. If you are getting the oracle server option that means you have the client version but it seems like you havent installed oracle in Administrator mode. Then only you will get app\product\12.2.0\client_1\network\admin folder where you can add database entry in tns file.Hope this helps.Kind Regards,
I need to get page url in client model .How can I do for it . Hi @DalKylekY ,Please refer to URL (ifs.com)Hope this helps.Kind Regards,
Hi All, Condition Fields are used to add rules that control what data that can be entered in a page; rules to make fields mandatory or read only, and rules that filter drop down lists, depending on values of other fields. Conditional Fields is not working in our APP9 Environment, We have tried on different IFS windows but receive errors View[ Form Name ] is not found in dictionary I have refreshed the Dictionary Cache using the IFS Refresh Cache area. Kindly support me on this issue Print screen of some forms/window is attached below Regards Hi @WSHAH ,Could you please restart your application and see if its working?Btw your attachments are not available.
Hi @KanishkaLK ,TECHNICAL_OBJECT_REFERENCE view contains the records and KEY_REF field has the mappings to the functional object. API : TECHNICAL_OBJECT_REFERENCE_APIRegards,
Hi @DalKylekY ,Custom Actions currently do not support Methods such as,Return data (Functions or methods with OUT Parameters) Complex Data Types (PL/SQL Record Types) BLOB, CLOB Parameters PL/SQL methods exposed in Projections (_SVC package), client metadata package (_CPI) and Report package (_RPI) methods
thanks. but I need to execute action to update data and return values .How can I do for it. This is not currently available in custom actions.Regards,Nadeesha.
Hi @GTGes ,Try adding PLSQL procedures in a Crystal Report (Using SQL Expression Fields)as below. This should work. <ifsowner>.Delivery_Route_API.Get_Description(ROUTE_ID)ifsapp.Delivery_Route_API.Get_Description(ROUTE_ID)
Hi @BZNSIMON ,Your string manipulation is bit wrong.SELECT to_char(to_date(substr(cf$_co_date_order,1,10), 'DD-MM-YYYY'), 'iw') FROM customer_order_cfv
Can somebody help me on the functionality of the Field Description Editor. The changes made do not become visible in the views/fields changed. What am I suppose to do for it to become visible? Try restarting the application and see. Because framework caches FDs.Hope it works.Regards,
Hi @EntNadeeL and @ola.nissen , Thank you both for your replies and your help. @EntNadeeL I tried your suggestion, but this didn’t change the outcome. But instead of 10 I tried 8, and then I got my desired result, see below, all date's returned weeknumber 12. 22-3-2021 0:00 12 23-3-2021 0:00 12 24-3-2021 0:00 12 24-3-2021 0:00 12 25-3-2021 0:00 12 26-3-2021 0:00 12 SELECT to_char(to_date(substr(cf$_co_date_order,1,8), 'DD-MM-YYYY'), 'iw') FROM customer_order_cfv Yes it should be something with substr. Because previously it was leaving one character and 10 worked for me. 13 week is supposed to start on 28th. it gave me the right results.somehow good that it worked :)
Hi @ascheeka12 ,When you define a custom reference field as a LOV it will include the display text and all the primary keys and LOV marked fields as @dhlelk mentioned, in that view as columns.In below example you will get the Display text along with Contract and part no and every LOV marked fields if there are any as separate columns.
Dears, I want group by based on sequel of dates. valid from: 1/1/2019 to valid_to: 12/18/2020 should be one record and it is sequel of dates. and valid from: 3/1/2021 to valid_to: 3/31/2021 should be another record. so the result will be two records. how to partition based on sequel of dates. Hi @Ramadass ,When you group like that either you need to have condition for each date range or it should be like set of records per month. What are the conditions on your scenario? Above two date ranges have nothing in similar.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
