Is there a way to query from YF repository all virtual tables queries from YF views?
Unfortunately this is not easily accessible. The queries are stored within the database as a blob between the documentitem(metadata) and document data(blob) tables.
I have had trouble finding a good way to convert these into a legible format but maybe you will have more luck (let me know if you do).
Sorry for the inconvenience here, let me know if you have any questions!
Actually I did find a way. This bit of java code can do this:
So for the input string "U0VMRUNUICogRlJPTSB0ZXN0ZGF0YXNldA=="
Will print out: "select * from testdataset"
sorry for the delay in response. I didn't completely understand where should i run the java script.
Can you please give more details?
I just run this out of Eclipse, and copy and paste my values into the decode("124324124") section. The idea here is more to show you how to decode these values than to provide a good means to do so :)
Comments have been locked on this page!