Okay
  Public Ticket #3673528
Frontend Posibilities
Closed

Comments

  •  1
    Fatih started the conversation

    Hi,

    I have bough and using the verison of 3.4.1. There is some improvements that Im planing on my site so I wanna ask;

    1) Is it possible to create a frontend post submission form ? I need my users to use the form to create new posts by multiselecting categories and etc. Posts should be saved as "pending" and then admin will approve or not. Previous post edit is not needed.

    2) Also I wanna ask that, how can I create a table that lists posts related to categories, in frontend. I wanna create a page to let users filter posts by selecting categories. In the search results, I wanna show the post's author, date, categories and etc.

    Thanks.

    Fatih Aker

  •  1,819
    Miloš replied

    Hi Fatih Aker,

    1. In regards to our Plugin being used to create a new Post on your Site;

    Sorry to disappoint you, but at this time, we don't have any built-in solution to achieve this.

    You can suggest it to our developers, though - they will do their best to make a solution in the future.

    Please feel free to search on our suggestions page

     to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

    You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

    and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

    -

    If you have coding skills and wish to try to make a custom solution now,

    you can check out our available hooks for Developers on this documentation and see if you can find any hook that might help.

    Please be advised that custom solutions with hooks are not included in our support.

    You can also research resources such as Stack Overflow to see if any other user perhaps found a workaround.

    ( We do like to give examples for certain solutions, but for this use-case, we, unfortunately, don't have anything yet)


    2. When it comes to listing post categories, and in general pulling data from your Posts in WordPress :

    As the custom posts/fields, are a part of the WordPress database;

    pulling this data can only be done through MySQL query-based tables.

    Please note: Using this plugin feature requires at least a basic knowledge of SQL. It is assumed that you can create the table in some MySQL data manager (e.g., PHPMyAdmin, MySQL Workbench), and prepare a SQL query that will return the data you need. 

    A good way to achieve this can be experimenting using our WPDB SQL Query Constructor tool.

    You can also try this other SQL Query helper Tool,

    Create a MySQL-query-based table by querying a database,

    that one has a wider range of all tables you can choose from your Database outside of WPDB.

    - Please note: this tool is not an ultimate query generator. It simply constructs a suggestion of a query. We are constantly working to improve it, but SQL is such a complicated and flexible language that full automation for constructing queries is next to impossible. 

    Consequently, the more complicated the query, the higher is the probability that it will not return exactly what you need. So, you will often need to play around with the resulting query.


    Please be advised that writing custom SQL Queries or debugging Queries does not fall under what our support covers.


    You can check out this official page of WP codex,  for help with writing custom Queries.

    If you manage to get a Query working  directly in your PHPMyAdmin ( or any other DB management Tool) to return the resulting Table as needed in the Database;

    You can then first try the same Query in our table.

    If our Table doesn't return it exactly as needed - our Plugin is not the same as a Database management Tool, it is running all our Queries through a PHP & SQL Parser.

    If that happens, you can prepare a MySQL view directly in your Database (which will return the data that you need, call it e.g. “view1” and then build a wpDataTables based on a simple query like "SELECT * FROM view1″.

     If you need help with that, you can see our video, where we show an example of using an SQL View in our plugin.


    I hope that helps.


    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables