Trackers Item Link Prefiltering Feature

Hi Bernard,

I've tried following your suggestion, however I'm stuck since I cannot 
use Item Link Pre-filtering feature. If that feature would work, 
everything would be perfect.

Returning to Mario And Luigi Example, let's say I have the following table:

_Machines Sold_
- *Customer* (Item Link To Customers Table)
- *Machine Type* (Item Link To Machine Types Table)
- *Machine Serial Number* (Text Field)

And then this other one:

_Tickets
_- *Customer* (Item Link To Customers Table)_
_- *Machine Type & Serial Number* (Item Link to Machines Sold displaying 
both *Machine Type* And *Machine Serial Number*, prefiltered on *Customer*)

Now, if this would work, it would be perfect. However the Item 
Link***Machine Type & Serial Number*//always list /all /the values in 
Machines Sold, and prefiltering seems not to be working.

I've set-up the *Machine Type & Serial Number *Item Link field in the 
following way:

- Tracker ID = Machines Sold
- Field ID = Machine Serial Number
- Dispay = Value
- Multiple Field = [Machine Type, Machine Serial Number] are selected
- Multiple Fields display type = Dropdown
- Preselect item based on value in this field = Customer
- Preselect based on the value in this remote field = Customer
- Preselection matching method = Exact Match
...

(all others field have been left to their default value)

Could someone please explain to me what I'm missing? is this not the 
intended use for this feature maybe?

Thank you very much

Alessandro



Il 13/08/2020 13:00, Bsfez Tiki ha scritto:
> Re-reading;
>
> May be 2 dynamic list (one after the other) won’t work fine (I had 
> issues a few times with that) but you should be able to use instead of 
> the dynamic list field an item list or item link field.
>
> I would need to put my hand under the hood to tell you more. That's 
> how I'am.🤗
>
> Bernard
>
>> On 13 Aug 2020, at 13:22 , Bsfez Tiki <[email protected] 
>> <mailto:[email protected]>> wrote:
>>
>> Hello Alessandro,
>>
>> (how can I not answer to a case related to Nintendo and Woodworking ?) 😂
>>
>> Not sure if you can achieve this with the relation field…
>>
>> Using the dynamic list field you can have on item creation a list of 
>> items from another tracker using the user or the machine as matching 
>> value you will select.
>> You should be able to cascade fields like:
>>
>>>  - *Customer* (choosen from the list) --> [Mario, Luigi], I select Mario
>>>
>> Item link to the tracker customers
>>
>>> - *Machine Types* Table, with the type of machines (Log Saw, 
>>> Embosser, Unwinder, Rewinder)
>>>
>> Dynamic item list to the tracker Machine with for matching value the 
>> customer
>>
>>> - *Machines Sold* Table: <Customer, Machine Type, Machine Serial 
>>> Number>.
>>>
>> Dynamic item list to the machine sold with for matching value the machine
>>
>> Theoretically this should work (may be with some adjustment) but 
>> that’s how I’ll start with this use case.
>> https://www.bernardsfez.com/article46-Tiki-Trackers-ItemLink-ItemList-and-Dynamic-ItemList-field-types
>>
>>
>>
>> About the relation fields I miss the part where you filter your 
>> relations to items dynamically (look for the items related to on the 
>> fly… before saving the item).
>> But may be someone will come up with more about this ? ;-)
>>
>> Bernard
>>
>>
>>
>>
>>> On 12 Aug 2020, at 15:31 , Alessandro Martinelli 
>>> <[email protected] 
>>> <mailto:[email protected]>> wrote:
>>>
>>> Hi,
>>>
>>> I'm here for trackers again :)
>>>
>>> I need to populate a field in the following way:
>>>
>>>
>>> Assume we have
>>>
>>> - *Customers *Table, with the list of customers;
>>>
>>> - *Machine Types* Table, with the type of machines (Log Saw, 
>>> Embosser, Unwinder, Rewinder)
>>>
>>> - *Machines Sold* Table: <Customer, Machine Type, Machine Serial 
>>> Number>.
>>>
>>>
>>> So we could have for example
>>>
>>> <Mario, LogSaw, 16125>
>>>
>>> <Mario, Rewinder, 16826>
>>>
>>> <Mario, LogSaw, 18152>
>>>
>>> <Luigi, Embosser, 19642>
>>>
>>>
>>> So when I create a new ticket, regarding a single machine belonging 
>>> to a given customer, I'll be requested to fill:
>>>
>>>     - *Customer* (choosen from the list) --> [Mario, Luigi], I 
>>> select Mario
>>>
>>>     - *Machine Type* (choosen from the subset composed by machine 
>>> types the given customer owns, so I use a Dynamic Dropdown) --> 
>>> [LogSaw, Rewinder], I select Log Saw
>>>
>>>     - *Machine Serial Number* (automatically filled: it should be a 
>>> dropdown automatically filled selecting the following values:
>>>         "SELECT MachineSerialNumber FROM MachinesSold WHERE Customer 
>>> = SelectedCustomer AND MachineType = SelectedMachineType). --> 
>>> [16125, 18152]
>>>
>>>
>>> Is there a way of achieving this, maybe by means of Relations? I've 
>>> taken a look at this page 
>>> http://doc.tiki.org/Relations-Tracker-Field but it is not enought 
>>> for me.
>>>
>>> Thank you in advance,
>>>
>>>     Alessandro Martinelli
>>>
>>> _______________________________________________
>>> TikiWiki-users mailing list
>>> [email protected] 
>>> <mailto:[email protected]>
>>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-users
>>
>> _______________________________________________
>> TikiWiki-users mailing list
>> [email protected] 
>> <mailto:[email protected]>
>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-users
>
>
>
> _______________________________________________
> TikiWiki-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-users

_______________________________________________
TikiWiki-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-users