cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamic Query Collection

Solved
Occasional Contributor

Dynamic Query Collection

Hello,

 

I am trying to wirte a dynamic query inside an HTML descriptor using [Collection].

My old code is:

 

[Collection = MyQuery] 

 

I am looking to have something like the following:

 

[Collection = "Select [Business Process] where ......"]

 

or 

 

<script> var dQuery = "Select [Business Process] Inherited Where [Organizational Process].[Short Name]  = " + [Property=ShortName/];

 

[Collection=dQuery]

..........

Any other suggestions are appreciated. 

Thanks in advance. 

2 Replies
Frequent Contributor

Re: Dynamic Query Collection

hello Sajam, This question is quite different from your last one Here when you are creating a new group inside your descriptor you can point at a registered ERQL query (with a parameter to catch the common object) or create an embedded query on-the-fly ... Then inside this group you will handle with the result directly. Hoping it was helpfull.
Lionel Mazurié
Contributor

Re: Dynamic Query Collection

Hi Sajam,

 

Asuming that you are developing for the static website - the query becomes 'dynamic' based on the object that you have selected.

 

You can use either the MetaAssociationEnd name to make the reference for example:

 

[Collection="Business Process"]

 

or the entire query - if you should use some additional filtering

 

[Collection="Select [Business Process] Where [Organizational Process] in &name And ..."]