2. PHPRunner General questions
  3. [SOLVED]  PHPrunner Edit mode question
This topic is locked
[SOLVED]

 PHPrunner Edit mode question

 		6/29/2019 4:52:45 PM
PHPRunner General questions
E
 excalibur author

Hi all. I have an issue editing a record (via inline edit or an edit page) in a custom view where the record has a unique item_id and date. When a field is edited in one record, all of the records with that date are edited only the date seems to be used on the edit. The SQL query Selects the item_id, date and fields from the database and is GROUP BY date. The PHPrunner Search is used to select the item_id and then all of the item_id records by date are shown. When a field is selected for edit via the edit page, only the date is shown as the key.
How can I add the item_id that is selected in the search to the edit feature in PHPrunner so only the field for that item_id AND date are updated? I tried to alter the SQL query to no avail and could not make event code work with my limited knowledge.
Thanks in advance for your help!
rdsanford 6/29/2019

Hi Excalibur,

One thing to check is that the key column(s) are defined on your custom views. Click the "Pages" button, verify what is defined for "Selected key columns", top right corner.
Thanks
E
 		excalibur author 6/30/2019

That worked! Thanks for your help. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=88082&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />
Sergey Kornilov admin 6/30/2019

It is a bit unclear what you want to edit here. GROUP BY query displays aggregated data, meaning that a single row on the list page will be comprised of several database records and not clear which one you want to edit. Normally data based on GROUP BY queries are meant for view purposes only.