Trying to execute a procedure from a folder list on an html page on our dashboard.

Everything is working except for the execution part. Getting a 404 error when I click on the link to the file name.

Used some code from other posts to this forum to get this far. Thank you.


-SET &ECHO=ALL;
-SET &DATADIR = '\ccsasip';
APP QUERY ccsasip HOLD
-RUN

TABLE FILE FOCAPPQ
PRINT
FILENAME AS ''
WHERE FILENAME LIKE 'ed%' OR FILENAME LIKE 'jeh%'
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
LINES-PER-PAGE=UNLIMITED,
$
TYPE=DATA,
TARGET='_blank',
URL=(FILENAME),
$
ENDSTYLE
END
-RUN



If I replace the URL=(FILENAME), with FOCEXEC=A_PROCEDURE_NAME the link works but only for that named file. I can not get it to use the value in FILENAME.

The value that is in FILENAME is not a valid URL. It would be something like CAR.MAS. You would have to do some additional DEFINE to get a properly formed URL into that field before it could be used like you are wanting.

Try searching on DRILL URL and take a look at the syntax on some of the examples.