Hello;

I'd like to ask you about DynamicList and filtering.

I have two catalogs:
- Clients
- Caretakers

Clients catalog has tabular section, in which References to Caretakers can be saved. So One Client can have many Caretakers.

And now in ItemForm of Caretaker, I want to display the Clients which are under care of the Caretaker. I added a DynamicList, sel ected the Clients Catalog ... and now I want to filter it based on the tabular data fr om Clients catalog (in which the references to Caretakers are held). How can I do this?

I tried Custom Query, but then I'm stuck with the Parameter - I don't know how to assign the Form's Object.Ref to it.

Please help

Hello,

In the ItemForm's module, try using this:

&AtServer
Procedure OnCreateAtServer(Cancel, StandardProcessing)
   ClientsList.Parameters.SetParameterValue("Caretaker", Object.Ref);
EndProcedure

SEL ECT
   ClientsCaretakers.Ref
FR OM
   Catalog.Clients.Caretakers AS ClientsCaretakers
WH ERE
   ClientsCaretakers.Caretaker = &Caretaker

Thank you very much, it works!

My Query is as follows:

SEL ECT
   CatalogClients.Ref,
   CatalogClients.DataVersion,
   CatalogClients.DeletionMark,
   CatalogClients.Predefined,
   CatalogClients.Code,
   CatalogClients.Description,
   CatalogClients.Caretakers.(
      Ref,
      LineNumber,
      Caretaker,
      Percent
   )
FR OM
   Catalog.Clients AS CatalogClients
WHERE
   CatalogClients.Caretakers.Caretaker.Ref = &Caretaker

You're welcome, good day!

Good day to you as well I would like your post if I could, but I don't have permission to vote.