none
New Forums Editor in Development for Review RRS feed

  • Question

  • It is no surprise to many of you that the current forums editor has its share of issues. Some have called it "horrible" while others have resorted to editing the html to post without it looking wrong.

    We have been working on an editor update. It is not finished yet, there are still issues. But I wanted to get people's feedback on the work in progress in our CTP environment. Take a look, reply to this thread, telling us what you think. Help us make it better.

    http://ctp.social.msdn.microsoft.com/Forums/en-US/msdnsandbox/threads (note: this is CTP environment, no questions will be answered, posts will stay in CTP and not be reflected in the real forums)

    Known Issue: Edit code doesn't yet work very well, posting code if further along but editing a code snipped after you insert it needs some work.

    Thanks in advance for any feedback you have. If we think it is pretty close and we can address any issues we want to deploy it sooner than later.


    Community Forums Program Manager
    Thursday, December 8, 2011 2:08 AM
    Answerer

Answers

  • See my test here. Things I observed:

    1. First time code block insert - all looked good, even saw a preview in the right panel.

    2. Second block insert in the same message by editing the already saved message - code looked like code, but I didn't get a right side preview.

    3. One more edit - this time attempt to edit the existing code block - at this point first block lost some of its coloring.

    Overall, this editor seems better than previous. The font seems a bit smaller than current font.


    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog

    Thursday, December 8, 2011 3:02 AM
    Moderator
  • Keep in mind I'm not only looking for bugs/problems. I also want to know whether it is better, same, worse than the current editor. Thinks you like/dislike etc.  Is code colorizing/formatting better? Worse?
    Community Forums Program Manager
    Thursday, December 8, 2011 7:21 AM
    Answerer
  • This is the behavior I want:

    1) The code stays as pre tag in all edits.

    2) The coloring happens automatically and never changes and the colors never go into the code text.

    This is not the current behavior and unfortunately not a behavior with the new editor.


    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog

    Thursday, December 8, 2011 1:25 PM
    Moderator
  • My initial comments:

    1. I like the border around code blocks.
    2. The colorization is different (for VB.Net, which is what I use for VBScript, and PowerShell).
    3. The font for code blocks is not fixed width.
    4. No Undo or Redo buttons.

    My main complaint is the lack of fixed width font. If I were to use the Insert Code Block feature, I would edit the HTML to specify a fixed width font. I have not yet tested what happens if I edit a reply. The look reminds me of what I've seen in MSDN forums (I believe).

     


    Richard Mueller - MVP Directory Services
    Thursday, December 8, 2011 4:41 PM
    Moderator

All replies

  • See my test here. Things I observed:

    1. First time code block insert - all looked good, even saw a preview in the right panel.

    2. Second block insert in the same message by editing the already saved message - code looked like code, but I didn't get a right side preview.

    3. One more edit - this time attempt to edit the existing code block - at this point first block lost some of its coloring.

    Overall, this editor seems better than previous. The font seems a bit smaller than current font.


    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog

    Thursday, December 8, 2011 3:02 AM
    Moderator
  • hitting <enter> at the bottom, doesn't scroll the screen. It only scrolls when text is typed.

    FF 3

    Thursday, December 8, 2011 4:24 AM
  • Keep in mind I'm not only looking for bugs/problems. I also want to know whether it is better, same, worse than the current editor. Thinks you like/dislike etc.  Is code colorizing/formatting better? Worse?
    Community Forums Program Manager
    Thursday, December 8, 2011 7:21 AM
    Answerer
  • This is the behavior I want:

    1) The code stays as pre tag in all edits.

    2) The coloring happens automatically and never changes and the colors never go into the code text.

    This is not the current behavior and unfortunately not a behavior with the new editor.


    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog

    Thursday, December 8, 2011 1:25 PM
    Moderator
  • OK, just quickly looked last night. Maybe i'll take a look again later.
    Thursday, December 8, 2011 2:23 PM
  • My initial comments:

    1. I like the border around code blocks.
    2. The colorization is different (for VB.Net, which is what I use for VBScript, and PowerShell).
    3. The font for code blocks is not fixed width.
    4. No Undo or Redo buttons.

    My main complaint is the lack of fixed width font. If I were to use the Insert Code Block feature, I would edit the HTML to specify a fixed width font. I have not yet tested what happens if I edit a reply. The look reminds me of what I've seen in MSDN forums (I believe).

     


    Richard Mueller - MVP Directory Services
    Thursday, December 8, 2011 4:41 PM
    Moderator
  • Image editor and code editor looks nice.

    large posts hang or freeze.

    larger posts causes next reply (without reloading the page) to not accept input. reloading the page allows the reply.

    Sorry Brent. I'm a problem finder whether i want to be or not. :)

    I was trying to post an example large post here, but it hung i this editor as well. :)

    Thursday, December 8, 2011 5:12 PM
  • here we go. the following posts (slowly) but with the code editor (preview, then post) the post goes on and on....

    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE INFORMATION = 'Facility' UNION ALL
    SELECT 'EPO_ALERT' FROM adminepo.EPO_ALERT WHERE RAISED = 'Facility' UNION ALL
    SELECT 'EPO_AUDITLOG' FROM adminepo.EPO_AUDITLOG WHERE DESCRIPTION = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_MESSAGES' FROM adminepo.EPO_AUDIT_MESSAGES WHERE MESSAGE = 'Facility' UNION ALL
    SELECT 'EPO_AUDIT_PROC_LIST' FROM adminepo.EPO_AUDIT_PROC_LIST WHERE PROCEDURENAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_NAME' FROM adminepo.EPO_AU_BOOK_NAME WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_BOOK_PROPERTY' FROM adminepo.EPO_AU_BOOK_PROPERTY WHERE CATEGORY = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE NAME = 'Facility' UNION ALL
    SELECT 'EPO_AU_CURRENCY_PROPERTY' FROM adminepo.EPO_AU_CURRENCY_PROPERTY WHERE VALUE = 'Facility' UNION ALL

    Thursday, December 8, 2011 5:16 PM
  • The original query, won't post at all. FWIW, trying to find where text is store in PCM, so i can add it to a query.

    This is just 100 lines repeated 5 times. 1000 lines breaks the editor, and the preview sometimes.

    Hmm... maybe it failed because it's Oracle. :)


    ----

    I posted it for testing. Just whack the long reply if you don't want the clutter here.

    Thursday, December 8, 2011 5:18 PM
  • The code should work in SQL Server as well, so it's not Oracle only problem. You can not blame it on Oracle :)
    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog
    Thursday, December 8, 2011 5:25 PM
    Moderator
  • Heh. I really like Oracle, actually. But, after all, this is a SQL Server forum. Got to be nice to the natives. :)
    Thursday, December 8, 2011 5:38 PM
  • I like the code editor, hoping it picks a default language for each forum though. HTML editor is nice too. Just from a pretty standpoint.

    Quoting a post repeatedly makes the reply appear empty in the third reply. It is there (can be seen in HTML editor) and does post and show up. But the edit box itself is empty.


    Thursday, December 8, 2011 5:47 PM
  • I wanted to get people's feedback on the work in progress in our CTP environment. Take a look, reply to this thread, telling us what you think. Help us make it better.


    Please add the CTP MSDN Sandbox  to the list of "newsgroups" for the NNTP bridge.   I can test forum functionality much better that way.  E.g. I would like to compare how replies to Text only and HTML would look.   I also tested color support that way originally.   Another consideration is when DIV is used instead of BLOCKQUOTE.   That affects WLMail in HTML mode.   Etc.


    TIA

    Robert
    ---

    Friday, December 9, 2011 5:20 PM
  • The CTP environment is completely separate and parallel from production, so it'll be impossible to get the sandbox from CTP to show up in the bridge. You could change the bridge config though to point to ctp.services.social.microsoft.com for the endpoint url domain though, that might work. Let me know if you get that running and how it goes. 
    Community Forums Program Manager
    Friday, December 9, 2011 6:49 PM
    Answerer
  • You could change the bridge config though to point to ctp.services.social.microsoft.com for the endpoint url domain


    I hope Jochen sees this post.   ; )


    ---

    Friday, December 9, 2011 8:01 PM
  • You could change the bridge config though to point to ctp.services.social.microsoft.com for the endpoint url domain


    I think I see what you are hinting at in

    C:\Program Files (x86)\Community\CommunityForumsNNTPServer\CommunityForumsNNTPServer.exe.config

     

    <client>
            <endpoint address="http://services.social.microsoft.com/ForumsServicePreview/ForumsService.svc" binding="wsHttpBinding" bindingConfiguration="social" contract="Forums.IForumsService" name="social"/>
            <endpoint address="http://services.answers.microsoft.com/ForumsServicePreview/ForumsService.svc" binding="wsHttpBinding" bindingConfiguration="answers" contract="Forums.IForumsService" name="answers"/>
          </client>

    So, replace the endpoint address for Answers?   I wonder if the other two parameters could stay the same, e.g. still be called Answers?  Since Answers isn't used any more I assume it wouldn't cause problems to try that?

    A hacking we will go...  ; )

     

    Robert
    ---

    Friday, December 9, 2011 9:29 PM
  • Success!  (After a few bumps mostly due to breaks in diagnostics.)

    http://ctp.social.msdn.microsoft.com/Forums/en-US/msdnsandbox/thread/0735a416-192c-4a69-964e-74a4b01101e6


    ---

    Friday, December 9, 2011 11:41 PM
  • Bugs

    • Padding in the editor too small. (Also, NO padding initially, only after some amount of typing.)
    • Empty <span class="t-marker"></span> tags appearing in the HTML preview. (Click Bold (to add styling), write something, Click Bold (to remove styling), Press enter, View HTML)
    • Styling persists in beginning of post. (Click Bold (to add styling), Write something, Delete everything with backspace, Click Bold (to remove styling), Press backspace)
    • No formatting in the HTML preview. Everything just inline.
    • Ending a list with the list button on the toolbar removes the whole list if the cursor is on an empty item.
    • Insert code block dialog not centered, can not be resized (neither can edit HTML).
    • Code text in code dialog fixed width, code preview NOT fixed width, code in post editor fixed width, code in post NOT fixed width. (You just shuffled the previous way it worked. I don't know whether to laugh or cry. Please just make every piece of code fixed width.)
    • Unnecessary extra borders appear inside the code preview.
    • Code syntax hilight too faint. Barely distinguishable from normal text.
    • Layout of Edit a thread. Title textbox not styled, editor oddly positioned inside the thread, ...
    • Can change thread type to the type it was already. No cancel option.
    • It's impossible to break out from a code snippet if it's the only thing in the post or adding text under a code snippet if it's the last item in the post. (Have to use the "edit html" button.) (Same for blockquote.)
    • Editing adds a <br/> to the end of the post. (I believe this bug has meen mentioned, confirmed and addressed a gazillion times. Loving the tenacity.) (Something to do with that previously mentioned feature?)

    Suggestions

    • Paragraph margins inside blockquote too big (or blockquote padding too big.)
    • More padding inside code snippets, border color too black. Possibly only a very light background color for code snippets.
    • "Edit code block" button needed. Same as insert, except everything in the current code already in the text area. Submitting would replace the original code block.
    • Change thread type could be a dialog box like edit code and edit HTML.
    • Giving the option to add images from non-microsoft domains not a good thing. (Loading times, no restricting of image size, links expiring, local firewall settings preventing load, who knows what abuses..)
    • "Forums markup" for everything.. <code>, <quote>, <bold>, ... Automatic pre-set styling & html-rendering applied when displayed (would also fix the code syntax hilight corruption since the actual hilight wouldn't be saved as style tags in the post.) This would prevent abuse such hidden links, people accidentally (or not) making their fonts in their posts too big or small or an annoying color, give the forum a more unified look, etc. Any non-valid tag would be considered text or deleted.
    • A (live) formatted html (forums markup) view could be visible at all times. Perhaps in another textarea underneath the actual post.
    Tuesday, December 13, 2011 9:49 AM
  • It's impossible to break out from a code snippet if it's the only thing in the post or adding text under a code snippet if it's the last item in the post. (Have to use the "edit html" button.) (Same for blockquote.)

    • Editing adds a <br/> to the end of the post. (I believe this bug has meen mentioned, confirmed and addressed a gazillion times. Loving the tenacity.) (Something to do with that previously mentioned feature?)


    The only new problem I see in this regard is that we no longer have a Status bar  Path:  as a guide about how much we need to delete.

    Which browser are you using?   I think I had a worse problem with Chrome in the old editor.   The br would be essential for it.

     

    ---

    Tuesday, December 13, 2011 3:25 PM
  • Thanks in advance for any feedback you have. If we think it is pretty close and we can address any issues we want to deploy it sooner than later.


    Community Forums Program Manager

    Brent,

    I think this is an improvement over the current editor.  I'd be happy with this replacing the current verison at any point in time...

    That being said, the one very annoying bug I see is quoting - right now, if you quote, the initial cursor position is inside of the quoted text.  So hitting quote then typing doesn't type below the quote, but rather modifies the original text area...

     


    Reed Copsey, Jr. - http://reedcopsey.com
    If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".
    Tuesday, December 13, 2011 11:11 PM
  •  I think this is an improvement over the current editor.


    Try it in IE10?   <eg>

    Try pasting a link--without using the Insert Hyperlink tool?

    I don't use the list features that much but I never noticed that they were as quirky in the old version as they appear to be now.   E.g. insertion point moving unexpectedly, tags not closing, etc.

    Also the HTML source frame provides less function than the previous separate tab implementation.   So prettier but not as potent, especially if we are having task problems or connectivity problems in IE, for example.

    Another removal of function which affects usability is the Path: line.  Closing of tags is still very quirky so I think we need all the cues we can get when things go strange.

     

    I'd be happy with this replacing the current verison at any point in time....

    IMO it would be trading one set of quirks for another.   What are the new features or fixes that would make such a tradeoff positive for the new version?

     

    ---

    Wednesday, December 14, 2011 3:14 AM

  • IMO it would be trading one set of quirks for another.   What are the new features or fixes that would make such a tradeoff positive for the new version?

     

    My general overall feel (granted, using IE 9 + Chrome) was that this editor seemed to have fewer quirks than the old.  It's far from perfect (many downsides listed here), but overall, it still seemed less quirky than the current version.

     

    Personally, I'd rather the team use whichever version will, over time, be the easiest to clean up and extend as needed, though.  I highly doubt that's the current editor (given the long history of problems), but I'm not in a position to judge.

     

    I guess my comment was mainly that, when I used it, it felt, overall, slightly nicer than the current.  I didn't see any single thing that seemed dramatically worse (some minor steps back), but it also had a few nice improvements, and obviously has had less effort put into it (at this point) when compared to the existing one...

     


    Reed Copsey, Jr. - http://reedcopsey.com
    If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".
    Wednesday, December 14, 2011 3:34 AM
  • Posting code is still very difficult. Instead of a funky icon, can't you at least have a button that says "CODE"? That's a minimum requirement.

    But it would be better to get rid of the separate window for code altogther. Just add a button for fixed width, just like you have buttons for B, I, U. The current way to insert code is just crazy. I have to fire up a separate window, and when I add code into I need to preview it, if I want to see it as fixed width. And in the end, the code does not appear with fixed width at all.

    From my perspective, this is the single biggest issue in the web UI. I use the NNTP Bridge for my posts, but most people use the web UI to post questions. I don't know exactly what happens there, but many times the SQL code is completely mangled. Blanks are stripped, and there are unmotivated line breaks. Probably because there is some rich-text copy-and-paste from SQL Server Management Studio.

    I will make more tests from the NNTP bridge to see how that works.

     


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    Saturday, December 17, 2011 7:10 PM
  • I've now tested from the NNTP bridge. The thread can be seen in

    http://ctp.social.msdn.microsoft.com/Forums/en-US/msdnsandbox/thread/a687c8ba-2a2e-4384-9786-6c9a3f23ce69

    Please disregard the first post; there is an error on my side. But if you scroll down to the second post, you can see this:

    http://www.sommarskog.se/temp/indented.jpg

    As you can see, the indendation is incorrect. All rows but the first one are indented one character too many. If you look at the source, you can see why:

    http://www.sommarskog.se/temp/viewctpsource.jpg

    The HTML code is incorrectly indented with one character. That is not how you do a <PRE>-tag!

    Then again, I can't tell whether this is the plain-text converter in the NNTP bridge or the WebService. (I use XNews + MIME-Proxy, and it's all plain text.)

    I should add that this is a lot better than what happens at the production site currently. But that's a topid for a different thread.



    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    Saturday, December 17, 2011 9:36 PM
  • And as a testimony how quirky the current UI is, I originally pasted the two pictures directly into the posting window where they displayed nicely. Then when I viewed the post, they were not there!

    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    Saturday, December 17, 2011 9:45 PM