New Topic
CommunityTopicQuestionAdministration
Following
photo
Nathan Schroeder
NA Business Team
Assigned
Properties
Category Administration
Product Version 7.2

Virtual Tables Queries

Tal Mickel shared this question 7 years ago
Answered

Hi,


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


Thanks!

1 The same question

Replies (4)

photo
1
Nathan Schroeder ● 7 years ago

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

Reply
photo
1
Nathan Schroeder ● 7 years ago

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

Reply
photo
1
Tal Mickel ● 7 years ago

Hi Nathan,


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

Can you please give more details?


Thanks!

Reply
photo
1
Nathan Schroeder ● 7 years ago

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

Reply
Leave a Comment
 
Attach a file