Get a list of DFI files (IRIS)

Question

Question

Ivan Myasnikov · Mar 20, 2019

#Other

Good day.

Can you please tell me how to programmatically get a list of DFI files that have been uploaded to the IRIS server?

Since CacheStudio can do this, it means that you can perform this operation from the code.

For earlier, I thank all who are not indifferent to my problem.

Discussion (2)0

Log in or sign up to continue

Vitaliy Serdtsev · Mar 20, 2019

For example, you can export them all to a single file:

SAMPLES>d $system.OBJ.ExportPattern("*.dfi","c:\exportAllDFI.xml",,,"UTF8")

You can get the list as follows (doc):
select Name from %Library.RoutineMgr_StudioOpenDialog('*.dfi')

1 0

score 0 · Answer 1 · 2019-03-20T04:11:03-04:00

Well, what do you want to do with that list? Depending on your use case, the solution may differ.

For example to get a list of dashboards execute this query:

SELECT *
FROM %DeepSee_Dashboard.Definition

And to get a list of Pivots execute this one:

SELECT *
FROM %DeepSee_Dashboard.Pivot

And in MDX2JSON project I need to get a list of dashboards visible to the current user. I use custom result set for that (because user may have access to dashes but not to SQL).