Find query name

[Former Member]

Hi

There is a query made earlier thru SQVI in QAS. I know the program name which got generated but don't know the query.

Now i want to create a query in DEV which should be same as the one in QAS.

How can i find out the query name through the program name generated. So that i can make a fresh query in DEV.

Helpful answers will be rewarded.

Regards

varun mathur

[Former Member]

Can anyone help me in this case??

I just want to see the query , which was created thru sqvi.

USERGROUP : SYSTQV000008

QUERY : ZFRC

CLIENT : 410

Where can i find this usergroup in qas.

[JozsefSzikszai]

hi Varun,

pls. use FM RSAQ_DECODE_REPORT_NAME, as import parameter you only enter the generated program name and you get back all information you need.

hope this helps

ec

[Former Member]

it shows me

USERGROUP SYSTQV000008

QUERY ZFRC

CLIENT 410

But this user group does not exist. I've searched in SQ03 but no result.

Does this mean this is showing wrong results.

[Former Member]

Hi,

No it is showing the correct results, you are creating query through SQVI transaction. Dont bother about the group while creating the query through SQVI. Goto your quality and check for the query.

Rgds,

Bujji

[Former Member]

Hi Bujji,

Yes its created thru sqvi. But how shud i be able to see the query.

As when i go in sqvi it shows query for that particular user only to which the login belongs.

I don't know the name of the person who created that query.

How to find that query now?. I want to make a copy of that query in DEV.

[Former Member]

Can anyone help me in this case??

I just want to see the query , which was created thru sqvi.

USERGROUP : SYSTQV000008

QUERY : ZFRC

CLIENT : 410

Where can i find this usergroup in qas.

[Former Member]

well i could not find the query.

But i have made it based on understanding of the program.

thanks for the replies though.

Regards

Varun Mathur