URL to LSQL Analysis with Parameter

Nov 18, 2018 4:46PM

Summary

How to prompt on LSQL column so that assignment_id can be passed in URL?

Hi guys,

We have a Logical SQL analysis which we'd like to embed on the app screen, so it would be filtered by the AssignmentID parameter.

Usually, I would pass the following link on the screen:

"../../analytics/PATH&.....&col1="Assignment%20Event%20Details"."Assignment%20Id"&val1=#{pageFlowScope.AssignmentId}

this time I used a different column name (as it appears on the analysis):

.....&col1="OUTER_Q.ASSIGNMENT_ID"."OUTER_Q.ASSIGNMENT_ID"&val1=#{pageFlowScope.AssignmentId}

and used the "OUTER_Q.ASSIGNMENT_ID"."OUTER_Q.ASSIGNMENT_ID" is prompted filter.