Hi, I want to create a Lobby Data Source which shows the sum of values stored in 3 views. Therefore, I need to create an IAL. But I struggle to get the desired result. I created the SQL Statement in the SQL Query Tool and it gives the result I want. But how do I implement the statement in an IAL? Your help is appreciated. The SQL Statement: select OPPORTUNITY_NO "ID", DESCRIPTION as Description, 'BO' "Type", EST_OPPORTUNITY_VALUE as Valuefrom BUSINESS_OPPORTUNITYWHERE OBJSTATE <> (select ifsapp.BUSINESS_OPPORTUNITY_API.FINITE_STATE_ENCODE__('Cancelled') from dual) and OBJSTATE <> (select ifsapp.BUSINESS_OPPORTUNITY_API.FINITE_STATE_ENCODE__('Closed') from dual)UNIONselect QUOTATION_NO "ID", CATALOG_DESC as Description, 'SQ' "Type", ifsapp.Order_Quotation_Line_API.Get_Base_Sale_Price_Total(QUOTATION_NO, LINE_NO, REL_NO, LINE_ITEM_NO) as Valuefrom Order_Quotation_LineWHERE OBJSTATE = (select ifsapp.ORDER_QUOTATION_LINE_API.FINITE_STATE_ENCODE__('Planned') from dual) or OBJSTA
System IFS Apps10 UPD8 Is it possible to create a drill down to an IAL or information source? I have create a lobby chart element and the data source is an IAL. The user has requested the ability to drill down to actual detail and cannot see a way to do this. For now I have created a quick report to the IAL and passed the year and week no that the user has clicked on in the chart but the quick report parameter dialogue box is displayed (with the year/week no) and the user has to click OK. I was hoping the parameter window would be somehow hidden and just opened the report.Thank you.
Hi AllIm trying to create a custom event which needs to use the Time portion of a DATE field, in this case to run a check against Holiday Request records. When I put the event code in as follows, it only seems to bring through the Date itself with the Time always being set to 00.00.00. This is despite the Debug Console showing that the time being put into the database is something else such as 11.30.00.Has anyone had any success with the use of Date and Time in custom events?My event code currently is DECLARE TIME_TO_ TIMESTAMP := TO_TIMESTAMP('&NEW:TIME_TO', 'YYYY-MM-DD-HH.MI.SS');BEGINerror_sys.Record_General('',TIME_TO_);END;The error shows that only the Date part is filled. I have tried DATE instead of TIMESTAMP with the same resultCheersGareth
I have a project set up that has related work activities. Note that this activity field is a custom field. When I want to search for an activity to attach to this particular project, the search brings up every activity in the database, for “all” projects. Is there a way to customize this activity field or the Search to only populate the activities for the project I have assigned in the line?Just looking for a way to possibly speed up the search.
Is it possible to link to another lobby from a lobby. I tried creating a link element with the page ID of my sub lobby but that didn’t seem to work
We have a Counter lobby element that when we drill-down it is loading all CustomerOrders- not just the ones for the SQL behind this element.The SQL uses an IAL - RW_ORDERS_SHIPPED_TODAY2, which is built on another IAL (RW_ORDERS_SHIPPED_TODAY).I’ve done other lobbies where the drill-down works, so I don’t see what’s different with this one, unless somehow IALs aren’t recognized? select count(*) from ifsinfo.RW_ORDERS_SHIPPED_TODAY2where contract = 'W'
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.