Hello,
I would have a questions about adding new column to the entity InventoryValuePart, after adding my own attribute CF_SUM through configuration entity I would like to add this entity through page designer, however after clicking to the content + the Attribute will not display it, how can I solve it?
Thank you
Best answer by SimonTestard
I don’t really get this, what do you mean update and set a view?
You don’t set values in a view in SQL, only in tables, and you certainly wouldn’t do that in IFS without going through APIs.
If you just want to create a column that is the sum of two other colums, you just parse your argument (column names of the entity you’re creating the custom attribute for), and use that as part of your select statement.
So in arguments, you do “quantity, qty” (without the quotes, and assuming quantity and qty are the names of the columns you want to sum), and do “select :quantity + :qty from dual” for the select statement.
:quantity and :qty will be bind variables that are used to do the sum “per row” of the two columns in the entity you’re working with.
Hello,
This might happen due to this configuration is not approved for the additional views. Go to ‘Additional Views’ which you can see on the entity configuration window and approve it for the views which has ‘OBJKEY’ value ‘YES’. Then synchronize the configuration again and check whether the field is available for you to add.
Hope this helps!
Nipuna
and it is possible that it will be added to the value per part tab next to the Quantity column as a new column like CF_SUM? Because in this case it will add next to the Currency. Both, value per part and the table above this have the same name of entity = InventoryValuePart
Hello,
Since you want to add this field to the ‘Value Per Part’ tab, you need to navigate to the list which is visible under that tab.
Then try to add this field after approving for additional views as per my previous comment.
Once it is added, you can change the order of the fields either from column choose or dragging the fields up and down on the page designer view.
Cheers!
Nipuna
Thank you, it works. I also want add to this column some values, which I will fetch from view. (Oracle db). I want display in this column sum of quantity and qty columns. How can I achieve this? for example, this is my SQL query which I want to execute:
UPDATE IFSAPP.SOME_VIEW
SET FINAL_SUM = QUANTITY + qty
but i am not sure what should I input in fields Arguments
I don’t really get this, what do you mean update and set a view?
You don’t set values in a view in SQL, only in tables, and you certainly wouldn’t do that in IFS without going through APIs.
If you just want to create a column that is the sum of two other colums, you just parse your argument (column names of the entity you’re creating the custom attribute for), and use that as part of your select statement.
So in arguments, you do “quantity, qty” (without the quotes, and assuming quantity and qty are the names of the columns you want to sum), and do “select :quantity + :qty from dual” for the select statement.
:quantity and :qty will be bind variables that are used to do the sum “per row” of the two columns in the entity you’re working with.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
