12-13-2012 2:28 PM
Hello,
I have created 2 tables. Each of these tables has a field created by.
Now, I created maintenance view for these tables and view cluster for these tables. (I did not include created by field in these view since I dont want those to be shown to user).
Whenever data is entered in the view cluster, I want the created by to be updated. How can I achieve this?
If I implement event in the view cluster would these fields be available?
Thanks and Regards,
Neha
12-13-2012 4:44 PM
Hello Neha,
I think you will have to add the CREATED_BY field in the maintenance view but you can hide it from appearing on the screen by entering 'H' in column 'P' on the View Fields tab.
Regards,
Akshat
12-13-2012 4:44 PM
Hello Neha,
I think you will have to add the CREATED_BY field in the maintenance view but you can hide it from appearing on the screen by entering 'H' in column 'P' on the View Fields tab.
Regards,
Akshat
12-14-2012 2:34 AM
Hi Akshat,
Thanks for the response. So, I should implement an event in view cluster now to ensure these checks?
Best Regards,
Neha
12-14-2012 3:15 AM
Yes, I believe so. But, you don't mean 'checks', right? Rather, you mean setting those fields in the event.
12-14-2012 6:43 AM
Goto SE54,
Enter you view Cluster name
goto the TMG
From the menu Environment--> Modification--> Events
Click on the New Entries Button
Event Number 05 TEST_SAVE Click on the button Just beside this field 'FORM Routine'
It will ask to create a new Sub-routine in a Include.
Say yes in a New Include.
A blank Include will be open for Editing.
Enter the code as follows.
FORM TEST_SAVE.
Break-Point.------> You can write your code. This will be triggered when ever user saves some data.
ENDFORM.
This should solve your problem..