Hi David, On Tue, 2007-12-18 at 08:55 -0800, David M. Goodstein wrote: > Syed Haider wrote: > > Hi Rochak, > > > > > > On Mon, 2007-12-17 at 21:33 +0000, Syed Haider wrote: > > > >> Hi Rochak, > >> firstly, the pointerFilter should have a different internalName. > >> Secondarily, I just realised that this wont solve your problem as you > >> need different qualifiers (<= and >=) which effectively means two > >> different filters pointing to a common filed. The problem you reported > >> earlier was that MartEditor does not let you export if two filters point > >> to the same field, which is a fairly reasonable use case. apologies i > >> misunderstood it. > >> > >> Let me speak to the team and see if we cant remove this check which > >> prevents the export when two filters point to the same field. > >> > > > > this is unlikely to happen with the current version of MartEditor. We > > will resolve this with new configuration system which will replace > > MartEditor. I am afraid, you have to introduce a new column and > > replicate the data in your table. > > > > > > > Is there a rough estimate of when the new configuration system will be > ready? We can duplicate the fields for now, though its really 24 fields > (all the different organisms represented in a gene family!), so it's > inelegant in the extreme.
Following this, could you please send me your XMLs, I can try and export this or edit the XMLs through script, if that works, I can provide you with appropriate shortcuts to get this to work without having to duplicate columns in database. thanks syed > > thx, > -David > > >> Meanwhile, if its not a lot of work, you can resolve it by introducing > >> another column in your Mart table having the same data, and point the > >> second filter to this field. Hideous but a quick solution. > >> > >> Martians: If somebody has a better idea, please do write. > >> > >> cheers > >> Syed > >> > >> On Mon, 2007-12-17 at 11:22 -0800, Rochak Neupane wrote: > >> > >>> On Dec 15, 2007 2:00 AM, Syed Haider <[EMAIL PROTECTED]> wrote: > >>> Hi David, > >>> > >>> > >>> On Fri, 2007-12-14 at 17:15 -0800, David Goodstein wrote: > >>> > I have gene family property, which is the number of > >>> representatives > >>> > of a particular species in the family. I'd like to be able > >>> to query > >>> > on that property with a range (at least X members and no > >>> more than Y > >>> > members). There is sort of like the transcript_count > >>> attribute in > >>> > the EnsMart gene sets, but there it's only a one-sided query > >>> (at > >>> > least X transcripts for this gene). When I try to build a > >>> filter > >>> > collection with two filters acting on this members field, > >>> one for <= > >>> > and one for >=, I'm unable to export the config (it > >>> complains about > >>> > duplicate entries). Is it not possible to have 2 filters > >>> acting on > >>> > the same field? > >>> > > >>> > >>> > >>> Make the second as pointer to the first filter, hope this > >>> should work. > >>> I presume it complains about field attribute being > >>> duplicated. > >>> > >>> marteditor accepts the 2nd as a pointer to the first filter, but > >>> configure.pl script complains about "internalName clash in dataset". > >>> martview only displays the first filter and not the pointer filter. Is > >>> this because of pointer to same dataset? > >>> > >>> thanks, > >>> rochak > >>> > >>> > >>> cheers > >>> syed > >>> > >>> > >>> > >>> > regards, > >>> > -David Goodstein > >>> > >>> > >>> > -- ====================================== Syed Haider. EMBL-European Bioinformatics Institute Wellcome Trust Genome Campus, Hinxton, Cambridge CB10 1SD, UK. ======================================
