Build Information Links for a complex SQL Query

Build Information Links for a complex SQL Query
Steps
1. Run Query and get the details of result set column names with data type. 2. Pick a table from SQL query, and using it create elements. Save the elements with Same name and data type retrieved in step 1. Do not bother about what column you are using, just focus on data type of column, and save with the name retrieved earlier. 3. Use these elements to create information link as usual. 4. Keep Order of column elements in IL same as in result set of step 1. Any other order may create issues. 5. Edit SQL and replace whole custom SQL contents with your complex query Done
Information
The steps provided here can be used to build Information Links for a complex SQL Query, which may contain multiple sub-queries,joins, group by. order by etc. Notes: All the joined tables should be in same schema and DB. The Data on demand setup with this approach may create some issues, if resulting SQL query is not configured properly. in order to make IL support Data on Demand, "and " should be palced in according to SQL where clause.