Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,294,209
Community Members
 
Community Events
165
Community Groups

Smart Multi-select and tableview

Is there a way to use Smart multi-select to filter through data that is being shown in the tableview and show the relevant data or grab the relevant data that is selected by the multi-select?

1 answer

Hi

Absolutely, just with any other field (except for "drawing canvas")

What is the problem? Do you want to filter by field values that the smart field references? Or multiple conditions or dynamically set conditions?

Alex

What I want to filter by is what the smart field references, Let's say the smart field chooses voice, sound, and drums. I want to display the rows that match those three selections if that is possible in the table view. I’m also using the confiforms form filter control is the wrong approach.

Sorry for the late reply

Where do you choose that? Are you talking about using the https://wiki.vertuna.com/display/CONFIFORMS/Using+and+configuring+ConfiForms+Dynamic+Filter?

Knowing where the actual "voice, sound, and drums" values are stored in the referenced (through the smart field) will help to set the filtering expression

Assuming the field name for smart field is named "option" and the field name that holds actual values for "voice, sound, and drums" is called "name"

Then the expression would be something like

option.name:voice OR option.name:sound OR option.name:drums

Alex

Okay this helpful but do I have to write an expression for every value I have over 600 is there a way to make it dynamic where I set up one would it be option.name:[entry.name]

That is why I am trying to understand where do you need that and what is the use case... And should be rather be a mention Filter control

OK, and what should be the value for "[entry.name]" (take from where?)

Capture.PNG

The image above is what I want to do is choose names in the smart field and only show those names but is there a way to do it dynamically where you can have one expression. When I choose one it only shows a blank table view.

<p class="auto-cursor-target"><br /></p><ac:structured-macro ac:name="div" ac:schema-version="1" ac:macro-id="a3cc89a4-19bb-45bb-a6e6-15b87cd76f50"><ac:parameter ac:name="class">form-item item23</ac:parameter><ac:rich-text-body>
<p class="auto-cursor-target">Input a Bundle:</p><ac:structured-macro ac:name="confiform-entry-filter" ac:schema-version="1" ac:macro-id="ea042b41-1193-4e14-bbd2-8095ebd0243e"><ac:parameter ac:name="formName">bundlesRoles</ac:parameter><ac:parameter ac:name="multipleChoices">true</ac:parameter><ac:parameter ac:name="useWildcards">true</ac:parameter><ac:parameter ac:name="showOnlyRelevantChoices">true</ac:parameter><ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter><ac:rich-text-body>
<p><ac:structured-macro ac:name="confiform-field" ac:schema-version="1" ac:macro-id="4ca2f68d-29ba-4726-9579-f8add40a06d3"><ac:parameter ac:name="fieldName">Bundl</ac:parameter></ac:structured-macro></p></ac:rich-text-body></ac:structured-macro>
<p class="auto-cursor-target"><br /></p><ac:structured-macro ac:name="html" ac:schema-version="1" ac:macro-id="dcf2ba13-93b5-4f96-81cc-c167b201f7d3"><ac:plain-text-body><![CDATA[
<div style="text-align: center">
<form class="aui">
<button type="button" class="aui-button" id="showBundleToggle">SHOW ROLES IN BUNDLES</button>
</form>
</div>

<script type="text/javascript">
AJS.toInit(function() {
AJS.$('showBundle').hide();
AJS.$('#showBundleToggle').click(function(){
AJS.$('#showBundle').toggle();
});
});
</script>]]></ac:plain-text-body></ac:structured-macro>
<p class="auto-cursor-target"><br /></p><ac:structured-macro ac:name="div" ac:schema-version="1" ac:macro-id="81ac60cf-d3f9-4b1f-b156-f8ad134333bf"><ac:parameter ac:name="id">showBundle</ac:parameter><ac:parameter ac:name="class">form-item bundles</ac:parameter><ac:rich-text-body>
<p class="auto-cursor-target"><br /></p><ac:structured-macro ac:name="div" ac:schema-version="1" ac:macro-id="ed7c36db-ba74-42d7-b562-65b5ebf67f8c"><ac:parameter ac:name="class">form-item item23</ac:parameter><ac:rich-text-body>
<p class="auto-cursor-target"><br /></p><ac:structured-macro ac:name="confiform-table" ac:schema-version="1" ac:macro-id="639c7298-0bc5-447e-8275-bc4f1a5219b2"><ac:parameter ac:name="enableFilterSupport">true</ac:parameter><ac:parameter ac:name="formName">bundlesRoles</ac:parameter><ac:rich-text-body>

The use cause is that I have a table with 600 different entries and I want to use the smart field and choose the ones that match. The data is imported into b form by a CSV and I’m trying to use the filter in the form a to filter form b table view that contains all columns. Form a smart field is using form c which has unique values like the one above john and Travis that shows up once in the smart field. I'm trying to use form a smart field that grabs the names from form c to filter form b table view and find the matching cases is that possible?

This the real question sorry about all the run around.

This is not something you can do with ConfiForms... as if you have a smart field in another form then it is just a field that has values loaded from a form.

You cannot use that (field) for the filtering of the other table / form. Not like that.

Sorry.

Okay than how about just using form B with a Smart Multi-select and tableview how would u do that using the image I shown above?

You will need to have records in form B

And then you use the  ConfiForms Filter Control macro (link above) over the form B

okay I have done that but since the data was imported into confiform into form it does not show the matching values when i use smart classifier would I need to import the record into the smart classifier.

Not sure I understand about the import, but here is what I have been trying to explain in my previous comment and this is what you can do with ConfiForms

 

http://recordit.co/7IQMh3SwE3

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

Confluence: Where work and wellness meet

Feeling overwhelmed by the demands of work and life? With a 25% increase in the prevalence of anxiety and depression worldwide during the pandemic, for most of us, it’s a resounding yes . 🙋‍♀️ ...

777 views 5 21
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you