how to refresh a embeded list

[alvatindra]

I need to   refresh the embeded list( of table pq) which is kept on other table(xyz) form. I am inserting values of xyz into the pq table with mapping fields through script.

The values are inserting into the table pq but its not showing in the embeded list on time. When I am reloading the page ,the values are shown in the embeded list.

[Harsh Vardhan]

After Business rule:

I am getting the result in table. but i don't understand why it's not reflecting in embedded list.

based on user reference i want to populate some records in embedded list.

[Chuck Tomasi]

Are you refreshing the form? Just because something was added to the table doesn't mean it will automatically show up in the form. Record watcher will tell you if a field was changed, but not related records in a related list or embedded list. For that you need to refresh.

Also, where are you relating the records in u_user_mailbox_and_aliases to the current record? Somewhere I would expect to see a reference field making reference to current.sys_id.

E.g.

embed.u_parent = current.sys_id; // or something like this

That's how records are related... through reference fields.

[Harsh Vardhan]

i simply save the form.

so how can i populate the record in embedded list? if embedded list will not solve my requirement do you have any other suggestion for it. i am on geneva version.

"user reference" field is referencing to sys_user table and there is a column user_name. based on that user_name i queried

into the "u_user_mailbox_and_aliases" table and get the "aliases" record now i need to populate it in aliases column.

Thanks,

Harshvardhan

[Chuck Tomasi]

Sorry if I wasn't clear. Your embedded list appears on a form. That form is a record on a table (I'll call it table_a for sake of this example.) Somewhere in your u_user_mailbox_and_aliases table, you have a reference field to table_a. I don't see that being populated by your script so therefor, there's no relationship. The records are likely being created (if you look at the entire table in a standard list you should find these records), but they just aren't "linked" to table_a because you never told them about table_a's record sys_id (current.sys_id).

[Harsh Vardhan]

there is a relationship between "table_a" and "u_user_mailbox_and_aliases".

Applies to table: just for your understanding it's table_a

Queries from table: embedded list table

if i need to make changes in my business rule where should i do ?

by the way i have a column on "u_user_mailbox_and_aliases" table that is reference type field and reference to the "table_a"(real table name is "u_ad_account_creation")