Advance Query Editor

Advance Query Editor

  

How can send the query dynamically to query editor?

Means If i enter (select *from employees)  in UI

 It should evaluate it and corresponding records should be displayed.

Can some one throw light on this please


Regards,

Sandeep

Hi Sandeep,

Attached is a basic OML for reference. 

WARNING!!!!: Please be advised that you never use these kind of functionalities in Production, because it can ruin your database.

Kind regards,

Remco Dekkinga

Thanks a lot Remco for the prompt Reply.

But if I want to retrieve only one Attribute {Employee}.[Name] Its throwing an Error

"Could not assign '' to 'GenericStruct.Attribute2'... Index was outside the bounds of the array."+


Can you help me to fix this issue. How we can able  to create a dynamic structure to solve this error


Regards,

Sandeep

Hi Sandeep,

This is a common error. You probably have a mismatch on columns returned or the type of the field returned is not the same as the type of the field in the query.

Kind regards,

Remco Dekkinga

Remco Dekkinga wrote:

Hi Sandeep,

This is a common error. You probably have a mismatch on columns returned or the type of the field returned is not the same as the type of the field in the query.

Kind regards,

Remco Dekkinga

Hi Remco,

To the same OML file you provided How can i retrieve only single column with the same generic structure ?

Regards,

Sandeep

Solution

Hi Sandeep,

You can select one column and then select 9x an empty string, because the generic structure has 10 fields.

Kind regards,

Remco Dekkinga

Solution