Reply to thread

Message

<blockquote data-quote="mXan" data-source="post: 476435" data-attributes="member: 90571">I managed to solve this issue temporarily using a SQL Server script I launch everytime I update the channels.Basically I have a DVB-S card filling tons of channel in group 2 and a DVB-T card which puts channels in the &quot;All channel&quot; group only..I have created a &quot;dvb-t&quot; group (it has id of 3) and use this script:[CODE]INSERT INTO GroupMap (idGroup, idChannel, SortOrder)SELECT 3, idChannel, SortOrder&nbsp; FROM GroupMap WHERE idChannel NOT IN (SELECT idChannel FROM GroupMap WHERE idGroup &lt;&gt; 1)[/CODE]This basically adds every channel only in group 1 (All channels) to group 3.I know it's a kludge.. and may also not work for you (above all, I'm no SQL expert <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" />)Sharing anyway.</blockquote>

[QUOTE="mXan, post: 476435, member: 90571"] I managed to solve this issue temporarily using a SQL Server script I launch everytime I update the channels. Basically I have a DVB-S card filling tons of channel in group 2 and a DVB-T card which puts channels in the "All channel" group only.. I have created a "dvb-t" group (it has id of 3) and use this script: [CODE]INSERT INTO GroupMap (idGroup, idChannel, SortOrder) SELECT 3, idChannel, SortOrder FROM GroupMap WHERE idChannel NOT IN (SELECT idChannel FROM GroupMap WHERE idGroup <> 1) [/CODE] This basically adds every channel only in group 1 (All channels) to group 3. I know it's a kludge.. and may also not work for you (above all, I'm no SQL expert :)) Sharing anyway. [/QUOTE]

Verification