Actually, I manage to get that pop up (but for a weird reason, the displayed message is truncated, I don’t know why, maybe the message is too long), but still, my issue is I don’t manage to run my event only in the case when rowstate goes from Preliminary to Completed, but on the other side, that works (although this context is excluded) SQL code I used : Client_SYS.add_info('Client', 'Rowstate = &NEW:ROWSTATE');
Hello William.Thanks for your feedback, but in my case, I don’t need to verify the OLD:ROWSTATE value, but just the NEW:ROWSTATE one.Have you made some tests with the action type = execute online SQL?Actually, I would need to display a message to the user, so I use the Client_SYS.add_info function.So that is the exact context that I have to work on.Edit : I defined my event this way : On the event action screen, I defined no particular condition to run the event just to verify if my event can well be ran, which is not the case today.
For info, I have a similar issue with the purchase order lines screen (url = ifsapf:tbwPurchaseOrderLine_Ext )
Hi @romsar “To be able extend a View with Custom Fields or Information Cards, all records in the view must have a rowkey which correspond to a record in the base table. There are views defined which are created using joins or unions where this is not the case. Custom fields and Information Cards functionality would not work on these views.” https://docs.ifs.com/techdocs/Foundation1/040_administration/220_user_interface/020_custom_objects/090_cus_obj_references/060_KnownLimitations.htm you can try one of below. You could first add part_no as a read only custom field (referring to PURCHASE_REQ_LINE_ALL ) and then pass that to this query. Or you could join PURCHASE_REQ_LINE_ALL to above query and pass order no, line no and release no information using params and join the part number. (I did not try this though but should be possible.) Hi, thanks for the reply but there is something weird on the IFS side : I managed to add the custom field on the configuration, I can see the new cus
You can join in the view that has part number and then supply the three key parameters instead of just part no: SELECT i.storage_zone_idFROM invent_part_putaway_zone i, purchase_req_line_all pWHERE i.part_no = p.part_noAND i.contract = p.contractAND p.requisition_no = :requisition_noAND p.line_no = :line_noAND p.release_no = :release_noORDER BY ranking DESCFETCH NEXT 1 ROWS ONLY Many thanks for your reply, although I could synchronize the configuration, the new custom field is not listed among the custom field list available.On SQL side, I can see the new custom field on the PURCHASE_REQ_LINE_CFV view
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.