Hide or reorder columns in a table using the API?

[Gabriel Rosser]

I've created some Cytoscape networks using the py2cytoscape library to access the REST API. I've added a large number of columns to the node table, many of which are for visualisation purposes (e.g. displaying nodes as pie charts). The node table is therefore very cluttered and difficult to use.

Is it possible to hide these columns programmatically using the API?

Failing that, how do I ensure the ordering of these columns is such that the most useful ones appear first?

If these operations are supported by the API but not the py2cytoscape library, I'm happy to add them or call them manually. The problem is that I don't currently know what API endpoints are relevant.

Thanks very much.

[Alex Pico]

Unfortunately, there is no API for tasks relating to the rendering of tables in Cytoscape (like column show/hide and order).  As far as I understand, even Java App authors don’t have access due to how tables are currently implemented. So, I don’t think we’ll be able to add those any time soon.

In any case, these tasks were considered very low priority for automation since you shouldn’t need to look at the table UI at all while running a script :)  Can you describe your use case. Are you using a script to setup a session file for end users to work with manually, for example?

 - Alex

--
You received this message because you are subscribed to the Google Groups "cytoscape-helpdesk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cytoscape-helpd...@googlegroups.com.
To post to this group, send email to cytoscape...@googlegroups.com.
Visit this group at https://groups.google.com/group/cytoscape-helpdesk.
To view this discussion on the web visit https://groups.google.com/d/msgid/cytoscape-helpdesk/218affeb-4208-4b73-b4fb-30ca002244ce%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Gabriel Rosser]

Thanks Alex, good to know.

That's correct - I couldn't care less about the table rendering myself, but you guessed the use case. I send session files to my colleagues so that they can explore our (gene / pathway) data for themselves. They use the tables to view node (pathway) attributes. Unfortunately, I have to throw a lot of extra columns in there to get the formatting right. This makes it harder for them to get at the attributes they need. I can of course get them to reorder/hide columns themselves!

Gabriel

On Monday, March 11, 2019 at 6:04:28 PM UTC, Alex Pico wrote:

Unfortunately, there is no API for tasks relating to the rendering of tables in Cytoscape (like column show/hide and order).  As far as I understand, even Java App authors don’t have access due to how tables are currently implemented. So, I don’t think we’ll be able to add those any time soon.

In any case, these tasks were considered very low priority for automation since you shouldn’t need to look at the table UI at all while running a script :)  Can you describe your use case. Are you using a script to setup a session file for end users to work with manually, for example?

 - Alex

On Mar 11, 2019, at 6:30 AM, Gabriel Rosser <gabriel...@gmail.com> wrote:

I've created some Cytoscape networks using the py2cytoscape library to access the REST API. I've added a large number of columns to the node table, many of which are for visualisation purposes (e.g. displaying nodes as pie charts). The node table is therefore very cluttered and difficult to use.

Is it possible to hide these columns programmatically using the API?

Failing that, how do I ensure the ordering of these columns is such that the most useful ones appear first?

If these operations are supported by the API but not the py2cytoscape library, I'm happy to add them or call them manually. The problem is that I don't currently know what API endpoints are relevant.

Thanks very much.

--
You received this message because you are subscribed to the Google Groups "cytoscape-helpdesk" group.

To unsubscribe from this group and stop receiving emails from it, send an email to cytoscape-helpdesk+unsub...@googlegroups.com.

[Alex Pico]

My only other suggestion would be to set the order by (an admittedly inefficient) use of deleteTableColumn() and loadTableColumn(). The order in the Node Table GUI is based on the load order. So, you should be able to set everything up, including style mappings, then delete all columns (except SUID, shared name and name, of course), then load the ones you need for data and visual style mappings back in the order you want.

Just might work…

 - Alex

To unsubscribe from this group and stop receiving emails from it, send an email to cytoscape-helpd...@googlegroups.com.

To post to this group, send email to cytoscape...@googlegroups.com.
Visit this group at https://groups.google.com/group/cytoscape-helpdesk.

To view this discussion on the web visit https://groups.google.com/d/msgid/cytoscape-helpdesk/7a56b75b-b7b5-4e41-a245-157bf6afea9c%40googlegroups.com.

[Gabriel Rosser]

Thanks for the suggestion - I wasn't aware of those methods. I'll give it a go - agree it's inefficient, but given the output will be studied intensely over a period of days, a few extra 100ms shouldn't be too dreadful :-)

If I delete a column used for a visual style (e.g. a passthrough mapping), will the styling immediately be deleted, or could I 'trick' Cytoscape into styling things correctly then delete them after the fact?

 - Alex

[Alex Pico]

Give it a try. The style mapping definition should stay the same. In the GUI, it will have a warning symbol, indicating that the column is missing, but it should still be there. Once a column with the same name is provided again, then it should automatically reconnect and produce the visual style again.

You can also simulate this in the GUI by just deleting a mapped column and then adding it back. But it’s probably easier to do programmatically :)

 - Alex

To unsubscribe from this group and stop receiving emails from it, send an email to cytoscape-helpd...@googlegroups.com.

To post to this group, send email to cytoscape...@googlegroups.com.
Visit this group at https://groups.google.com/group/cytoscape-helpdesk.

To view this discussion on the web visit https://groups.google.com/d/msgid/cytoscape-helpdesk/88914eb5-4bad-4490-9b95-fe4c4496397e%40googlegroups.com.