Filtering

Filter a CCv6 connection to show specific timesheet entries.

Overview

The default view shows all entries without filtering by worker or client.
Use column view filters with URL parameters and read data conditions that skip when empty to create clickable filters for workers and clients.

Answered
Connectivity v6
he healyhatman 18 Apr, 2018
Answer
I have a CCv6 connection showing all the time sheets entered by my workers. I want to be able to click on a worker's name to show just the timesheets for that user. Same for the client - click to filter by them.

By default, all entries should be shown.


EDIT: never mind.

Column view: user.name:{view:filter_by_worker}
filter_by_worker: Content-> {var:timesheets_list.row.user.name} URL -> worker={var:timesheets_list.row.timesheet.user_id}

Read data:
timesheet.user_id:{data:worker}/-
timesheet.client_name:{data:client}/-


the /- after means skip the condition if empty.
st stikkimorey 19 Aug, 2018
That works really well Thanks.

All the available assets are now coming into the repeater area and I have a book it button on the repeater, but the value from that row is not going into the datbase. what do I put in the value box of the button so that it knows how to save the asset_id from that particular row.

I tried {var:area_repeater69.key.row} and {var:area_repeater69.key.row} but this is not working.
he healyhatman 19 Aug, 2018
look at your debug. Make sure you named the fields correctly
he healyhatman 19 Aug, 2018
Are you talking about a CC TABLE or about a CF REPEATER AREA?
This topic is locked and no more replies can be posted.