This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

WebDesigner collection type for JOIN

Hello Experts,

I need a collection in my local component which is a very simple JOIN between ESetHasEntitlement and Application table (Using Entitlement = XObjectKey)

How can I do this? I can't see any way to write SQL queries or the correct type of collection :(

Thanks

Kin

7.1.1

+1 Geraldine Hopf over 7 years ago

Join can be achieved with properties and rule for the collection. Or you can use DatabaseQuery and the Table QBMLimitedSQL.
Cancel
Up 0 Down

Cancel
0 michele.polizio over 6 years ago

Any example to show?
Cancel
Up 0 Down

Cancel
0 kinshasa over 6 years ago

I sorted this by loading the collections in a sequence. E.g.: First load ESet (with my where clause), then load ESethasEntitlement using the parent ESet collection
Cancel
Up 0 Down

Cancel
0 michele.polizio over 6 years ago

I created a new Database object with the view I need (after I will use it) but when I execute the preview the object is empty
Cancel
Up 0 Down

Cancel
0 kinshasa over 6 years ago

You need to load the collection maybe in the initialize node if required
Cancel
Up 0 Down

Cancel