I am developing a procedure that picks up hold files created by different users in MRE. I am able to use GETUSER(USERID) to determine the user who is running this procedure. But I can't find a way to get the folder name of the HOLDDATA path of the user (we create private HOLDDATA folder for each user in user.prf profile). Is there a sys function like GETUSER can do this?

Thanks.

This message has been edited. Last edited by: bug,

I don't know of a system function that provides that info, but perhaps you could use APP QUERY to list files within the folder.

APP MAP TEST1 "C:\IBI\SRV77\WFS"
APP QUERY TEST1 HOLD
TABLE FILE FOCAPPQ
PRINT
*
END

Documentation: Developing Reporting Applications > Managing Applications > Reports and Help

Francis, thanks for your input.

The program does not know the HOLDDATA app name ("TEST1" in your example). Is there a way to retrieve the app name, or the physical folder name mapped to the app name? My ultimate goal is to get the physical folder name ("C:\IBI\serv77\wfs" in your example). It must be stored somewhere on the server, just don't know how to get it.

First, let's determine what

quote:

we create private HOLDDATA folder for each user in user.prf profile

means - you must know a higher-level directory...

Hi,

My thoughts here --since the app folder created at run time will be part of the approot- you can user APP LIST and check for the naming pattern of the user specific APP folder.
Again it depends on the way the dynamic folder is being created --naming used and all.

thanks
Sashanka

This could do with some cleaning up, but it may be what you're after.

It uses the TEMPPATH function.

-* Set up APP MAP for Users EDATEMP TS directory  * * * * * * * * * *
-SET &TMP_PATH = TEMPPATH(50,'A50') ;
-SET &TMP_PATH = TRUNCATE(&TMP_PATH);
-SET &TLEN = &TMP_PATH.LENGTH;
-SET &TFMT = 'A' | &TLEN ;
-SET &TMP_PATH1 = TRIM('T',&TMP_PATH ,&TLEN,'\',1,'&TFMT');
-SET &TMP_PATH = TRUNCATE(&TMP_PATH1) ;

APP MAP TMPAGENT &TMP_PATH
-RUN

As long as you know the name of a file that is in the directory, you can use FMI to get the physical file name. You can then strip out the name to get the actual directory name:

SQL FMI SET SYSFILES MASTER
TABLE FILE SYSFILES PRINT PHNAME
WHERE FILENAME EQ 'car';
ON TABLE HOLD AS TF
END 
-RUN
-READFILE TF
-TYPE FILE NAME IS &PHNAME  

Just an enhancement:

SQL FMI SET SYSFILES MASTER
TABLE FILE SYSFILES PRINT PHNAME
WHERE RECORDLIMIT EQ 12
ON TABLE HOLD AS TF
END 
-RUN
-REPEAT ENDOFLOOP &LINES TIMES ;
-READ TF &PHNAME.A80.
-IF &PHNAME CONTAINS '&FindThis.EVAL' THEN GOTO DO_SOMETHING ELSE GOTO DO_NOTHING  ;
-DO_SOMETHING
-TYPE Doing Something ... FILE NAME IS &PHNAME
-GOTO ENDOFLOOP
-DO_NOTHING
-TYPE Doing Nothing ..... FILE NAME IS &PHNAME
-GOTO ENDOFLOOP
-ENDOFLOOP
-* Do more...

the "WHERE RECORDLIMIT EQ 12" is just there for test/demo.

Sorry for the late feed back. I was occupied in other issues in the the past week.

Twanette's code work perfectly for me. It's interesting that I can't find TEMPPATH() from the webfocus help file. I am wondering how many other system functions I am still not aware of

I appreciate everyone's input. This is a solved case. Thanks!

The only documentation I've found that mentions TEMPPATH is the Stored Procedure Reference (v7.7.03), an interesting document, where among other things, you learn how to write a stored procedure in Dialogue Manager.

quote:

Originally posted by Francis Mariani:
The only documentation I've found that mentions TEMPPATH is the Stored Procedure Reference (v7.7.03), an interesting document, where among other things, you learn how to write a stored procedure in Dialogue Manager.

Guess I have to update my help file library. Thanks Francis!