Page History

...

Document Properties Marker

override	false

Short Description

Module to provide a filter for a display table macro.

Doctype

docmodule

hide

Name

Filter Module

Short Name

Parent

Parent Property

property-name	Name

hide

Audience

Name List

doctype	role
render-no-hits-as-blank	true
property	Audience
empty-as-none	true

Subject

Name List

doctype	subject
property	Subject

Tags

Tag List

property	Tags

Flags

hide

Iteration


value	finished

Type

Name List

doctype	module-type
render-no-hits-as-blank	true
property	Type

Sort Key

hide

Section

title	Description

...

Section

title	Content

Below this text is the HTML-Code to be transcluded to provide a filter for a display table macro using the remote controlled feature.

The javascript code uses the variable initialwhere which can be replaced using the transclusion variable replacement feature and be set to the initial where condition used in the display table macro.

Morover two more variables have to be set to provide options for a dropdown.

Full example replacement to put in transclusion box to disable the dropdown:

tableid=fitered

datalistselects=<datalist id="selects"></datalist>
datalistwheres=<datalist id="wheres"></datalist>

Full example replacement to put in transclusion box to set values for the dropdowns:

tableid=filtered

datalistselects=<datalist id="selects"><option value="Name">Name only</option><option value="Name, Short Description, Iteration">With Iteration</option></datalist>
datalistwheres=<datalist id="wheres"><option value="$<Iteration>=[Facade]">Facade</option><option value="$<Iteration>=[Filled]">Filled</option><option value="$<Iteration>=[Finished]">Finished</option></datalist>

Section

hide	true
title	Hide

Section

title	HTML-CODE

X

HTML
<form id="

filterForm$

filterForm-${tableid}" action="">
  <label for="select">select:</label>
  <input id="

filterSelect$

filterSelect-${tableid}" size="50" type="text" list="

selects$

selects-${tableid}" name="select" autocomplete="on">

${datalistselects}


  <label for="where">where:</label>
  <input id="

filterWhere$

filterWhere-${tableid}" size="50" type="text" list="

wheres$

wheres-${tableid}" name="where" autocomplete="on">

${datalistwheres}

<input type="submit" value="Submit">
  <input type="reset" value="Reset">
</form>

<form id="filterForm${tableid}" action=""> select: <input id="filterSelect${tableid}" size="50" type="text" list="selects${tableid}" name="select" > ${datalistselects} where: <input id="filterWhere${tableid}" size="50" type="text" list="wheres${tableid}" name="where"> ${datalistwheres} <input type="submit" value="Submit"> <input type="reset" value="Reset"> </form> <script> AJS.toInit(function() { function appendToQueryString( queryString, queryParam ) {

            }
            if (

queryString

$select.trim()) {

{

queryString=queryString

+

"&"

+

queryParam;

}

var $encodedSelect =

else

encodeURI($select);

{

queryString="?"+queryParam;

}

  var $selectQueryParam = tableId +

return queryString; }; var urlParams = new URLSearchParams(window.location.search); var originalSelect = urlParams.get('${tableid}:select'); var originalWhere = urlParams.get('${tableid}customWhere'); var initialWhere = urlParams.get('${tableid}initialWhere');

":" + "select" + "=" + $encodedSelect;
                $queryString = appendToQueryString($queryString, $selectQueryParam);
            }

var

oldQueryParams

= "" urlParams.forEach(function(value, key) { if(!key.startsWith("${tableid}")) { oldQueryParams=appendToQueryString(oldQueryParams, key+"="+encodeURI(value)); } }); if (initialWhere != null && initialWhere.trim()) { console.debug("initial where is NOT empty"); } else { console.debug("initial where is empty"); initialWhere = $('#${tableid} table').attr('data-projectdoc-query-where'); } $('#filterForm${tableid} datalist').attr('id', function(index, id) { return id+"${tableid}"; }) $("#filterSelect${tableid}").val(originalSelect); $("#filterWhere${tableid}").val(originalWhere); $('#filterForm${tableid}').submit(function(evt) { evt.preventDefault(); var tableId = "${tableid}"; var $select = $('#filterSelect${tableid}').val(); var $where = $('#filterWhere${tableid}').val(); var $queryString=""; if(oldQueryParams.trim()) {

      if ($where.trim()) {
                var $encodedCustomWhere = encodeURI($where);
                var $customWhereQueryParam = "${tableid}customWhere" + "=" + $encodedCustomWhere;

                var $encodedWhere = "";

                if (typeof initialWhere == 'undefined' || initialWhere == null) {
                    console.debug("Check 3 : initial where is empty");
                    $encodedWhere = encodeURI($where);

$queryString=appendToQueryString($queryString,

oldQueryParams.substr(1));

      } else {

$queryString=appendToQueryString($queryString, "${tableid}initialWhere=" + encodeURI(initialWhere)); if ($select.trim()) { var $encodedSelect = encodeURI($select

              console.debug("Check 3 : initial where is not empty");

var

$selectQueryParam

=

tableId

+

":"+"select"+"="+$encodedSelect;

$queryString=appendToQueryString($queryString, $selectQueryParam); } if ($where.trim()) { var $encodedCustomWhere = encodeURI(

 $encodedWhere = encodeURI(initialWhere + " AND " + $where);

var

$customWhereQueryParam

=

"${tableid}customWhere"+"="+$encodedCustomWhere;

var

$encodedWhere

=

encodeURI(initialWhere

+

"

AND

"

+

$where);

       var $whereQueryParam = tableId + ":" + "where" + "=" + $encodedWhere;
                $queryString = appendToQueryString($queryString, $whereQueryParam);
                $queryString = appendToQueryString($queryString, $customWhereQueryParam

);

            $action = window.location.href.split('?')[0] + $queryString;

            $('#filterForm').attr('action', $action);

            console.debug($action);
            window.location.href = $action;
        });
    }
)

;


</script>

HTML

<form id="filterForm${tableid}" action="">
  <label for="select">select:</label>

console.debug('${datalistselects}') function appendToQueryString(queryString, queryParam) { if (queryString.trim()) { queryString = queryString + "&" + queryParam; } else {

<input id="filterSelect${tableid}" size="50" type="text" list="selects${tableid}" name="select" autocomplete="on">
  ${datalistselects}
  <label for="where">where:</label>
  <input id="filterWhere${tableid}" size="50" type="text" list="wheres${tableid}" name="where" autocomplete="on">
  ${datalistwheres}
  <input type="submit" value="Submit">
  <input type="reset" value="Reset">
</form>
<script>
AJS.toInit(
    function() {
	 const logToConsole = false;
	  if (logToConsole) AJS.log("[copy-page-id] Registering action 'Copy Page ID to Clipboard' to keydown 'p'...");

        console.debug('${datalistselects}')

queryString = "?" + queryParam;

function appendToQueryString(queryString, queryParam) {

}

if (queryString.trim()) {

return

queryString;

  queryString = queryString + "&" +

}

queryParam;

var

urlParams

=

new URLSearchParams(window.location.search);

else {

var

originalSelect

= urlParams.get('${tableid}:select');

     queryString = "?" + queryParam;

var

originalWhere

=

urlParams.get('${tableid

customWhere');

var

initialWhere

= urlParams.get('${tableid}initialWhere')

return queryString;

console.debug("From Queryparam : initial where is: " + initialWhere);

};

        var urlParams = new URLSearchParams(window.location.search);
        var

oldQueryParams

originalSelect =

""

urlParams.

forEach(function(value, key) {

get('${tableid}:select');
        var originalWhere

if (!key.startsWith("

= urlParams.get('${tableid}

"

customWhere')

)

{

       var initialWhere = urlParams.get('${tableid}initialWhere');

oldQueryParams

=

appendToQueryString(oldQueryParams, key + "=

console.debug("From Queryparam : initial where is: " +

encodeURI(value)

initialWhere);

        var oldQueryParams =

}

""

});

urlParams.forEach(function(value, key) {

if

(typeof

initialWhere

==

'undefined' || initialWhere == null

if (!key.startsWith("${tableid}")) {

console.debug("Check

1

a:

initial

where is empty");

oldQueryParams = appendToQueryString(oldQueryParams, key + "=" + encodeURI(value));
            }
        });

        if (typeof initialWhere ==

originalWhere) {

'undefined' || initialWhere == null) {
            console.debug("

In

Check 1

b

a: initial where is

:

 empty"

+ initialWhere);

);
            if (initialWhere == originalWhere) {
                console.debug("In Check 1 b :

original

initial where is: " +

originalWhere

initialWhere);

}

else

{

 console.debug("In Check 1 b : original where is: " + originalWhere);

initialWhere

=

$('#${tableid} table

     } else {
                initialWhere = $('#${tableid} table').attr('data-projectdoc-query-where');
                console.debug("In Check 1 c: initial where is: " + initialWhere);
                console.debug("In Check 1 c : original where is: " + originalWhere);
            }
            if (typeof initialWhere == 'undefined' || initialWhere == null) {
                console.debug("Check 1 : initial is set to empty string.");
                initialWhere = null;
                console.debug("In Check 1/1 : initial where is: " + initialWhere);
            }
        } else {
            console.debug("Check 1 : initial where is not empty");
            console.debug("In Check 1 : initial where is: " + initialWhere);
        }

        $('#filterForm${tableid} datalist').attr('id', function(index, id) {
            return id + "${tableid}";
        })

        $("#filterSelect${tableid}").val(originalSelect);
        $("#filterWhere${tableid}").val(originalWhere);

        $('#filterForm${tableid}').submit(function(evt) {
            evt.preventDefault();

            var tableId = "${tableid}";
            var $select = $('#filterSelect${tableid}').val();
            var $where = $('#filterWhere${tableid}').val();

            var $queryString = "";
            if (oldQueryParams.trim()) {
                $queryString = appendToQueryString($queryString, oldQueryParams.substr(1));
            }
            if (typeof initialWhere == 'undefined' || initialWhere == null) {
                console.debug("Check 2 : initial where is empty");
            } else {
                console.debug("Check 2 : initial where is not empty");
                if (initialWhere == originalWhere) {
                    console.debug("In Check 2 b : initial where is: " + initialWhere);
                    console.debug("In Check 2 b : original where is: " + originalWhere);
                } else {
                    $queryString = appendToQueryString($queryString, "${tableid}initialWhere=" + encodeURI(initialWhere));
                    console.debug("In Check 2 c: initial where is: " + initialWhere);
                    console.debug("In Check 2 c : original where is: " + originalWhere);
                }
                console.debug("In Check 2 : initial where is: " + initialWhere);
                console.debug("In Check 2 : querystring is: " + $queryString);

} if ($select.trim()) { var $encodedSelect = encodeURI($select); var $selectQueryParam = tableId + ":" + "select" + "=" + $encodedSelect; $queryString = appendToQueryString($queryString, $selectQueryParam); } if ($where.trim()) { var $encodedCustomWhere = encodeURI($where); var $customWhereQueryParam = "${tableid}customWhere" + "=" + $encodedCustomWhere; var $encodedWhere = ""; if (typeof initialWhere == 'undefined' || initialWhere == null) { console.debug("Check 3 : initial where is empty"); $encodedWhere = encodeURI($where); } else { console.debug("Check 3 : initial where is not empty"); $encodedWhere = encodeURI(initialWhere + " AND " + $where); } var $whereQueryParam = tableId + ":" + "where" + "=" + $encodedWhere; $queryString = appendToQueryString($queryString, $whereQueryParam); $queryString = appendToQueryString($queryString, $customWhereQueryParam); } $action = window.location.href.split('?')[0] + $queryString; $('#filterForm').attr('action', $action); console.debug($action); window.location.href = $action; }); } ) </script>

Section

title	HTML Code

Code Block

Section

title	Transcluded By

Display Table

render-no-hits-as-blank	true
select	Name, Short Description, Doctype
sort-by	Sort Key, Name
where	$<TranscludedDocumentTitles>=[${Space Key}.${Title}]

...

Space shortcuts

Page tree

Versions Compared

Old Version 66

New Version Current

Key