steve hodos Posted November 14, 2020 Share Posted November 14, 2020 Is there a system variable with the table name available, without having to to -SET &TABLE_NAME for every focexec The table name exists, because Resource Analyzer knows about it. We know the user name, and can grab that any number of ways. We know filters, because all the <REQUEST.variables are available for text: why isnt the TABLE name available- this seems like it would be simple system variable to provide Also, I just did a search from the OLD TechSupport site (and the AppStudio online help) for REQUEST.SORT_KEYS_CONTEXT - nothing comes up. So, for fans of focexec documentation: these are some VERY handy tools> https://webfocusinfocenter.informationbuilders.com/wfappent/TL3s/TL_srv_rel/source/heading_filters.htm Link to comment Share on other sites More sharing options...
Noel McAvoy Posted November 16, 2020 Share Posted November 16, 2020 At first I thought you were looking for the procedure name (&FOCFEXNAME). I dont think that there is a programmatic way to find this as there could be multiple primary masters / queries per procedure. You may be able to get some of this from resource manager or by querying the repository but I dont think there is a system variable or function to get a single master name for a procedure. Link to comment Share on other sites More sharing options...
NYCBabak . Posted November 16, 2020 Share Posted November 16, 2020 Not sure if thisll be exactly what you want, but if you right click the fex and look at Properties under the Query Detail the first thing youll see is the Master Files. So, if your goal is to quickly find out what master is used in the report/chart, thats one way to find out. Admittedly, I dont know of a way to have the master populated into a variable but Ive not run into a use case for it either. Link to comment Share on other sites More sharing options...
Toby Mills Posted November 16, 2020 Share Posted November 16, 2020 Hey Steve! Thats some cool stuff - the REQUEST. info Never seen that before. If you had an &variable that has the TABLE name in it - youd have to check it after each request since the master file being referenced could change anytime. I bet such a thing exists and is being used by Resource Analyzer. Let me look around a little to see if I can find anything. Im not at IBI anymore (as of early 2017), so visibility to the coding is pretty tough. I bet its there somewhere. Toby Link to comment Share on other sites More sharing options...
Toby Mills Posted November 16, 2020 Share Posted November 16, 2020 Hi Steve I think this would be a good NFR to send in. Not sure what youd use it for, but lets say you wanted to have an ON TABLE SUBFOOT trailer page come out on a report someone built in IA for example Maybe itd be handy for debugging. I found some references to these variables in the compiled code, but of course I cant make much out of them. Internally these seem to be called: NTTP_TLT_REQUEST_NONE NTTP_TLT_REQUEST_VERB_OBJECTS NTTP_TLT_REQUEST_VERB_OBJECTS_CONTEXT NTTP_TLT_REQUEST_FILTERS NTTP_TLT_REQUEST_SORT_KEYS NTTP_TLT_REQUEST_SORT_KEYS_CONTEXT NTTP_TLT_REQUEST_BYKEYS NTTP_TLT_REQUEST_ACROSSKEYS NTTP_TLT_REQUEST_LAST I tried making a report to show me what was might be in REQUEST.NONE and REQUEST.LAST (since I saw the naming convention), but that just have errors. IOH_MASTER is what youd like to have exposed If you want to open a case about this - aim it and the Reporting Server people (EDA) so Jareds people get it. If you put it in under WebFOCUS, itll just be lost on them. This is magic thats happening on the WFRS. I bet if Art Greenhaus was still around, hed know of some random thing to get it. Other ideas - its work, but if you only have a few Master files to keep up with, you could try adding a master file profile to those Masters Make each one run a fex that just sets your &TABLENAME like you want. Then - anytime anybody refers to that Master - the &TABLENAME will end up being populated. If you get anywhere, let us know. Thanks! Toby Link to comment Share on other sites More sharing options...
David Briars Posted November 16, 2020 Share Posted November 16, 2020 toby.mills: if Art Greenhaus was still around Hi Toby, I hope Art is still with Information Builders. I didnt see a so long on FocalPoint. Do you know something different Thanks, Dave Link to comment Share on other sites More sharing options...
steve hodos Posted November 16, 2020 Author Share Posted November 16, 2020 Hey Toby- nice work finding out where the .REQUEST.variables come from. David probably remembers when the FOCUS USER Group used to run the Enhancement ballot. If I hear anything else on tis topic from anyone else, I will let you everyone know. Link to comment Share on other sites More sharing options...
steve hodos Posted November 16, 2020 Author Share Posted November 16, 2020 Babak, use case: at a very basic level- if I can get the focexcec name, and the WHERE filters, I should be able to get the TABLE name- just a nice basic feature to have during development / documentation. Link to comment Share on other sites More sharing options...
David Briars Posted November 17, 2020 Share Posted November 17, 2020 steve.hodos: David probably remembers when the FOCUS USER Group used to run the Enhancement ballot. Yes I do. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now