<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hi all,</p>
<p> I have requirement of storing list of tuple of elements in
record fields of a table in mnesia.</p>
<p>This is the record defined for the table,<br>
</p>
<p> record( test_info, { test_id:: integer(), username::atom(),
test_details::list(), dut_card_details::list(),
ats_card_details::list(), test_result::list()}).<br>
</p>
<p>example:</p>
<p> This is the 'test_info' table with data,<br>
</p>
<p> {test_info,3,kavi123,<br>
["#102","09:45","11:55",pass],<br>
[ommp82_plus,12775,'1_4_3','0.1','0.0.1',123458889],<br>
[ats_card,12790,'1_7_5','1.1','0.1.1',123775777],<br>
[{port1,{sfp,185,wqc,<font color="#ff0000"><b>wxt193</b></font>,1905,80,no,pass,pass,pass,pass,pass,<br>
pass,pass,pass,pass}},<br>
{port2,{sfp,174,was,zte142,1960,80,no,pass,pass,pass,pass,pass,<br>
pass,pass,pass,pass}},<br>
{port3,{sfp,189,wsc,svz77,2306,80,no,pass,pass,pass,pass,pass,<br>
pass,pass,pass,pass}},<br>
{port4,{xfp,134,was,xtg142,2560,80,no,fail,pass,pass,pass,fail,<br>
pass,pass,pass,pass}}]}<br>
</p>
<p>i have an issue, how to search a record, which contains specific
element from the list of tuple from mnesia table?</p>
<p>example:</p>
<p> i need list of all the records containing 'wxt193' element in
it.</p>
<p>Can you please suggest if any solution to resolve my issue,</p>
<p><br>
</p>
<p>Regards,</p>
<p>Gattu ShivaKrishna<br>
</p>
<p><br>
</p>
</body>
</html>