I have a URL that returns that data in a format show below. Is it possible to reconstruct the data back into a table that can be filtered with a criteria.
I think you can use an HTTP binding on a tables data prop, and it should work as is.
After your HTTP binding, add a Script Transform to your binding and apply the filtering there.
Tip:
If you want the table to update if the filter criteria changes then some further rearrangement is required. Explain your setup and a nicely cropped screenshot of your user interface if it will help us.
I had a static URL. I used the HTTP binding and it returned the data in the attached format. I bound the URL to a table, it loaded all 15,600 rows. Applying a filter would be nice but I do not know much about it. Thank you for your help.
- On the table properties set
props.filter.enabled : trueand see if that's good enough for you.
You can pre-populate the filter by setting a value:
props.filter.text : M8
The user could then clear that. - Alternatively, enable the filters on whichever columns are relevant.
props.columns.0.filter.enabled : true
props.columns.0.filter.visible : always
If you want something better then write a quick specification.
Hi,
Get a read at Perspective - Table | Ignition User Manual
I tried the method described, that gave me a new issue. The data coming from the HTML source is in the form of a text so hard to figure out if there are spaces etc in it. It is not recognizing the filter value on the props.filter.text.
however when I test view it gives a filter choice and It recognizes there.
Is there a way to convert the entire data in the column to integer so a number search would give the result I need
Try,
props.columns.1.render : number
rather than auto.
Then put your filter value into
props.columns.1.filter.number.value
You might also want to set
props.columns.1.filter.number.condition : equals