Virtual Tables Queries

Tal Mickel shared this question 2 years ago
Answered

Hi,


Is there a way to query from YF repository all virtual tables queries from YF views?


Thanks!

Comments (4)

photo
1

Hi Tal,


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!

Regards,

Nathan

photo
1

Hi Tal,


Actually I did find a way. This bit of java code can do this:


2cfd8a002be5ecad0bf76d5780bca3b2


So for the input string "U0VMRUNUICogRlJPTSB0ZXN0ZGF0YXNldA=="


Will print out: "select * from testdataset"


Regards,

Nathan

photo
1

Hi Nathan,


sorry for the delay in response. I didn't completely understand where should i run the java script.

Can you please give more details?


Thanks!

photo
1

Hi Tal,


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 :)


Regards,

Nathan