topic Re: Populate table fields on insert in view cluster in Application Development and Automation Discussions

Populate table fields on insert in view cluster

former_member382625 — Thu, 13 Dec 2012 14:28:14 GMT

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

Re: Populate table fields on insert in view cluster

kakshat — Thu, 13 Dec 2012 16:44:58 GMT

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

Re: Populate table fields on insert in view cluster

former_member382625 — Fri, 14 Dec 2012 02:34:31 GMT

Hi Akshat,

Thanks for the response. So, I should implement an event in view cluster now to ensure these checks?

Best Regards,

Neha

Re: Populate table fields on insert in view cluster

kakshat — Fri, 14 Dec 2012 03:15:45 GMT

Yes, I believe so. But, you don't mean 'checks', right? Rather, you mean setting those fields in the event.

Re: Populate table fields on insert in view cluster

Venkat_Sesha — Fri, 14 Dec 2012 06:43:16 GMT

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..