jelenacvijic

<p>Looking for the <strong>easiest way to manage your data</strong>?<br />
We are here to help. 😉</p>
<p>Black-Desk is a comprehensive WordPress plugin that helps you <strong>create and manage custom database tables and data</strong> directly from your WordPress dashboard.</p>
<p>The plugin provides an intuitive interface that lets you create, update, and query your data in the simplest way possible, without requiring deep technical knowledge.</p>
<p>Save queries and reuse them quickly.</p>
<p>Black-Desk plugin <strong>shortcodes</strong> let you display selected data on your WordPress pages or posts, as well as easily create input forms directly connected to your tables.</p>
<p><strong>Key Features:</strong></p>
<ul>
<li>Create custom tables with various column types</li>
<li>Manage table data with an easy-to-use interface</li>
<li>View and edit table data</li>
<li>Create and save custom queries, including joins (across multiple related tables)</li>
<li>Soft delete support with trash management</li>
<li>Shortcodes for data display</li>
<li>Shortcodes for input form generation</li>
</ul>
<h3>Usage</h3>
<p>After installation, look for the <strong>‘Tables’</strong> menu item in your WordPress dashboard/admin panel.</p>
<h4>Creating Tables</h4>
<ol>
<li>Go to <em>Tables</em> > <strong>Add Table</strong></li>
<li>Enter table name and description</li>
<li>Add columns with their respective names, types and properties</li>
<li>Preview and save your table structure</li>
</ol>
<p>Available Column Types:</p>
<ul>
<li>Short text – varchar(255)</li>
<li>Number     – int(11)</li>
<li>Big number – bigint(20)</li>
<li>Currency   – decimal(15,2)</li>
<li>Date time  – datetime</li>
<li>Yes no     – bit(1)</li>
<li>Lookup     – varchar(100)</li>
<li>Rich text  – mediumtext</li>
<li>Long text  – longtext</li>
<li>Attachment – longblob</li>
<li>Hyperlink  – varchar(1024)</li>
<li>ENUM       – ENUM (your list of options)</li>
</ul>
<h4>Managing Data</h4>
<ol>
<li>Navigate to <em>Tables</em> > <strong>All Tables</strong></li>
<li>Click on a table to view/edit its data or its structure</li>
<li>Add, edit, or delete records (edit by clicking the field itself)</li>
<li>Use bulk actions for multiple records</li>
<li>Restore deleted records from trash</li>
<li>Display data in your WordPress page or post using shortcodes</li>
</ol>
<h4>Creating Queries</h4>
<ol>
<li>Go to <em>Tables</em> > <em>All Queries</em> > <strong>Select</strong></li>
<li>Choose tables and fields to include</li>
<li>Add conditions and aliases</li>
<li>Preview and save your query</li>
<li>Display the query results in your WordPress page or post using shortcodes</li>
</ol>
<p>If you want to view data from related, joined tables you can create and save a query by setting one of its conditions so that the value from the first table column is equal to the second table column/field (effectively indicating a foreign key column and pointing it to another table’s primary key).</p>
<p><strong>Example</strong> of such query condition:<br />
[<code>review.product_id</code>] [equal to] [FIELD] [<code>product.id</code>]</p>
<h4>View Query Results</h4>
<ol>
<li>Go to <em>Tables</em> > <strong>All Queries</strong></li>
<li>View specific query</li>
</ol>
<h4>Deleting Data</h4>
<p>There are three options for deleting data:</p>
<ol>
<li>Deleting rows while viewing a table, one by one or in bulk; soft delete, <strong>reversible</strong></li>
<li>Truncate – delete all data in a table; <strong>irreversible</strong></li>
<li>Delete the whole table; <strong>irreversible</strong></li>
</ol>
<h4>Shortcodes</h4>
<p>Shortcodes are a powerful feature of Black-Desk that let you seamlessly connect your data tables to any of your WordPress pages or posts, in one of the two directions:</p>
<ul>
<li>Display data from your tables directly on your page or post;</li>
<li>Create custom data entry <strong>forms</strong> to store user input directly into your data tables.</li>
</ul>
<p>Using shortcodes, you can easily:</p>
<ul>
<li>Display data from your table or query result – <code>[bdds-view-table]</code></li>
<li>Display specific field – <code>[bdds-view-field]</code></li>
<li>Display specific field data <strong>for each</strong> row of your table or query result – <code>[bdds-view-repeat]</code></li>
<li>Create an input form using shortcodes:<br />
- <code>[bdds-form-start]</code> – to start a form<br />
- <code>[bdds-form-field]</code> – to add form field<br />
- <code>[bdds-form-stop]</code> – to end a form</li>
</ul>
<p><strong>Detailed shortcodes usage instructions</strong> are provided in dashboard > <em>Tables</em> > <strong>Shortcodes</strong>.</p>


Black-Desk

WordPress plugin for easier data management.

Shabti Kaplan

<p>Only works with Elementor PRO (for now….)</p>
<p>An Elementor PRO extension that allows you to easily dynamically query your posts and portfolio widget results without custom query IDs.</p>
<p>This plugin is built on Elementor’s posts, portfolio, and loop grid widgets so Elementor Pro must be installed and activated. You can use this plugin to query your posts based on a dynamic author field or date field. If you have any special requests, just message us on our website or FB page and we will try to add it to the plugin right away.</p>
<p>This is compatible with ACF and Jetengine too. This works for the Elementor Pro posts, portfolio, loop grid, and loop carousel widgets as well as Elementor Extras post extras widget. (If you want this to be compatible with another widget, we can check if it’s possible).</p>
<p>So far you can query your posts in the following ways:</p>
<h4>Users</h4>
<ol>
<li>Author is Current User. The logged in user will only see posts that he/she is the author of.</li>
<li>Author is Current Author. Show other posts by the current author.</li>
<li>Custom Field is Current User. The logged in user will only see posts where the custom field equals his/her ID, email, or username, based on whichever key you choose.</li>
</ol>
<h4>Dates</h4>
<ol>
<li>Pre Expired Posts. Choose a custom date field ( in “Ymd” format ) that returns an expiration date. Only non-expired posts will show.</li>
<li>Expired Posts. Choose a custom date field ( in “Ymd” format ) that returns an expiration date. Only expired posts will show.</li>
<li>Start and end dates. Choose 2 custom date fields ( in “Ymd” format ) that return a start and end date. Only posts within between these 2 dates will show.</li>
<li>Query by the time.</li>
</ol>
<h4>Related Posts</h4>
<ol>
<li>Dynamic Related Posts. Show posts that are dynamically hand picked by a relationship or post object field.</li>
<li>Dynamic Related Terms. Show posts that are dynamically hand picked by a taxonomy field.</li>
<li>Custom Field is Current Post ID. Show posts that contain a custom field that is equal to the current post.</li>
</ol>
<h4>Similar Field Values</h4>
<ol>
<li>Custom Field is Value. Show posts that contain a custom field with a similar value.</li>
<li>Custom Field Contains Value. Show posts that contain a custom field with one of many values.</li>
</ol>
<h4>Order By</h4>
<ol>
<li>Dynamic OrderBy. Dynamically order the posts by a custom field.</li>
<li>OrderBy Last Modified. Order posts by last modified date.</li>
</ol>
<h3>Useful Links</h3>
<p>Appreciate what we’re doing? Want to stay updated with new features? Give us a like and follow us on our facebook page:<br />
<a href="https://www.facebook.com/dynamiapps/" rel="nofollow ugc">DynamiApps Facebook page</a></p>
<p>Check out our website:<br />
<a href="https://www.dynamiapps.com/" rel="nofollow ugc">DynamiApps website</a></p>
<p>Check out Elementor Pro. We highly recommend pro for anyone who is looking to get more out of WordPress and Elementor:<br />
<a href="https://elementor.com/pricing/" rel="nofollow ugc">Elementor Pro</a></p>


Advanced Queries

An Elementor extension that allows you to easily dynamically query your posts, portfolio, and loop grid widget results without custom query IDs.

Black-Desk vs Advanced Queries