If I try this query:
select id, customers from pricelist where id=....
and the field customers is a many-to-many field, the result only show one (the first) customer?
How can I use a select-query to get an array of customers in the result?
For your case the query will not work as it is many to many relationship. You can use rbv_api.getRelatedIds API or template loop.
Hi all,
My question is - I have an object say "A" where i need to select user and provide his rating through grid control. A user can have many rating. Say- user "abc" has given 5 ratings - "1,2,3,4,5" so I calculated average of all the ratings in the grid by creating a read only field in grid. This is done.
Now i want to assign this average value to some field say "newfield"(decimalt type) in an object "A". means I want to extract the value of "average" field(exist in grid) to a new field named "newfield".
Please suggest me and find the solution soon.
Thanks.