Marco
2 years agoContributor II
What is the table from which the information of the QView comes from? (sql question)
I'm running a SQL query to display the data as if it were a QView, but I realized that the table I was using didn't contain the values it should.
SELECT
EntityId,
UD1Id,
UD4Id,
TimeId,
ICId,
Amount,
FlowId,
ConsId
FROM
DataEntryAuditCell
WHERE
ScenarioId = (
SELECT
MemberId
FROM
Member
WHERE
Name = '|WFScenario|'
)
AND CubeId = 4
AND ICId != -999
AND AccountId = 17826015
AND Amount != 0
AND FlowId IN (1048639,-999)
AND UD1Id != -999
AND UD4Id != -999
The reason for using SQL is to facilitate user access to that specific information, as a QView wouldn't display everything according to the required permissions, which in this case doesn't apply as it's very specific information.
So it would be helpful if you could tell me which table or tables I can use to achieve the same result as I would see when using a QView.