Setting values of entity selection qodlysources

General
1

Can I set the initial value of a qodly USER entsel source to something like:

ds.ACCOUNT.get(ID).accountOwners(entsel attr).userAuthorizations(entsel attr).authorizedUser(entity attr)

This would ideally return a USER entsel? with zero or more USER entities.

or do i need to:

  1. Set the value that way via function or
  2. Use a querystring to set the initial value

If i am able to use a querystring, can I query to find any user whose attribute:
accountAuthorizations(entsel).authorizingOwner(entity)
(should return one or more account owner entities)
is contained in an account owners entsel qodly source, “theOwners”

QUERYSTRING to return a USER entsel?:
“:1 in :2”, accountAuthorizations.authorizingOwner(entsel), theOwners(entsel)
Would something like that work as a querystring?

Thanks. I like my lean table setup but makes for a few involved relationships/related attributes.

2

Hello Robert, thanks for your feedback.

If you want to initialize an entitysel Qodly Source, it is possible to add a standard action to that Qodly Source and apply it (by choosing the type “Query”) a querystring with placeholder values (:1, :2,…).

There is also another way to set up the entity selection initially: creating a function and returning an entity selection.
Inside that function, you can manage a query (or queries) depending on your needs.

Best regards.

1 Like