Purpose

The ideal approach in searching data in a Table Data macro is to add a Text Filter macro and then injecting Text Data macro to filter out the results.

Answer

Technique used in Text filter:

Key:

data:searchFieldInScaffoldingTable> match %variable:search%> value

Minimum Length:

1

Basically the above says compare searchFieldInScaffoldingTable with Scaffolding Search data and show all the results which matches the value at least one time.

<p class="auto-cursor-target">Enter the a value to search :</p>
<p>
  <br/>
</p>
<ac:structured-macro ac:macro-id="39450e51-5bf6-47a1-bccd-ff0a8b109c3b" ac:name="text-data" ac:schema-version="1">
  <ac:parameter ac:name="name">mySearch</ac:parameter>
  <ac:parameter ac:name="content">text</ac:parameter>
  <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
  <ac:rich-text-body>
    <p>
      <br/>
    </p>
  </ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="e45a2a4e-01b5-4367-a68e-07d8fe9e4577" ac:name="report-block" ac:schema-version="1">
  <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
  <ac:rich-text-body>
    <ac:structured-macro ac:macro-id="f41c158b-727a-4d28-b019-3e9a1495c930" ac:name="local-reporter" ac:schema-version="1">
      <ac:parameter ac:name="">@self</ac:parameter>
      <ac:rich-text-body>
        <p>
          <br/>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="a0d6522a-3b5f-470f-bc05-94a81ef34ace" ac:name="report-header" ac:schema-version="1">
      <ac:rich-text-body>
        <ac:structured-macro ac:macro-id="3d354165-c9d4-46cf-82be-079a495b62ea" ac:name="report-variable" ac:schema-version="1">
          <ac:parameter ac:name="name">search</ac:parameter>
          <ac:parameter ac:name="value">%data:mySearch%</ac:parameter>
          <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
          <ac:rich-text-body>
            <p>
              <br/>
            </p>
          </ac:rich-text-body>
        </ac:structured-macro>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="2c8f9a58-2a33-4f6b-ac81-1871abb85659" ac:name="report-body" ac:schema-version="1">
      <ac:parameter ac:name="injected">true</ac:parameter>
      <ac:rich-text-body>
        <ac:structured-macro ac:macro-id="31f602ab-edf4-4563-9d80-68dd0ba071d4" ac:name="report-block" ac:schema-version="1">
          <ac:parameter ac:name="injected">true</ac:parameter>
          <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
          <ac:rich-text-body>
            <ac:structured-macro ac:macro-id="6ce958e0-2068-468a-b8d6-4f6490fa795c" ac:name="local-reporter" ac:schema-version="1">
              <ac:parameter ac:name="">data:mytable</ac:parameter>
              <ac:rich-text-body>
                <p>
                  <ac:structured-macro ac:macro-id="ec7b3282-43e2-4f1f-8d9a-c79d58ecdfa8" ac:name="text-filter" ac:schema-version="1">
                    <ac:parameter ac:name="minLength">1</ac:parameter>
                    <ac:parameter ac:name="required">true</ac:parameter>
                    <ac:parameter ac:name="">data:searchFieldInScaffoldingTable&gt; match %variable:search%&gt; value</ac:parameter>
                  </ac:structured-macro>
                </p>
              </ac:rich-text-body>
            </ac:structured-macro>
            <ac:structured-macro ac:macro-id="78995809-6a56-4c80-8e19-d50db5037270" ac:name="report-body" ac:schema-version="1">
              <ac:rich-text-body>
                <p>
                  <ac:structured-macro ac:macro-id="c27c315a-5927-4a99-940a-5a03dc948cdc" ac:name="report-info" ac:schema-version="1">
                    <ac:parameter ac:name="format">#</ac:parameter>
                    <ac:parameter ac:name="">data:findValueInTableData</ac:parameter>
                  </ac:structured-macro>
                </p>
              </ac:rich-text-body>
            </ac:structured-macro>
          </ac:rich-text-body>
        </ac:structured-macro>
      </ac:rich-text-body>
    </ac:structured-macro>
    <p class="auto-cursor-target">
      <br/>
    </p>
    <p class="auto-cursor-target">
      <br/>
    </p>
  </ac:rich-text-body>
</ac:structured-macro>
<p>
  <br/>
</p>
<p>
  <br/>
</p>
<p>
  <br/>
</p>
<p class="auto-cursor-target">
  <br/>
</p>