Hi AllI have a problem with the Datasource Designer in IFS. I want to create a table which show me different values based on different date / timeperiods. The values which I want to select are all located on the same view. I am able to generate the date in PL/SQL without problems. In PL/SQL I use subquerrys, in which I use different abbreviations for the same view. For example: (select round(sum(lo.hours_loaded)) from ifsapp.labor_operation_load lo where lo.labor_class_no = l.labor_class_no and lo.contract = l.contract and lo.company = l.company and lo.work_day between trunc(sysdate,'iw')and trunc(sysdate + 7,'iw')-1)in this example “l.” usees also the datasource “ifsapp.labor_operation_load”.As you can see, I use the same datasource in my query. In PL/SQL I receive differnet results for different Labor classes (as wanted). But when I want to create a Lobby Element
Hi allI am strugeling with the TOP-N Function. I have a list with the quantity of some product families orderd by the highest quantity. The hole list is also filtered to different sites, where the parts are available. Sometimes there are mor then 10 product families per site. But I want to show only the 10 product families with the highest quantity. In a bar Chart or a pie Chart it’s possible to enable the TOP-N function. I have tried to get the wanted result in PL/SQL. I’ve found two ways to set the TOP-N function correctly in PL/SQL. Both of them won’t work in IFS.In the first Option i’ve put the hole query in a SUBSELECT and set a filter on the ROWNUM. In the Datasourcedesigner I havn’t a Option, to enter a SUBSELECT over the hole query.In the second Option i’ve use the FETCH command at the end of the query. But I can’t add this command in IFS.Are there any other Solutions, to select only the 10 product families with the highest quantity and display the hole result in a list? Thanks
Hi @ADNAN I have two questions about the Drill Down function. Is it possible to have two drill down functions on the same element? For example, if you press the Picklist_No. that the Picklist Report and a view of the Shop Order table opens at the same time?My second question has to do with the same topic. Is it possible to open a picklist report with the drill down function? I try different options, but I don't get the desired result.ThanksAchilles0129
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.