query like first check Partner level and depend on Partner Level , it will filter out Message for each Partner Level. It will be kind of dynamic SOQL with comparison kind of each values of Partner level.
[SELECT Id,Name, Channel__c,Partner_Level__c
                        FROM MessageAlert__c
                        WHERE Channel__c = 'Partner' AND
                        Partner_Level__c INCLUDES ('Diamond , Gold')];

How to remove None option from drop down pick list

I want write down query to fetch value.
where Channel value is equal to Partner(pick list value) and then display value in dependent pick list  Partner Level which have multi pick list values (Diamond , Gold).
how can write down correct query for same.
I have written below like :

String squery = 'SELECT Id, Channel__c,Partner_Level__c from MessageAlert__c AND Partner_Level__c INCLUDES (' + slist + ')';

Position of Pop up message box is changing at every page.It should be come in same fashion. It's working fine only for Home page.
..

<apex:component controller="CommunityNavFooterController" allowDML="true">
      <!--script-->
      <style type="text/css">
          .popup
        {
            background-color: white;
                    
            z-index: 9999;
            left: 50%;
            padding:40px;
            position: auto;
            width: 500px;
            height:240px;
            border-radius:15px;
            border-width:2px;
            margin-left: -300px;
            top:650px;
        }

        .popupBg
        {
            background-color:black;
            opacity: 0.20;
            filter: alpha(opacity = 90);
            position: auto;
            width: 100%;
            height: 100%;
            top: 650px;
            left: 0;
            z-index: 9998;
        }
    </style>

......

<div class="ftr-box-left one-half palm--one-whole lap--one-whole">
                <div class="ftr-links">
               <!-- <a href="/apex/CommunityFeedbackForm" style="color: #FFFFFF" target="popup" onclick='window.open("/apex/CommunityFeedbackForm", "MsgWindow","width=370, height=270")'>
                Submit Feedback
                </a>-->
               
                <apex:form id="feed">
                <center>
                    <apex:outputPanel id="popup">
                        <apex:outputPanel styleClass="popupBg" layout="block" rendered="{!Hide}"/>
                       
                        <apex:outputPanel styleClass="popup" layout="block" rendered="{!Hide}">
                          <apex:actionRegion >
                              <apex:outputLabel style="margin-left:-74%">Submit Feedback</apex:outputLabel><br/>
                              <apex:actionFunction name="testfeedback" reRender="enablebtn"/>
                              <apex:inputTextarea value="{!Feedback}" onkeyup="testfeedback()" style="width:500px;Height:200px;resize:none"/> 
                          </apex:actionRegion>
                          <br/><br/>
                         <center>

how to show Feedback link in footer. now how to show popup window alert when click on Submit Feedback.

VF

<apex:page standardController="WorkFeedback" extensions="FeedBackController" sidebar="false" showHeader="false" >
<apex:form >
  <apex:pageBlock title="Feedback Form" rendered="{!Hide}">
   <apex:pageBlockSection columns="1" >
   
    <apex:inputField value="{!WorkFeedback.Feedback}"/>
   </apex:pageBlockSection>
   <apex:pageBlockButtons location="bottom">
    <apex:commandButton value="Submit" action="{!Save}"/>
    <apex:commandButton value="Cancel" onclick="self.close()"/>
   </apex:pageBlockButtons>
  </apex:pageBlock>
  <apex:pageBlock rendered="{!Show}">
   <center> Your feedback has been successfully submitted.
            Thank you for leaving feedback.
            Your contribution is valued and appreciated. </center>
   <apex:commandButton value="Ok" onclick="self.close()"/>
  </apex:pageBlock>
</apex:form>
</apex:page>


......

Controller

public class FeedBackController {
   
    public ApexPages.StandardController con;
    public Boolean Hide{get;set;}
    public Boolean Show{get;set;}
   
    public FeedBackController(ApexPages.StandardController controller) {
        con=controller;
        Hide=true;
        Show=false;
    }
   
    public PageReference save()
    {
        con.save();
        Hide=false;
        Show=true;
        return null;   
    }

}

Narrative:
As a registered user
I want to proved feedback to the site
So that I can get the fixes and features that matter to me

Acceptance Criteria: (presented as Scenarios)

Scenario 1: Opening the feedback form
Given I am on any page in the site
  And I want to give feedback
When I click the "Submit Feedback"
Then a form opens in a floating window
  And I can enter my feedback in a text field

Scenario 2: Filling out the feedback form
Given I have opened the feedback form
  And I want to give feedback
When I enter my feedback in the provided text field
  And I click "Submit"
Then the window closes
  And a confirmation appears with the text:
Your feedback has been successfully submitted.

Thank you for leaving feedback.  Your contribution is valued and appreciated.

  And I can click an "OK" button to close the confirmation
Negative Case:
  If I click the "Cancel" button instead of the Submit button
    Then the feedback window closes and nothing is retained

Scenario 3: Receiving feedback
Given I am a site admin
  And I want to review feedback provided to the site
When I open salesforce and view a "feedback" object
Then I can see a list of all feedback that has been provided

Note: A determination needs to be made as to the best way to support the feedback object.  Is there a standard salesforce object we can use or do we need a custom one?

query like first check Partner level and depend on Partner Level , it will filter out Message for each Partner Level. It will be kind of dynamic SOQL with comparison kind of each values of Partner level.
[SELECT Id,Name, Channel__c,Partner_Level__c
                        FROM MessageAlert__c
                        WHERE Channel__c = 'Partner' AND
                        Partner_Level__c INCLUDES ('Diamond , Gold')];

Narrative:
As a registered user
I want to proved feedback to the site
So that I can get the fixes and features that matter to me

Acceptance Criteria: (presented as Scenarios)

Scenario 1: Opening the feedback form
Given I am on any page in the site
  And I want to give feedback
When I click the "Submit Feedback"
Then a form opens in a floating window
  And I can enter my feedback in a text field

Scenario 2: Filling out the feedback form
Given I have opened the feedback form
  And I want to give feedback
When I enter my feedback in the provided text field
  And I click "Submit"
Then the window closes
  And a confirmation appears with the text:
Your feedback has been successfully submitted.

Thank you for leaving feedback.  Your contribution is valued and appreciated.

  And I can click an "OK" button to close the confirmation
Negative Case:
  If I click the "Cancel" button instead of the Submit button
    Then the feedback window closes and nothing is retained

Scenario 3: Receiving feedback
Given I am a site admin
  And I want to review feedback provided to the site
When I open salesforce and view a "feedback" object
Then I can see a list of all feedback that has been provided

Note: A determination needs to be made as to the best way to support the feedback object.  Is there a standard salesforce object we can use or do we need a custom one?