For example, if I have forms:
and I want to make a TableView with the following:
I tried the following, but it seems it doesn't seem to work:
id.queryAndRender(F1:@self;name1:[entry.id];info;table).uniqueBy(info)
Is it possible to distinct filter a queryAndRender tableview?
What should be unique? The value in the “info” field?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
No, not with the queryAndRender
I think you will need to have something like a ListView with a nested and dynamically filtered TableView/CardView (where you can use distinct parameter)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks
but how would you configure that?
If I make the ListView for F2 and the nested TableView for F1, it won't show F2 values which are not used in F1.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Why not? ListView shows fields from F2 and the nested TableView shows data from F1
Something like this https://wiki.vertuna.com/display/CONFIFORMS/Master+Detail+forms+or+how+to+show+data+from+2+forms+which+are+referenced+using+ConfiForms+smart+fields
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Oh, I haven't used fields outside of the nested TableView. I thought you meant something like that:
Thanks, will try using this idea.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, but you can also put a ConfiForms Field macro, setting it's field name to name2 under the ListView
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for the response!
Just before I close the question, is there a way to render the list view as a table? or is there another view that will give me the same effect but would render as a table?
I tried to put a confluence table inside the listview, but even without any spaces below it's visible that it's just a list of tables and not one table.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
a possible solution I thought of would be using an expression instead of a field on the fields list:
queryAndRender(<formName:pageId>;<FILTER>;<FIELDS_OR_EXPRESSIONS>;<VIEW_TYPE>)
but for some reason it doesn't recognize expressions when I put them there.
Am I missing something regarding the usage of that function?
Whenever I try to put an expression there, no matter how simple the expression is, it just render the whole table, ignoring the fields.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What expressions "it doesn't recognize "?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
for example, I tried to put info.asCount() just to test it out also ([_count]), ([entry.)_count]) (_count).
queryCount doesn't fit there at all since there is a semicolon in it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I've seen now on another question that it is bugged on older versions of confiform.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.