Hi @cilik , You right, we should use parent key columns (P) + list (L). I thought you have already known that the project activity will give you all activities in all projects and you will be gotten a ton of data in LOV. I don’t know what is purpose of your report. For my opinion, if users would need to run the report after the status approved, I would recommend you to use view “ACCOUNTING_PROJECT_LEDGER” instead of “PROJECT_ACTIVITY”. However, the you have make sure you granted this view to users are not accounting too.
Hello, I’m trying to prepare a quick report with parameter has default values. (IFS10) Like given example in F1 development guide; “ SELECT * from customer_info where customer_category_db = '&CUSTOMER_INFO.CUSTOMER_CATEGORY_DB' ” I have used “ where t.project_id LIKE '&PROJECT_LOV.PROJECT_ID' ” but this is not working. Does anyone know why ? What is difference between them ? I can’t tell you why because I didn’t see whole statement in PROJECT_LOV statement and I do not think you CUSTOMER_INFO statement is work because of parameter incorrect. In my opinion, you should use select t.* from project_lov t where t.project_id like nvl(‘&Project_ID’,’%’)
If you want the check box in both screens can update the values. You have to create an event action to submit a commend to background job and that command will be updated the value in another screen for you. For your example,User checked in customer orders in background event action start to create a background job. That will update your check box in shop order. Also, if user unchecked in shop order in background event action start to create a background job again to update the value in customer order. Does it help?
@IFSmattis, you were missing a semi-colon. You can copy my statement below. WHERE (';&[-C--L]catalog_no;' LIKE '%;' || aspd.catalog_no || ';%' OR aspd.catalog_no LIKE NVL('&[-C--L]catalog_no','%'))
@IFSmattis, Let try this.WHERE ( ';&VAR1;' LIKE '%;' || PART_NO || ';%' )
I have used ISO20022 in IFS8. For me it’s not complicate just follow the document. What is version you on?
I have used the statement below. SELECT CUSTOMER_ID, NAME FROM &AO.CUSTOMER_INFO WHERE ( '&[-C--L]VAR1' LIKE '%' || CUSTOMER_ID || '%' OR CUSTOMER_ID LIKE NVL('&[-C--L]VAR1','%'))
Already have an account? Login
No account yet? Create an account
Enter your username or 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.