How do you implement 2 data sources (views) into the lobby data source designer. I want the following code to return the count in the data source.select distinct(sp.catalog_no)from lora1app.sales_part sp, lora1app.sales_price_part_join splp where splp.catalog_no = sp.catalog_no and splp.SALES_PRICE_TYPE_DB = 'SALES PRICES'and sp.activeind_db = 'Y' and (splp.part_valid_to_date >= (sysdate) or splp.part_valid_to_date is null)and splp.valid_to_date >= (sysdate) --currently I have gone about it the following way seeing that the data source cannot handle two views:select distinct SALES_PART.Catalog_NO from SALES_PART where SALES_PART.activeind_db = 'Y' and SALES_PART.Catalog_NO in (select catalog_no from sales_price_part_join where sales_price_part_join.catalog_no = SALES_PART.CATALOG_NO AND sales_price_part_join.SALES_PRICE_TYPE_DB = 'SALES PRICES' and (sales_price_part_join.part_valid_to_date >= sysdate or sales_price_part_join.part_valid_to_date is null) and sales_p
When I preview my data source I see the following count returned in the data source preview and database (toad)However, when in the lobby overview, the element is not returning data Any ideas?
Does anyone have an example of how they are configuring/managing contexts in IFS Aurena?Specifically for elevated permission sets in IFS 10.Example:I could create a context called base sales and configure a read only sales profile to the respective usergroup mapping.I could create a context called salesAdmin and configure a sales Admin who can change data in screens to the USERGROUP = RSMBut what about the one off scenarios of users who are in the base sales user group whom do not have admin permission set but need elevated privileges in Aurena (Edit data or see additional screens)From my understanding, They cannot simply be added to the salesAdmin context or group of users since Aurena takes the highest level of permissions for contexts a user is apart of. How do you go about configuring context mappings for these 3 scenarios? Base sales profile Sales admin profile Base sales profile with additional permission sets/privledges (but is not an admin)Thanks,
Hello, When creating a custom field expression using the following API:LORA1APP.ORDER_SUPPLY_DEMAND_API.GET_ORDER_SUPPLY_DEMAND_TAB(CONTRACT, PART_NO, CONFIGURATION_ID, PROJECT_ID)I receive the following error. I have tried formatting the API with TO_CHAR but no luck. Any guidance on how to resolve this? I have also tried writing the following SQL statement to return the results field ORDER_SUPPLY_DEMAND_TYPESELECT ORDER_SUPPLY_DEMAND_TYPEFROM CUSTOMER_ORDER_LINE_DEMANDWHERE order_no = :order_noAND line_no =:line_noAND rel_no = :rel_no When using the above SQL argument to create the custom field I receive the following error Please advise, Thanks.
In Aurena, Is there a way to remove a time card shortcut? Now whenever we select a value from the project activity the shortcut was created for it populates as the shortcut value and not the actual project activity. Please advise. Thanks,
Why are these 2 links coming up as right justified? they are set up like the rest of the links which are coming in as expected in aurena. In IEE they come in normally but in Aurena these 2 links are to the right?
I am attempting to navigate to inventory parts from a lobby. The following web access url address for the nav works page/InventoryParts/List?$filter=Cf_Lmw_Inv_Meth eq IfsApp.InventoryPartsHandling.CfEnum_LMWINVMETH'CfEnum_6'cfEnum_6 returns all the non safety stock inventory methods (6 is the db value for CF$_LMW_INV_METHOD_DB that correlates to LMW_INV_METHOD value of non safety stock) So essentially CfEnum_6 is the hardcoded value for non safety stock. In my case I need this to be a dynamic variable to return the enumerated value based off the users input. what would the syntax for this be if using a variable in replacement of ‘CfEnum_6’my initial thoughts were the following which did not work:page/InventoryParts/List?$filter=Cf_Lmw_Inv_Meth eq IfsApp.InventoryPartsHandling.CfEnum_LMWINVMETH'CfEnum_[CF$_LMW_INV_METH_DB]'
In the IFS lobby data source. How do you go about appending a ‘$’ to the front of a value? Below is what I am attempting to concat in the column:CONCAT(‘$’, round(SUM(&AO.Customer_Order_Line_API.Get_Base_Sale_Price_Total(ORDER_NO, LINE_NO, REL_NO, LINE_ITEM_NO)),0))
Hello all,Our organization recently upgraded to IFS Cloud instance. I have lobbies working in IEE and Aurena Interface. But when looking at these lobbies in IFS Cloud, some of the elements are working and some are not.The debug logs say : Application - Unable to initialize lobby element. Type=List, Title="Part Numbers with no Lead Time Values"Any idea what is causing these elements to not work in Cloud?? (working in IEE and Aurena with same code) Appreciate any insight into this.
Is there a table/query that shows the connection between the LU system control value and the data source object (to be able to tell what form/screen a custom field is coming from)
I have a lobby that is working in IEE and returning data. But when migrating from IEE to Aurena. I get an invalid data source definition error. The client type is set to Aurena. IN AURENA IN IEE data source: Also the elements that are returning data are returning null values. Any ideas why this is?
Is there a way to export a context and all its configuration from a test instance to PROD?Please advise. Thank you!
I am looking for the Navigation path link to the following Logical units in IFS IEECommodityGroup InternalCustomer WorkType SiteMscomInfo TechnicalSpecAlphanum PurchaseOrderReservation ProjectConnectionDetails
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.
